Package | Description |
---|---|
com.healthmarketscience.common.util | |
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 |
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 |
SqlBuilder customizations specific to the MySQL database.
|
com.healthmarketscience.sqlbuilder.custom.oracle |
SqlBuilder customizations specific to the Oracle database.
|
com.healthmarketscience.sqlbuilder.custom.postgresql |
SqlBuilder customizations specific to the PostgreSQL database.
|
com.healthmarketscience.sqlbuilder.custom.sqlserver |
SqlBuilder customizations specific to the SQL Server database.
|
Modifier and Type | Class and Description |
---|---|
class |
StringAppendableExt
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.
|
Modifier and Type | Method and Description |
---|---|
AppendableExt |
AppendableExt.append(Appendee a)
Will call the appendTo() method on the given object.
|
AppendableExt |
AppendableExt.append(char c) |
AppendableExt |
AppendableExt.append(CharSequence s) |
AppendableExt |
AppendableExt.append(CharSequence s,
int start,
int end) |
AppendableExt |
AppendableExt.append(Iterable<?> iable,
Object delimiter)
Will iterate the given Iterable and append each object separated by the
given delimiter.
|
AppendableExt |
AppendableExt.append(Object o)
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).
|
Modifier and Type | Method and Description |
---|---|
void |
AppendeeObject.appendTo(AppendableExt a) |
void |
Appendee.appendTo(AppendableExt a)
Appends this object to the given AppendableExt.
|
Modifier and Type | Method and Description |
---|---|
protected AppendableExt |
CustomizableSqlObject.customAppendTo(AppendableExt app,
HookAnchor anchor)
Appends any
HookType.BEFORE or HookType.AFTER
customizations for the given anchor. |
protected AppendableExt |
CustomizableSqlObject.customAppendTo(AppendableExt app,
HookAnchor anchor,
String str)
Appends all customizations for the given anchor.
|
Modifier and Type | Method and Description |
---|---|
void |
CustomCondition.appendTo(AppendableExt app) |
void |
SqlObjectList.appendTo(AppendableExt app) |
void |
ComboExpression.appendTo(AppendableExt app) |
void |
AliasedObject.appendTo(AppendableExt app) |
void |
Subquery.appendTo(AppendableExt app) |
void |
NegateExpression.appendTo(AppendableExt app) |
void |
WindowDefinitionClause.appendTo(AppendableExt app) |
void |
WindowDefinitionClause.FrameBound.appendTo(AppendableExt app) |
void |
CustomSql.appendTo(AppendableExt app) |
void |
Comment.appendTo(AppendableExt app) |
void |
ForeignKeyConstraintClause.appendTo(AppendableExt app) |
void |
FunctionCall.appendTo(AppendableExt app) |
void |
BetweenCondition.appendTo(AppendableExt app) |
void |
ComboCondition.appendTo(AppendableExt app) |
void |
NumberValueObject.appendTo(AppendableExt app) |
void |
BinaryCondition.appendTo(AppendableExt app) |
void |
CustomExpression.appendTo(AppendableExt app) |
void |
BooleanValueObject.appendTo(AppendableExt app) |
void |
BaseCaseStatement.appendTo(AppendableExt app) |
void |
ValueObject.appendTo(AppendableExt app) |
void |
BaseGrantQuery.Privilege.appendTo(AppendableExt app) |
void |
BaseGrantQuery.TargetObject.appendTo(AppendableExt app) |
void |
AlterTableQuery.AddConstraintAction.appendTo(AppendableExt app) |
void |
AlterTableQuery.AddColumnAction.appendTo(AppendableExt app) |
void |
OrderObject.appendTo(AppendableExt app) |
void |
Query.appendTo(AppendableExt app) |
void |
InCondition.appendTo(AppendableExt app) |
void |
CheckConstraintClause.appendTo(AppendableExt app) |
void |
ExtractExpression.appendTo(AppendableExt app) |
void |
JdbcEscape.appendTo(AppendableExt app) |
void |
NotCondition.appendTo(AppendableExt app) |
void |
UnaryCondition.appendTo(AppendableExt app) |
void |
QueryPreparer.PlaceHolder.appendTo(AppendableExt app) |
void |
QueryPreparer.ListPlaceHolder.appendTo(AppendableExt app) |
void |
ConstraintClause.appendTo(AppendableExt app) |
void |
QueryReader.Column.appendTo(AppendableExt app) |
void |
CommonTableExpression.appendTo(AppendableExt app) |
protected void |
InsertQuery.appendTo(AppendableExt app,
SqlContext newContext) |
protected void |
DeleteQuery.appendTo(AppendableExt app,
SqlContext newContext) |
protected void |
GrantQuery.appendTo(AppendableExt app,
SqlContext newContext) |
protected void |
InsertSelectQuery.appendTo(AppendableExt app,
SqlContext newContext) |
protected void |
SetOperationQuery.appendTo(AppendableExt app,
SqlContext newContext) |
protected void |
CreateTableQuery.appendTo(AppendableExt app,
SqlContext newContext) |
protected void |
DropQuery.appendTo(AppendableExt app,
SqlContext newContext) |
protected void |
UpdateQuery.appendTo(AppendableExt app,
SqlContext newContext) |
protected void |
AlterTableQuery.appendTo(AppendableExt app,
SqlContext newContext) |
protected abstract void |
Query.appendTo(AppendableExt app,
SqlContext newContext)
Appends the sql query to the given AppendableExt within the given,
modifiable SqlContext.
|
protected void |
RevokeQuery.appendTo(AppendableExt app,
SqlContext newContext) |
protected void |
CreateViewQuery.appendTo(AppendableExt app,
SqlContext newContext) |
protected void |
SelectQuery.appendTo(AppendableExt app,
SqlContext newContext) |
protected void |
CreateIndexQuery.appendTo(AppendableExt app,
SqlContext newContext) |
protected void |
InCondition.closeParen(AppendableExt app) |
protected AppendableExt |
CustomizableSqlObject.customAppendTo(AppendableExt app,
HookAnchor anchor)
Appends any
HookType.BEFORE or HookType.AFTER
customizations for the given anchor. |
protected AppendableExt |
CustomizableSqlObject.customAppendTo(AppendableExt app,
HookAnchor anchor,
String str)
Appends all customizations for the given anchor.
|
static SqlContext |
SqlContext.getContext(AppendableExt app)
Gets the current SqlContext from the given AppendableExt, creating one if
necessary.
|
protected void |
CustomizableSqlObject.maybeAppendTo(AppendableExt app,
HookAnchor anchor,
String clauseText,
boolean includeClause)
Appends the appropriate customizations for the given anchor (and possibly
the anchor clause itself) based on whether or not the clause should be
included.
|
protected void |
CustomizableSqlObject.maybeAppendTo(AppendableExt app,
HookAnchor anchor,
String clauseText,
SqlObject clauseContent,
boolean includeClause)
Appends the appropriate customizations for the given anchor (and possibly
the anchor clause itself) based on whether or not the clause should be
included.
|
static void |
SqlContext.popContext(AppendableExt app,
SqlContext context)
Replaces the current SqlContext (checking it against the given
SqlContext) with the parent SqlContext (stored within the new one).
|
protected void |
ConstraintClause.postAppendTo(AppendableExt app) |
protected void |
ConstraintClause.preAppendTo(AppendableExt app) |
protected void |
BaseCTEQuery.prependTo(AppendableExt app) |
protected void |
Query.prependTo(AppendableExt app)
Called by
Query.appendTo(AppendableExt) before
Query.appendTo(AppendableExt,SqlContext) within the original
SqlContext. |
static SqlContext |
SqlContext.pushContext(AppendableExt app)
Creates a new SqlContext (cloning current one if available), replaces the
current SqlContext with the new SqlContext, and returns the new
SqlContext.
|
Modifier and Type | Method and Description |
---|---|
void |
NamedParamObject.appendTo(AppendableExt app) |
Modifier and Type | Method and Description |
---|---|
void |
MysLimitClause.appendTo(AppendableExt app) |
Modifier and Type | Method and Description |
---|---|
void |
OraTableSpaceClause.appendTo(AppendableExt app) |
Modifier and Type | Method and Description |
---|---|
void |
PgLimitClause.appendTo(AppendableExt app) |
void |
PgOffsetClause.appendTo(AppendableExt app) |
Modifier and Type | Method and Description |
---|---|
void |
MssTopClause.appendTo(AppendableExt app) |
Copyright © 2006–2021 OpenHMS. All rights reserved.