com.healthmarketscience.jackcess.query
Class CrossTabQuery

java.lang.Object
  com.healthmarketscience.jackcess.query.Query
      com.healthmarketscience.jackcess.query.BaseSelectQuery
          com.healthmarketscience.jackcess.query.CrossTabQuery

public class CrossTabQuery
extends BaseSelectQuery

Concrete Query subclass which represents a crosstab/pivot query, e.g.: TRANSFORM <expr> SELECT <query> PIVOT <expr>

Nested Class Summary

Nested classes/interfaces inherited from class com.healthmarketscience.jackcess.query.Query

Query.AppendableList<E>, Query.Row, Query.RowFilter, Query.RowFormatter, Query.Type

Field Summary

Fields inherited from class com.healthmarketscience.jackcess.query.Query

LOG

Constructor Summary

CrossTabQuery(java.lang.String name, java.util.List<Query.Row> rows, int objectId)

Method Summary

protected java.util.List<Query.Row>	getColumnRows()
protected java.util.List<Query.Row>	getGroupByRows()
java.lang.String	getPivotExpression()
protected Query.Row	getPivotRow()
java.lang.String	getTransformExpression()
protected Query.Row	getTransformRow()
protected void	toSQLString(java.lang.StringBuilder builder)

Methods inherited from class com.healthmarketscience.jackcess.query.BaseSelectQuery

getFromRemoteDbPath, getFromRemoteDbType, getFromTables, getGroupings, getHavingExpression, getOrderings, getSelectColumns, getSelectType, getWhereExpression, toSelectInto, toSQLSelectString

Methods inherited from class com.healthmarketscience.jackcess.query.Query

create, filterRowsByFlag, filterRowsByNotFlag, getFlagRow, getHavingRow, getIntValue, getJoinRows, getName, getObjectFlag, getObjectId, getOrderByRows, getOwnerAccessType, getParameterRows, getParameters, getRemoteDatabaseRow, getRowByAttribute, getRows, getRowsByAttribute, getShortValue, getTableRows, getType, getTypeRow, getUniqueRow, getWhereRow, hasFlag, hasFlag, supportsStandardClauses, toAlias, toOptionalQuotedExpr, toQuotedExpr, toRemoteDb, toSQLParameterString, toSQLString, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

CrossTabQuery

public CrossTabQuery(java.lang.String name,
                     java.util.List<Query.Row> rows,
                     int objectId)

Method Detail

getTransformRow

protected Query.Row getTransformRow()

getColumnRows

protected java.util.List<Query.Row> getColumnRows()

Overrides:

getColumnRows in class Query

getGroupByRows

protected java.util.List<Query.Row> getGroupByRows()

Overrides:

getGroupByRows in class Query

getPivotRow

protected Query.Row getPivotRow()

getTransformExpression

public java.lang.String getTransformExpression()

getPivotExpression

public java.lang.String getPivotExpression()

toSQLString

protected void toSQLString(java.lang.StringBuilder builder)

Specified by:

toSQLString in class Query