com.healthmarketscience.jackcess.impl.query

Class QueryImpl

java.lang.Object

com.healthmarketscience.jackcess.impl.query.QueryImpl

All Implemented Interfaces:

Query

Direct Known Subclasses:

BaseSelectQueryImpl, DataDefinitionQueryImpl, PassthroughQueryImpl, QueryImpl.UnknownQueryImpl, UnionQueryImpl, UpdateQueryImpl

public abstract class QueryImpl
extends java.lang.Object
implements Query

Base class for classes which encapsulate information about an Access query. The toSQLString() method can be used to convert this object into the actual SQL string which this query data represents.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected static class	QueryImpl.AppendableList<E>
private static class	QueryImpl.Join
static class	QueryImpl.Row Struct containing the information from a single row of the system query table.
protected static class	QueryImpl.RowFilter
protected static class	QueryImpl.RowFormatter
private static class	QueryImpl.UnknownQueryImpl

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

Query.Type

Field Summary

Fields

Modifier and Type	Field and Description
private java.lang.String	_name
private int	_objectFlag
private int	_objectId
private java.util.List<QueryImpl.Row>	_rows
private Query.Type	_type
private static QueryImpl.Row	EMPTY_ROW
protected static org.apache.commons.logging.Log	LOG

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	QueryImpl(java.lang.String name, java.util.List<QueryImpl.Row> rows, int objectId, int objectFlag, Query.Type type)

Method Summary

Modifier and Type	Method and Description
private java.util.Collection<java.util.List<QueryImpl.Row>>	combineJoins(java.util.List<QueryImpl.Row> joins)
static QueryImpl	create(int objectFlag, java.lang.String name, java.util.List<QueryImpl.Row> rows, int objectId) Creates a concrete Query instance from the given query data.
protected static java.util.List<QueryImpl.Row>	filterRowsByFlag(java.util.List<QueryImpl.Row> rows, short flag)
protected static java.util.List<QueryImpl.Row>	filterRowsByNotFlag(java.util.List<QueryImpl.Row> rows, short flag)
protected java.util.List<QueryImpl.Row>	getColumnRows()
protected QueryImpl.Row	getFlagRow()
protected java.lang.String	getFromRemoteDbPath()
protected java.lang.String	getFromRemoteDbType()
protected java.util.List<java.lang.String>	getFromTables()
protected java.util.List<QueryImpl.Row>	getGroupByRows()
protected QueryImpl.Row	getHavingRow()
protected static int	getIntValue(java.lang.Integer i, int def)
private QueryImpl.Join	getJoinExpr(java.lang.String table, java.util.List<QueryImpl.Join> joinExprs)
protected java.util.List<QueryImpl.Row>	getJoinRows()
java.lang.String	getName() Returns the name of the query.
int	getObjectFlag()
int	getObjectId() Returns the unique object id of the query.
protected java.util.List<QueryImpl.Row>	getOrderByRows()
protected java.util.List<java.lang.String>	getOrderings()
java.lang.String	getOwnerAccessType()
protected java.util.List<QueryImpl.Row>	getParameterRows()
java.util.List<java.lang.String>	getParameters() Returns the rows from the system query table from which the query information was derived.
private java.lang.Short	getQueryType(java.util.List<QueryImpl.Row> rows)
protected QueryImpl.Row	getRemoteDatabaseRow()
protected QueryImpl.Row	getRowByAttribute(java.lang.Byte attribute)
java.util.List<QueryImpl.Row>	getRows() Returns the rows from the system query table from which the query information was derived.
protected java.util.List<QueryImpl.Row>	getRowsByAttribute(java.lang.Byte attribute)
private static java.util.List<QueryImpl.Row>	getRowsByAttribute(java.util.List<QueryImpl.Row> rows, java.lang.Byte attribute)
protected static short	getShortValue(java.lang.Short s, int def)
protected java.util.List<QueryImpl.Row>	getTableRows()
Query.Type	getType() Returns the type of the query.
QueryImpl.Row	getTypeRow()
protected QueryImpl.Row	getUniqueRow(java.util.List<QueryImpl.Row> rows)
protected java.lang.String	getWhereExpression()
protected QueryImpl.Row	getWhereRow()
protected boolean	hasFlag(int flagMask)
protected static boolean	hasFlag(QueryImpl.Row row, int flagMask)
boolean	isHidden() Whether or not this query has been marked as hidden.
protected static boolean	isQuoted(java.lang.String expr)
protected boolean	supportsStandardClauses()
protected static java.lang.StringBuilder	toAlias(java.lang.StringBuilder builder, java.lang.String alias)
protected static java.lang.StringBuilder	toOptionalQuotedExpr(java.lang.StringBuilder builder, java.lang.String fullExpr, boolean isIdentifier)
protected static java.lang.StringBuilder	toQuotedExpr(java.lang.StringBuilder builder, java.lang.String expr)
protected static java.lang.StringBuilder	toRemoteDb(java.lang.StringBuilder builder, java.lang.String remoteDbPath, java.lang.String remoteDbType)
protected void	toSQLParameterString(java.lang.StringBuilder builder)
java.lang.String	toSQLString() Returns the actual SQL string which this query data represents.
protected abstract void	toSQLString(java.lang.StringBuilder builder)
java.lang.String	toString()
private java.lang.String	withErrorContext(java.lang.String msg)
private static java.lang.String	withErrorContext(java.lang.String msg, java.lang.String queryName)

Methods inherited from class java.lang.Object

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

Field Detail

LOG

protected static final org.apache.commons.logging.Log LOG

EMPTY_ROW

private static final QueryImpl.Row EMPTY_ROW

_name

private final java.lang.String _name

_rows

private final java.util.List<QueryImpl.Row> _rows

_objectId

private final int _objectId

_type

private final Query.Type _type

_objectFlag

private final int _objectFlag

Constructor Detail

QueryImpl

protected QueryImpl(java.lang.String name,
                    java.util.List<QueryImpl.Row> rows,
                    int objectId,
                    int objectFlag,
                    Query.Type type)

Method Detail

getName

public java.lang.String getName()

Returns the name of the query.

Specified by:

getName in interface Query

getType

public Query.Type getType()

Returns the type of the query.

Specified by:

getType in interface Query

isHidden

public boolean isHidden()

Description copied from interface: Query

Whether or not this query has been marked as hidden.

Specified by:

isHidden in interface Query

getObjectId

public int getObjectId()

Returns the unique object id of the query.

Specified by:

getObjectId in interface Query

getObjectFlag

public int getObjectFlag()

Specified by:

getObjectFlag in interface Query

getRows

public java.util.List<QueryImpl.Row> getRows()

Returns the rows from the system query table from which the query information was derived.

getRowsByAttribute

protected java.util.List<QueryImpl.Row> getRowsByAttribute(java.lang.Byte attribute)

getRowByAttribute

protected QueryImpl.Row getRowByAttribute(java.lang.Byte attribute)

getTypeRow

public QueryImpl.Row getTypeRow()

getParameterRows

protected java.util.List<QueryImpl.Row> getParameterRows()

getFlagRow

protected QueryImpl.Row getFlagRow()

getRemoteDatabaseRow

protected QueryImpl.Row getRemoteDatabaseRow()

getTableRows

protected java.util.List<QueryImpl.Row> getTableRows()

getColumnRows

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

getJoinRows

protected java.util.List<QueryImpl.Row> getJoinRows()

getWhereRow

protected QueryImpl.Row getWhereRow()

getGroupByRows

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

getHavingRow

protected QueryImpl.Row getHavingRow()

getOrderByRows

protected java.util.List<QueryImpl.Row> getOrderByRows()

toSQLString

protected abstract void toSQLString(java.lang.StringBuilder builder)

toSQLParameterString

protected void toSQLParameterString(java.lang.StringBuilder builder)

getParameters

public java.util.List<java.lang.String> getParameters()

Description copied from interface: Query

Returns the rows from the system query table from which the query information was derived.

Specified by:

getParameters in interface Query

getFromTables

protected java.util.List<java.lang.String> getFromTables()

getJoinExpr

private QueryImpl.Join getJoinExpr(java.lang.String table,
                                   java.util.List<QueryImpl.Join> joinExprs)

combineJoins

private java.util.Collection<java.util.List<QueryImpl.Row>> combineJoins(java.util.List<QueryImpl.Row> joins)

getFromRemoteDbPath

protected java.lang.String getFromRemoteDbPath()

getFromRemoteDbType

protected java.lang.String getFromRemoteDbType()

getWhereExpression

protected java.lang.String getWhereExpression()

getOrderings

protected java.util.List<java.lang.String> getOrderings()

getOwnerAccessType

public java.lang.String getOwnerAccessType()

Specified by:

getOwnerAccessType in interface Query

hasFlag

protected boolean hasFlag(int flagMask)

supportsStandardClauses

protected boolean supportsStandardClauses()

toSQLString

public java.lang.String toSQLString()

Returns the actual SQL string which this query data represents.

Specified by:

toSQLString in interface Query

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

create

public static QueryImpl create(int objectFlag,
                               java.lang.String name,
                               java.util.List<QueryImpl.Row> rows,
                               int objectId)

Creates a concrete Query instance from the given query data.

Parameters:

objectFlag - the flag indicating the type of the query

name - the name of the query

rows - the rows from the system query table containing the data describing this query

objectId - the unique object id of this query

Returns:

a Query instance for the given query data

getQueryType

private java.lang.Short getQueryType(java.util.List<QueryImpl.Row> rows)

getRowsByAttribute

private static java.util.List<QueryImpl.Row> getRowsByAttribute(java.util.List<QueryImpl.Row> rows,
                                                                java.lang.Byte attribute)

getUniqueRow

protected QueryImpl.Row getUniqueRow(java.util.List<QueryImpl.Row> rows)

filterRowsByFlag

protected static java.util.List<QueryImpl.Row> filterRowsByFlag(java.util.List<QueryImpl.Row> rows,
                                                                short flag)

filterRowsByNotFlag

protected static java.util.List<QueryImpl.Row> filterRowsByNotFlag(java.util.List<QueryImpl.Row> rows,
                                                                   short flag)

hasFlag

protected static boolean hasFlag(QueryImpl.Row row,
                                 int flagMask)

getShortValue

protected static short getShortValue(java.lang.Short s,
                                     int def)

getIntValue

protected static int getIntValue(java.lang.Integer i,
                                 int def)

toOptionalQuotedExpr

protected static java.lang.StringBuilder toOptionalQuotedExpr(java.lang.StringBuilder builder,
                                                              java.lang.String fullExpr,
                                                              boolean isIdentifier)

toQuotedExpr

protected static java.lang.StringBuilder toQuotedExpr(java.lang.StringBuilder builder,
                                                      java.lang.String expr)

isQuoted

protected static boolean isQuoted(java.lang.String expr)

toRemoteDb

protected static java.lang.StringBuilder toRemoteDb(java.lang.StringBuilder builder,
                                                    java.lang.String remoteDbPath,
                                                    java.lang.String remoteDbType)

toAlias

protected static java.lang.StringBuilder toAlias(java.lang.StringBuilder builder,
                                                 java.lang.String alias)

withErrorContext

private java.lang.String withErrorContext(java.lang.String msg)

withErrorContext

private static java.lang.String withErrorContext(java.lang.String msg,
                                                 java.lang.String queryName)