Index (SQL Query Builders 3.0.2 API)

A B C D E F G H I J L M N O P Q R S T U V W _

A

add() - Static method in class com.healthmarketscience.sqlbuilder.ComboExpression: Convenience method for generating a ComboExpression for joining expressions using '+'.
add(Object...) - Static method in class com.healthmarketscience.sqlbuilder.ComboExpression: Convenience method for generating a ComboExpression for joining the given expressions using '+'.
add() - Static method in class com.healthmarketscience.sqlbuilder.Expressions: Convenience method for generating a ComboExpression for joining expressions using '+'.
add(Object...) - Static method in class com.healthmarketscience.sqlbuilder.Expressions: Convenience method for generating a ComboExpression for joining the given expressions using '+'.
addAliasedColumn(Object, String) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds the given column with the given alias to the SELECT column list.
addAllColumns() - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds the ALL_SYMBOL to the select column list.
addAllTableColumns(Table) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds a "<alias>.*" column to the select column list.
addColumn(String) - Method in class com.healthmarketscience.sqlbuilder.CommonTableExpression: Adds a new column with the given name to this CTE and returns the pseudo Column instane.
addColumn(Column, CreateTableQuery.ColumnConstraint) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery: Deprecated.
use ConstraintClause instead of ColumnConstraint
addColumn(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable: Creates and adds an untyped column with the given name to this table.
addColumn(String, String, Integer) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable: Creates and adds an typed column with the given parameters to this table.
addColumn(String, String, Integer, Integer) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable: Creates and adds an typed column with the given parameters to this table.
addColumn(String, int, Integer) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable: Creates and adds an typed column with the given parameters to this table.
addColumn(String, int, Integer, Integer) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable: Creates and adds an typed column with the given parameters to this table.
addColumn(T) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable: Adds the given column to this table.
addColumn(Column, Object) - Method in class com.healthmarketscience.sqlbuilder.InsertQuery: Adds the given column and its corresponding value to the query.
addColumn(Column) - Method in class com.healthmarketscience.sqlbuilder.ValidationContext
AddColumnAction(Object) - Constructor for class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddColumnAction
addColumnConstraint(Column, Object) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery: Adds the constraint on a previously added column
addColumnParams(Column...) - Method in class com.healthmarketscience.sqlbuilder.FunctionCall: Adds column parameters to the function call as "<alias>.<column>".
addColumns(Column...) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddPrimaryConstraintAction: Deprecated.

Adds a column to the primary key constraint definition.
addColumns(Column...) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddUniqueConstraintAction: Deprecated.

Adds a column to the unique constraint definition.
addColumns(Column...) - Method in class com.healthmarketscience.sqlbuilder.BaseCreateQuery: Adds column descriptions for the given Columns.
addColumns(Column...) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery.Privilege: Adds the given columns to the column list.
addColumns(Column...) - Method in class com.healthmarketscience.sqlbuilder.ConstraintClause: Adds a column to the constraint definition.
addColumns(Column...) - Method in class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause
addColumns(Column[], Object[]) - Method in class com.healthmarketscience.sqlbuilder.InsertQuery: Adds the given columns and their corresponding values to the query.
addColumns(Column...) - Method in class com.healthmarketscience.sqlbuilder.InsertSelectQuery: Adds the given columns to the query
addColumns(Column...) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds the given columns to the SELECT column list.
addCommonTableExpression(Object) - Method in class com.healthmarketscience.sqlbuilder.BaseCTEQuery: Adds the given common table expression to this query.
addCondition(Condition) - Method in class com.healthmarketscience.sqlbuilder.CheckConstraintClause: Adds a condition to the condition clause for the CHECK constraint (AND'd with any other conditions).
addCondition(Condition) - Method in class com.healthmarketscience.sqlbuilder.ComboCondition: Adds the given condition to the list of conditions.
addCondition(Condition) - Method in class com.healthmarketscience.sqlbuilder.DeleteQuery: Sets the WHERE clause for the delete query.
addCondition(Condition) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds a condition to the WHERE clause for the select query (AND'd with any other WHERE conditions).
addCondition(Condition) - Method in class com.healthmarketscience.sqlbuilder.UpdateQuery: Sets the WHERE clause for the update query.
addConditions(Condition...) - Method in class com.healthmarketscience.sqlbuilder.ComboCondition: Adds the given conditions to the list of conditions.
addConstraint(Object) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddColumnAction: Adds a constraint to the column specified in this action
addConstraint(T) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn: Adds the given constraint to this column.
addConstraint(T) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable: Adds the given constraint to this table.
AddConstraintAction(Object) - Constructor for class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddConstraintAction
addConstraints(Constraint...) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery: Adds the given Constraints as table constraints.
addCustomColumn(Object, CreateTableQuery.ColumnConstraint) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery: Deprecated.
use ConstraintClause instead of ColumnConstraint
addCustomColumn(Object, Object) - Method in class com.healthmarketscience.sqlbuilder.InsertQuery: Adds the given column and its corresponding value to the query.
addCustomColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddPrimaryConstraintAction: Deprecated.

Adds a custom column to the primary key constraint definition.
addCustomColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddUniqueConstraintAction: Deprecated.

Adds a custom column to the unique constraint definition.
addCustomColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.BaseCreateQuery: Adds the given SqlObjects as column descriptions, according to the subclass type.
addCustomColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery.Privilege: Adds the given columns to the column list.
addCustomColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.ConstraintClause: Adds a custom column to the constraint definition.
addCustomColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.CreateIndexQuery: Adds the given SqlObjects as column descriptions, according to the subclass type.
addCustomColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery: Adds the given Objects as column descriptions, should look like "<column> <type> [<constraint> ...
addCustomColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.CreateViewQuery: Adds the given SqlObjects as column descriptions, according to the subclass type.
addCustomColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause
addCustomColumns(Object[], Object[]) - Method in class com.healthmarketscience.sqlbuilder.InsertQuery: Adds the given columns and their corresponding values to the query.
addCustomColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.InsertSelectQuery: Adds the given columns to the query
addCustomColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds the given columns to the SELECT column list.
addCustomCondition(Object) - Method in class com.healthmarketscience.sqlbuilder.ComboCondition: Adds the given custom condition to the list of conditions.
addCustomConditions(Object...) - Method in class com.healthmarketscience.sqlbuilder.ComboCondition: Adds the given custom conditions to the list of conditions.
addCustomConstraints(Object...) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery: Adds the given Objects as table constraints, should look like "<constraint>".
addCustomFromTable(Object) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds a table to the FROM clause, should not be used with any add*Join methods
addCustomGrantees(Object...) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery: Adds the given custom grantees to the query
addCustomGroupings(Object...) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds the given columns to the "GROUP BY" clause
addCustomization(CreateIndexQuery.Hook, HookType, Object) - Method in class com.healthmarketscience.sqlbuilder.CreateIndexQuery: Adds custom SQL to this query.
addCustomization(CustomSyntax) - Method in class com.healthmarketscience.sqlbuilder.CreateIndexQuery: Adds custom SQL to this query.
addCustomization(CreateTableQuery.Hook, HookType, Object) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery: Adds custom SQL to this query.
addCustomization(CustomSyntax) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery: Adds custom SQL to this query.
addCustomization(HookAnchor, HookType, Object) - Method in class com.healthmarketscience.sqlbuilder.CustomizableSqlObject: Adds a new customization to this object.
addCustomization(SelectQuery.Hook, HookType, Object) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds custom SQL to this query.
addCustomization(CustomSyntax) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds custom SQL to this query.
addCustomJoin(Object) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds a custom join string.
addCustomJoin(SelectQuery.JoinType, Object, Object, Condition) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds a join of the given type from fromTableStr to toTableStr on joinCond of the given join type.
addCustomOrdering(Object, OrderObject.Dir) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds the given column with the given direction to the "ORDER BY" clause
addCustomOrdering(Object, OrderObject.Dir) - Method in class com.healthmarketscience.sqlbuilder.SetOperationQuery: Adds the given column with the given direction to the "ORDER BY" clause
addCustomOrderings(Object...) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds the given columns to the "ORDER BY" clause
addCustomOrderings(Object...) - Method in class com.healthmarketscience.sqlbuilder.SetOperationQuery: Adds the given columns to the "ORDER BY" clause
addCustomParams(Object...) - Method in class com.healthmarketscience.sqlbuilder.FunctionCall: Adds custom parameters to the function call.
addCustomPreparedColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.InsertQuery: Adds the given columns and an equal number of QUESTION_MARK values to the query.
addCustomPrimaryKeyReference(Object) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddForeignConstraintAction: Deprecated.

Adds col as a reference to the primary key in the referenced table.
addCustomPrivileges(Object...) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery: Adds the given privileges to the query.
addCustomRefColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause: Adds a custom referenced column to the foreign key constraint definition.
addCustomReference(Object, Object) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddForeignConstraintAction: Deprecated.

Adds col as a reference to referencedCol in the referenced table.
addCustomSetClause(Object, Object) - Method in class com.healthmarketscience.sqlbuilder.UpdateQuery: Adds the given column and new value to the SET clause list.
addCustomWhen(Object, Object) - Method in class com.healthmarketscience.sqlbuilder.BaseCaseStatement: Adds a "WHEN" clause to the "CASE" statement.
addDefaultFunctionPackage() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema: Creates and adds a package with no name to this spec (often referred to as the default package).
addDefaultSchema() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec: Creates and adds a schema with no name to this spec (often referred to as the default schema).
addElse(Object) - Method in class com.healthmarketscience.sqlbuilder.BaseCaseStatement: Adds an "ELSE" clause to the "CASE" statement.
addElseNull() - Method in class com.healthmarketscience.sqlbuilder.BaseCaseStatement: Adds an "ELSE NULL" clause to the "CASE" statement.
addExpression(Object) - Method in class com.healthmarketscience.sqlbuilder.ComboExpression: Adds the given expression to the list of expression (wrapped appropriately).
addExpressions(Object...) - Method in class com.healthmarketscience.sqlbuilder.ComboExpression: Adds the given expressions to the list of expressions (wrapped appropriately).
AddForeignConstraintAction(Table) - Constructor for class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddForeignConstraintAction: Deprecated.

Creates a new AlterTableQuery.AddForeignConstraintAction which references the given Table.
AddForeignConstraintAction(Object) - Constructor for class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddForeignConstraintAction: Deprecated.

Creates a new AlterTableQuery.AddForeignConstraintAction which references the given Table.
addFromTable(Table) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds a table to the FROM clause, should not be used with any add*Join methods
addFunction(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbFunctionPackage: Creates and adds a function with the given name to this package.
addFunction(T) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbFunctionPackage: Adds the given function to this package.
addFunctionPackage(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema: Creates and adds a package with the given name to this spec.
addFunctionPackage(T) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema: Adds the given functionPackage to this schema.
addGrantees(String...) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery: Adds the given grantees to the query
addGroupings(Column...) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds the given columns to the "GROUP BY" clause
addHaving(Condition) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds a condition to the HAVING clause for the select query (AND'd with any other HAVING conditions).
addIndex(String, String, String...) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema: Creates and adds a index with the given parameters to this schema.
addIndex(T) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema: Adds the given index to this schema.
addIndex(int) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.MultiPlaceHolder
addIndex(int) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder
addIndex(int) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column
addIndexedOrdering(Integer, OrderObject.Dir) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds the given column index with the given direction to the "ORDER BY" clause
addIndexedOrdering(Integer, OrderObject.Dir) - Method in class com.healthmarketscience.sqlbuilder.SetOperationQuery: Adds the given column index with the given direction to the "ORDER BY" clause
addIndexedOrderings(Integer...) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds the given column index to the "ORDER BY" clause
addIndexedOrderings(Integer...) - Method in class com.healthmarketscience.sqlbuilder.SetOperationQuery: Adds the given column index to the "ORDER BY" clause
addJoin(String, String, String, String, String...) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec: Creates and adds a join with the given parameters to this spec.
addJoin(String, String, String, String, String[], String[]) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec: Creates and adds a join with the given parameters to this spec.
addJoin(T) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec: Adds the given join to this schema.
addJoin(SelectQuery.JoinType, Table, Table, Condition) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds a join of the given type from fromTable to toTable on joinCond of the given join type.
addJoin(SelectQuery.JoinType, Table, Table, List<? extends Column>, List<? extends Column>) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds a join of the given type from fromTable to toTable with a join condition requiring each column in fromColumns to equal the corresponding column in toColumns.
addJoin(SelectQuery.JoinType, Table, Table, Column, Column) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds a join of the given type from fromTable to toTable with a join condition requiring fromColumn to equal toColumn.
addJoins(SelectQuery.JoinType, Join...) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds all of the joins of the given join type where each join is from join.getFromTable() to join.getToTable() with a join condition requiring each column in join.getFromColumns() to equal the corresponding column in join.getToColumns().
addNewMultiPlaceHolder() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds a new MultiPlaceHolder to this list and returns it.
addNewPlaceHolder() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds a new PlaceHolder to this list and returns it.
addNumericValueParam(Object) - Method in class com.healthmarketscience.sqlbuilder.FunctionCall: Adds a numeric value parameter to the function call.
addNumericWhen(Object, Object) - Method in class com.healthmarketscience.sqlbuilder.SimpleCaseStatement: Adds a "WHEN" clause to the "CASE" statement.
addObject(Object) - Method in class com.healthmarketscience.sqlbuilder.InCondition: Adds the given object to the tested value.
addObject(ObjType) - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList: Adds the given object to the list
addObjects(Collection<T>, DbObject<?>, T...) - Static method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbObject: Adds the given objects to the given collection after verifying that they are owned by the given parent.
addObjects(Object...) - Method in class com.healthmarketscience.sqlbuilder.InCondition: Adds the given objects to the tested values.
addObjects(ObjType...) - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList: Adds the given objects to the list
addObjects(Iterable<? extends ObjType>) - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList: Adds the given objects to the list
addObjects(Converter<SrcType, DstType>, SrcType...) - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList: Adds the given objects to the list after converting each of them using the given converter.
addObjects(Converter<SrcType, DstType>, Iterable<? extends SrcType>) - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList: Adds the given objects to the list after converting each of them using the given converter.
addOrdering(Column, OrderObject.Dir) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds the given column with the given direction to the "ORDER BY" clause
addOrdering(Column, OrderObject.Dir) - Method in class com.healthmarketscience.sqlbuilder.SetOperationQuery: Adds the given column with the given direction to the "ORDER BY" clause
addOrdering(Object, OrderObject.Dir) - Method in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause: Adds the given column with the given direction to the "ORDER BY" clause
addOrderings(Column...) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds the given columns to the "ORDER BY" clause
addOrderings(Column...) - Method in class com.healthmarketscience.sqlbuilder.SetOperationQuery: Adds the given columns to the "ORDER BY" clause
addOrderings(Object...) - Method in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause: Adds the given columns to the "ORDER BY" clause
addPartitionColumns(Object...) - Method in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause: Adds the given columns to the PARTITION BY column list.
addPlaceHolders(int) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds the given number of PlaceHolders to this list.
addPreparedColumnCollection(Collection<? extends Column>) - Method in class com.healthmarketscience.sqlbuilder.InsertQuery: Adds the given columns and an equal number of QUESTION_MARK values to the query.
addPreparedColumns(Column...) - Method in class com.healthmarketscience.sqlbuilder.InsertQuery: Adds the given columns and an equal number of QUESTION_MARK values to the query.
AddPrimaryConstraintAction() - Constructor for class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddPrimaryConstraintAction: Deprecated.
addPrimaryKeyReference(Column) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddForeignConstraintAction: Deprecated.

Adds col as a reference to the primary key in the referenced table.
addPrivileges(BaseGrantQuery.Privilege...) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery: Adds the given privileges to the query.
addQueries(SelectQuery...) - Method in class com.healthmarketscience.sqlbuilder.SetOperationQuery: Adds the given queries to the list of queries with the default set operation type (the one configured in the constructor).
addQueries(SetOperationQuery.Type, SelectQuery...) - Method in class com.healthmarketscience.sqlbuilder.SetOperationQuery: Adds the given queries to the list of queries with the given set operation type.
addQueries(Object...) - Method in class com.healthmarketscience.sqlbuilder.SetOperationQuery: Adds the given queries to the list of queries with the default set operation type (the one configured in the constructor).
addQueries(SetOperationQuery.Type, Object...) - Method in class com.healthmarketscience.sqlbuilder.SetOperationQuery: Adds the given queries to the list of queries with the given set operation type.
addRefColumns(Column...) - Method in class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause: Adds a referenced column to the foreign key constraint definition.
addReference(Column, Column) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddForeignConstraintAction: Deprecated.

Adds col as a reference to referencedCol in the referenced table.
addSchema(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec: Creates and adds a schema with the given name to this spec.
addSchema(T) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec: Adds the given schema to this schema.
addSetClause(Column, Object) - Method in class com.healthmarketscience.sqlbuilder.UpdateQuery: Adds the given column and new value to the SET clause list.
addStaticBooleans(boolean...) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds StaticPlaceHolders for the given boolean values.
addStaticBooleans(Iterable<? extends Boolean>) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds StaticPlaceHolders for the given Boolean values.
addStaticIntegers(int...) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds StaticPlaceHolders for the given int values.
addStaticIntegers(Iterable<? extends Integer>) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds StaticPlaceHolders for the given Integer values.
addStaticLongs(long...) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds StaticPlaceHolders for the given long values.
addStaticLongs(Iterable<? extends Long>) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds StaticPlaceHolders for the given Long values.
addStaticObjects(Object...) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds StaticPlaceHolders for the given Object values.
addStaticObjects(Iterable<?>) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds StaticPlaceHolders for the given Object values.
addStaticObjects(int, Object...) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds StaticPlaceHolders for the given Object values and given sql type.
addStaticObjects(int, Iterable<?>) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds StaticPlaceHolders for the given Object values and given sql type.
addStaticPlaceHolder(String) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer
addStaticPlaceHolder(Long) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer
addStaticPlaceHolder(Integer) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer
addStaticPlaceHolder(Boolean) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer
addStaticPlaceHolder(long) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer
addStaticPlaceHolder(int) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer
addStaticPlaceHolder(boolean) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer
addStaticPlaceHolder(Object) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer
addStaticPlaceHolder(Object, int) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer
addStaticPlaceHolder(QueryPreparer.StaticPlaceHolder) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer: Adds a new StaticPlaceHolder to the list maintained by this class
addStaticPlaceHolder(QueryPreparer.StaticPlaceHolder) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds the given StaticPlaceHolder to this list and returns it.
addStaticStrings(String...) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds StaticPlaceHolders for the given String values.
addStaticStrings(Iterable<? extends String>) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder: Adds StaticPlaceHolders for the given String values.
addTable(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema: Creates and adds a table with the given name to this schema.
addTable(T) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema: Adds the given table to this schema.
addTable(Table) - Method in class com.healthmarketscience.sqlbuilder.ValidationContext
AddUniqueConstraintAction() - Constructor for class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddUniqueConstraintAction: Deprecated.
addVerifiable(Verifiable<?>) - Method in class com.healthmarketscience.sqlbuilder.ValidationContext
addWhen(Condition, Object) - Method in class com.healthmarketscience.sqlbuilder.CaseStatement: Adds a "WHEN" clause to the "CASE" statement.
addWhen(String, Object) - Method in class com.healthmarketscience.sqlbuilder.SimpleCaseStatement: Adds a "WHEN" clause to the "CASE" statement.
addWindowDefinition(String, Object) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery: Adds a named window definition to the select query's WINDOW definitions
AliasedObject - Class in com.healthmarketscience.sqlbuilder: Outputs the given object with a column alias "<obj> AS <alias>".
AliasedObject(SqlObject, String) - Constructor for class com.healthmarketscience.sqlbuilder.AliasedObject
ALL_SYMBOL - Static variable in class com.healthmarketscience.sqlbuilder.SqlObject: SqlObject which represents a * string for generating "SELECT *" statements.
AlterTableQuery - Class in com.healthmarketscience.sqlbuilder: Query which generates an ALTER TABLE statement.
AlterTableQuery(Table) - Constructor for class com.healthmarketscience.sqlbuilder.AlterTableQuery
AlterTableQuery(Object) - Constructor for class com.healthmarketscience.sqlbuilder.AlterTableQuery: Object -> SqlObject conversions handled by Converter.toCustomTableSqlObject(Object).
AlterTableQuery.AddColumnAction - Class in com.healthmarketscience.sqlbuilder: "Action" for adding a column to a table., e.g.
AlterTableQuery.AddConstraintAction - Class in com.healthmarketscience.sqlbuilder: Base "Action" for adding a constraint to a table., e.g.
AlterTableQuery.AddForeignConstraintAction - Class in com.healthmarketscience.sqlbuilder: Deprecated.
use AddConstraintAction instead
AlterTableQuery.AddPrimaryConstraintAction - Class in com.healthmarketscience.sqlbuilder: Deprecated.
use AddConstraintAction instead
AlterTableQuery.AddUniqueConstraintAction - Class in com.healthmarketscience.sqlbuilder: Deprecated.
use AddConstraintAction instead
and() - Static method in class com.healthmarketscience.sqlbuilder.ComboCondition: Convenience method for generating a ComboCondition for joining conditions using AND.
and(Condition...) - Static method in class com.healthmarketscience.sqlbuilder.ComboCondition: Convenience method for generating a ComboCondition for joining the given conditions using AND.
and(Object...) - Static method in class com.healthmarketscience.sqlbuilder.ComboCondition: Convenience method for generating a ComboCondition for joining the given custom conditions using AND.
and() - Static method in class com.healthmarketscience.sqlbuilder.Conditions: Convenience method for generating a ComboCondition for joining conditions using AND.
and(Condition...) - Static method in class com.healthmarketscience.sqlbuilder.Conditions: Convenience method for generating a ComboCondition for joining the given conditions using AND.
and(Object...) - Static method in class com.healthmarketscience.sqlbuilder.Conditions: Convenience method for generating a ComboCondition for joining the given custom conditions using AND.
append(char) - Method in class com.healthmarketscience.common.util.AppendableExt
append(CharSequence) - Method in class com.healthmarketscience.common.util.AppendableExt
append(CharSequence, int, int) - Method in class com.healthmarketscience.common.util.AppendableExt
append(Appendee) - Method in class com.healthmarketscience.common.util.AppendableExt: Will call the appendTo() method on the given object.
append(Object) - Method in class com.healthmarketscience.common.util.AppendableExt: Will call append(String.valueOf(o)) with the given object (unless the object is an Appendee or CharSequence in which case it will be passed to the appropriate method).
append(Iterable<?>, Object) - Method in class com.healthmarketscience.common.util.AppendableExt: Will iterate the given Iterable and append each object separated by the given delimiter.
append(char) - Method in class com.healthmarketscience.common.util.StringAppendableExt
append(CharSequence) - Method in class com.healthmarketscience.common.util.StringAppendableExt
append(CharSequence, int, int) - Method in class com.healthmarketscience.common.util.StringAppendableExt
append(Appendee) - Method in class com.healthmarketscience.common.util.StringAppendableExt
append(Object) - Method in class com.healthmarketscience.common.util.StringAppendableExt
append(Iterable<?>, Object) - Method in class com.healthmarketscience.common.util.StringAppendableExt
AppendableExt - Class in com.healthmarketscience.common.util: Wrapper for an Appendable which adds the ability for objects to append themselves directly to the given Appendable instead of creating intermediate CharSequence objects (Strings, etc).
AppendableExt(Appendable) - Constructor for class com.healthmarketscience.common.util.AppendableExt: Initialize a new AppendableExt based on the given Appendable.
AppendableExt(Appendable, Object) - Constructor for class com.healthmarketscience.common.util.AppendableExt: Initialize a new AppendableExt based on the given Appendable and context.
Appendee - Interface in com.healthmarketscience.common.util: Should be implemented by an object which can append itself to an AppendableExt object, where the work of generating a result for toString() would itself involve the appending of multiple CharSequences (Strings, etc).
AppendeeObject - Class in com.healthmarketscience.common.util: Simple subclass for objects wishing to use the AppendableExt/Appendee interface in new class hierarchies.
AppendeeObject() - Constructor for class com.healthmarketscience.common.util.AppendeeObject
appendTo(AppendableExt) - Method in interface com.healthmarketscience.common.util.Appendee: Appends this object to the given AppendableExt.
appendTo(AppendableExt) - Method in class com.healthmarketscience.common.util.AppendeeObject
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.AliasedObject
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddColumnAction
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddConstraintAction
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.BaseCaseStatement
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery.Privilege
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery.TargetObject
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.BetweenCondition
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.BinaryCondition
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.BooleanValueObject
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.CheckConstraintClause
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.ComboCondition
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.ComboExpression
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.Comment
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.CommonTableExpression
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.ConstraintClause
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.CreateIndexQuery
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.CreateViewQuery
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.custom.mysql.MysLimitClause
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.custom.NamedParamObject
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.custom.oracle.OraTableSpaceClause
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgLimitClause
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgOffsetClause
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.custom.sqlserver.MssTopClause
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.CustomCondition
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.CustomExpression
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.CustomSql
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.DeleteQuery
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.DropQuery
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.ExtractExpression
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.FunctionCall
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.GrantQuery
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.InCondition
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.InsertQuery
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.InsertSelectQuery
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.JdbcEscape
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.NegateExpression
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.NotCondition
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.NumberValueObject
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.OrderObject
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.Query
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.Query: Appends the sql query to the given AppendableExt within the given, modifiable SqlContext.
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.RevokeQuery
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.SetOperationQuery
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.Subquery
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.UnaryCondition
appendTo(AppendableExt, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.UpdateQuery
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.ValueObject
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause
appendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause.FrameBound
apply(SelectQuery) - Method in class com.healthmarketscience.sqlbuilder.custom.CustomSyntax: Called by SelectQuery.addCustomization(CustomSyntax) to add this custom syntax to the appropriate location in the SelectQuery.
apply(CreateTableQuery) - Method in class com.healthmarketscience.sqlbuilder.custom.CustomSyntax: Called by CreateTableQuery.addCustomization(CustomSyntax) to add this custom syntax to the appropriate location in the CreateTableQuery.
apply(CreateIndexQuery) - Method in class com.healthmarketscience.sqlbuilder.custom.CustomSyntax: Called by CreateIndexQuery.addCustomization(CustomSyntax) to add this custom syntax to the appropriate location in the CreateIndexQuery.
apply(SelectQuery) - Method in class com.healthmarketscience.sqlbuilder.custom.mysql.MysLimitClause
apply(CreateTableQuery) - Method in class com.healthmarketscience.sqlbuilder.custom.oracle.OraTableSpaceClause
apply(CreateIndexQuery) - Method in class com.healthmarketscience.sqlbuilder.custom.oracle.OraTableSpaceClause
apply(SelectQuery) - Method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgLimitClause
apply(SelectQuery) - Method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgOffsetClause
apply(SelectQuery) - Method in class com.healthmarketscience.sqlbuilder.custom.sqlserver.MssTopClause
asc(Object) - Static method in class com.healthmarketscience.sqlbuilder.OrderObject: Convenience method for generating an ascending OrderObject for the given column.
AUTO_INCREMENT_COLUMN - Static variable in class com.healthmarketscience.sqlbuilder.custom.mysql.MysObjects: Appends a MySQL "AUTO_INCREMENT " column constraint.
avg() - Static method in class com.healthmarketscience.sqlbuilder.FunctionCall: Convenience method for generating a FunctionCall using the standard AVG function.





B

BaseCaseStatement<ThisType extends BaseCaseStatement<ThisType>> - Class in com.healthmarketscience.sqlbuilder

Common base class for "CASE ...


BaseCaseStatement(SqlObject) - Constructor for class com.healthmarketscience.sqlbuilder.BaseCaseStatement
 
BaseCreateQuery<ThisType extends BaseCreateQuery<ThisType>> - Class in com.healthmarketscience.sqlbuilder

Query which generates a CREATE statement.

BaseCreateQuery(SqlObject) - Constructor for class com.healthmarketscience.sqlbuilder.BaseCreateQuery
 
BaseCTEQuery<ThisType extends BaseCTEQuery<ThisType>> - Class in com.healthmarketscience.sqlbuilder

Base class for all queries which support common table expressions (the
 "WITH " clause).

BaseCTEQuery() - Constructor for class com.healthmarketscience.sqlbuilder.BaseCTEQuery
 
BaseGrantQuery<ThisType extends BaseGrantQuery<ThisType>> - Class in com.healthmarketscience.sqlbuilder

Base of a query which generates a query for manipulating privileges.

BaseGrantQuery() - Constructor for class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
BaseGrantQuery.Privilege - Class in com.healthmarketscience.sqlbuilder

Encapsulation of a database privilege.

BaseGrantQuery.Privilege.Type - Enum in com.healthmarketscience.sqlbuilder

Enumeration representing the various database privilege types

BaseGrantQuery.TargetObject - Class in com.healthmarketscience.sqlbuilder

Information about the database object upon which a privilege allows (or
 disallows) action.

BaseGrantQuery.TargetObject.Type - Enum in com.healthmarketscience.sqlbuilder

Enumeration representing the types of database objects which have
        privileges for interacting with them.

between(Object, Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a BETWEEN condition..

BetweenCondition - Class in com.healthmarketscience.sqlbuilder

Outputs a "BETWEEN" condition
 "(<column> [NOT] BETWEEN (<rightObj1>, <rightObj2>, ...) )"

BetweenCondition(Object, Object, Object) - Constructor for class com.healthmarketscience.sqlbuilder.BetweenCondition

Column Object -> SqlObject conversions handled by
 Converter.toColumnSqlObject(com.healthmarketscience.sqlbuilder.dbspec.Column).

BinaryCondition - Class in com.healthmarketscience.sqlbuilder

Outputs a binary midfix based condition
 "(<column1> <binaryOp> <column2>)".

BinaryCondition(BinaryCondition.Op, SqlObject, SqlObject) - Constructor for class com.healthmarketscience.sqlbuilder.BinaryCondition
 
BinaryCondition(BinaryCondition.Op, Object, Object) - Constructor for class com.healthmarketscience.sqlbuilder.BinaryCondition

Object -> SqlObject conversions handled by
 Converter.toColumnSqlObject(Object).

BinaryCondition(Object, Object, Object) - Constructor for class com.healthmarketscience.sqlbuilder.BinaryCondition

Object -> SqlObject conversions handled by
 Converter.toColumnSqlObject(Object).

BinaryCondition.Op - Enum in com.healthmarketscience.sqlbuilder

Enum representing the binary midfix operations supported in a SQL
 condition, e.g.

BooleanStaticPlaceHolder(boolean, QueryPreparer) - Constructor for class com.healthmarketscience.sqlbuilder.QueryPreparer.BooleanStaticPlaceHolder
 
BooleanValueObject - Class in com.healthmarketscience.sqlbuilder

By default, outputs a boolean value as a number literal, where true
 == 1 and false == 0.

BooleanValueObject(Object) - Constructor for class com.healthmarketscience.sqlbuilder.BooleanValueObject
 
BooleanValueObject(Boolean) - Constructor for class com.healthmarketscience.sqlbuilder.BooleanValueObject
 
boundedFollowing(int) - Static method in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause.FrameBound
 
boundedPreceding(int) - Static method in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause.FrameBound
 




C

CaseStatement - Class in com.healthmarketscience.sqlbuilder

Outputs a case statement like:
 "CASE WHEN <cond1> THEN <result1> [ WHEN
 <cond2> THEN <result2> WHEN ...


CaseStatement() - Constructor for class com.healthmarketscience.sqlbuilder.CaseStatement
 
caseStmt() - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a CASE statement.

caseStmt(Object) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a simple CASE statement.

checkCondition(Condition) - Static method in class com.healthmarketscience.sqlbuilder.ConstraintClause

Convenience method for generating an unnamed check constraint.

checkCondition(Object, Condition) - Static method in class com.healthmarketscience.sqlbuilder.ConstraintClause

Convenience method for generating a check constraint with the given name.

checkCondition(String, Condition) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Creates and adds check constraint with the given parameters to this
 table.

checkCondition(String, Condition) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable

Creates and adds check constraint with the given parameters to this
 table.

CheckConstraint - Interface in com.healthmarketscience.sqlbuilder.dbspec

Maintains information about a database (table or column) check constraint
 for use with the sqlbuilder utilities.

CheckConstraintClause - Class in com.healthmarketscience.sqlbuilder

Outputs a table or column CHECK constraint like:
 "[CONSTRAINT <name> ] CHECK (<condition>)"

CheckConstraintClause(CheckConstraint) - Constructor for class com.healthmarketscience.sqlbuilder.CheckConstraintClause
 
CheckConstraintClause(Object, Condition) - Constructor for class com.healthmarketscience.sqlbuilder.CheckConstraintClause
 
checkOwnership(T) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbObject
 
checkOwnership(T...) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbObject
 
checkOwnership(T) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec
 
clear() - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList

Removes all objects from the list.

clone() - Method in class com.healthmarketscience.sqlbuilder.SqlContext
 
closeParen(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.InCondition
 
collectNestedQuerySchemaObjects(SqlObject) - Method in class com.healthmarketscience.sqlbuilder.ValidationContext

Handles schema object collection for nested queries.

collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.AliasedObject
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddColumnAction
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddConstraintAction
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.BaseCaseStatement
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.BaseCreateQuery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.BaseCTEQuery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery.Privilege
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery.TargetObject
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.BetweenCondition
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.BinaryCondition
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.BooleanValueObject
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.CheckConstraintClause
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.ComboCondition
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.ComboExpression
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.Comment
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.CommonTableExpression
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.ConstraintClause
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.CreateIndexQuery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.CreateViewQuery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.custom.mysql.MysLimitClause
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.custom.NamedParamObject
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.custom.oracle.OraTableSpaceClause
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgLimitClause
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgOffsetClause
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.custom.sqlserver.MssTopClause
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.CustomCondition
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.CustomExpression
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.CustomizableSqlObject
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.CustomSql
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.DeleteQuery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.DropQuery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.ExtractExpression
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.FunctionCall
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.InCondition
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.InsertQuery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.InsertSelectQuery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.JdbcEscape
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.NegateExpression
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.NotCondition
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.NumberValueObject
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.OrderObject
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.Query
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.SetOperationQuery
 
collectSchemaObjects(SqlObject, ValidationContext) - Static method in class com.healthmarketscience.sqlbuilder.SqlObject

Utility method for classes which may not be in this package to invoke
 SqlObject.collectSchemaObjects(ValidationContext) on a SqlObject.

collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.SqlObject

Used during Query.validate() calls to collect the dbschema objects
 referenced in a query.

collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.Subquery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.UnaryCondition
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.UpdateQuery
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.ValueObject
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause
 
collectSchemaObjects(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause.FrameBound
 
Column - Interface in com.healthmarketscience.sqlbuilder.dbspec

Maintains information about a database column for use with the sqlbuilder
 utilities.

Column(QueryReader) - Constructor for class com.healthmarketscience.sqlbuilder.QueryReader.Column
 
COLUMN_TO_OBJ - Static variable in class com.healthmarketscience.sqlbuilder.Converter

Converter which converts a Column to a ColumnObject.

COLUMN_VALUE_TO_OBJ - Static variable in class com.healthmarketscience.sqlbuilder.Converter

Converter which converts a column value object to a SqlObject using
      Converter.toColumnSqlObject(Object)

com.healthmarketscience.common.util - package com.healthmarketscience.common.util
 
com.healthmarketscience.sqlbuilder - package com.healthmarketscience.sqlbuilder


    Builder-style classes for generating a wide variety of SQL statements (see
    the Syntax Reference for
    the major highlights).

com.healthmarketscience.sqlbuilder.custom - package com.healthmarketscience.sqlbuilder.custom

SqlBuilder supports two types of custom SQL:
 
 Custom values/expressions within existing queries - this type of
     customization can be achieved using the custom SqlObject variants:
     CustomSql, CustomExpression, and CustomCondition.
 Custom clauses added to existing queries - the classes in this package
     (and subpackages) enable this type of customization, read on for
     details.
 

com.healthmarketscience.sqlbuilder.custom.mysql - package com.healthmarketscience.sqlbuilder.custom.mysql

SqlBuilder customizations specific to the MySQL database.

com.healthmarketscience.sqlbuilder.custom.oracle - package com.healthmarketscience.sqlbuilder.custom.oracle

SqlBuilder customizations specific to the Oracle database.

com.healthmarketscience.sqlbuilder.custom.postgresql - package com.healthmarketscience.sqlbuilder.custom.postgresql

SqlBuilder customizations specific to the PostgreSQL database.

com.healthmarketscience.sqlbuilder.custom.sqlserver - package com.healthmarketscience.sqlbuilder.custom.sqlserver

SqlBuilder customizations specific to the SQL Server database.

com.healthmarketscience.sqlbuilder.dbspec - package com.healthmarketscience.sqlbuilder.dbspec


Group of interfaces which simplify the usage of SqlBuilder when multiple
queries will be built over the same collection of database objects.

com.healthmarketscience.sqlbuilder.dbspec.basic - package com.healthmarketscience.sqlbuilder.dbspec.basic


Very basic implementations of the
dbspec interfaces.

ComboCondition - Class in com.healthmarketscience.sqlbuilder

Outputs combination conditions joined by a given string (AND, OR)
 "(<cond1> <comboOp> <cond2> <comboOp> <cond3> ...)".

ComboCondition(ComboCondition.Op) - Constructor for class com.healthmarketscience.sqlbuilder.ComboCondition
 
ComboCondition(ComboCondition.Op, Condition...) - Constructor for class com.healthmarketscience.sqlbuilder.ComboCondition
 
ComboCondition(ComboCondition.Op, Object...) - Constructor for class com.healthmarketscience.sqlbuilder.ComboCondition

Object -> Condition conversions handled by
 Converter.CUSTOM_TO_CONDITION.

ComboCondition(Object, Object...) - Constructor for class com.healthmarketscience.sqlbuilder.ComboCondition

Object -> Condition conversions handled by
 Converter.CUSTOM_TO_CONDITION.

ComboCondition.Op - Enum in com.healthmarketscience.sqlbuilder

Enum representing the combo operations supported in a SQL
 condition, e.g.

ComboExpression - Class in com.healthmarketscience.sqlbuilder

Outputs combination expressions joined by a given mathematical operation (+,
 -, *, /) or string operation (||) "(<expr1> <exprOp> <expr2> <exprOp> <expr3> ...)".

ComboExpression(ComboExpression.Op) - Constructor for class com.healthmarketscience.sqlbuilder.ComboExpression
 
ComboExpression(ComboExpression.Op, Object...) - Constructor for class com.healthmarketscience.sqlbuilder.ComboExpression

Object -> Expression conversions handled by
 Converter.CUSTOM_TO_EXPRESSION.

ComboExpression(Object, Object...) - Constructor for class com.healthmarketscience.sqlbuilder.ComboExpression

Object -> Expression conversions handled by
 Converter.CUSTOM_TO_EXPRESSION.

ComboExpression.Op - Enum in com.healthmarketscience.sqlbuilder

Enum representing the combo mathematical operations supported in a SQL
 expression, e.g.

Comment - Class in com.healthmarketscience.sqlbuilder

Generates a comment, e.g.

Comment(Object) - Constructor for class com.healthmarketscience.sqlbuilder.Comment
 
CommonTableExpression - Class in com.healthmarketscience.sqlbuilder

Outputs the Common Table Expression (CTE) definition as part of a "WITH " clause.

CommonTableExpression(String) - Constructor for class com.healthmarketscience.sqlbuilder.CommonTableExpression
 
concatenate() - Static method in class com.healthmarketscience.sqlbuilder.ComboExpression

Convenience method for generating a ComboExpression for joining
 expressions using '||'.

concatenate(Object...) - Static method in class com.healthmarketscience.sqlbuilder.ComboExpression

Convenience method for generating a ComboExpression for joining
 the given expressions using '||'.

concatenate() - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a ComboExpression for joining
 expressions using '||'.

concatenate(Object...) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a ComboExpression for joining
 the given expressions using '||'.

Condition - Class in com.healthmarketscience.sqlbuilder

An object representing a conditional expression.

Condition() - Constructor for class com.healthmarketscience.sqlbuilder.Condition
 
Conditions - Class in com.healthmarketscience.sqlbuilder

Useful static accessors for building conditions.

Constraint - Interface in com.healthmarketscience.sqlbuilder.dbspec

Maintains information about a database (table or column) constraint for use
 with the sqlbuilder utilities.

Constraint.Type - Enum in com.healthmarketscience.sqlbuilder.dbspec
 
ConstraintClause - Class in com.healthmarketscience.sqlbuilder

Outputs a table or column constraint clause (depending on the current
 context) [ CONSTRAINT <name> ] <type> [ (<col1> ...) ].

ConstraintClause(Constraint) - Constructor for class com.healthmarketscience.sqlbuilder.ConstraintClause
 
ConstraintClause(ConstraintClause.Type, Object) - Constructor for class com.healthmarketscience.sqlbuilder.ConstraintClause
 
ConstraintClause(ConstraintClause.Type, Object, List<?>) - Constructor for class com.healthmarketscience.sqlbuilder.ConstraintClause
 
ConstraintClause.CheckTime - Enum in com.healthmarketscience.sqlbuilder

Enum representing the different times that a constraint can be checked.

ConstraintClause.Type - Enum in com.healthmarketscience.sqlbuilder

Enum representing the types of constraints supported for a column or
 table.

convert(SrcType) - Method in class com.healthmarketscience.sqlbuilder.Converter

Converts the given src object to a SqlObject of the expected type.

Converter<SrcType,DstType> - Class in com.healthmarketscience.sqlbuilder

Class which encapsulates various object to SqlObject conversions.

Converter() - Constructor for class com.healthmarketscience.sqlbuilder.Converter
 
count() - Static method in class com.healthmarketscience.sqlbuilder.FunctionCall

Convenience method for generating a FunctionCall using the standard COUNT
 function.

countAll() - Static method in class com.healthmarketscience.sqlbuilder.FunctionCall

Convenience method for generating a FunctionCall using the standard COUNT
 function with the single parameter '*'.

create() - Static method in class com.healthmarketscience.sqlbuilder.SqlObjectList

Constructs and returns a new SqlObjectList, conveniently allows
 construction without respecifying generic param type.

create(String) - Static method in class com.healthmarketscience.sqlbuilder.SqlObjectList

Constructs and returns a new SqlObjectList, conveniently allows
 construction without respecifying generic param type.

createColumn(DbTable, String, String, Object...) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Creates and returns a new DbColumn with the given parameters.

createColumnCheckConstraint(DbColumn, String, Condition) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Creates and returns a new column DbCheckConstraint with the given
 parameters.

createColumnConstraint(DbColumn, String, Constraint.Type) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Creates and returns a new column DbConstraint with the given
 parameters.

createColumnForeignKeyConstraint(DbColumn, String, DbTable, String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Deprecated.
use DbSpec.createColumnForeignKeyConstraint(DbColumn,String,DbTable,DbColumn) instead


createColumnForeignKeyConstraint(DbColumn, String, DbTable, DbColumn) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Creates and returns a new column DbForeignKeyConstraint with the
 given parameters.

createFunction(DbFunctionPackage, String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Creates and returns a new DbFunction with the given parameters.

createFunctionPackage(DbSchema, String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Creates and returns a new DbFunctionPackage with the given
 parameters.

createIndex(DbTable, String, String...) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Creates and returns a new DbIndex with the given parameters.

CreateIndexQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates a CREATE INDEX statement.

CreateIndexQuery(Index) - Constructor for class com.healthmarketscience.sqlbuilder.CreateIndexQuery
 
CreateIndexQuery(Table, String) - Constructor for class com.healthmarketscience.sqlbuilder.CreateIndexQuery
 
CreateIndexQuery(Table, Object) - Constructor for class com.healthmarketscience.sqlbuilder.CreateIndexQuery
 
CreateIndexQuery(Object, Object) - Constructor for class com.healthmarketscience.sqlbuilder.CreateIndexQuery

Index Object -> SqlObject conversions handled by
 Converter.toCustomIndexSqlObject(Object).

CreateIndexQuery.Hook - Enum in com.healthmarketscience.sqlbuilder

The HookAnchors supported for CREATE INDEX queries.

CreateIndexQuery.IndexType - Enum in com.healthmarketscience.sqlbuilder

Enum which defines the optional index type information.

createJoin(DbTable, DbTable, String[], String[]) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Creates and returns a new DbJoin with the given parameters.

createSchema(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Creates and returns a new DbSchema with the given parameters.

createTable(DbSchema, String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Creates and returns a new DbTable with the given parameters.

createTableCheckConstraint(DbTable, String, Condition) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Creates and returns a new table DbCheckConstraint with the given
 parameters.

createTableConstraint(DbTable, String, Constraint.Type, String...) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Creates and returns a new table DbConstraint with the given
 parameters.

createTableForeignKeyConstraint(DbTable, String, DbTable, String[], String[]) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Deprecated.
use DbSpec.createTableForeignKeyConstraint(DbTable,String,DbTable,DbColumn[],DbColumn[]) instead


createTableForeignKeyConstraint(DbTable, String, DbTable, DbColumn[], DbColumn[]) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

Creates and returns a new table DbForeignKeyConstraint with the
 given parameters.

CreateTableQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates a CREATE TABLE statement.

CreateTableQuery(Table) - Constructor for class com.healthmarketscience.sqlbuilder.CreateTableQuery
 
CreateTableQuery(Table, boolean) - Constructor for class com.healthmarketscience.sqlbuilder.CreateTableQuery

Column -> SqlObject conversions handled by
 Converter.TYPED_COLUMN_TO_OBJ.

CreateTableQuery(Object) - Constructor for class com.healthmarketscience.sqlbuilder.CreateTableQuery

Object -> SqlObject conversions handled by
 Converter.toCustomTableSqlObject(Object).

CreateTableQuery.ColumnConstraint - Enum in com.healthmarketscience.sqlbuilder

Deprecated.
use ConstraintClause instead


CreateTableQuery.Hook - Enum in com.healthmarketscience.sqlbuilder

The HookAnchors supported for CREATE TABLE queries.

CreateTableQuery.TableType - Enum in com.healthmarketscience.sqlbuilder

Enum which defines the optional table type information.

CreateViewQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates a CREATE VIEW statement.

CreateViewQuery(Table) - Constructor for class com.healthmarketscience.sqlbuilder.CreateViewQuery
 
CreateViewQuery(Object) - Constructor for class com.healthmarketscience.sqlbuilder.CreateViewQuery

Object -> SqlObject conversions handled by
 Converter.toCustomTableSqlObject(Object).

cte(String) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a common table expression.

CURRENT_ROW - Static variable in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause.FrameBound
 
CUSTOM_COLUMN_TO_OBJ - Static variable in class com.healthmarketscience.sqlbuilder.Converter

Converter which converts a custom column object to a SqlObject using
      Converter.toCustomColumnSqlObject(Object)

CUSTOM_TABLE_DEF_TO_OBJ - Static variable in class com.healthmarketscience.sqlbuilder.Converter

Converter which converts a custom table def object to a SqlObject using
      Converter.toCustomTableDefSqlObject(Object)

CUSTOM_TO_CONDITION - Static variable in class com.healthmarketscience.sqlbuilder.Converter

Converter which converts an Object to a Condition using
 Converter.toConditionObject(Object)

CUSTOM_TO_CONSTRAINTCLAUSE - Static variable in class com.healthmarketscience.sqlbuilder.Converter

Converter which converts an Object to a SqlObject using
      Converter.toCustomConstraintSqlObject(java.lang.Object)

CUSTOM_TO_EXPRESSION - Static variable in class com.healthmarketscience.sqlbuilder.Converter

Converter which converts an Object to an Expression using
 Converter.toExpressionObject(Object)

CUSTOM_TO_OBJ - Static variable in class com.healthmarketscience.sqlbuilder.Converter

Converter which converts an Object to a CustomSql using
      Converter.toCustomSqlObject(Object)

CUSTOM_TO_SUBQUERY - Static variable in class com.healthmarketscience.sqlbuilder.Converter

Converter which converts an Object to a Subquery using
      Converter.toSubquery(java.lang.Object)

customAppendTo(AppendableExt, HookAnchor) - Method in class com.healthmarketscience.sqlbuilder.CustomizableSqlObject

Appends any HookType.BEFORE or HookType.AFTER
 customizations for the given anchor.

customAppendTo(AppendableExt, HookAnchor, String) - Method in class com.healthmarketscience.sqlbuilder.CustomizableSqlObject

Appends all customizations for the given anchor.

customCond(Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a custom condition.

CustomCondition - Class in com.healthmarketscience.sqlbuilder

Outputs the given custom object surrounded by parentheses
 "(<customCond>)".

CustomCondition(Object) - Constructor for class com.healthmarketscience.sqlbuilder.CustomCondition
 
CustomCondition(SqlObject) - Constructor for class com.healthmarketscience.sqlbuilder.CustomCondition
 
customExpr(Object) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a custom expression.

CustomExpression - Class in com.healthmarketscience.sqlbuilder

Outputs the given custom object surrounded by parentheses
 "(<customExpr>)".

CustomExpression(Object) - Constructor for class com.healthmarketscience.sqlbuilder.CustomExpression
 
CustomExpression(SqlObject) - Constructor for class com.healthmarketscience.sqlbuilder.CustomExpression
 
CustomizableSqlObject - Class in com.healthmarketscience.sqlbuilder

Base class for all SqlObjects which support SQL syntax customizations.

CustomizableSqlObject() - Constructor for class com.healthmarketscience.sqlbuilder.CustomizableSqlObject
 
CustomSql - Class in com.healthmarketscience.sqlbuilder

Outputs the given object as is (can be used to insert any custom SQL into a
 statement).

CustomSql(Object) - Constructor for class com.healthmarketscience.sqlbuilder.CustomSql
 
customSql(Object) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating literal sql (not truly an "expression",
 but convenient nonetheless).

CustomSyntax - Class in com.healthmarketscience.sqlbuilder.custom

Utility base class for custom SQL syntax instances.

CustomSyntax() - Constructor for class com.healthmarketscience.sqlbuilder.custom.CustomSyntax
 




D

date(Date) - Static method in class com.healthmarketscience.sqlbuilder.JdbcEscape
 
date(LocalDate) - Static method in class com.healthmarketscience.sqlbuilder.JdbcEscape
 
date(TemporalAccessor) - Static method in class com.healthmarketscience.sqlbuilder.JdbcEscape
 
DbCheckConstraint - Class in com.healthmarketscience.sqlbuilder.dbspec.basic

Representation of a (table or column) check constraint in a database
 schema.

DbCheckConstraint(DbColumn, String, Condition) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbCheckConstraint
 
DbCheckConstraint(DbTable, String, Condition) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbCheckConstraint
 
DbColumn - Class in com.healthmarketscience.sqlbuilder.dbspec.basic

Representation of a column in a database schema.

DbColumn(DbTable, String, String, Integer) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn
 
DbColumn(DbTable, String, String, Object...) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn
 
DbConstraint - Class in com.healthmarketscience.sqlbuilder.dbspec.basic

Representation of a (table or column) constraint in a database schema.

DbConstraint(DbColumn, String, Constraint.Type) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbConstraint
 
DbConstraint(DbTable, String, Constraint.Type, String...) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbConstraint
 
DbConstraint(DbTable, String, Constraint.Type, DbColumn...) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbConstraint
 
DbForeignKeyConstraint - Class in com.healthmarketscience.sqlbuilder.dbspec.basic

Representation of a (table or column) foreign key constraint in a database
 schema.

DbForeignKeyConstraint(DbColumn, String, DbTable, String) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbForeignKeyConstraint
 
DbForeignKeyConstraint(DbColumn, String, DbTable, DbColumn) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbForeignKeyConstraint
 
DbForeignKeyConstraint(DbTable, String, DbTable, String[], String[]) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbForeignKeyConstraint
 
DbForeignKeyConstraint(DbTable, String, DbTable, DbColumn[], DbColumn[]) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbForeignKeyConstraint
 
DbFunction - Class in com.healthmarketscience.sqlbuilder.dbspec.basic

Representation of a function in a database function package.

DbFunction(DbFunctionPackage, String) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbFunction
 
DbFunctionPackage - Class in com.healthmarketscience.sqlbuilder.dbspec.basic

Representation of a group of functions in a database schema (similar to a
 schema for functions).

DbFunctionPackage(DbSchema, String) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbFunctionPackage
 
DbIndex - Class in com.healthmarketscience.sqlbuilder.dbspec.basic

Representation of an index in a database schema.

DbIndex(DbTable, String, String...) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbIndex
 
DbIndex(DbTable, String, DbColumn...) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbIndex
 
DbJoin - Class in com.healthmarketscience.sqlbuilder.dbspec.basic

Representation of a join between two database tables.

DbJoin(DbSpec, DbTable, DbTable, String[], String[]) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbJoin
 
DbJoin(DbSpec, DbTable, DbTable, DbColumn[], DbColumn[]) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbJoin
 
DbObject<ParentType extends DbObject<?>> - Class in com.healthmarketscience.sqlbuilder.dbspec.basic

Base class for the simple implementations of the dbspec database objects.

DbObject(ParentType, String) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbObject
 
DbSchema - Class in com.healthmarketscience.sqlbuilder.dbspec.basic

Representation of a database schema, for aggregating tables, indexes, and
 function packages.

DbSchema(DbSpec, String) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema
 
DbSpec - Class in com.healthmarketscience.sqlbuilder.dbspec.basic

Root object for a collection of db objects all residing in the same
 logical database.

DbSpec() - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec
 
DbSpec(String) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec
 
DbTable - Class in com.healthmarketscience.sqlbuilder.dbspec.basic

Representation of a table in a database schema.

DbTable(DbSchema, String) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable
 
DbTable(DbSchema, String, String) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable
 
DEFAULT_ALIAS_PREFIX - Static variable in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec

the default alias prefix used by a db spec if none is specified

DEFAULT_DELIMITER - Static variable in class com.healthmarketscience.sqlbuilder.SqlObjectList

the default delimiter used by a SqlObjectList

DEFAULT_LOCAL_ONLY - Static variable in class com.healthmarketscience.sqlbuilder.ValidationContext
 
DEFAULT_START_INDEX - Static variable in class com.healthmarketscience.sqlbuilder.QueryPreparer

the default first index that will be assigned to a placeholder

DEFAULT_START_INDEX - Static variable in class com.healthmarketscience.sqlbuilder.QueryReader

the default first index that will be assigned to a column

DeleteQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates a DELETE statement.

DeleteQuery(Table) - Constructor for class com.healthmarketscience.sqlbuilder.DeleteQuery
 
DeleteQuery(Object) - Constructor for class com.healthmarketscience.sqlbuilder.DeleteQuery

Object -> SqlObject conversions handled by
 Converter.toCustomTableSqlObject(Object).

denseRank() - Static method in class com.healthmarketscience.sqlbuilder.FunctionCall

Convenience method for generating a FunctionCall using the DENSE_RANK
 aggregate function.

desc(Object) - Static method in class com.healthmarketscience.sqlbuilder.OrderObject

Convenience method for generating a descending OrderObject for the given
 column.

displayToString() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.BooleanStaticPlaceHolder
 
displayToString() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.IntegerStaticPlaceHolder
 
displayToString() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.LongStaticPlaceHolder
 
displayToString() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.NullStaticPlaceHolder
 
displayToString() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ObjectStaticPlaceHolder
 
displayToString() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.StaticPlaceHolder

Displays the value of this place holder as a String

divide() - Static method in class com.healthmarketscience.sqlbuilder.ComboExpression

Convenience method for generating a ComboExpression for joining
 expressions using '/'.

divide(Object...) - Static method in class com.healthmarketscience.sqlbuilder.ComboExpression

Convenience method for generating a ComboExpression for joining
 the given expressions using '/'.

divide() - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a ComboExpression for joining
 expressions using '/'.

divide(Object...) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a ComboExpression for joining
 the given expressions using '/'.

doValidate() - Method in class com.healthmarketscience.sqlbuilder.SqlObject

Utility method for implementing the Verifiable.validate() method.

dropIndex(Index) - Static method in class com.healthmarketscience.sqlbuilder.DropQuery
 
dropIndex(Object) - Static method in class com.healthmarketscience.sqlbuilder.DropQuery
 
DropQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates a DROP statement.

DropQuery(DropQuery.Type, Object) - Constructor for class com.healthmarketscience.sqlbuilder.DropQuery

Object -> SqlObject conversions handled by
 Converter.toCustomSqlObject(Object).

DropQuery.Behavior - Enum in com.healthmarketscience.sqlbuilder

Enum representing additional behavior for the drop query, e.g.:
 "DROP <type> <obj> <behavior>"

DropQuery.Type - Enum in com.healthmarketscience.sqlbuilder

Enum representing he type of the object being dropped

dropTable(Table) - Static method in class com.healthmarketscience.sqlbuilder.DropQuery
 
dropTable(Object) - Static method in class com.healthmarketscience.sqlbuilder.DropQuery
 
dropView(Table) - Static method in class com.healthmarketscience.sqlbuilder.DropQuery
 
dropView(Object) - Static method in class com.healthmarketscience.sqlbuilder.DropQuery
 




E

EMPTY - Static variable in class com.healthmarketscience.sqlbuilder.Condition

a Condition object which will always return true for
      NestableClause.isEmpty().

EMPTY - Static variable in class com.healthmarketscience.sqlbuilder.Expression

an Expression object which will always return true for
      NestableClause.isEmpty().

emptyCond() - Static method in class com.healthmarketscience.sqlbuilder.Conditions

a Condition object which will always return true for
      NestableClause.isEmpty().

emptyExpr() - Static method in class com.healthmarketscience.sqlbuilder.Expressions

an Expression object which will always return true for
      NestableClause.isEmpty().

equalTo(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.BinaryCondition

Convenience method for generating a Condition for testing if a column
 is equal to another column.

equalTo(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing if a column
 is equal to another column.

escapeLikeLiteral(String, char) - Static method in class com.healthmarketscience.sqlbuilder.BinaryCondition

Escapes the special chars '%', '_', and the given char itself in the
 given literal string using the given escape character.

except() - Static method in class com.healthmarketscience.sqlbuilder.SetOperationQuery

Convenience method to create a EXCEPT query.

except(SelectQuery...) - Static method in class com.healthmarketscience.sqlbuilder.SetOperationQuery

Convenience method to create a EXCEPT query.

exceptAll() - Static method in class com.healthmarketscience.sqlbuilder.SetOperationQuery

Convenience method to create a EXCEPT ALL query.

exceptAll(SelectQuery...) - Static method in class com.healthmarketscience.sqlbuilder.SetOperationQuery

Convenience method to create a EXCEPT ALL query.

ExceptQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates a series of SELECT queries joined by EXCEPT clauses.

ExceptQuery(SetOperationQuery.Type) - Constructor for class com.healthmarketscience.sqlbuilder.ExceptQuery
 
ExceptQuery(SetOperationQuery.Type, SelectQuery...) - Constructor for class com.healthmarketscience.sqlbuilder.ExceptQuery
 
exists(Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing whether a
 subquery returns any rows.

exists(Object) - Static method in class com.healthmarketscience.sqlbuilder.UnaryCondition

Convenience method for generating a Condition for testing whether a
 subquery returns any rows.

Expression - Class in com.healthmarketscience.sqlbuilder

An object representing a value expression.

Expression() - Constructor for class com.healthmarketscience.sqlbuilder.Expression
 
Expressions - Class in com.healthmarketscience.sqlbuilder

Useful static accessors for building expressions.

extractDay(Object) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating an EXTRACT day expression.

ExtractExpression - Class in com.healthmarketscience.sqlbuilder

Outputs an extract expression like:
 "EXTRACT(<datePart> FROM <dateExpression>)"

ExtractExpression(ExtractExpression.DatePart, Object) - Constructor for class com.healthmarketscience.sqlbuilder.ExtractExpression
 
ExtractExpression(Object, Object) - Constructor for class com.healthmarketscience.sqlbuilder.ExtractExpression
 
ExtractExpression.DatePart - Enum in com.healthmarketscience.sqlbuilder

The SQL defined date parts for the extract expression.

extractHour(Object) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating an EXTRACT hour expression.

extractMinute(Object) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating an EXTRACT minute expression.

extractMonth(Object) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating an EXTRACT month expression.

extractSecond(Object) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating an EXTRACT second expression.

extractTimezoneHour(Object) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating an EXTRACT timezone hour expression.

extractTimezoneMinute(Object) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating an EXTRACT timezone minute expression.

extractYear(Object) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating an EXTRACT year expression.





F

FALSE - Static variable in class com.healthmarketscience.sqlbuilder.BooleanValueObject

BooleanValueObject representing "false"

findColumn(String) - Method in class com.healthmarketscience.sqlbuilder.CommonTableExpression

Returns a previously defined pseudo Column from this CTE definition with
 the given name, or null if one cannot be found.

findColumn(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable
 
findColumn(Column) - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable

Finds the RejoinColumn in this table for the given original column.

findColumnByName(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable

Finds the RejoinColumn in this table with the given name.

findColumns(String...) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable
 
findFunction(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbFunctionPackage
 
findFunctionPackage(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema
 
findIndex(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema
 
findObject(Collection<T>, String) - Static method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbObject
 
findSchema(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec
 
findTable(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema
 
foreignKey(Object) - Static method in class com.healthmarketscience.sqlbuilder.ConstraintClause

Convenience method for generating an unnamed foreign key constraint.

foreignKey(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.ConstraintClause

Convenience method for generating a foreign key constraint with the given
 name.

foreignKey(String, String[], String, String[]) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable

Creates and adds foreign key constraint with the given parameters to this
 table.

foreignKey(String, String[], String, String, String[]) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable

Creates and adds foreign key constraint with the given parameters to this
 table.

foreignKey(String, DbColumn[], DbTable, DbColumn[]) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable

Creates and adds foreign key constraint with the given parameters to this
 table.

ForeignKeyConstraint - Interface in com.healthmarketscience.sqlbuilder.dbspec

Maintains information about a database (table or column) foreign key
 constraint for use with the sqlbuilder utilities.

ForeignKeyConstraintClause - Class in com.healthmarketscience.sqlbuilder

Outputs a table or column foreign constraint clause (depending on the
 current context)
 [ CONSTRAINT <name> ] FOREIGN KEY [ (<col1> ...) ] REFERENCES <refRable> [ (<refCol1> ...) ].

ForeignKeyConstraintClause(ForeignKeyConstraint) - Constructor for class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause
 
ForeignKeyConstraintClause(Object, Object) - Constructor for class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause
 
ForeignKeyConstraintClause(Object, List<?>, Object, List<?>) - Constructor for class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause
 
ForeignKeyConstraintClause.ReferentialAction - Enum in com.healthmarketscience.sqlbuilder

Enum representing the referential action to be taken on update/delete.

FrameBound(Object, Object) - Constructor for class com.healthmarketscience.sqlbuilder.WindowDefinitionClause.FrameBound
 
from(Constraint) - Static method in class com.healthmarketscience.sqlbuilder.ConstraintClause

Returns the appropriately configured ConstraintClause (or
 ForeignKeyConstraintClause) for the given Constraint.

Function - Interface in com.healthmarketscience.sqlbuilder.dbspec

Maintains information about a database function for use with the sqlbuilder
 utilities.

FunctionCall - Class in com.healthmarketscience.sqlbuilder

Outputs a function call
 "<name>([<param1>, ...


FunctionCall(Function) - Constructor for class com.healthmarketscience.sqlbuilder.FunctionCall
 
FunctionCall(Object) - Constructor for class com.healthmarketscience.sqlbuilder.FunctionCall

Object -> SqlObject conversions handled by
 Converter.toCustomFunctionSqlObject(Object).





G

get(int) - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList

Returns the object at the specified index.

getAbsoluteName() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbObject
 
getAlias() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable
 
getAlias() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable
 
getAlias() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Table
 
getAppendable() - Method in class com.healthmarketscience.common.util.AppendableExt

Get the underlying Appendable.

getBoolean(ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls getBoolean on the given ResultSet for the position of this
 Column.

getColumnNameSQL() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn
 
getColumnNameSQL() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Column
 
getColumnNameSQL() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable.RejoinColumn
 
getColumns() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbConstraint
 
getColumns() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbIndex
 
getColumns() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable
 
getColumns() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Constraint
 
getColumns() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Index
 
getColumns() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable
 
getColumns() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Table
 
getColumns() - Method in class com.healthmarketscience.sqlbuilder.ValidationContext
 
getColumnTables() - Method in class com.healthmarketscience.sqlbuilder.ValidationContext

Retrieves the tables referenced by the column objects.

getColumnTables(Collection<Table>) - Method in class com.healthmarketscience.sqlbuilder.ValidationContext

Retrieves the tables referenced by the column objects.

getCondition() - Method in class com.healthmarketscience.sqlbuilder.CheckConstraintClause

Allows access to the AND ComboCondition of the condition clause to
 facilitate common condition building code.

getCondition() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbCheckConstraint
 
getCondition() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.CheckConstraint
 
getConstraint() - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddConstraintAction
 
getConstraint() - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddForeignConstraintAction

Deprecated.
 
getConstraintNameSQL() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbConstraint
 
getConstraintNameSQL() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Constraint
 
getConstraints() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn
 
getConstraints() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable
 
getConstraints() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Column
 
getConstraints() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable
 
getConstraints() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable.RejoinColumn
 
getConstraints() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Table
 
getContext() - Method in class com.healthmarketscience.common.util.AppendableExt
 
getContext(AppendableExt) - Static method in class com.healthmarketscience.sqlbuilder.SqlContext

Gets the current SqlContext from the given AppendableExt, creating one if
 necessary.

getConverter() - Method in interface com.healthmarketscience.sqlbuilder.UnaryCondition.CustomUnaryOp

Returns the Converter which handles the Object -> SqlObject conversion for the operation value.

getConverter() - Method in enum com.healthmarketscience.sqlbuilder.UnaryCondition.Op
 
getCustomColumnObject() - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column
 
getDefaultFunctionPackage() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema
 
getDefaultSchema() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec
 
getDefaultValue() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn
 
getDefaultValue() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Column
 
getDefaultValue() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable.RejoinColumn
 
getDelimiter() - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList
 
getDropQuery() - Method in class com.healthmarketscience.sqlbuilder.BaseCreateQuery
 
getDropQuery() - Method in class com.healthmarketscience.sqlbuilder.CreateIndexQuery
 
getDropQuery() - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery
 
getDropQuery() - Method in class com.healthmarketscience.sqlbuilder.CreateViewQuery
 
getFailedVerifiable() - Method in exception com.healthmarketscience.sqlbuilder.ValidationException
 
getFromColumns() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbJoin
 
getFromColumns() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Join
 
getFromTable() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbJoin
 
getFromTable() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Join
 
getFunctionNameSQL() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbFunction
 
getFunctionNameSQL() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Function
 
getFunctionPackage() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbFunction
 
getFunctionPackages() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema
 
getHavingClause() - Method in class com.healthmarketscience.sqlbuilder.SelectQuery

Allows access to the AND ComboCondition of the having clause to
 facilitate common condition building code.

getIndex() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Returns the 1-based index of this PlaceHolder in the query.

getIndex() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.MultiPlaceHolder

Returns the 1-based index of this PlaceHolder in the query.

getIndex() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Returns the 1-based index of this PlaceHolder in the query.

getIndex() - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column
 
getIndexes() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder
 
getIndexes() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.MultiPlaceHolder
 
getIndexes() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder
 
getIndexNameSQL() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbIndex
 
getIndexNameSQL() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Index
 
getIndexs() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema
 
getInt(ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls getInt on the given ResultSet for the position of this Column.

getIOException() - Method in class com.healthmarketscience.common.util.StringAppendableExt

Get the last IOException thrown by an append call, or null if 
 no IOException was caught.

getJoins() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec
 
getLong(ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls getLong on the given ResultSet for the position of this Column.

getMessage() - Method in exception com.healthmarketscience.sqlbuilder.ValidationException
 
getName() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbObject
 
getNewColumn() - Method in class com.healthmarketscience.sqlbuilder.QueryReader
 
getNewListPlaceHolder() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer
 
getNewMultiPlaceHolder() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer
 
getNewPlaceHolder() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer
 
getNextAlias() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec
 
getObject(ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls getObject on the given ResultSet for the position of this Column.

getOriginalColumn() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable.RejoinColumn
 
getOriginalTable() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable
 
getOuter() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder
 
getParent() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbObject
 
getParent() - Method in class com.healthmarketscience.sqlbuilder.SqlContext

Gets the SqlContext which was in effect before this SqlContext was
 "pushed" onto the context stack.

getParent() - Method in class com.healthmarketscience.sqlbuilder.ValidationContext
 
getQuery() - Method in class com.healthmarketscience.sqlbuilder.SqlContext

Gets the handle to the immediate wrapping query

getReferencedColumns() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbForeignKeyConstraint
 
getReferencedColumns() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.ForeignKeyConstraint
 
getReferencedTable() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbForeignKeyConstraint
 
getReferencedTable() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.ForeignKeyConstraint
 
getSchema() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbFunctionPackage
 
getSchema() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbIndex
 
getSchemas() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec
 
getSpec() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbJoin
 
getSpec() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbObject

Default implementation returns the parent's spec.

getSpec() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema
 
getString(ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls getString on the given ResultSet for the position of this Column.

getTable() - Method in class com.healthmarketscience.sqlbuilder.CommonTableExpression

Returns the pseudo Table instance for this CTE.

getTable() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn
 
getTable() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbIndex
 
getTable() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Column
 
getTable() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Index
 
getTable() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable.RejoinColumn
 
getTableNameSQL() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable
 
getTableNameSQL() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable
 
getTableNameSQL() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Table
 
getTables() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema
 
getTables() - Method in class com.healthmarketscience.sqlbuilder.ValidationContext
 
getThisType() - Method in class com.healthmarketscience.sqlbuilder.BaseCaseStatement
 
getThisType() - Method in class com.healthmarketscience.sqlbuilder.Query
 
getToColumns() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbJoin
 
getToColumns() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Join
 
getToTable() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbJoin
 
getToTable() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Join
 
getType() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbConstraint
 
getType() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.CheckConstraint
 
getType() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Constraint
 
getType() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.ForeignKeyConstraint
 
getTypeLength() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn
 
getTypeLength() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Column

Deprecated.
use Column.getTypeQualifiers() instead


getTypeLength() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable.RejoinColumn
 
getTypeName(int) - Static method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Returns the standard jdbc type name for the give type value (one of Types).

getTypeNameSQL() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn
 
getTypeNameSQL() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Column
 
getTypeNameSQL() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable.RejoinColumn
 
getTypeQualifiers() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn
 
getTypeQualifiers() - Method in interface com.healthmarketscience.sqlbuilder.dbspec.Column
 
getTypeQualifiers() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable.RejoinColumn
 
getUseTableAliases() - Method in class com.healthmarketscience.sqlbuilder.SqlContext
 
getUseTableConstraints() - Method in class com.healthmarketscience.sqlbuilder.SqlContext
 
getWhereClause() - Method in class com.healthmarketscience.sqlbuilder.DeleteQuery

Allows access to the AND ComboCondition of the where clause to facilitate
 common condition building code.

getWhereClause() - Method in class com.healthmarketscience.sqlbuilder.SelectQuery

Allows access to the AND ComboCondition of the where clause to facilitate
 common condition building code.

getWhereClause() - Method in class com.healthmarketscience.sqlbuilder.UpdateQuery

Allows access to the AND ComboCondition of the where clause to facilitate
 common condition building code.

GrantQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates a GRANT (privileges) statement.

GrantQuery() - Constructor for class com.healthmarketscience.sqlbuilder.GrantQuery
 
greaterThan(Object, Object, boolean) - Static method in class com.healthmarketscience.sqlbuilder.BinaryCondition

Convenience method for generating a Condition for testing if a column
 is greater than a given value (inclusive or exclusive).

greaterThan(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.BinaryCondition

Convenience method for generating a Condition for testing if a column
 is strictly greater than a given value.

greaterThan(Object, Object, boolean) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing if a column
 is greater than a given value (inclusive or exclusive).

greaterThan(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing if a column
 is strictly greater than a given value.

greaterThanOrEq(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.BinaryCondition

Convenience method for generating a Condition for testing if a column
 is greater than or equal to a given value.

greaterThanOrEq(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing if a column
 is greater than or equal to a given value.





H

hasParens() - Method in class com.healthmarketscience.sqlbuilder.BooleanValueObject
 
hasParens() - Method in class com.healthmarketscience.sqlbuilder.ComboCondition
 
hasParens() - Method in class com.healthmarketscience.sqlbuilder.ComboExpression
 
hasParens() - Method in class com.healthmarketscience.sqlbuilder.ExtractExpression
 
hasParens() - Method in class com.healthmarketscience.sqlbuilder.FunctionCall
 
hasParens() - Method in class com.healthmarketscience.sqlbuilder.JdbcEscape
 
hasParens() - Method in class com.healthmarketscience.sqlbuilder.NumberValueObject
 
hasParens() - Method in class com.healthmarketscience.sqlbuilder.ValueObject
 
HookAnchor - Interface in com.healthmarketscience.sqlbuilder.custom

Marker interface for the custom hook anchors use by specific SqlObjects.

HookType - Enum in com.healthmarketscience.sqlbuilder.custom

Enum defining the type of customization relative to the HookAnchor
 (which is typically a sub-clause within a query).





I

IF_NOT_EXISTS_TABLE - Static variable in class com.healthmarketscience.sqlbuilder.custom.mysql.MysObjects

Appends a MySQL "IF NOT EXISTS " modifier after the
 "CREATE TABLE " query clause.

IF_NOT_EXISTS_TABLE - Static variable in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgObjects

Appends a PostgreSQL "IF NOT EXISTS " modifier after the
 "CREATE TABLE " query clause.

iLike(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgBinaryCondition

Convenience method for generating a Condition for testing if a column is
 "ilike" (case-insensitive like) a given value (sql pattern matching).

iMatchesRe(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgBinaryCondition

Convenience method for generating a Condition for testing if a column
 "regex matches" (case-insensitive) a given value (posix regex matching).

in(Object, Object...) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a IN condition..

in(Object, Collection<?>) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a IN condition..

InCondition - Class in com.healthmarketscience.sqlbuilder

Outputs an "IN" condition
 "(<column> [NOT] IN (<rightObj1>, <rightObj2>, ...) )"

InCondition(Object, Object...) - Constructor for class com.healthmarketscience.sqlbuilder.InCondition

Column Object -> SqlObject conversions handled by
 Converter.toColumnSqlObject(com.healthmarketscience.sqlbuilder.dbspec.Column).

InCondition(Object, Collection<?>) - Constructor for class com.healthmarketscience.sqlbuilder.InCondition

Column Object -> SqlObject conversions handled by
 Converter.toColumnSqlObject(com.healthmarketscience.sqlbuilder.dbspec.Column).

Index - Interface in com.healthmarketscience.sqlbuilder.dbspec

Maintains information about a database function for use with the sqlbuilder
 utilities.

InsertQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates a simple INSERT statement.

InsertQuery(Table) - Constructor for class com.healthmarketscience.sqlbuilder.InsertQuery
 
InsertQuery(Object) - Constructor for class com.healthmarketscience.sqlbuilder.InsertQuery
 
InsertSelectQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates an INSERT statement where the data is generated from
 a SELECT query.

InsertSelectQuery(Table) - Constructor for class com.healthmarketscience.sqlbuilder.InsertSelectQuery
 
InsertSelectQuery(Object) - Constructor for class com.healthmarketscience.sqlbuilder.InsertSelectQuery
 
IntegerStaticPlaceHolder(int, QueryPreparer) - Constructor for class com.healthmarketscience.sqlbuilder.QueryPreparer.IntegerStaticPlaceHolder
 
intersect() - Static method in class com.healthmarketscience.sqlbuilder.SetOperationQuery

Convenience method to create a INTERSECT query.

intersect(SelectQuery...) - Static method in class com.healthmarketscience.sqlbuilder.SetOperationQuery

Convenience method to create a INTERSECT query.

intersectAll() - Static method in class com.healthmarketscience.sqlbuilder.SetOperationQuery

Convenience method to create a INTERSECT ALL query.

intersectAll(SelectQuery...) - Static method in class com.healthmarketscience.sqlbuilder.SetOperationQuery

Convenience method to create a INTERSECT ALL query.

IntersectQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates a series of SELECT queries joined by INTERSECT
 clauses.

IntersectQuery(SetOperationQuery.Type) - Constructor for class com.healthmarketscience.sqlbuilder.IntersectQuery
 
IntersectQuery(SetOperationQuery.Type, SelectQuery...) - Constructor for class com.healthmarketscience.sqlbuilder.IntersectQuery
 
isEmpty() - Method in class com.healthmarketscience.sqlbuilder.BaseCaseStatement
 
isEmpty() - Method in class com.healthmarketscience.sqlbuilder.ComboCondition
 
isEmpty() - Method in class com.healthmarketscience.sqlbuilder.ComboExpression
 
isEmpty() - Method in class com.healthmarketscience.sqlbuilder.CustomCondition
 
isEmpty() - Method in class com.healthmarketscience.sqlbuilder.CustomExpression
 
isEmpty() - Method in class com.healthmarketscience.sqlbuilder.InCondition
 
isEmpty() - Method in class com.healthmarketscience.sqlbuilder.NegateExpression
 
isEmpty() - Method in class com.healthmarketscience.sqlbuilder.NotCondition
 
isEmpty() - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList
 
isEmpty() - Method in class com.healthmarketscience.sqlbuilder.Subquery
 
isInQuery() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder
 
isInQuery() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.MultiPlaceHolder
 
isInQuery() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Returns true if this PlaceHolder was used in the query,
 false otherwise.

isInQuery() - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column
 
isIntegralInRange(long, long) - Method in class com.healthmarketscience.sqlbuilder.NumberValueObject
 
isLocalOnly() - Method in class com.healthmarketscience.sqlbuilder.ValidationContext
 
isNotNull(Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing if a column
 is not NULL.

isNotNull(Object) - Static method in class com.healthmarketscience.sqlbuilder.UnaryCondition

Convenience method for generating a Condition for testing if a column
 is not NULL.

isNull(Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing if a column
 is NULL.

isNull(Object) - Static method in class com.healthmarketscience.sqlbuilder.UnaryCondition

Convenience method for generating a Condition for testing if a column
 is NULL.

isPrefixOp() - Method in interface com.healthmarketscience.sqlbuilder.UnaryCondition.CustomUnaryOp

Returns true if the operator comes before the value, false otherwise.

isPrefixOp() - Method in enum com.healthmarketscience.sqlbuilder.UnaryCondition.Op
 
iterator() - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList
 




J

JdbcEscape - Class in com.healthmarketscience.sqlbuilder

Outputs SQL and a prefix enclosed within JDBC escape syntax
 "{<prefix> <sql>}".

JdbcEscape(JdbcEscape.Type, SqlObject) - Constructor for class com.healthmarketscience.sqlbuilder.JdbcEscape
 
JdbcEscape.Type - Enum in com.healthmarketscience.sqlbuilder

Enum which defines the escape types supported.

JdbcScalarFunction - Class in com.healthmarketscience.sqlbuilder

Outputs a JDBC escaped scalar function call
 "{fn <funcCall>}".

JdbcScalarFunction(Object) - Constructor for class com.healthmarketscience.sqlbuilder.JdbcScalarFunction

Object -> SqlObject conversions handled by
 Converter.toCustomSqlObject(Object).

Join - Interface in com.healthmarketscience.sqlbuilder.dbspec

Maintains information about a database join for use with the sqlbuilder
 utilities.





L

lessThan(Object, Object, boolean) - Static method in class com.healthmarketscience.sqlbuilder.BinaryCondition

Convenience method for generating a Condition for testing if a column
 is less than another column (inclusive or exclusive).

lessThan(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.BinaryCondition

Convenience method for generating a Condition for testing if a column
 is strictly less than another column.

lessThan(Object, Object, boolean) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing if a column
 is less than another column (inclusive or exclusive).

lessThan(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing if a column
 is strictly less than another column.

lessThanOrEq(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.BinaryCondition

Convenience method for generating a Condition for testing if a column
 is less than or equal to another column.

lessThanOrEq(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing if a column
 is less than or equal to another column.

like(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.BinaryCondition

Convenience method for generating a Condition for testing if a column
 is "like" a given value (sql pattern matching).

like(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing if a column
 is "like" a given value (sql pattern matching).

listIterator() - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList
 
ListPlaceHolder(QueryPreparer) - Constructor for class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder
 
LongStaticPlaceHolder(long, QueryPreparer) - Constructor for class com.healthmarketscience.sqlbuilder.QueryPreparer.LongStaticPlaceHolder
 




M

matchesRe(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgBinaryCondition

Convenience method for generating a Condition for testing if a column
 "regex matches" a given value (posix regex matching).

max() - Static method in class com.healthmarketscience.sqlbuilder.FunctionCall

Convenience method for generating a FunctionCall using the standard MAX
 function.

maybeAppendTo(AppendableExt, HookAnchor, String, SqlObject, boolean) - Method in class com.healthmarketscience.sqlbuilder.CustomizableSqlObject

Appends the appropriate customizations for the given anchor (and possibly
 the anchor clause itself) based on whether or not the clause should be
 included.

maybeAppendTo(AppendableExt, HookAnchor, String, boolean) - Method in class com.healthmarketscience.sqlbuilder.CustomizableSqlObject

Appends the appropriate customizations for the given anchor (and possibly
 the anchor clause itself) based on whether or not the clause should be
 included.

maySpecifyColumns() - Method in enum com.healthmarketscience.sqlbuilder.BaseGrantQuery.Privilege.Type
 
min() - Static method in class com.healthmarketscience.sqlbuilder.FunctionCall

Convenience method for generating a FunctionCall using the standard MIN
 function.

MssTopClause - Class in com.healthmarketscience.sqlbuilder.custom.sqlserver

Appends a SQLServer TOP clause like " TOP <count> [PERCENT]" for
 use in SelectQuerys.

MssTopClause(Object) - Constructor for class com.healthmarketscience.sqlbuilder.custom.sqlserver.MssTopClause
 
MssTopClause(Object, boolean) - Constructor for class com.healthmarketscience.sqlbuilder.custom.sqlserver.MssTopClause
 
MultiPlaceHolder(QueryPreparer) - Constructor for class com.healthmarketscience.sqlbuilder.QueryPreparer.MultiPlaceHolder
 
multiply() - Static method in class com.healthmarketscience.sqlbuilder.ComboExpression

Convenience method for generating a ComboExpression for joining
 expressions using '*'.

multiply(Object...) - Static method in class com.healthmarketscience.sqlbuilder.ComboExpression

Convenience method for generating a ComboExpression for joining
 the given expressions using '*'.

multiply() - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a ComboExpression for joining
 expressions using '*'.

multiply(Object...) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a ComboExpression for joining
 the given expressions using '*'.

MysExtractDatePart - Enum in com.healthmarketscience.sqlbuilder.custom.mysql

The MySQL defined date parts for the
 ExtractExpression.

MysLimitClause - Class in com.healthmarketscience.sqlbuilder.custom.mysql

Appends a MySQL limit clause like " LIMIT [<offset>] <limit>" for
 use in SelectQuerys.

MysLimitClause(Object) - Constructor for class com.healthmarketscience.sqlbuilder.custom.mysql.MysLimitClause
 
MysLimitClause(Object, Object) - Constructor for class com.healthmarketscience.sqlbuilder.custom.mysql.MysLimitClause
 
MysObjects - Class in com.healthmarketscience.sqlbuilder.custom.mysql

Miscellaneous useful constructs for custom MySQL syntax.





N

namedParam(String) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a custom "named" parameter expression.

NamedParamObject - Class in com.healthmarketscience.sqlbuilder.custom

SqlObject expression which inserts a "named" parameter like ":<name>".

NamedParamObject(String) - Constructor for class com.healthmarketscience.sqlbuilder.custom.NamedParamObject
 
negate(Object) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating the negation of an expression.

NegateExpression - Class in com.healthmarketscience.sqlbuilder

Outputs the negation of the given expression "(- <expression>)"

NegateExpression(Object) - Constructor for class com.healthmarketscience.sqlbuilder.NegateExpression

Object -> Expression conversions handled by
 Converter.toExpressionObject(Object).

NegateExpression(Expression) - Constructor for class com.healthmarketscience.sqlbuilder.NegateExpression
 
not(Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a NOT condition..

notBetween(Object, Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a NOT BETWEEN condition..

NotCondition - Class in com.healthmarketscience.sqlbuilder

Outputs the negation of the given condition "(NOT <condition>)"

NotCondition(Object) - Constructor for class com.healthmarketscience.sqlbuilder.NotCondition

Object -> Condition conversions handled by
 Converter.toConditionObject(Object).

NotCondition(Condition) - Constructor for class com.healthmarketscience.sqlbuilder.NotCondition
 
notEqualTo(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.BinaryCondition

Convenience method for generating a Condition for testing if a column
 is not equal to another column.

notEqualTo(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing if a column
 is not equal to another column.

notILike(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgBinaryCondition

Convenience method for generating a Condition for testing if a column is
 not "ilike" (case-insensitive like) a given value (sql pattern matching).

notIMatchesRe(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgBinaryCondition

Convenience method for generating a Condition for testing if a column
 does not "regex match" (case-insensitive) a given value (posix regex
 matching).

notIn(Object, Object...) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a NOT IN condition..

notIn(Object, Collection<?>) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a NOT IN condition..

notLike(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.BinaryCondition

Convenience method for generating a Condition for testing if a column
 is not "like" a given value (sql pattern matching).

notLike(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing if a column
 is not "like" a given value (sql pattern matching).

notMatchesRe(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgBinaryCondition

Convenience method for generating a Condition for testing if a column
 does not "regex match" a given value (posix regex matching).

notNull() - Static method in class com.healthmarketscience.sqlbuilder.ConstraintClause

Convenience method for generating an unnamed not null constraint.

notNull(Object) - Static method in class com.healthmarketscience.sqlbuilder.ConstraintClause

Convenience method for generating a not null constraint with the given
 name.

notNull() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Creates and adds not null constraint with the given parameters to this
 column.

notNull(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Creates and adds not null constraint with the given parameters to this
 column.

notSimilarTo(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgBinaryCondition

Convenience method for generating a Condition for testing if a column is
 not "similar to" a given value (sql regex matching).

NOW - Static variable in class com.healthmarketscience.sqlbuilder.JdbcScalarFunction

JdbcScalarFunction which represents the scalar function NOW for
      returning a timestamp of the current time.

NULL_VALUE - Static variable in class com.healthmarketscience.sqlbuilder.SqlObject

SqlObject which represents a NULL value string

NullStaticPlaceHolder(int, QueryPreparer) - Constructor for class com.healthmarketscience.sqlbuilder.QueryPreparer.NullStaticPlaceHolder
 
NumberValueObject - Class in com.healthmarketscience.sqlbuilder

Outputs a number literal <value>.

NumberValueObject(Object) - Constructor for class com.healthmarketscience.sqlbuilder.NumberValueObject
 
NumberValueObject(Number) - Constructor for class com.healthmarketscience.sqlbuilder.NumberValueObject
 




O

ObjectStaticPlaceHolder(ObjType, QueryPreparer) - Constructor for class com.healthmarketscience.sqlbuilder.QueryPreparer.ObjectStaticPlaceHolder
 
or() - Static method in class com.healthmarketscience.sqlbuilder.ComboCondition

Convenience method for generating a ComboCondition for joining
 conditions using OR.

or(Condition...) - Static method in class com.healthmarketscience.sqlbuilder.ComboCondition

Convenience method for generating a ComboCondition for joining
 the given conditions using OR.

or(Object...) - Static method in class com.healthmarketscience.sqlbuilder.ComboCondition

Convenience method for generating a ComboCondition for joining
 the given custom conditions using OR.

or() - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a ComboCondition for joining
 conditions using OR.

or(Condition...) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a ComboCondition for joining
 the given conditions using OR.

or(Object...) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a ComboCondition for joining
 the given custom conditions using OR.

OraExtractDatePart - Enum in com.healthmarketscience.sqlbuilder.custom.oracle

The Oracle defined date parts for the
 ExtractExpression.

OraObjects - Class in com.healthmarketscience.sqlbuilder.custom.oracle

Miscellaneous useful constructs for custom Oracle syntax.

OraTableSpaceClause - Class in com.healthmarketscience.sqlbuilder.custom.oracle

Appends an Oracle " TABLESPACE ..." clause to a CreateTableQuery or CreateIndexQuery if a tableSpace has been
 specified.

OraTableSpaceClause(String) - Constructor for class com.healthmarketscience.sqlbuilder.custom.oracle.OraTableSpaceClause
 
OrderObject - Class in com.healthmarketscience.sqlbuilder

Outputs the given object along with an order specification
 <obj> <dir>

OrderObject(OrderObject.Dir, Object) - Constructor for class com.healthmarketscience.sqlbuilder.OrderObject
 
OrderObject(OrderObject.Dir, SqlObject) - Constructor for class com.healthmarketscience.sqlbuilder.OrderObject
 
OrderObject.Dir - Enum in com.healthmarketscience.sqlbuilder

Enumeration representing the direction of an ordering clause

OrderObject.NullOrder - Enum in com.healthmarketscience.sqlbuilder

Enumeration representing the order of NULL





P

PgBinaryCondition - Class in com.healthmarketscience.sqlbuilder.custom.postgresql

Condition which supports PostgreSQL specific binary operators.

PgBinaryCondition(PgBinaryCondition.PgOp, Object, Object) - Constructor for class com.healthmarketscience.sqlbuilder.custom.postgresql.PgBinaryCondition
 
PgBinaryCondition.PgOp - Enum in com.healthmarketscience.sqlbuilder.custom.postgresql
 
PgExtractDatePart - Enum in com.healthmarketscience.sqlbuilder.custom.postgresql

The PostgreSQL defined date parts for the
 ExtractExpression.

PgLimitClause - Class in com.healthmarketscience.sqlbuilder.custom.postgresql

Appends a PostgreSQL limit clause like " LIMIT <limit>" for use in
 SelectQuerys.

PgLimitClause(Object) - Constructor for class com.healthmarketscience.sqlbuilder.custom.postgresql.PgLimitClause
 
PgObjects - Class in com.healthmarketscience.sqlbuilder.custom.postgresql

Miscellaneous useful constructs for custom PostgreSQL syntax.

PgOffsetClause - Class in com.healthmarketscience.sqlbuilder.custom.postgresql

Appends a PostgreSQL offset clause like " OFFSET <offset>" for use in
 SelectQuerys.

PgOffsetClause(Object) - Constructor for class com.healthmarketscience.sqlbuilder.custom.postgresql.PgOffsetClause
 
PlaceHolder(QueryPreparer) - Constructor for class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder
 
popContext(AppendableExt, SqlContext) - Static method in class com.healthmarketscience.sqlbuilder.SqlContext

Replaces the current SqlContext (checking it against the given
 SqlContext) with the parent SqlContext (stored within the new one).

postAppendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.ConstraintClause
 
preAppendTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.ConstraintClause
 
prependTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.BaseCTEQuery
 
prependTo(AppendableExt) - Method in class com.healthmarketscience.sqlbuilder.Query

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

primaryKey() - Static method in class com.healthmarketscience.sqlbuilder.ConstraintClause

Convenience method for generating an unnamed primary key constraint.

primaryKey(Object) - Static method in class com.healthmarketscience.sqlbuilder.ConstraintClause

Convenience method for generating a primary key constraint with the given
 name.

primaryKey() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Creates and adds primary key constraint with the given parameters to this
 column.

primaryKey(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Creates and adds primary key constraint with the given parameters to this
 column.

primaryKey(String, String...) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable

Creates and adds primary key constraint with the given parameters to this
 table.

Privilege(BaseGrantQuery.Privilege.Type, Column...) - Constructor for class com.healthmarketscience.sqlbuilder.BaseGrantQuery.Privilege
 
privilegeAll() - Static method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
privilegeDelete() - Static method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
privilegeInsert(Column...) - Static method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
privilegeReferences(Column...) - Static method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
privilegeSelect() - Static method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
privilegeUpdate(Column...) - Static method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
privilegeUsage() - Static method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
PUBLIC_GRANTEE - Static variable in class com.healthmarketscience.sqlbuilder.BaseGrantQuery

grantee object which represents PUBLIC access

pushContext(AppendableExt) - Static method in class com.healthmarketscience.sqlbuilder.SqlContext

Creates a new SqlContext (cloning current one if available), replaces the
 current SqlContext with the new SqlContext, and returns the new
 SqlContext.





Q

Query<ThisType extends Query<ThisType>> - Class in com.healthmarketscience.sqlbuilder

Base class for all query statements which adds a validation facility.

Query() - Constructor for class com.healthmarketscience.sqlbuilder.Query
 
QueryPreparer - Class in com.healthmarketscience.sqlbuilder

Helper class which keeps track of '?' positions in dynamically generated
 prepared statements so that the query user can easily set the parameters
 correctly, especially useful where the code which generates the prepared
 query is separate from the code which uses the prepared query.

QueryPreparer() - Constructor for class com.healthmarketscience.sqlbuilder.QueryPreparer
 
QueryPreparer(int) - Constructor for class com.healthmarketscience.sqlbuilder.QueryPreparer

Creates a QueryPreparer with a different startIndex from the default.

QueryPreparer.BooleanStaticPlaceHolder - Class in com.healthmarketscience.sqlbuilder

StaticPlaceHolder which calls setInt on the PreparedStatement
 with the saved value.

QueryPreparer.IntegerStaticPlaceHolder - Class in com.healthmarketscience.sqlbuilder

StaticPlaceHolder which calls setInt on the PreparedStatement
 with the saved value.

QueryPreparer.ListPlaceHolder - Class in com.healthmarketscience.sqlbuilder

A SqlObject which outputs 0 or more '?' separated by commas, and records
 the current indexes at the times the appendTo method is
 called.

QueryPreparer.LongStaticPlaceHolder - Class in com.healthmarketscience.sqlbuilder

StaticPlaceHolder which calls setLong on the PreparedStatement
 with the saved value.

QueryPreparer.MultiPlaceHolder - Class in com.healthmarketscience.sqlbuilder

A SqlObject which outputs a '?', and records the current index at the
 time(s) the appendTo method is called.

QueryPreparer.NullStaticPlaceHolder - Class in com.healthmarketscience.sqlbuilder

StaticPlaceHolder which always calls setNull on the PreparedStatement
 with the saved sql type.

QueryPreparer.ObjectStaticPlaceHolder<ObjType> - Class in com.healthmarketscience.sqlbuilder

StaticPlaceHolder which calls setObject on the PreparedStatement
 with the saved value.

QueryPreparer.PlaceHolder - Class in com.healthmarketscience.sqlbuilder

A SqlObject which outputs a '?', and records the current index at the
 time the appendTo method is called.

QueryPreparer.StaticPlaceHolder - Class in com.healthmarketscience.sqlbuilder

Convenience PlaceHolder which also maintains a value which will always be
 inserted into the PreparedStatement when setValue is called.

QueryPreparer.StringStaticPlaceHolder - Class in com.healthmarketscience.sqlbuilder

StaticPlaceHolder which calls setString on the PreparedStatement
 with the saved value.

QueryPreparer.TypedStaticPlaceHolder - Class in com.healthmarketscience.sqlbuilder

StaticPlaceHolder which calls setObject on the PreparedStatement
 with the saved value and the saved sql type.

QueryReader - Class in com.healthmarketscience.sqlbuilder

Helper class which keeps track of the column positions in dynamically
 generated select statements so that the query user can easily get the
 results correctly, especially useful where the code which generates the
 query is separate from the code which uses the query.

QueryReader() - Constructor for class com.healthmarketscience.sqlbuilder.QueryReader
 
QueryReader(int) - Constructor for class com.healthmarketscience.sqlbuilder.QueryReader

Creates a QueryReader with a different startIndex from the default.

QueryReader.Column - Class in com.healthmarketscience.sqlbuilder

A SqlObject which outputs the passed in SqlObject, and records the
 current index at the time the appendTo method is called.

QUESTION_MARK - Static variable in class com.healthmarketscience.sqlbuilder.SqlObject

SqlObject which represents a ? string for generating
      prepared statements.





R

rank() - Static method in class com.healthmarketscience.sqlbuilder.FunctionCall

Convenience method for generating a FunctionCall using the RANK
 aggregate function.

references(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Creates and adds foreign key constraint with the given parameters to this
 column.

references(String, String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Creates and adds foreign key constraint with the given parameters to this
 column.

references(String, String, String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Creates and adds foreign key constraint with the given parameters to this
 column.

references(String, String, String, String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Creates and adds foreign key constraint with the given parameters to this
 column.

references(String, DbTable, DbColumn) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Creates and adds foreign key constraint with the given parameters to this
 column.

rejoin(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable

Convenience method for creating a new RejoinTable instance for this table
 with the given alias.

RejoinTable - Class in com.healthmarketscience.sqlbuilder.dbspec

Utility class for using a table multiple times in the same query with
 different aliases.

RejoinTable(Table, String) - Constructor for class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable
 
RejoinTable.RejoinColumn - Class in com.healthmarketscience.sqlbuilder.dbspec

Utility class which wraps a Column and returns a reference to the
 RejoinTable instead of the original table.

RevokeQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates a REVOKE (privileges) statement.

RevokeQuery() - Constructor for class com.healthmarketscience.sqlbuilder.RevokeQuery
 
ROWNUM - Static variable in class com.healthmarketscience.sqlbuilder.custom.oracle.OraObjects

SqlObject which represents the Oracle ROWNUM pseudo-column.

rowNumber() - Static method in class com.healthmarketscience.sqlbuilder.FunctionCall

Convenience method for generating a FunctionCall using the ROW_NUMBER
 aggregate function.





S

SelectQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates a SELECT statement.

SelectQuery() - Constructor for class com.healthmarketscience.sqlbuilder.SelectQuery
 
SelectQuery(boolean) - Constructor for class com.healthmarketscience.sqlbuilder.SelectQuery
 
SelectQuery.Hook - Enum in com.healthmarketscience.sqlbuilder

The HookAnchors supported for SELECT queries.

SelectQuery.JoinType - Enum in com.healthmarketscience.sqlbuilder

Enum which defines the join types supported in a FROM clause.

setAction(Object) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery

Sets the alter table action.

setAddColumn(Column) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery

Sets the alter table action to add the given column.

setAddConstraint(Constraint) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery

Sets the alter table action to add the given constraint.

setAddCustomColumn(Object) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery

Sets the alter table action to add the given column.

setAddCustomConstraint(Object) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery

Sets the alter table action to add the given constraint.

setAllowGranteeToGrant(boolean) - Method in class com.healthmarketscience.sqlbuilder.GrantQuery

Sets whether or not grantee is allowed to grant these privileges to
      others

setBehavior(DropQuery.Behavior) - Method in class com.healthmarketscience.sqlbuilder.DropQuery

Sets the behavior for the drop query

setBehavior(DropQuery.Behavior) - Method in class com.healthmarketscience.sqlbuilder.RevokeQuery

Sets the behavior for the revoke query

setBoolean(boolean, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.MultiPlaceHolder
 
setBoolean(boolean, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Calls setBoolean on the given PreparedStatement with the given value
 for the position of this PlaceHolder.

setBoolean(Boolean, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Calls setBoolean on the given PreparedStatement with the given value for
 the position of this PlaceHolder.

setBooleans(PreparedStatement, boolean...) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Calls setBoolean on the given PreparedStatement with the given values
 for the positions of this PlaceHolder.

setBooleans(PreparedStatement, Iterable<? extends Boolean>) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Calls setBoolean on the given PreparedStatement with the given values for
 the positions of this PlaceHolder.

setCheckTime(Object) - Method in class com.healthmarketscience.sqlbuilder.ConstraintClause

Sets the check time for this constraint.

setColumnConstraint(Column, CreateTableQuery.ColumnConstraint) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery

Deprecated.
use ConstraintClause instead of ColumnConstraint


setColumnDefaultValue(Column, Object) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery

Sets the given value as the column default value on a previously added
 column

setColumnObject(Column) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Sets the actual sql to be generated by this column.

setColumns(Collection<Column>) - Method in class com.healthmarketscience.sqlbuilder.ValidationContext
 
setColumnTypeName(Column, String) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery

Sets the given type name as the column type name on a previously added
 column (overriding any type info on the column instance itself).

setContext(Object) - Method in class com.healthmarketscience.common.util.AppendableExt

Sets the "context" that will be returned from subsequent
 getContext() calls.

setCustomColumnObject(Object) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Sets the actual sql to be generated by this column.

setCustomName(Object) - Method in class com.healthmarketscience.sqlbuilder.BaseCreateQuery

Sets the name of the object being created.

setCustomTableName(Object) - Method in class com.healthmarketscience.sqlbuilder.CreateIndexQuery

Sets the name of the table which is being indexed.

setCustomTarget(Object) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery

Sets the target for the query.

setDefaultValue(Object) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddColumnAction

Sets the given value as the column default value for this action.

setDefaultValue(Object) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Sets the default value for this column.

setDisableParens(boolean) - Method in class com.healthmarketscience.sqlbuilder.Condition
 
setDisableParens(boolean) - Method in class com.healthmarketscience.sqlbuilder.Expression
 
setFailedVerifiable(Map.Entry<ValidationContext, ? extends Verifiable<?>>) - Method in exception com.healthmarketscience.sqlbuilder.ValidationException
 
setFetchNext(Object) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery

Sets the value for the "FETCH NEXT" clause.

setForUpdate(boolean) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery

Iff forUpdate is true, adds the FOR UPDATE clause to the
      end of the SELECT clause

setFrame(Object, Object) - Method in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause

Sets the window's "frame" clause to the given units and starting bound.

setFrame(Object, Object, Object) - Method in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause

Sets the window's "frame" clause to the given units, starting bound, and
 exclusion.

setFrameBetween(Object, Object, Object) - Method in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause

Sets the window's "frame" clause to the given units and bound range.

setFrameBetween(Object, Object, Object, Object) - Method in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause

Sets the window's "frame" clause to the given units, bound range, and
 exclusion.

setIndexType(CreateIndexQuery.IndexType) - Method in class com.healthmarketscience.sqlbuilder.CreateIndexQuery

Sets the type of index to be created.

setInt(int, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.MultiPlaceHolder
 
setInt(int, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Calls setInt on the given PreparedStatement with the given value
 for the position of this PlaceHolder.

setInt(Integer, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Calls setInt on the given PreparedStatement with the given value for
 the position of this PlaceHolder.

setInts(PreparedStatement, int...) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Calls setInt on the given PreparedStatement with the given values for
 the positions of this PlaceHolder.

setInts(PreparedStatement, Iterable<? extends Integer>) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Calls setInt on the given PreparedStatement with the given values for
 the positions of this PlaceHolder.

setIsDistinct(boolean) - Method in class com.healthmarketscience.sqlbuilder.FunctionCall

Iff isDistinct is true, adds the DISTINCT keyword to the
      parameter clause

setIsDistinct(boolean) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery

Iff isDistinct is true, adds the DISTINCT keyword to the
      SELECT clause so that only unique rows are returned

setIsPercent(boolean) - Method in class com.healthmarketscience.sqlbuilder.custom.sqlserver.MssTopClause
 
setLikeEscapeChar(Character) - Method in class com.healthmarketscience.sqlbuilder.BinaryCondition

Sets the escape charactor for a [NOT] LIKE condition pattern.

setLocalOnly(boolean) - Method in class com.healthmarketscience.sqlbuilder.ValidationContext
 
setLong(long, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.MultiPlaceHolder
 
setLong(long, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Calls setLong on the given PreparedStatement with the given value
 for the position of this PlaceHolder.

setLong(Long, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Calls setLong on the given PreparedStatement with the given value for
 the position of this PlaceHolder.

setLongs(PreparedStatement, long...) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Calls setLong on the given PreparedStatement with the given values
 for the positions of this PlaceHolder.

setLongs(PreparedStatement, Iterable<? extends Long>) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Calls setLong on the given PreparedStatement with the given values for
 the positions of this PlaceHolder.

setName(String) - Method in class com.healthmarketscience.sqlbuilder.BaseCreateQuery

Sets the name of the object being created.

setNegate(boolean) - Method in class com.healthmarketscience.sqlbuilder.BetweenCondition

Sets whether or not the between condition should be negated or not

setNegate(boolean) - Method in class com.healthmarketscience.sqlbuilder.InCondition

Sets whether or not the in condition should be negated or not

setNonNullObject(Object, int, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.MultiPlaceHolder
 
setNonNullObject(Object, int, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Calls setObject on the given PreparedStatement with the given value
 and the given sql type for the position of this PlaceHolder.

setNonNullString(String, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.MultiPlaceHolder
 
setNonNullString(String, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Calls setString on the given PreparedStatement with the given value
 for the position of this PlaceHolder.

setNull(int, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.MultiPlaceHolder
 
setNull(int, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Calls setNull on the given PreparedStatement with the given sql type
 for the position of this PlaceHolder.

setNullOrder(OrderObject.NullOrder) - Method in class com.healthmarketscience.sqlbuilder.OrderObject

Sets the null order for this order specification.

setNulls(int, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Calls setNull on the given PreparedStatement with the given sql type
 for the positions of this PlaceHolder.

setObject(Object, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.MultiPlaceHolder
 
setObject(Object, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Calls setObject on the given PreparedStatement with the given value
 for the position of this PlaceHolder.

setObject(Object, int, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Calls setObject on the given PreparedStatement with the given value
 and the given sql type for the position of this PlaceHolder.

setObjects(PreparedStatement, Object...) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Calls setObject on the given PreparedStatement with the given values
 for the positions of this PlaceHolder.

setObjects(PreparedStatement, Iterable<?>) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Calls setObject on the given PreparedStatement with the given values
 for the positions of this PlaceHolder.

setObjects(int, PreparedStatement, Object...) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Calls setObject on the given PreparedStatement with the given values
 and the given sql type for the positions of this PlaceHolder.

setObjects(int, PreparedStatement, Iterable<?>) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Calls setObject on the given PreparedStatement with the given value and
 the given sql type for the position of this PlaceHolder.

setOffset(Object) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery

Sets the value for the "OFFSET" clause.

setOnDeleteAction(Object) - Method in class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause

Sets the referential action to be taken on delete.

setOnUpdateAction(Object) - Method in class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause

Sets the referential action to be taken on update.

SetOperationQuery<ThisType extends SetOperationQuery<ThisType>> - Class in com.healthmarketscience.sqlbuilder

Base query for queries which generate a series of SELECT queries joined by
 one or more "set operations", such as UNION [ALL], EXCEPT [ALL], and
 INTERSECT [ALL].

SetOperationQuery(SetOperationQuery.Type) - Constructor for class com.healthmarketscience.sqlbuilder.SetOperationQuery
 
SetOperationQuery(SetOperationQuery.Type, Object...) - Constructor for class com.healthmarketscience.sqlbuilder.SetOperationQuery
 
SetOperationQuery.Type - Enum in com.healthmarketscience.sqlbuilder

Enumeration representing the type of union to use

setQuery(Object) - Method in class com.healthmarketscience.sqlbuilder.CommonTableExpression

Sets the CTE definition query.

setQuery(Query<?>) - Method in class com.healthmarketscience.sqlbuilder.SqlContext

Sets the handle to the immediate wrapping query

setRecursive(boolean) - Method in class com.healthmarketscience.sqlbuilder.BaseCTEQuery
 
setSelectQuery(SelectQuery) - Method in class com.healthmarketscience.sqlbuilder.CreateViewQuery

Sets the SELECT query which will generate the data in the view

setSelectQuery(SelectQuery) - Method in class com.healthmarketscience.sqlbuilder.InsertSelectQuery

Sets the SELECT query which will generate the data to insert into the
      table

setStaticValues(PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer

Calls QueryPreparer.StaticPlaceHolder.setValue(java.sql.PreparedStatement) on all the StaticPlaceHolders
 held by this class with the given PreparedStatement.

setString(String, PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.PlaceHolder

Calls setString on the given PreparedStatement with the given value
 for the position of this PlaceHolder.

setStrings(PreparedStatement, String...) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Calls setString on the given PreparedStatement with the given values for
 the positions of this PlaceHolder.

setStrings(PreparedStatement, Iterable<? extends String>) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ListPlaceHolder

Calls setString on the given PreparedStatement with the given values
 for the positions of this PlaceHolder.

setTableAlias(String) - Method in class com.healthmarketscience.sqlbuilder.CommonTableExpression

Sets the pseudo Table alias for use by the pseudo Columns when used in
 subsequent queries.

setTableName(String) - Method in class com.healthmarketscience.sqlbuilder.CreateIndexQuery

Sets the name of the table which is being indexed.

setTables(Collection<Table>) - Method in class com.healthmarketscience.sqlbuilder.ValidationContext
 
setTableSpace(String) - Method in class com.healthmarketscience.sqlbuilder.CreateIndexQuery

Deprecated.
Use addCustomization(new OraTableSpaceClause(tableSpace))
             instead.


setTableSpace(String) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery

Deprecated.
Use addCustomization(new OraTableSpaceClause(tableSpace))
             instead.


setTableType(CreateTableQuery.TableType) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery

Sets the type of table to be created.

setTarget(BaseGrantQuery.TargetObject) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery

Sets the target for the query.

setTypeName(String) - Method in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddColumnAction

Sets the given type name as the column type name for this action
 (overriding any type info on the column instance itself).

setUseTableAliases(boolean) - Method in class com.healthmarketscience.sqlbuilder.SqlContext

Sets flag indicating whether or not table aliases should be used in the
 current SQL generation context.

setUseTableConstraints(boolean) - Method in class com.healthmarketscience.sqlbuilder.SqlContext

Sets flag indicating whether or not table constraints should be used in
 the current SQL generation context.

setValue(PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.BooleanStaticPlaceHolder
 
setValue(PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.IntegerStaticPlaceHolder
 
setValue(PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.LongStaticPlaceHolder
 
setValue(PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.NullStaticPlaceHolder
 
setValue(PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.ObjectStaticPlaceHolder
 
setValue(PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.StaticPlaceHolder

Calls the appropriate set method on the given PreparedStatement with
 the saved static value for the position of this PlaceHolder.

setValue(PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.StringStaticPlaceHolder
 
setValue(PreparedStatement) - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer.TypedStaticPlaceHolder
 
setWindow(Object) - Method in class com.healthmarketscience.sqlbuilder.FunctionCall

Sets the window clause for this function call, like
 "OVER (<windowClause>)".

setWindowByName(String) - Method in class com.healthmarketscience.sqlbuilder.FunctionCall

Sets the window clause for this function call to a reference to the named
 window definition, like "OVER <windowClauseName>".

setWithCheckOption(boolean) - Method in class com.healthmarketscience.sqlbuilder.CreateViewQuery

Sets whether or not inserts/updates to the view are required to affect
 rows with are in fact visible to the view.

similarTo(Object, Object) - Static method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgBinaryCondition

Convenience method for generating a Condition for testing if a column is
 "similar to" a given value (sql regex matching).

SimpleCaseStatement - Class in com.healthmarketscience.sqlbuilder

Outputs a simple case statement like:
 "CASE <column1> WHEN <val1> THEN <result1> [ WHEN
 <val2> THEN <result2> WHEN ...


SimpleCaseStatement(Column) - Constructor for class com.healthmarketscience.sqlbuilder.SimpleCaseStatement
 
SimpleCaseStatement(Object) - Constructor for class com.healthmarketscience.sqlbuilder.SimpleCaseStatement

Object -> SqlObject conversions handled by
 Converter.toColumnSqlObject(Object).

size() - Method in class com.healthmarketscience.sqlbuilder.SqlObjectList
 
SqlContext - Class in com.healthmarketscience.sqlbuilder

Object which maintains context for the sqlbuilder classes when a SQL
 statement is being generated.

SqlContext() - Constructor for class com.healthmarketscience.sqlbuilder.SqlContext
 
SqlObject - Class in com.healthmarketscience.sqlbuilder

Base object which all classes in this facility extend.

SqlObject() - Constructor for class com.healthmarketscience.sqlbuilder.SqlObject
 
SqlObjectList<ObjType extends SqlObject> - Class in com.healthmarketscience.sqlbuilder

Maintains a list of SqlObjects.

SqlObjectList() - Constructor for class com.healthmarketscience.sqlbuilder.SqlObjectList
 
SqlObjectList(String) - Constructor for class com.healthmarketscience.sqlbuilder.SqlObjectList
 
SqlObjectList(String, List<ObjType>) - Constructor for class com.healthmarketscience.sqlbuilder.SqlObjectList
 
StaticPlaceHolder(QueryPreparer) - Constructor for class com.healthmarketscience.sqlbuilder.QueryPreparer.StaticPlaceHolder
 
StringAppendableExt - Class in com.healthmarketscience.common.util

Simple extension of AppendableExt that swallows IOExceptions under the
 assumption that it will generally be used with Appendables which do not
 actually throw any IOExceptions (i.e.

StringAppendableExt() - Constructor for class com.healthmarketscience.common.util.StringAppendableExt

Initialize a new StringAppendableExt based on a StringBuilder.

StringAppendableExt(int) - Constructor for class com.healthmarketscience.common.util.StringAppendableExt

Initialize a new StringAppendableExt based on a StringBuilder, with a
 specified initial capacity.

StringAppendableExt(int, Object) - Constructor for class com.healthmarketscience.common.util.StringAppendableExt

Initialize a new StringAppendableExt based on a StringBuilder, with a
 specified initial capacity and given context.

StringAppendableExt(Appendable) - Constructor for class com.healthmarketscience.common.util.StringAppendableExt

Initialize a new StringAppendableExt based on the given Appendable.

StringAppendableExt(Appendable, Object) - Constructor for class com.healthmarketscience.common.util.StringAppendableExt

Initialize a new StringAppendableExt based on the given Appendable and
 context.

StringStaticPlaceHolder(String, QueryPreparer) - Constructor for class com.healthmarketscience.sqlbuilder.QueryPreparer.StringStaticPlaceHolder
 
subquery(Object) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a subquery expression.

Subquery - Class in com.healthmarketscience.sqlbuilder

Outputs the given query surrounded by parentheses
 "(<query>)", useful for embedding one query within
 another.

Subquery(Object) - Constructor for class com.healthmarketscience.sqlbuilder.Subquery

Object -> SqlObject conversions handled by
 Converter.toCustomSqlObject(Object).

subtract() - Static method in class com.healthmarketscience.sqlbuilder.ComboExpression

Convenience method for generating a ComboExpression for joining
 expressions using '-'.

subtract(Object...) - Static method in class com.healthmarketscience.sqlbuilder.ComboExpression

Convenience method for generating a ComboExpression for joining
 the given expressions using '-'.

subtract() - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a ComboExpression for joining
 expressions using '-'.

subtract(Object...) - Static method in class com.healthmarketscience.sqlbuilder.Expressions

Convenience method for generating a ComboExpression for joining
 the given expressions using '-'.

sum() - Static method in class com.healthmarketscience.sqlbuilder.FunctionCall

Convenience method for generating a FunctionCall using the standard SUM
 function.

supportsEscape(Object) - Method in class com.healthmarketscience.sqlbuilder.BinaryCondition
 
supportsEscape(Object) - Method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgBinaryCondition
 




T

Table - Interface in com.healthmarketscience.sqlbuilder.dbspec

Maintains information about a database table for use with the sqlbuilder
 utilities.

TargetObject(BaseGrantQuery.TargetObject.Type, SqlObject) - Constructor for class com.healthmarketscience.sqlbuilder.BaseGrantQuery.TargetObject
 
targetTable(Table) - Static method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
time(Date) - Static method in class com.healthmarketscience.sqlbuilder.JdbcEscape
 
time(LocalTime) - Static method in class com.healthmarketscience.sqlbuilder.JdbcEscape
 
time(TemporalAccessor) - Static method in class com.healthmarketscience.sqlbuilder.JdbcEscape
 
timestamp(Date) - Static method in class com.healthmarketscience.sqlbuilder.JdbcEscape
 
timestamp(LocalDateTime) - Static method in class com.healthmarketscience.sqlbuilder.JdbcEscape
 
timestamp(TemporalAccessor) - Static method in class com.healthmarketscience.sqlbuilder.JdbcEscape
 
toAliasedObject(SqlObject, String) - Static method in class com.healthmarketscience.sqlbuilder.AliasedObject

Optionally adds an alias to a SqlObject.

toColumnSqlObject(Column) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a Column to a SqlObject.

toColumnSqlObject(Column, String) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a Column to a SqlObject with the given alias.

toColumnSqlObject(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a column Object to a SqlObject.

toColumnSqlObject(Object, String) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a column Object to a SqlObject with the given alias.

toConditionObject(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts an Object to a Condition.

toConstraintSqlObject(Constraint) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a Constraint to a SqlObject.

toCustomColumnSqlObject(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a column Object to a SqlObject.

toCustomColumnSqlObject(Object, String) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a column Object to a SqlObject.

toCustomConstraintClause(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts an constraint clause Object to a SqlObject.

toCustomConstraintSqlObject(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a constraint Object to a SqlObject for use in a constraint
 clause..

toCustomFunctionSqlObject(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a function Object to a SqlObject.

toCustomIndexSqlObject(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a index Object to a SqlObject.

toCustomSqlObject(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts an Object to a custom SqlObject.

toCustomSqlObject(Object, String) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts an Object to a custom SqlObject.

toCustomTableDefSqlObject(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a table Object to a SqlObject.

toCustomTableSqlObject(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a table Object to a SqlObject.

toCustomTypedColumnSqlObject(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a column Object to a SqlObject.

toExpressionObject(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts an Object to an Expression.

toFunctionSqlObject(Function) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a Function to a SqlObject.

toIndexSqlObject(Index) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a Index to a SqlObject.

toString() - Method in class com.healthmarketscience.common.util.AppendableExt

Get the result of calling toString() on the underlying Appendable.

toString(int) - Method in class com.healthmarketscience.common.util.AppendeeObject
 
toString() - Method in class com.healthmarketscience.common.util.AppendeeObject
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.BaseGrantQuery.Privilege.Type
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.BaseGrantQuery.TargetObject.Type
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.BinaryCondition.Op
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.ComboCondition.Op
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.ComboExpression.Op
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.ConstraintClause.CheckTime
 
toString(boolean) - Method in enum com.healthmarketscience.sqlbuilder.ConstraintClause.Type
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.CreateIndexQuery.IndexType
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.CreateTableQuery.ColumnConstraint

Deprecated.
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.CreateTableQuery.TableType
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.custom.postgresql.PgBinaryCondition.PgOp
 
toString() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbConstraint
 
toString() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbObject
 
toString() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable
 
toString() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable.RejoinColumn
 
toString() - Method in class com.healthmarketscience.sqlbuilder.dbspec.RejoinTable
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.DropQuery.Behavior
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.DropQuery.Type
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause.ReferentialAction
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.JdbcEscape.Type
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.OrderObject.Dir
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.OrderObject.NullOrder
 
toString() - Method in class com.healthmarketscience.sqlbuilder.QueryPreparer

outputs the static place holders in order

toString() - Method in enum com.healthmarketscience.sqlbuilder.SelectQuery.JoinType
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.SetOperationQuery.Type
 
toString(int, SqlContext) - Method in class com.healthmarketscience.sqlbuilder.SqlObject

Creates a SQL string from this object using the given initial size for
 the AppendableExt buffer and the given SqlContext.

toString() - Method in enum com.healthmarketscience.sqlbuilder.UnaryCondition.Op
 
toString() - Method in enum com.healthmarketscience.sqlbuilder.WindowDefinitionClause.FrameExclusion
 
toSubquery(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts an Object to a Subquery.

toTableDefSqlObject(Table) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a Table to a table definition SqlObject.

toTableSqlObject(Table) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a Table to a SqlObject.

toValueSqlObject(Object) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a value Object to a SqlObject.

toValueSqlObject(Object, String) - Static method in class com.healthmarketscience.sqlbuilder.Converter

Converts a value Object to a SqlObject with the given alias.

TRUE - Static variable in class com.healthmarketscience.sqlbuilder.BooleanValueObject

BooleanValueObject representing "true"

TYPED_COLUMN_TO_OBJ - Static variable in class com.healthmarketscience.sqlbuilder.Converter

Converter which converts a Column to a TypedColumnObject or a value
      object to a SqlObject using Converter.toCustomSqlObject(Object)

TypedStaticPlaceHolder(Object, int, QueryPreparer) - Constructor for class com.healthmarketscience.sqlbuilder.QueryPreparer.TypedStaticPlaceHolder
 




U

UnaryCondition - Class in com.healthmarketscience.sqlbuilder

Outputs a unary based condition
 "(<column> <unaryOp>)" or
 "(<unaryOp> <column>)".

UnaryCondition(UnaryCondition.Op, SqlObject) - Constructor for class com.healthmarketscience.sqlbuilder.UnaryCondition
 
UnaryCondition(UnaryCondition.Op, Object) - Constructor for class com.healthmarketscience.sqlbuilder.UnaryCondition

Object -> SqlObject conversions handled by
 UnaryCondition.Op.getConverter().

UnaryCondition(UnaryCondition.CustomUnaryOp, Object) - Constructor for class com.healthmarketscience.sqlbuilder.UnaryCondition

Object -> SqlObject conversions handled by
 UnaryCondition.CustomUnaryOp.getConverter().

UnaryCondition.CustomUnaryOp - Interface in com.healthmarketscience.sqlbuilder

Interface which can be implemented to provide a custom unary operation.

UnaryCondition.Op - Enum in com.healthmarketscience.sqlbuilder

Enum representing the unary operations supported in a SQL condition,
 e.g.

UNBOUNDED_FOLLOWING - Static variable in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause.FrameBound
 
UNBOUNDED_PRECEDING - Static variable in class com.healthmarketscience.sqlbuilder.WindowDefinitionClause.FrameBound
 
union() - Static method in class com.healthmarketscience.sqlbuilder.SetOperationQuery

Convenience method to create a UNION query.

union(SelectQuery...) - Static method in class com.healthmarketscience.sqlbuilder.SetOperationQuery

Convenience method to create a UNION query.

unionAll() - Static method in class com.healthmarketscience.sqlbuilder.SetOperationQuery

Convenience method to create a UNION ALL query.

unionAll(SelectQuery...) - Static method in class com.healthmarketscience.sqlbuilder.SetOperationQuery

Convenience method to create a UNION ALL query.

UnionQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates a series of SELECT queries joined by UNION clauses.

UnionQuery(SetOperationQuery.Type) - Constructor for class com.healthmarketscience.sqlbuilder.UnionQuery
 
UnionQuery(SetOperationQuery.Type, SelectQuery...) - Constructor for class com.healthmarketscience.sqlbuilder.UnionQuery
 
unique(Object) - Static method in class com.healthmarketscience.sqlbuilder.Conditions

Convenience method for generating a Condition for testing whether a
 subquery returns exactly one row.

unique() - Static method in class com.healthmarketscience.sqlbuilder.ConstraintClause

Convenience method for generating an unnamed unique constraint.

unique(Object) - Static method in class com.healthmarketscience.sqlbuilder.ConstraintClause

Convenience method for generating a unique constraint with the given
 name.

unique() - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Creates and adds unique constraint with the given parameters to this
 column.

unique(String) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbColumn

Creates and adds unique constraint with the given parameters to this
 column.

unique(String, String...) - Method in class com.healthmarketscience.sqlbuilder.dbspec.basic.DbTable

Creates and adds unique constraint with the given parameters to this
 table.

unique(Object) - Static method in class com.healthmarketscience.sqlbuilder.UnaryCondition

Convenience method for generating a Condition for testing whether a
 subquery returns exactly one row.

updateBoolean(boolean, ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls updateBoolean on the given ResultSet with the given value
 for the position of this PlaceHolder.

updateBoolean(Boolean, ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls updateBoolean on the given ResultSet with the given value for
 the position of this PlaceHolder.

updateInt(int, ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls updateInt on the given ResultSet with the given value
 for the position of this PlaceHolder.

updateInt(Integer, ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls updateInt on the given ResultSet with the given value for
 the position of this PlaceHolder.

updateLong(long, ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls updateLong on the given ResultSet with the given value
 for the position of this PlaceHolder.

updateLong(Long, ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls updateLong on the given ResultSet with the given value for
 the position of this PlaceHolder.

updateNull(ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls updateNull on the given ResultSet with the given sql type
 for the position of this PlaceHolder.

updateObject(Object, ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls updateObject on the given ResultSet with the given value for the
 position of this PlaceHolder.

UpdateQuery - Class in com.healthmarketscience.sqlbuilder

Query which generates an UPDATE statement.

UpdateQuery(Table) - Constructor for class com.healthmarketscience.sqlbuilder.UpdateQuery
 
UpdateQuery(Object) - Constructor for class com.healthmarketscience.sqlbuilder.UpdateQuery

Object -> SqlObject conversions handled by
 Converter.toCustomTableSqlObject(Object).

updateString(String, ResultSet) - Method in class com.healthmarketscience.sqlbuilder.QueryReader.Column

Calls updateString on the given ResultSet with the given value
 for the position of this PlaceHolder.

USE_BOOLEAN_LITERALS_PROPERTY - Static variable in class com.healthmarketscience.sqlbuilder.BooleanValueObject
 
USE_SPACE_AFTER_DELIMITER_PROPERTY - Static variable in class com.healthmarketscience.sqlbuilder.SqlObjectList
 




V

validate() - Method in class com.healthmarketscience.sqlbuilder.BaseCaseStatement
 
validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.BaseCaseStatement
 
validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.BaseCreateQuery
 
validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
validate() - Method in class com.healthmarketscience.sqlbuilder.CommonTableExpression
 
validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.CommonTableExpression
 
validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.CreateTableQuery
 
validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.CreateViewQuery
 
validate() - Method in class com.healthmarketscience.sqlbuilder.custom.mysql.MysLimitClause
 
validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.custom.mysql.MysLimitClause
 
validate() - Method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgLimitClause
 
validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgLimitClause
 
validate() - Method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgOffsetClause
 
validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.custom.postgresql.PgOffsetClause
 
validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.InsertQuery

Does Query.validate() and additionally verifies that there are an equal
 number of columns and values.

validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.InsertSelectQuery
 
validate() - Method in class com.healthmarketscience.sqlbuilder.Query
 
validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.Query
 
validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.SelectQuery
 
validate(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.SetOperationQuery
 
validate() - Method in interface com.healthmarketscience.sqlbuilder.Verifiable

Runs validation on this verifiable object.

validate(ValidationContext) - Method in interface com.healthmarketscience.sqlbuilder.Verifiable

Runs validation on this verifiable object using a previously collected
 ValidationContext.

validateAll() - Method in class com.healthmarketscience.sqlbuilder.ValidationContext
 
validateOrdering(int, SqlObjectList<SqlObject>, boolean) - Static method in class com.healthmarketscience.sqlbuilder.SelectQuery

Checks any indexed ordering values for validity using a variety of
 criteria.

validateTables(ValidationContext) - Method in class com.healthmarketscience.sqlbuilder.Query

Verifies that any columns referenced in the query have their respective
 tables also referenced in the query.

ValidationContext - Class in com.healthmarketscience.sqlbuilder

Object used to accummulate state during query validation.

ValidationContext() - Constructor for class com.healthmarketscience.sqlbuilder.ValidationContext
 
ValidationContext(ValidationContext) - Constructor for class com.healthmarketscience.sqlbuilder.ValidationContext
 
ValidationContext(boolean) - Constructor for class com.healthmarketscience.sqlbuilder.ValidationContext
 
ValidationContext(Collection<Table>, Collection<Column>) - Constructor for class com.healthmarketscience.sqlbuilder.ValidationContext
 
ValidationContext(ValidationContext, Collection<Table>, Collection<Column>, boolean) - Constructor for class com.healthmarketscience.sqlbuilder.ValidationContext
 
ValidationException - Exception in com.healthmarketscience.sqlbuilder

Indicates that a sql builder query is not valid.

ValidationException(String) - Constructor for exception com.healthmarketscience.sqlbuilder.ValidationException
 
ValidationException(String, Throwable) - Constructor for exception com.healthmarketscience.sqlbuilder.ValidationException
 
ValidationException(Throwable) - Constructor for exception com.healthmarketscience.sqlbuilder.ValidationException
 
VALUE_TO_OBJ - Static variable in class com.healthmarketscience.sqlbuilder.Converter

Converter which converts a value object to a SqlObject using
      Converter.toValueSqlObject(Object)

ValueObject - Class in com.healthmarketscience.sqlbuilder

Outputs a quoted value "'<value>'".

ValueObject(Object) - Constructor for class com.healthmarketscience.sqlbuilder.ValueObject
 
valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.BaseGrantQuery.Privilege.Type

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.BaseGrantQuery.TargetObject.Type

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.BinaryCondition.Op

Returns the enum constant of this type with the specified name.

valueOf(Boolean) - Static method in class com.healthmarketscience.sqlbuilder.BooleanValueObject

Returns a BooleanValueObject for the given Boolean value.

valueOf(boolean) - Static method in class com.healthmarketscience.sqlbuilder.BooleanValueObject

Returns a BooleanValueObject for the given boolean value.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.ComboCondition.Op

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.ComboExpression.Op

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.ConstraintClause.CheckTime

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.ConstraintClause.Type

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.CreateIndexQuery.Hook

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.CreateIndexQuery.IndexType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.CreateTableQuery.ColumnConstraint

Deprecated.
Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.CreateTableQuery.Hook

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.CreateTableQuery.TableType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.custom.HookType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.custom.mysql.MysExtractDatePart

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.custom.oracle.OraExtractDatePart

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.custom.postgresql.PgBinaryCondition.PgOp

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.custom.postgresql.PgExtractDatePart

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.dbspec.Constraint.Type

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.DropQuery.Behavior

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.DropQuery.Type

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.ExtractExpression.DatePart

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause.ReferentialAction

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.JdbcEscape.Type

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.OrderObject.Dir

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.OrderObject.NullOrder

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.SelectQuery.Hook

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.SelectQuery.JoinType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.SetOperationQuery.Type

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.UnaryCondition.Op

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.WindowDefinitionClause.FrameExclusion

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum com.healthmarketscience.sqlbuilder.WindowDefinitionClause.FrameUnits

Returns the enum constant of this type with the specified name.

values() - Static method in enum com.healthmarketscience.sqlbuilder.BaseGrantQuery.Privilege.Type

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.BaseGrantQuery.TargetObject.Type

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.BinaryCondition.Op

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.ComboCondition.Op

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.ComboExpression.Op

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.ConstraintClause.CheckTime

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.ConstraintClause.Type

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.CreateIndexQuery.Hook

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.CreateIndexQuery.IndexType

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.CreateTableQuery.ColumnConstraint

Deprecated.
Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.CreateTableQuery.Hook

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.CreateTableQuery.TableType

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.custom.HookType

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.custom.mysql.MysExtractDatePart

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.custom.oracle.OraExtractDatePart

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.custom.postgresql.PgBinaryCondition.PgOp

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.custom.postgresql.PgExtractDatePart

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.dbspec.Constraint.Type

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.DropQuery.Behavior

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.DropQuery.Type

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.ExtractExpression.DatePart

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause.ReferentialAction

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.JdbcEscape.Type

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.OrderObject.Dir

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.OrderObject.NullOrder

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.SelectQuery.Hook

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.SelectQuery.JoinType

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.SetOperationQuery.Type

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.UnaryCondition.Op

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.WindowDefinitionClause.FrameExclusion

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum com.healthmarketscience.sqlbuilder.WindowDefinitionClause.FrameUnits

Returns an array containing the constants of this enum type, in
the order they are declared.

Verifiable<ThisType extends Verifiable<ThisType>> - Interface in com.healthmarketscience.sqlbuilder

Interface for SqlObjects wishing to provide verifiablity.





W

WindowDefinitionClause - Class in com.healthmarketscience.sqlbuilder

Outputs a window function clause like:
 ([PARTITION BY <cols>] [ORDER BY <cols>] [<frameClause>])
 Can be used inline on a FunctionCall or via a named reference in a
 SelectQuery.

WindowDefinitionClause() - Constructor for class com.healthmarketscience.sqlbuilder.WindowDefinitionClause
 
WindowDefinitionClause.FrameBound - Class in com.healthmarketscience.sqlbuilder

Outputs a bound for the window frame clause.

WindowDefinitionClause.FrameExclusion - Enum in com.healthmarketscience.sqlbuilder

Outputs the exclusion for the window frame clause.

WindowDefinitionClause.FrameUnits - Enum in com.healthmarketscience.sqlbuilder

Outputs the units for the window frame clause.





_

_checkTime - Variable in class com.healthmarketscience.sqlbuilder.ConstraintClause
 
_columns - Variable in class com.healthmarketscience.sqlbuilder.BaseCreateQuery
 
_columns - Variable in class com.healthmarketscience.sqlbuilder.ConstraintClause
 
_constraint - Variable in class com.healthmarketscience.sqlbuilder.AlterTableQuery.AddConstraintAction
 
_constraints - Variable in class com.healthmarketscience.sqlbuilder.CreateTableQuery
 
_grantees - Variable in class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
_name - Variable in class com.healthmarketscience.sqlbuilder.ConstraintClause
 
_object - Variable in class com.healthmarketscience.sqlbuilder.BaseCreateQuery
 
_onDeleteAction - Variable in class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause
 
_onUpdateAction - Variable in class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause
 
_privileges - Variable in class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
_query - Variable in class com.healthmarketscience.sqlbuilder.Subquery
 
_refColumns - Variable in class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause
 
_refTable - Variable in class com.healthmarketscience.sqlbuilder.ForeignKeyConstraintClause
 
_table - Variable in class com.healthmarketscience.sqlbuilder.CreateIndexQuery
 
_targetObj - Variable in class com.healthmarketscience.sqlbuilder.BaseGrantQuery
 
_type - Variable in class com.healthmarketscience.sqlbuilder.ConstraintClause
 
_val - Variable in class com.healthmarketscience.sqlbuilder.QueryPreparer.ObjectStaticPlaceHolder
 

A B C D E F G H I J L M N O P Q R S T U V W _