Package | Description |
---|---|
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.mysql |
SqlBuilder customizations specific to the MySQL database.
|
com.healthmarketscience.sqlbuilder.custom.postgresql |
SqlBuilder customizations specific to the PostgreSQL database.
|
Modifier and Type | Interface and Description |
---|---|
interface |
Verifiable<ThisType extends Verifiable<ThisType>>
Interface for SqlObjects wishing to provide verifiablity.
|
Modifier and Type | Class and Description |
---|---|
class |
AlterTableQuery
Query which generates an
ALTER TABLE statement. |
class |
BaseCaseStatement<ThisType extends BaseCaseStatement<ThisType>>
Common base class for
"CASE ... |
class |
BaseCreateQuery<ThisType extends BaseCreateQuery<ThisType>>
Query which generates a CREATE statement.
|
class |
BaseCTEQuery<ThisType extends BaseCTEQuery<ThisType>>
Base class for all queries which support common table expressions (the
"WITH " clause).
|
class |
BaseGrantQuery<ThisType extends BaseGrantQuery<ThisType>>
Base of a query which generates a query for manipulating privileges.
|
class |
CaseStatement
Outputs a case statement like:
"CASE WHEN <cond1> THEN <result1> [ WHEN
<cond2> THEN <result2> WHEN ... |
class |
CommonTableExpression
Outputs the Common Table Expression (CTE) definition as part of a
"WITH " clause. |
class |
CreateIndexQuery
Query which generates a CREATE INDEX statement.
|
class |
CreateTableQuery
Query which generates a CREATE TABLE statement.
|
class |
CreateViewQuery
Query which generates a CREATE VIEW statement.
|
class |
DeleteQuery
Query which generates a DELETE statement.
|
class |
DropQuery
Query which generates a DROP statement.
|
class |
ExceptQuery
Query which generates a series of SELECT queries joined by EXCEPT clauses.
|
class |
GrantQuery
Query which generates a GRANT (privileges) statement.
|
class |
InsertQuery
Query which generates a simple INSERT statement.
|
class |
InsertSelectQuery
Query which generates an INSERT statement where the data is generated from
a SELECT query.
|
class |
IntersectQuery
Query which generates a series of SELECT queries joined by INTERSECT
clauses.
|
class |
Query<ThisType extends Query<ThisType>>
Base class for all query statements which adds a validation facility.
|
class |
RevokeQuery
Query which generates a REVOKE (privileges) statement.
|
class |
SelectQuery
Query which generates a SELECT statement.
|
class |
SetOperationQuery<ThisType extends SetOperationQuery<ThisType>>
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].
|
class |
SimpleCaseStatement
Outputs a simple case statement like:
"CASE <column1> WHEN <val1> THEN <result1> [ WHEN
<val2> THEN <result2> WHEN ... |
class |
UnionQuery
Query which generates a series of SELECT queries joined by UNION clauses.
|
class |
UpdateQuery
Query which generates an UPDATE statement.
|
Modifier and Type | Method and Description |
---|---|
Map.Entry<ValidationContext,? extends Verifiable<?>> |
ValidationException.getFailedVerifiable() |
Modifier and Type | Method and Description |
---|---|
void |
ValidationContext.addVerifiable(Verifiable<?> verifiable) |
Modifier and Type | Method and Description |
---|---|
void |
ValidationException.setFailedVerifiable(Map.Entry<ValidationContext,? extends Verifiable<?>> newFailedVerifiable) |
Modifier and Type | Class and Description |
---|---|
class |
MysLimitClause
Appends a MySQL limit clause like
" LIMIT [<offset>] <limit>" for
use in SelectQuery s. |
Modifier and Type | Class and Description |
---|---|
class |
PgLimitClause
Appends a PostgreSQL limit clause like
" LIMIT <limit>" for use in
SelectQuery s. |
class |
PgOffsetClause
Appends a PostgreSQL offset clause like
" OFFSET <offset>" for use in
SelectQuery s. |
Copyright © 2006–2021 OpenHMS. All rights reserved.