com.tsgrp.opencontent.wizard.core.query

Class WizardQueryServiceUtil

java.lang.Object

com.tsgrp.opencontent.wizard.core.query.WizardQueryServiceUtil

public class WizardQueryServiceUtil
extends java.lang.Object

Util methods for manipulating Wizard Query strings. Ported over passthough util methods to consolidate WizardQuery implementations

Constructor Summary

Constructors

Constructor and Description
WizardQueryServiceUtil()

Method Summary

Modifier and Type	Method and Description
static java.util.ArrayList<java.lang.String>	getSelectColumns(java.lang.String dql) Returns an arraylist of the columns that are selected from the specified DQL statement
static java.util.HashMap<java.lang.String,java.lang.String>	getVariables(java.lang.String query) Unwrap every ${ variable } and pass to an array for processing
static QueryResult	processQueryResults(java.lang.String query, java.util.List<java.util.List<java.lang.String>> resultList) Process query result table into parseable query result object
static java.lang.String	replaceVariables(java.lang.String query, java.util.HashMap<java.lang.String,java.lang.String> variables, Substitution[] substitutions) Replace each instance of a query variable with its solution
static java.lang.String	stripDistinct(java.lang.String columnName) Strips the "distinct " text from a column name if necessary
static java.lang.String	stripTableIdentifier(java.lang.String columnName) Strips the table identifier before the column name including the '.' if necessary
static java.lang.String	unwrapVariable(java.lang.String variable) Unwrap ${ } from variable

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

WizardQueryServiceUtil

public WizardQueryServiceUtil()

Method Detail

unwrapVariable

public static java.lang.String unwrapVariable(java.lang.String variable)

Unwrap ${ } from variable

Parameters:

variable - - wrapped variable

Returns:

unwrapped variable

getVariables

public static java.util.HashMap<java.lang.String,java.lang.String> getVariables(java.lang.String query)

Unwrap every ${ variable } and pass to an array for processing

Parameters:

query - Wizard Query - usually a SELECT query

Returns:

list of unwrapped query variables

replaceVariables

public static java.lang.String replaceVariables(java.lang.String query,
                                                java.util.HashMap<java.lang.String,java.lang.String> variables,
                                                Substitution[] substitutions)

Replace each instance of a query variable with its solution

Parameters:

query - Wizard Query string

variables - unwrapped variables (call getVariables)

substitutions - Map of passed in variables with their solutions

Returns:

resolved query string ready for execution

getSelectColumns

public static java.util.ArrayList<java.lang.String> getSelectColumns(java.lang.String dql)
                                                              throws java.lang.Exception

Returns an arraylist of the columns that are selected from the specified DQL statement

Parameters:

dql - the dql statement

Returns:

an ArrayList of columns

Throws:

java.lang.Exception - if an error occurs

stripDistinct

public static java.lang.String stripDistinct(java.lang.String columnName)

Strips the "distinct " text from a column name if necessary

Parameters:

columnName -

Returns:

the column name minus the distinct text if present

stripTableIdentifier

public static java.lang.String stripTableIdentifier(java.lang.String columnName)

Strips the table identifier before the column name including the '.' if necessary

Parameters:

columnName -

Returns:

the column name minus the table identifier if present

processQueryResults

public static QueryResult processQueryResults(java.lang.String query,
                                              java.util.List<java.util.List<java.lang.String>> resultList)

Process query result table into parseable query result object

Parameters:

query - query used to get these results

resultList - results from this query

Returns: