oracle.pg.rdbms.pgql

Class SqlQuery

java.lang.Object

oracle.pg.rdbms.pgql.SqlQuery

public class SqlQuery
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	COL_MODIFY_IDX_SEPARATOR
static java.lang.String	VAR_PROP_SEPARATOR

Constructor Summary

Constructors

Constructor and Description
SqlQuery()

Method Summary

Modifier and Type	Method and Description
void	addFromElem(ValuePair vp) Adds a from element to this select query
void	addGroupElem(java.lang.String s) Adds a group element to this select query
void	addHavingElem(java.lang.String s) Adds a having element to this select query
void	addHintElem(java.lang.String h) Adds a hint element to this select query
void	addMatchModifySelectElem(ValuePair vp) Adds a match modify select element to this select query
void	addModifySelectElem(ValuePair vp) Adds a modify select element to the current list of modify select elements of this select query
void	addModifySqlQueryElem(boolean addFromMatchQuery) Adds a list of modify select elements to this select query
void	addOrderElem(java.lang.String s) Adds an order element to this select query
void	addSelectElem(ValuePair vp) Adds a select element to this select query
void	addUnpivot(java.lang.String selectColumns, java.lang.String forColumn, java.lang.String unpivotColumns) Creates an unpivot for this select query
void	addUnpivotElem(java.lang.String elem) Adds an unpivot element to the unpivot of this select query
void	addUnpivotList() Adds an unpivot list to the unpivot of this select query
void	addWhereElem(java.lang.String s) Adds a where element to this select query
void	addWithClause(ValuePair vp) Adds a with clause to this select query
java.lang.String[]	buildMatchTranslation(boolean useExtdSize) Builds the translation of the match clause of this select query
java.lang.StringBuffer	buildQueryUnpivot() Builds an Unpivot SQL query string from populated SQL query component lists.
java.lang.StringBuffer	buildSQLModifyString(int idx) Builds a SQL query string for modify from populated SQL query component lists.
java.lang.StringBuffer	buildSQLString() Builds a SQL query string from populated SQL query component lists.
java.lang.StringBuffer	buildSQLString(java.util.List<ValuePair> selectElems, java.util.List<ValuePair> fromElems, java.util.List<java.lang.String> whereElems, boolean addGroupBy, boolean addOrderByAndLimit) Builds a SQL query string from populated SQL query component lists.
void	clear()
void	moveMatchElemsToModify() Moves the from elements and where elements of this select query to every modify list
void	putModifyFromElem(java.lang.Integer i, ValuePair vp) Adds a from element to the modify list at given index in this select query
void	putModifyWhereElem(java.lang.Integer i, java.lang.String s) Adds a where element to the modify list at given index in this select query
void	setDistinct(boolean distinct) Sets if this select query has a distinct modifier
void	setLimit(java.lang.String limit) Sets the limit value of this select query
void	setMatchTableName(java.lang.String matchTableName) Sets the match table name of this select query
void	setOffset(java.lang.String offset) Sets the offset value of this select query
java.lang.String	toString() Prints elements of this select query

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

COL_MODIFY_IDX_SEPARATOR

public static final java.lang.String COL_MODIFY_IDX_SEPARATOR

See Also:

Constant Field Values

VAR_PROP_SEPARATOR

public static final java.lang.String VAR_PROP_SEPARATOR

See Also:

Constant Field Values

Constructor Detail

SqlQuery

public SqlQuery()

Method Detail

addFromElem

public void addFromElem(ValuePair vp)

Adds a from element to this select query

Parameters:

vp - The from element to add

addGroupElem

public void addGroupElem(java.lang.String s)

Adds a group element to this select query

Parameters:

s - The group element to add

addHavingElem

public void addHavingElem(java.lang.String s)

Adds a having element to this select query

Parameters:

s - The having element to add

addHintElem

public void addHintElem(java.lang.String h)

Adds a hint element to this select query

Parameters:

h - The hint element to add

addMatchModifySelectElem

public void addMatchModifySelectElem(ValuePair vp)

Adds a match modify select element to this select query

Parameters:

vp - The match modify select element to add

addModifySelectElem

public void addModifySelectElem(ValuePair vp)

Adds a modify select element to the current list of modify select elements of this select query

Parameters:

vp - The modify select element to add

addModifySqlQueryElem

public void addModifySqlQueryElem(boolean addFromMatchQuery)

Adds a list of modify select elements to this select query

Parameters:

addFromMatchQuery - true if should add a select element for the match table

addOrderElem

public void addOrderElem(java.lang.String s)

Adds an order element to this select query

Parameters:

s - The order element to add

addSelectElem

public void addSelectElem(ValuePair vp)

Adds a select element to this select query

Parameters:

vp - The select element to add

addUnpivot

public void addUnpivot(java.lang.String selectColumns,
                       java.lang.String forColumn,
                       java.lang.String unpivotColumns)

Creates an unpivot for this select query

Parameters:

selectColumns - The select columns of the unpivot

forColumn - The for column of the unpivot

unpivotColumns - The unpivot columns of the unpivot

addUnpivotElem

public void addUnpivotElem(java.lang.String elem)

Adds an unpivot element to the unpivot of this select query

Parameters:

elem - The unpivot element to add

addUnpivotList

public void addUnpivotList()

Adds an unpivot list to the unpivot of this select query

addWhereElem

public void addWhereElem(java.lang.String s)

Adds a where element to this select query

Parameters:

s - The where element to add

addWithClause

public void addWithClause(ValuePair vp)

Adds a with clause to this select query

Parameters:

vp - The with clause to add

buildMatchTranslation

public java.lang.String[] buildMatchTranslation(boolean useExtdSize)

Builds the translation of the match clause of this select query

Parameters:

useExtdSize - true if should use extended size for nvarchar columns

Returns:

The translation of the match clause

buildQueryUnpivot

public java.lang.StringBuffer buildQueryUnpivot()

Builds an Unpivot SQL query string from populated SQL query component lists.

Returns:

The Unpivot SQL query

buildSQLModifyString

public java.lang.StringBuffer buildSQLModifyString(int idx)

Builds a SQL query string for modify from populated SQL query component lists.

Parameters:

idx - The index of the modify to build

Returns:

The SQL query string for modify

buildSQLString

public java.lang.StringBuffer buildSQLString()

Builds a SQL query string from populated SQL query component lists.

Returns:

The SQL query string

buildSQLString

public java.lang.StringBuffer buildSQLString(java.util.List<ValuePair> selectElems,
                                             java.util.List<ValuePair> fromElems,
                                             java.util.List<java.lang.String> whereElems,
                                             boolean addGroupBy,
                                             boolean addOrderByAndLimit)

Builds a SQL query string from populated SQL query component lists.

Parameters:

selectElems - The select elements for the query

fromElems - The from elements for the query

whereElems - The where elements for the query

addGroupBy - true if should add a group by clause

addOrderByAndLimit - true if should add order by and limit clauses

Returns:

The SQL query string

clear

public void clear()

moveMatchElemsToModify

public void moveMatchElemsToModify()

Moves the from elements and where elements of this select query to every modify list

putModifyFromElem

public void putModifyFromElem(java.lang.Integer i,
                              ValuePair vp)

Adds a from element to the modify list at given index in this select query

Parameters:

i - The index of the modify list

vp - The modify from element to add

putModifyWhereElem

public void putModifyWhereElem(java.lang.Integer i,
                               java.lang.String s)

Adds a where element to the modify list at given index in this select query

Parameters:

i - The index of the modify list

s - The modify where element to add

setDistinct

public void setDistinct(boolean distinct)

Sets if this select query has a distinct modifier

Parameters:

distinct - Set to true if this select should have a distinct modifier

setLimit

public void setLimit(java.lang.String limit)

Sets the limit value of this select query

Parameters:

limit - The limit value to set

setMatchTableName

public void setMatchTableName(java.lang.String matchTableName)

Sets the match table name of this select query

Parameters:

matchTableName - The match table name

setOffset

public void setOffset(java.lang.String offset)

Sets the offset value of this select query

Parameters:

offset - The offset value to set

toString

public java.lang.String toString()

Prints elements of this select query

Overrides:

toString in class java.lang.Object