com.healthmarketscience.sqlbuilder

Class BaseCTEQuery<ThisType extends BaseCTEQuery<ThisType>>

java.lang.Object

com.healthmarketscience.common.util.AppendeeObject

com.healthmarketscience.sqlbuilder.SqlObject

com.healthmarketscience.sqlbuilder.CustomizableSqlObject

com.healthmarketscience.sqlbuilder.Query<ThisType>

com.healthmarketscience.sqlbuilder.BaseCTEQuery<ThisType>

All Implemented Interfaces:

Appendee, Verifiable<ThisType>

Direct Known Subclasses:

DeleteQuery, InsertQuery, InsertSelectQuery, SelectQuery, UpdateQuery

public abstract class BaseCTEQuery<ThisType extends BaseCTEQuery<ThisType>>
extends Query<ThisType>

Base class for all queries which support common table expressions (the "WITH " clause). Note that CTEs are defined in "SQL 99".

Author:

James Ahlborn

Field Summary

Fields inherited from class com.healthmarketscience.sqlbuilder.SqlObject

ALL_SYMBOL, NULL_VALUE, QUESTION_MARK

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	BaseCTEQuery()

Method Summary

Modifier and Type	Method and Description
ThisType	addCommonTableExpression(Object cteObj) Adds the given common table expression to this query.
protected void	collectSchemaObjects(ValidationContext vContext) Used during Query.validate() calls to collect the dbschema objects referenced in a query.
protected void	prependTo(AppendableExt app) Called by Query.appendTo(AppendableExt) before Query.appendTo(AppendableExt,SqlContext) within the original SqlContext.
ThisType	setRecursive(boolean recursive)

Methods inherited from class com.healthmarketscience.sqlbuilder.Query

appendTo, appendTo, getThisType, validate, validate, validateTables

Methods inherited from class com.healthmarketscience.sqlbuilder.CustomizableSqlObject

addCustomization, customAppendTo, customAppendTo, maybeAppendTo, maybeAppendTo

Methods inherited from class com.healthmarketscience.sqlbuilder.SqlObject

collectSchemaObjects, doValidate, toString

Methods inherited from class com.healthmarketscience.common.util.AppendeeObject

toString, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

BaseCTEQuery

protected BaseCTEQuery()

Method Detail

setRecursive

public ThisType setRecursive(boolean recursive)

addCommonTableExpression

public ThisType addCommonTableExpression(Object cteObj)

Adds the given common table expression to this query. Object -> SqlObject conversions handled by Converter.toCustomSqlObject(Object).

collectSchemaObjects

protected void collectSchemaObjects(ValidationContext vContext)

Description copied from class: SqlObject

Used during Query.validate() calls to collect the dbschema objects referenced in a query. Any subclass of this class should add all referenced tables and columns to the appropriate collections.

Overrides:

collectSchemaObjects in class Query<ThisType extends BaseCTEQuery<ThisType>>

Parameters:

vContext - handle to the current validation context

prependTo

protected void prependTo(AppendableExt app)
                  throws IOException

Description copied from class: Query

Called by Query.appendTo(AppendableExt) before Query.appendTo(AppendableExt,SqlContext) within the original SqlContext.

Overrides:

prependTo in class Query<ThisType extends BaseCTEQuery<ThisType>>

Throws:

IOException