com.healthmarketscience.jackcess.impl.query

Class CrossTabQueryImpl

java.lang.Object

com.healthmarketscience.jackcess.impl.query.QueryImpl

com.healthmarketscience.jackcess.impl.query.BaseSelectQueryImpl

com.healthmarketscience.jackcess.impl.query.CrossTabQueryImpl

All Implemented Interfaces:

BaseSelectQuery, CrossTabQuery, Query

public class CrossTabQueryImpl
extends BaseSelectQueryImpl
implements CrossTabQuery

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

Author:

James Ahlborn

Nested Class Summary

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

QueryImpl.AppendableList<E>, QueryImpl.Row, QueryImpl.RowFilter, QueryImpl.RowFormatter

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

Query.Type

Field Summary

Fields inherited from class com.healthmarketscience.jackcess.impl.query.QueryImpl

LOG

Constructor Summary

Constructors

Constructor and Description
CrossTabQueryImpl(String name, List<QueryImpl.Row> rows, int objectId, int objectFlag)

Method Summary

Modifier and Type	Method and Description
protected List<QueryImpl.Row>	getColumnRows()
protected List<QueryImpl.Row>	getGroupByRows()
String	getPivotExpression()
protected QueryImpl.Row	getPivotRow()
String	getTransformExpression()
protected QueryImpl.Row	getTransformRow()
protected void	toSQLString(StringBuilder builder)

Methods inherited from class com.healthmarketscience.jackcess.impl.query.BaseSelectQueryImpl

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

Methods inherited from class com.healthmarketscience.jackcess.impl.query.QueryImpl

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, isHidden, isQuoted, 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

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

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

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

getName, getObjectFlag, getObjectId, getOwnerAccessType, getParameters, getType, isHidden, toSQLString

Constructor Detail

CrossTabQueryImpl

public CrossTabQueryImpl(String name,
                         List<QueryImpl.Row> rows,
                         int objectId,
                         int objectFlag)

Method Detail

getTransformRow

protected QueryImpl.Row getTransformRow()

getColumnRows

protected List<QueryImpl.Row> getColumnRows()

Overrides:

getColumnRows in class QueryImpl

getGroupByRows

protected List<QueryImpl.Row> getGroupByRows()

Overrides:

getGroupByRows in class QueryImpl

getPivotRow

protected QueryImpl.Row getPivotRow()

getTransformExpression

public String getTransformExpression()

Specified by:

getTransformExpression in interface CrossTabQuery

getPivotExpression

public String getPivotExpression()

Specified by:

getPivotExpression in interface CrossTabQuery

toSQLString

protected void toSQLString(StringBuilder builder)

Specified by:

toSQLString in class QueryImpl