public class DefaultDSLContext extends Object implements DSLContext, Serializable
DSLContext.
You may use this as a base implementation for custom DSLContext
subtypes preventing potential API breakage when upgrading jOOQ, or to
delegate DSL method calls to your custom implementations.
| Constructor and Description |
|---|
DefaultDSLContext(Configuration configuration) |
DefaultDSLContext(ConnectionProvider connectionProvider,
SQLDialect dialect) |
DefaultDSLContext(ConnectionProvider connectionProvider,
SQLDialect dialect,
Settings settings) |
DefaultDSLContext(Connection connection,
SQLDialect dialect) |
DefaultDSLContext(Connection connection,
SQLDialect dialect,
Settings settings) |
DefaultDSLContext(DataSource datasource,
SQLDialect dialect) |
DefaultDSLContext(DataSource datasource,
SQLDialect dialect,
Settings settings) |
DefaultDSLContext(SQLDialect dialect) |
DefaultDSLContext(SQLDialect dialect,
Settings settings) |
| Modifier and Type | Method and Description |
|---|---|
AlterIndexOnStep |
alterIndex(Index index)
Create a new DSL
ALTER INDEX statement. |
AlterIndexOnStep |
alterIndex(Name index)
Create a new DSL
ALTER INDEX statement. |
AlterIndexOnStep |
alterIndex(String index)
Create a new DSL
ALTER INDEX statement. |
AlterIndexStep |
alterIndexIfExists(Index index)
Create a new DSL
ALTER INDEX statement. |
AlterIndexStep |
alterIndexIfExists(Name index)
Create a new DSL
ALTER INDEX statement. |
AlterIndexStep |
alterIndexIfExists(String index)
Create a new DSL
ALTER INDEX statement. |
AlterSchemaStep |
alterSchema(Name schema)
Create a new DSL
ALTER SCHEMA statement. |
AlterSchemaStep |
alterSchema(Schema schema)
Create a new DSL
ALTER SCHEMA statement. |
AlterSchemaStep |
alterSchema(String schema)
Create a new DSL
ALTER SCHEMA statement. |
AlterSchemaStep |
alterSchemaIfExists(Name schema)
Create a new DSL
ALTER SCHEMA statement. |
AlterSchemaStep |
alterSchemaIfExists(Schema schema)
Create a new DSL
ALTER SCHEMA statement. |
AlterSchemaStep |
alterSchemaIfExists(String schema)
Create a new DSL
ALTER SCHEMA statement. |
AlterSequenceStep<BigInteger> |
alterSequence(Name sequence)
Create a new DSL
ALTER SEQUENCE statement. |
<T extends Number> |
alterSequence(Sequence<T> sequence)
Create a new DSL
ALTER SEQUENCE statement. |
AlterSequenceStep<BigInteger> |
alterSequence(String sequence)
Create a new DSL
ALTER SEQUENCE statement. |
AlterSequenceStep<BigInteger> |
alterSequenceIfExists(Name sequence)
Create a new DSL
ALTER SEQUENCE statement. |
<T extends Number> |
alterSequenceIfExists(Sequence<T> sequence)
Create a new DSL
ALTER SEQUENCE statement. |
AlterSequenceStep<BigInteger> |
alterSequenceIfExists(String sequence)
Create a new DSL
ALTER SEQUENCE statement. |
AlterTableStep |
alterTable(Name table)
Create a new DSL
ALTER TABLE statement. |
AlterTableStep |
alterTable(String table)
Create a new DSL
ALTER TABLE statement. |
AlterTableStep |
alterTable(Table<?> table)
Create a new DSL
ALTER TABLE statement. |
AlterTableStep |
alterTableIfExists(Name table)
Create a new DSL
ALTER TABLE statement. |
AlterTableStep |
alterTableIfExists(String table)
Create a new DSL
ALTER TABLE statement. |
AlterTableStep |
alterTableIfExists(Table<?> table)
Create a new DSL
ALTER TABLE statement. |
AlterViewStep |
alterView(Name table)
Create a new DSL
ALTER VIEW statement. |
AlterViewStep |
alterView(String table)
Create a new DSL
ALTER VIEW statement. |
AlterViewStep |
alterView(Table<?> table)
Create a new DSL
ALTER VIEW statement. |
AlterViewStep |
alterViewIfExists(Name table)
Create a new DSL
ALTER VIEW statement. |
AlterViewStep |
alterViewIfExists(String table)
Create a new DSL
ALTER VIEW statement. |
AlterViewStep |
alterViewIfExists(Table<?> table)
Create a new DSL
ALTER VIEW statement. |
void |
attach(Attachable... attachables)
Attach this
DSLContext's underlying Scope.configuration()
to some attachables. |
void |
attach(Collection<? extends Attachable> attachables)
Attach this
DSLContext's underlying Scope.configuration()
to some attachables. |
Batch |
batch(Collection<? extends Query> queries)
Create a batch statement to execute a set of queries in batch mode
(without bind values).
|
Batch |
batch(Queries queries)
Create a batch statement to execute a set of queries in batch mode
(without bind values).
|
Batch |
batch(Query... queries)
Create a batch statement to execute a set of queries in batch mode
(without bind values).
|
BatchBindStep |
batch(Query query)
Create a batch statement to execute a set of queries in batch mode (with
bind values).
|
Batch |
batch(Query query,
Object[]... bindings)
Create a batch statement to execute a set of queries in batch mode (with
bind values).
|
Batch |
batch(String... queries)
Create a batch statement to execute a set of queries in batch mode
(without bind values).
|
BatchBindStep |
batch(String sql)
Create a batch statement to execute a set of queries in batch mode (with
bind values).
|
Batch |
batch(String sql,
Object[]... bindings)
Create a batch statement to execute a set of queries in batch mode (with
bind values).
|
Batch |
batchDelete(Collection<? extends UpdatableRecord<?>> records)
Create a batch statement to execute a set of
DELETE queries
in batch mode (with bind values) according to
UpdatableRecord.delete() sematics. |
Batch |
batchDelete(UpdatableRecord<?>... records)
Create a batch statement to execute a set of
DELETE queries
in batch mode (with bind values) according to
UpdatableRecord.delete() sematics. |
Batch |
batchInsert(Collection<? extends TableRecord<?>> records)
Create a batch statement to execute a set of
INSERT queries
in batch mode (with bind values) according to
TableRecord.insert() semantics. |
Batch |
batchInsert(TableRecord<?>... records)
Create a batch statement to execute a set of
INSERT queries
in batch mode (with bind values) according to
TableRecord.insert() semantics. |
Batch |
batchStore(Collection<? extends UpdatableRecord<?>> records)
Create a batch statement to execute a set of
INSERT and
UPDATE queries in batch mode (with bind values) according to
UpdatableRecord.store() semantics. |
Batch |
batchStore(UpdatableRecord<?>... records)
Create a batch statement to execute a set of
INSERT and
UPDATE queries in batch mode (with bind values) according to
UpdatableRecord.store() semantics. |
Batch |
batchUpdate(Collection<? extends UpdatableRecord<?>> records)
Create a batch statement to execute a set of
UPDATE queries
in batch mode (with bind values) according to
UpdatableRecord.update() semantics. |
Batch |
batchUpdate(UpdatableRecord<?>... records)
Create a batch statement to execute a set of
UPDATE queries
in batch mode (with bind values) according to
UpdatableRecord.update() semantics. |
Block |
begin(Collection<? extends Statement> statements)
Wrap a collection of statements in an anoymous procedural block.
|
Block |
begin(Statement... statements)
Wrap a collection of statements in an anonymous procedural block.
|
int |
bind(QueryPart part,
PreparedStatement stmt)
Deprecated.
|
BindContext |
bindContext(PreparedStatement stmt)
Get a new
BindContext for the context of this
DSLContext. |
void |
close()
Close the underlying resources, if any resources have been allocated when
constructing this
DSLContext. |
CommentOnIsStep |
commentOnColumn(Field<?> field)
Create a new DSL
COMMENT ON COLUMN statement. |
CommentOnIsStep |
commentOnColumn(Name columnName)
Create a new DSL
COMMENT ON COLUMN statement. |
CommentOnIsStep |
commentOnTable(Name tableName)
Create a new DSL
COMMENT ON TABLE statement. |
CommentOnIsStep |
commentOnTable(String tableName)
Create a new DSL
COMMENT ON TABLE statement. |
CommentOnIsStep |
commentOnTable(Table<?> table)
Create a new DSL
COMMENT ON TABLE statement. |
CommentOnIsStep |
commentOnView(Name viewName)
Create a new DSL
COMMENT ON VIEW statement. |
CommentOnIsStep |
commentOnView(String viewName)
Create a new DSL
COMMENT ON VIEW statement. |
CommentOnIsStep |
commentOnView(Table<?> view)
Create a new DSL
COMMENT ON VIEW statement. |
Configuration |
configuration()
The configuration of the current scope.
|
void |
connection(ConnectionRunnable runnable)
Run a
ConnectionRunnable in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.connectionProvider(). |
<T> T |
connectionResult(ConnectionCallable<T> callable)
Run a
ConnectionCallable in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.connectionProvider(). |
CreateTableAsStep<Record> |
createGlobalTemporaryTable(Name table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
createGlobalTemporaryTable(String table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
createGlobalTemporaryTable(Table<?> table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateIndexStep |
createIndex()
Create a new DSL
CREATE INDEX statement. |
CreateIndexStep |
createIndex(Index index)
Create a new DSL
CREATE INDEX statement. |
CreateIndexStep |
createIndex(Name index)
Create a new DSL
CREATE INDEX statement. |
CreateIndexStep |
createIndex(String index)
Create a new DSL
CREATE INDEX statement. |
CreateIndexStep |
createIndexIfNotExists(Index index)
Create a new DSL
CREATE INDEX IF NOT EXISTS statement. |
CreateIndexStep |
createIndexIfNotExists(Name index)
Create a new DSL
CREATE INDEX IF NOT EXISTS statement. |
CreateIndexStep |
createIndexIfNotExists(String index)
Create a new DSL
CREATE INDEX IF NOT EXISTS statement. |
CreateViewAsStep<Record> |
createOrReplaceView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
createOrReplaceView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
createOrReplaceView(Name view,
Name... fields)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
createOrReplaceView(String view,
BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
createOrReplaceView(String view,
Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
createOrReplaceView(String view,
String... fields)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
createOrReplaceView(Table<?> view,
BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
createOrReplaceView(Table<?> view,
Field<?>... fields)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateViewAsStep<Record> |
createOrReplaceView(Table<?> view,
Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSL
CREATE OR REPLACE VIEW statement. |
CreateSchemaFinalStep |
createSchema(Name schema)
Create a new DSL
CREATE SCHEMA statement. |
CreateSchemaFinalStep |
createSchema(Schema schema)
Create a new DSL
CREATE SCHEMA statement. |
CreateSchemaFinalStep |
createSchema(String schema)
Create a new DSL
CREATE SCHEMA statement. |
CreateSchemaFinalStep |
createSchemaIfNotExists(Name schema)
Create a new DSL
CREATE SCHEMA statement. |
CreateSchemaFinalStep |
createSchemaIfNotExists(Schema schema)
Create a new DSL
CREATE SCHEMA statement. |
CreateSchemaFinalStep |
createSchemaIfNotExists(String schema)
Create a new DSL
CREATE SCHEMA statement. |
CreateSequenceFinalStep |
createSequence(Name sequence)
Create a new DSL
CREATE SEQUENCE statement. |
CreateSequenceFinalStep |
createSequence(Sequence<?> sequence)
Create a new DSL
CREATE SEQUENCE statement. |
CreateSequenceFinalStep |
createSequence(String sequence)
Create a new DSL
CREATE SEQUENCE statement. |
CreateSequenceFinalStep |
createSequenceIfNotExists(Name sequence)
Create a new DSL
CREATE SEQUENCE statement. |
CreateSequenceFinalStep |
createSequenceIfNotExists(Sequence<?> sequence)
Create a new DSL
CREATE SEQUENCE statement. |
CreateSequenceFinalStep |
createSequenceIfNotExists(String sequence)
Create a new DSL
CREATE SEQUENCE statement. |
CreateTableAsStep<Record> |
createTable(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
createTable(String table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
createTable(Table<?> table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
createTableIfNotExists(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
createTableIfNotExists(String table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
createTableIfNotExists(Table<?> table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
createTemporaryTable(Name table)
Create a new DSL
CREATE TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
createTemporaryTable(String table)
Create a new DSL
CREATE TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
createTemporaryTable(Table<?> table)
Create a new DSL
CREATE TEMPORARY TABLE statement. |
CreateIndexStep |
createUniqueIndex()
Create a new DSL
CREATE UNIQUE INDEX statement. |
CreateIndexStep |
createUniqueIndex(Index index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
CreateIndexStep |
createUniqueIndex(Name index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
CreateIndexStep |
createUniqueIndex(String index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
CreateIndexStep |
createUniqueIndexIfNotExists(Index index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
CreateIndexStep |
createUniqueIndexIfNotExists(Name index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
CreateIndexStep |
createUniqueIndexIfNotExists(String index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
CreateViewAsStep<Record> |
createView(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createView(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createView(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createView(String view,
BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createView(String view,
Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createView(String view,
String... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createView(Table<?> view,
BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createView(Table<?> view,
Field<?>... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createView(Table<?> view,
Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createViewIfNotExists(Name view,
BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createViewIfNotExists(Name view,
Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createViewIfNotExists(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createViewIfNotExists(String view,
BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createViewIfNotExists(String view,
Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createViewIfNotExists(String view,
String... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createViewIfNotExists(Table<?> view,
BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createViewIfNotExists(Table<?> view,
Field<?>... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
createViewIfNotExists(Table<?> view,
Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSL
CREATE VIEW statement. |
BigInteger |
currval(Name sequence)
Convenience method to fetch the CURRVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
<T extends Number> |
currval(Sequence<T> sequence)
Convenience method to fetch the CURRVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
BigInteger |
currval(String sequence)
Convenience method to fetch the CURRVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
Map<Object,Object> |
data()
Get all custom data from this
Scope. |
Object |
data(Object key)
Get some custom data from this
Scope. |
Object |
data(Object key,
Object value)
Set some custom data to this
Scope. |
Queries |
ddl(Catalog catalog)
Generate the complete creation script for the entire catalog.
|
Queries |
ddl(Catalog schema,
DDLFlag... flags)
Generate a partial creation script for the entire catalog.
|
Queries |
ddl(Collection<? extends Table<?>> tables)
Generate the complete creation script for tables.
|
Queries |
ddl(Collection<? extends Table<?>> tables,
DDLFlag... flags)
Generate the complete creation script for tables.
|
Queries |
ddl(Schema schema)
Generate the complete creation script for the entire schema.
|
Queries |
ddl(Schema schema,
DDLFlag... flags)
Generate a partial creation script for the entire schema.
|
Queries |
ddl(Table... tables)
Generate the complete creation script for tables.
|
Queries |
ddl(Table[] tables,
DDLFlag... flags)
Generate the complete creation script for tables.
|
Queries |
ddl(Table<?> table)
Generate the complete creation script for a table.
|
Queries |
ddl(Table<?> table,
DDLFlag... flags)
Generate a partial creation script for a table.
|
<R extends Record> |
delete(Table<R> table)
Create a new DSL delete statement.
|
<R extends Record> |
deleteFrom(Table<R> table)
Create a new DSL delete statement.
|
<R extends Record> |
deleteQuery(Table<R> table)
Create a new
DeleteQuery |
Connection |
diagnosticsConnection()
A JDBC connection that proxies the underlying connection to run the jOOQ
Diagnostics Pack on executed queries.
|
DataSource |
diagnosticsDataSource()
A JDBC connection that proxies the underlying connection to run the jOOQ
Diagnostics Pack on executed queries.
|
SQLDialect |
dialect()
The
SQLDialect wrapped by this context. |
DropIndexOnStep |
dropIndex(Index index)
Create a new DSL
DROP INDEX statement. |
DropIndexOnStep |
dropIndex(Name index)
Create a new DSL
DROP INDEX statement. |
DropIndexOnStep |
dropIndex(String index)
Create a new DSL
DROP INDEX statement. |
DropIndexOnStep |
dropIndexIfExists(Index index)
Create a new DSL
DROP INDEX IF EXISTS statement. |
DropIndexOnStep |
dropIndexIfExists(Name index)
Create a new DSL
DROP INDEX IF EXISTS statement. |
DropIndexOnStep |
dropIndexIfExists(String index)
Create a new DSL
DROP INDEX IF EXISTS statement. |
DropSchemaStep |
dropSchema(Name schema)
Create a new DSL
DROP SCHEMA statement. |
DropSchemaStep |
dropSchema(Schema schema)
Create a new DSL
DROP SCHEMA statement. |
DropSchemaStep |
dropSchema(String schema)
Create a new DSL
DROP SCHEMA statement. |
DropSchemaStep |
dropSchemaIfExists(Name schema)
Create a new DSL
DROP SCHEMA statement. |
DropSchemaStep |
dropSchemaIfExists(Schema schema)
Create a new DSL
DROP SCHEMA statement. |
DropSchemaStep |
dropSchemaIfExists(String schema)
Create a new DSL
DROP SCHEMA statement. |
DropSequenceFinalStep |
dropSequence(Name sequence)
Create a new DSL
DROP SEQUENCE statement. |
DropSequenceFinalStep |
dropSequence(Sequence<?> sequence)
Create a new DSL
DROP SEQUENCE statement. |
DropSequenceFinalStep |
dropSequence(String sequence)
Create a new DSL
DROP SEQUENCE statement. |
DropSequenceFinalStep |
dropSequenceIfExists(Name sequence)
Create a new DSL
DROP SEQUENCE IF EXISTS statement. |
DropSequenceFinalStep |
dropSequenceIfExists(Sequence<?> sequence)
Create a new DSL
DROP SEQUENCE IF EXISTS statement. |
DropSequenceFinalStep |
dropSequenceIfExists(String sequence)
Create a new DSL
DROP SEQUENCE IF EXISTS statement. |
DropTableStep |
dropTable(Name table)
Create a new DSL
DROP TABLE statement. |
DropTableStep |
dropTable(String table)
Create a new DSL
DROP TABLE statement. |
DropTableStep |
dropTable(Table<?> table)
Create a new DSL
DROP TABLE statement. |
DropTableStep |
dropTableIfExists(Name table)
Create a new DSL
DROP TABLE IF EXISTS statement. |
DropTableStep |
dropTableIfExists(String table)
Create a new DSL
DROP TABLE IF EXISTS statement. |
DropTableStep |
dropTableIfExists(Table<?> table)
Create a new DSL
DROP TABLE IF EXISTS statement. |
DropTableStep |
dropTemporaryTable(Name table)
Create a new DSL
DROP TEMPORARY TABLE statement. |
DropTableStep |
dropTemporaryTable(String table)
Create a new DSL
DROP TEMPORARY TABLE statement. |
DropTableStep |
dropTemporaryTable(Table<?> table)
Create a new DSL
DROP TEMPORARY TABLE statement. |
DropViewFinalStep |
dropView(Name view)
Create a new DSL
DROP VIEW statement. |
DropViewFinalStep |
dropView(String view)
Create a new DSL
DROP VIEW statement. |
DropViewFinalStep |
dropView(Table<?> view)
Create a new DSL
DROP VIEW statement. |
DropViewFinalStep |
dropViewIfExists(Name view)
Create a new DSL
DROP VIEW IF EXISTS statement. |
DropViewFinalStep |
dropViewIfExists(String view)
Create a new DSL
DROP VIEW IF EXISTS statement. |
DropViewFinalStep |
dropViewIfExists(Table<?> view)
Create a new DSL
DROP VIEW IF EXISTS statement. |
DSLContext |
dsl()
Wrap the
Scope.configuration() in a DSLContext, providing
access to the configuration-contextual DSL to construct executable
queries. |
int |
execute(Query query)
Execute a
Query in the context of this DSLContext. |
int |
execute(SQL sql)
Execute a query holding plain SQL.
|
int |
execute(String sql)
Execute a query holding plain SQL.
|
int |
execute(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
int |
execute(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<R extends UpdatableRecord<R>> |
executeDelete(R record)
Delete a record from a table.
|
<R extends TableRecord<R>,T> |
executeDelete(R record,
Condition condition)
Delete a record from a table.
|
<R extends TableRecord<R>> |
executeInsert(R record)
Insert one record.
|
<R extends UpdatableRecord<R>> |
executeUpdate(R record)
Update a table.
|
<R extends TableRecord<R>,T> |
executeUpdate(R record,
Condition condition)
Update a table.
|
Explain |
explain(Query query)
Run an
EXPLAIN statement in the database to estimate the
cardinality of the query. |
List<Object> |
extractBindValues(QueryPart part)
Retrieve the bind values that will be bound by a given
QueryPart. |
Param<?> |
extractParam(QueryPart part,
String name)
Get a named parameter from a
QueryPart, provided its name. |
Map<String,Param<?>> |
extractParams(QueryPart part)
Get a
Map of named parameters. |
SQLDialect |
family()
The
SQLDialect.family() wrapped by this context. |
<R extends Record> |
fetch(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
results. |
Result<Record> |
fetch(ResultSet rs)
|
Result<Record> |
fetch(ResultSet rs,
Class<?>... types)
|
Result<Record> |
fetch(ResultSet rs,
DataType<?>... types)
|
Result<Record> |
fetch(ResultSet rs,
Field<?>... fields)
|
Result<Record> |
fetch(SQL sql)
Execute a new query holding plain SQL.
|
Result<Record> |
fetch(String sql)
Execute a new query holding plain SQL.
|
Result<Record> |
fetch(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Result<Record> |
fetch(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<R extends Record> |
fetch(Table<R> table)
Execute and return all records for
SELECT * FROM [table]. |
<R extends Record> |
fetch(Table<R> table,
Condition condition)
Execute and return all records for
SELECT * FROM [table] WHERE [condition] . |
<R extends Record> |
fetchAny(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table] LIMIT 1. |
<R extends Record> |
fetchAny(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition] LIMIT 1. |
<R extends Record> |
fetchAsync(Executor executor,
ResultQuery<R> query)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
fetchAsync(Executor executor,
ResultSet rs)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
fetchAsync(Executor executor,
ResultSet rs,
Class<?>... types)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
fetchAsync(Executor executor,
ResultSet rs,
DataType<?>... types)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
fetchAsync(Executor executor,
ResultSet rs,
Field<?>... fields)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
fetchAsync(Executor executor,
SQL sql)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
fetchAsync(Executor executor,
String sql)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
fetchAsync(Executor executor,
String sql,
Object... bindings)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
CompletionStage<Result<Record>> |
fetchAsync(Executor executor,
String sql,
QueryPart... parts)
Fetch results in a new
CompletionStage that is asynchronously
completed by a task running in the given executor. |
<R extends Record> |
fetchAsync(Executor executor,
Table<R> table)
Execute and return all records asynchronously for
SELECT * FROM [table]. |
<R extends Record> |
fetchAsync(Executor executor,
Table<R> table,
Condition condition)
Execute and return all records asynchronously for
SELECT * FROM [table] WHERE [condition] . |
<R extends Record> |
fetchAsync(ResultQuery<R> query)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
fetchAsync(ResultSet rs)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
fetchAsync(ResultSet rs,
Class<?>... types)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
fetchAsync(ResultSet rs,
DataType<?>... types)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
fetchAsync(ResultSet rs,
Field<?>... fields)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
fetchAsync(SQL sql)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
fetchAsync(String sql)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
fetchAsync(String sql,
Object... bindings)
Fetch results in a new
CompletionStage. |
CompletionStage<Result<Record>> |
fetchAsync(String sql,
QueryPart... parts)
Fetch results in a new
CompletionStage. |
<R extends Record> |
fetchAsync(Table<R> table)
Execute and return all records asynchronously for
SELECT * FROM [table]. |
<R extends Record> |
fetchAsync(Table<R> table,
Condition condition)
Execute and return all records asynchronously for
SELECT * FROM [table] WHERE [condition] . |
<R extends TableRecord<R>> |
fetchByExample(R example)
Execute a "Query by Example" (QBE) based on an example record.
|
int |
fetchCount(Select<?> query)
|
int |
fetchCount(Table<?> table)
Count the number of records in a table.
|
int |
fetchCount(Table<?> table,
Condition condition)
Count the number of records in a table that satisfy a condition.
|
boolean |
fetchExists(Select<?> query)
Check if a
Select would return any records, if it were executed. |
boolean |
fetchExists(Table<?> table)
Check if a table has any records.
|
boolean |
fetchExists(Table<?> table,
Condition condition)
Check if a table has any records that satisfy a condition.
|
Result<Record> |
fetchFromCSV(String string)
Fetch all data from a CSV string.
|
Result<Record> |
fetchFromCSV(String string,
boolean header)
Fetch all data from a CSV string.
|
Result<Record> |
fetchFromCSV(String string,
boolean header,
char delimiter)
Fetch all data from a CSV string.
|
Result<Record> |
fetchFromCSV(String string,
char delimiter)
Fetch all data from a CSV string.
|
Result<Record> |
fetchFromHTML(String string)
Convert an HTML table into a jOOQ
Result. |
Result<Record> |
fetchFromJSON(String string)
Fetch all data from a JSON string.
|
Result<Record> |
fetchFromStringData(List<String[]> strings)
Fetch all data from a list of strings.
|
Result<Record> |
fetchFromStringData(List<String[]> strings,
boolean header)
Fetch all data from a list of strings.
|
Result<Record> |
fetchFromStringData(String[]... strings)
Fetch all data from a list of strings.
|
Result<Record> |
fetchFromTXT(String string)
Fetch all data from a formatted string.
|
Result<Record> |
fetchFromTXT(String string,
String nullLiteral)
Fetch all data from a formatted string.
|
<R extends Record> |
fetchLazy(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a cursor. |
Cursor<Record> |
fetchLazy(ResultSet rs)
|
Cursor<Record> |
fetchLazy(ResultSet rs,
Class<?>... types)
|
Cursor<Record> |
fetchLazy(ResultSet rs,
DataType<?>... types)
|
Cursor<Record> |
fetchLazy(ResultSet rs,
Field<?>... fields)
|
Cursor<Record> |
fetchLazy(SQL sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
fetchLazy(String sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
fetchLazy(String sql,
Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
fetchLazy(String sql,
QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
<R extends Record> |
fetchLazy(Table<R> table)
Execute and return all records lazily for
SELECT * FROM [table]. |
<R extends Record> |
fetchLazy(Table<R> table,
Condition condition)
Execute and return all records lazily for
SELECT * FROM [table] WHERE [condition] . |
<R extends Record> |
fetchMany(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a cursor. |
Results |
fetchMany(SQL sql)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Results |
fetchMany(String sql)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Results |
fetchMany(String sql,
Object... bindings)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
Results |
fetchMany(String sql,
QueryPart... parts)
Execute a new query holding plain SQL, possibly returning several result
sets.
|
<R extends Record> |
fetchOne(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a record. |
Record |
fetchOne(ResultSet rs)
|
Record |
fetchOne(ResultSet rs,
Class<?>... types)
|
Record |
fetchOne(ResultSet rs,
DataType<?>... types)
|
Record |
fetchOne(ResultSet rs,
Field<?>... fields)
|
Record |
fetchOne(SQL sql)
Execute a new query holding plain SQL.
|
Record |
fetchOne(String sql)
Execute a new query holding plain SQL.
|
Record |
fetchOne(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Record |
fetchOne(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<R extends Record> |
fetchOne(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table]. |
<R extends Record> |
fetchOne(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition] . |
<R extends Record> |
fetchOptional(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a record. |
Optional<Record> |
fetchOptional(ResultSet rs)
|
Optional<Record> |
fetchOptional(ResultSet rs,
Class<?>... types)
|
Optional<Record> |
fetchOptional(ResultSet rs,
DataType<?>... types)
|
Optional<Record> |
fetchOptional(ResultSet rs,
Field<?>... fields)
|
Optional<Record> |
fetchOptional(SQL sql)
Execute a new query holding plain SQL.
|
Optional<Record> |
fetchOptional(String sql)
Execute a new query holding plain SQL.
|
Optional<Record> |
fetchOptional(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Optional<Record> |
fetchOptional(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<R extends Record> |
fetchOptional(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table]. |
<R extends Record> |
fetchOptional(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition] . |
<T,R extends Record1<T>> |
fetchOptionalValue(ResultQuery<R> query)
Execute a
ResultQuery in the context of this
DSLContext and return a single value. |
Optional<?> |
fetchOptionalValue(ResultSet rs)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> Optional<T> |
fetchOptionalValue(ResultSet rs,
Class<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> Optional<T> |
fetchOptionalValue(ResultSet rs,
DataType<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> Optional<T> |
fetchOptionalValue(ResultSet rs,
Field<T> field)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
Optional<?> |
fetchOptionalValue(SQL sql)
Execute a new query holding plain SQL.
|
Optional<?> |
fetchOptionalValue(String sql)
Execute a new query holding plain SQL.
|
Optional<?> |
fetchOptionalValue(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Optional<?> |
fetchOptionalValue(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<T> Optional<T> |
fetchOptionalValue(TableField<?,T> field)
Execute a
ResultQuery in the context of this
DSLContext and return a single value. |
<R extends Record> |
fetchSingle(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a record. |
Record |
fetchSingle(ResultSet rs)
|
Record |
fetchSingle(ResultSet rs,
Class<?>... types)
|
Record |
fetchSingle(ResultSet rs,
DataType<?>... types)
|
Record |
fetchSingle(ResultSet rs,
Field<?>... fields)
|
Record |
fetchSingle(SQL sql)
Execute a new query holding plain SQL.
|
Record |
fetchSingle(String sql)
Execute a new query holding plain SQL.
|
Record |
fetchSingle(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Record |
fetchSingle(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<R extends Record> |
fetchSingle(Table<R> table)
Execute and return exactly one record for
SELECT * FROM [table]. |
<R extends Record> |
fetchSingle(Table<R> table,
Condition condition)
Execute and return exactly one record for
SELECT * FROM [table] WHERE [condition] . |
<R extends Record> |
fetchStream(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a stream. |
Stream<Record> |
fetchStream(ResultSet rs)
|
Stream<Record> |
fetchStream(ResultSet rs,
Class<?>... types)
|
Stream<Record> |
fetchStream(ResultSet rs,
DataType<?>... types)
|
Stream<Record> |
fetchStream(ResultSet rs,
Field<?>... fields)
|
Stream<Record> |
fetchStream(SQL sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Stream<Record> |
fetchStream(String sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Stream<Record> |
fetchStream(String sql,
Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Stream<Record> |
fetchStream(String sql,
QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
<R extends Record> |
fetchStream(Table<R> table)
Execute and return all records lazily for
SELECT * FROM [table]. |
<R extends Record> |
fetchStream(Table<R> table,
Condition condition)
Execute and return all records lazily for
SELECT * FROM [table] WHERE [condition] . |
<T> T |
fetchValue(Field<T> field)
Execute a
ResultQuery in the context of this
DSLContext and return a single value. |
<T,R extends Record1<T>> |
fetchValue(ResultQuery<R> query)
Execute a
ResultQuery in the context of this
DSLContext and return a single value. |
Object |
fetchValue(ResultSet rs)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> T |
fetchValue(ResultSet rs,
Class<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> T |
fetchValue(ResultSet rs,
DataType<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> T |
fetchValue(ResultSet rs,
Field<T> field)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
Object |
fetchValue(SQL sql)
Execute a new query holding plain SQL.
|
Object |
fetchValue(String sql)
Execute a new query holding plain SQL.
|
Object |
fetchValue(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Object |
fetchValue(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<T> T |
fetchValue(Table<? extends Record1<T>> table)
Fetch a single value from a single column table.
|
<T> T |
fetchValue(TableField<?,T> field)
Execute a
ResultQuery in the context of this
DSLContext and return a single value. |
<T,R extends Record1<T>> |
fetchValues(ResultQuery<R> query)
Execute a
ResultQuery in the context of this
DSLContext and return all values for the only column. |
List<?> |
fetchValues(ResultSet rs)
Fetch a result from a JDBC
ResultSet and return the only
contained column's values. |
<T> List<T> |
fetchValues(ResultSet rs,
Class<T> type)
Fetch a result from a JDBC
ResultSet and return the only
contained column's values. |
<T> List<T> |
fetchValues(ResultSet rs,
DataType<T> type)
Fetch a result from a JDBC
ResultSet and return the only
contained column's values. |
<T> List<T> |
fetchValues(ResultSet rs,
Field<T> field)
Fetch a result from a JDBC
ResultSet and return the only
contained column's values. |
List<?> |
fetchValues(SQL sql)
Execute a new query holding plain SQL.
|
List<?> |
fetchValues(String sql)
Execute a new query holding plain SQL.
|
List<?> |
fetchValues(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
List<?> |
fetchValues(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<T> List<T> |
fetchValues(Table<? extends Record1<T>> table)
Fetch all values from a single column table.
|
<T> List<T> |
fetchValues(TableField<?,T> field)
Fetch all values in a given
Table's TableField. |
GrantOnStep |
grant(Collection<? extends Privilege> privileges)
Grant privileges on a table to user or role.
|
GrantOnStep |
grant(Privilege... privileges)
Grant privileges on a table to user or role.
|
GrantOnStep |
grant(Privilege privilege)
Grant a privilege on a table to user or role.
|
InformationSchema |
informationSchema(Catalog... catalogs)
Export a set of catalogs to the
InformationSchema format. |
InformationSchema |
informationSchema(Catalog catalog)
Export a catalog to the
InformationSchema format. |
InformationSchema |
informationSchema(Schema... schemas)
Export a set of schemas to the
InformationSchema format. |
InformationSchema |
informationSchema(Schema schema)
Export a schema to the
InformationSchema format. |
InformationSchema |
informationSchema(Table<?>... tables)
Export a set of tables to the
InformationSchema format. |
InformationSchema |
informationSchema(Table<?> table)
Export a table to the
InformationSchema format. |
<R extends Record> |
insertInto(Table<R> into)
Create a new DSL insert statement.
|
<R extends Record> |
insertInto(Table<R> into,
Collection<? extends Field<?>> fields)
Create a new DSL insert statement.
|
<R extends Record> |
insertInto(Table<R> into,
Field<?>... fields)
Create a new DSL insert statement.
|
<R extends Record,T1> |
insertInto(Table<R> into,
Field<T1> field1)
Create a new DSL insert statement.
|
<R extends Record,T1,T2> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21)
Create a new DSL insert statement.
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
insertInto(Table<R> into,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22)
Create a new DSL insert statement.
|
<R extends Record> |
insertQuery(Table<R> into)
Create a new
InsertQuery |
BigInteger |
lastID()
Retrieve the last inserted ID.
|
<R extends Record> |
loadInto(Table<R> table)
Create a new
Loader object to load data from a CSV or XML
source. |
Schema |
map(Schema schema)
Map a schema to another one.
|
<R extends Record> |
map(Table<R> table)
Map a table to another one.
|
<R extends Record> |
mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.
|
<R extends Record> |
mergeInto(Table<R> table,
Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).
|
<R extends Record> |
mergeInto(Table<R> table,
Field<?>... fields)
|
<R extends Record,T1> |
mergeInto(Table<R> table,
Field<T1> field1)
|
<R extends Record,T1,T2> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2)
|
<R extends Record,T1,T2,T3> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
|
<R extends Record,T1,T2,T3,T4> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
|
<R extends Record,T1,T2,T3,T4,T5> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
|
<R extends Record,T1,T2,T3,T4,T5,T6> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21)
|
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
mergeInto(Table<R> table,
Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22)
|
Meta |
meta()
Access the database meta data.
|
Meta |
meta(Catalog... catalogs)
Access the database meta data from explicit catalog information.
|
Meta |
meta(DatabaseMetaData meta)
Access the database meta data from an explicit JDBC
DatabaseMetaData. |
Meta |
meta(InformationSchema schema)
Access the database meta data from an explicit JAXB-annotated meta model.
|
Meta |
meta(Schema... schemas)
Access the database meta data from explicit schema information.
|
Meta |
meta(Table<?>... tables)
Access the database meta data from explicit table information.
|
void |
mock(MockDataProvider provider,
MockRunnable mockable)
Run a
MockRunnable in the context of this DSLContext
's underlying Scope.configuration()'s, and of a
MockDataProvider. |
<T> T |
mockResult(MockDataProvider provider,
MockCallable<T> mockable)
Run a
MockRunnable in the context of this DSLContext
's underlying Scope.configuration()'s, and of a
MockDataProvider and return the mockable's outcome. |
Record |
newRecord(Collection<? extends Field<?>> fields)
Create a new empty
Record. |
Record |
newRecord(Field<?>... fields)
Create a new empty
Record. |
<T1> Record1<T1> |
newRecord(Field<T1> field1)
Create a new empty
Record. |
<T1,T2> Record2<T1,T2> |
newRecord(Field<T1> field1,
Field<T2> field2)
Create a new empty
Record. |
<T1,T2,T3> Record3<T1,T2,T3> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new empty
Record. |
<T1,T2,T3,T4> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Create a new empty
Record. |
<T1,T2,T3,T4,T5> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21)
Create a new empty
Record. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
newRecord(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22)
Create a new empty
Record. |
<R extends Record> |
newRecord(Table<R> table)
Create a new
Record that can be inserted into the corresponding
table. |
<R extends Record> |
newRecord(Table<R> table,
Object source)
Create a new pre-filled
Record that can be inserted into the
corresponding table. |
<R extends UDTRecord<R>> |
newRecord(UDT<R> type)
Create a new
UDTRecord. |
Result<Record> |
newResult(Collection<? extends Field<?>> fields)
Create a new empty
Record. |
Result<Record> |
newResult(Field<?>... fields)
Create a new empty
Record. |
<T1> Result<Record1<T1>> |
newResult(Field<T1> field1)
Create a new empty
Result. |
<T1,T2> Result<Record2<T1,T2>> |
newResult(Field<T1> field1,
Field<T2> field2)
Create a new empty
Result. |
<T1,T2,T3> Result<Record3<T1,T2,T3>> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3)
Create a new empty
Result. |
<T1,T2,T3,T4> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4)
Create a new empty
Result. |
<T1,T2,T3,T4,T5> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21)
Create a new empty
Result. |
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
newResult(Field<T1> field1,
Field<T2> field2,
Field<T3> field3,
Field<T4> field4,
Field<T5> field5,
Field<T6> field6,
Field<T7> field7,
Field<T8> field8,
Field<T9> field9,
Field<T10> field10,
Field<T11> field11,
Field<T12> field12,
Field<T13> field13,
Field<T14> field14,
Field<T15> field15,
Field<T16> field16,
Field<T17> field17,
Field<T18> field18,
Field<T19> field19,
Field<T20> field20,
Field<T21> field21,
Field<T22> field22)
Create a new empty
Result. |
<R extends Record> |
newResult(Table<R> table)
Create a new empty
Result. |
BigInteger |
nextval(Name sequence)
Convenience method to fetch the NEXTVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
<T extends Number> |
nextval(Sequence<T> sequence)
Convenience method to fetch the NEXTVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
BigInteger |
nextval(String sequence)
Convenience method to fetch the NEXTVAL for a sequence directly from this
DSLContext's underlying JDBC Connection. |
Parser |
parser()
Access the parser API.
|
Connection |
parsingConnection()
A JDBC connection that runs each statement through the
DSLContext.parser()
first, prior to re-generating and running the SQL. |
DataSource |
parsingDataSource()
A JDBC data source that runs each statement through the
DSLContext.parser()
first, prior to re-generating and running the SQL. |
Queries |
queries(Collection<? extends Query> queries)
Wrap a collection of queries.
|
Queries |
queries(Query... queries)
Wrap a collection of queries.
|
Query |
query(SQL sql)
Create a new query holding plain SQL.
|
Query |
query(String sql)
Create a new query holding plain SQL.
|
Query |
query(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
Query |
query(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
String |
render(QueryPart part)
Render a QueryPart in the context of this
DSLContext. |
RenderContext |
renderContext()
Get a new
RenderContext for the context of this DSLContext. |
String |
renderInlined(QueryPart part)
Render a QueryPart in the context of this
DSLContext, inlining all bind
variables. |
String |
renderNamedOrInlinedParams(QueryPart part)
Render a QueryPart in the context of this
DSLContext, rendering bind
variables as named parameters, or inlined parameters if they have no name. |
String |
renderNamedParams(QueryPart part)
Render a QueryPart in the context of this
DSLContext, rendering bind
variables as named parameters. |
ResultQuery<Record> |
resultQuery(SQL sql)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
resultQuery(String sql)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
resultQuery(String sql,
Object... bindings)
Create a new query holding plain SQL.
|
ResultQuery<Record> |
resultQuery(String sql,
QueryPart... parts)
Create a new query holding plain SQL.
|
RevokeOnStep |
revoke(Collection<? extends Privilege> privileges)
Revoke privileges on table from user or role.
|
RevokeOnStep |
revoke(Privilege... privileges)
Revoke privileges on table from user or role.
|
RevokeOnStep |
revoke(Privilege privilege)
Revoke a privilege on table from user or role.
|
RevokeOnStep |
revokeGrantOptionFor(Collection<? extends Privilege> privileges)
Revoke grant option for some privileges on a table from user or role.
|
RevokeOnStep |
revokeGrantOptionFor(Privilege... privileges)
Revoke grant option for some privileges on a table from user or role.
|
RevokeOnStep |
revokeGrantOptionFor(Privilege privilege)
Revoke grant option for a privilege on a table from user or role.
|
SelectSelectStep<Record> |
select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.
|
<T1> SelectSelectStep<Record1<T1>> |
select(SelectField<T1> field1)
Create a new DSL select statement.
|
<T1,T2> SelectSelectStep<Record2<T1,T2>> |
select(SelectField<T1> field1,
SelectField<T2> field2)
Create a new DSL select statement.
|
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3)
Create a new DSL select statement.
|
<T1,T2,T3,T4> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18,
SelectField<T19> field19)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18,
SelectField<T19> field19,
SelectField<T20> field20)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18,
SelectField<T19> field19,
SelectField<T20> field20,
SelectField<T21> field21)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
select(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18,
SelectField<T19> field19,
SelectField<T20> field20,
SelectField<T21> field21,
SelectField<T22> field22)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
select(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.
|
SelectSelectStep<Record1<Integer>> |
selectCount()
Create a new DSL select statement for
COUNT(*). |
SelectSelectStep<Record> |
selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.
|
<T1> SelectSelectStep<Record1<T1>> |
selectDistinct(SelectField<T1> field1)
Create a new DSL select statement.
|
<T1,T2> SelectSelectStep<Record2<T1,T2>> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2)
Create a new DSL select statement.
|
<T1,T2,T3> SelectSelectStep<Record3<T1,T2,T3>> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3)
Create a new DSL select statement.
|
<T1,T2,T3,T4> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18,
SelectField<T19> field19)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18,
SelectField<T19> field19,
SelectField<T20> field20)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18,
SelectField<T19> field19,
SelectField<T20> field20,
SelectField<T21> field21)
Create a new DSL select statement.
|
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> |
selectDistinct(SelectField<T1> field1,
SelectField<T2> field2,
SelectField<T3> field3,
SelectField<T4> field4,
SelectField<T5> field5,
SelectField<T6> field6,
SelectField<T7> field7,
SelectField<T8> field8,
SelectField<T9> field9,
SelectField<T10> field10,
SelectField<T11> field11,
SelectField<T12> field12,
SelectField<T13> field13,
SelectField<T14> field14,
SelectField<T15> field15,
SelectField<T16> field16,
SelectField<T17> field17,
SelectField<T18> field18,
SelectField<T19> field19,
SelectField<T20> field20,
SelectField<T21> field21,
SelectField<T22> field22)
Create a new DSL select statement.
|
SelectSelectStep<Record> |
selectDistinct(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.
|
<R extends Record> |
selectFrom(Name table)
Create a new DSL select statement.
|
<R extends Record> |
selectFrom(SQL sql)
Create a new DSL select statement.
|
<R extends Record> |
selectFrom(String sql)
Create a new DSL select statement.
|
<R extends Record> |
selectFrom(String sql,
Object... bindings)
Create a new DSL select statement.
|
<R extends Record> |
selectFrom(String sql,
QueryPart... parts)
Create a new DSL select statement.
|
<R extends Record> |
selectFrom(Table<R> table)
Create a new DSL select statement.
|
SelectSelectStep<Record1<Integer>> |
selectOne()
Create a new DSL select statement for a constant
1 literal. |
SelectQuery<Record> |
selectQuery()
Create a new
SelectQuery |
<R extends Record> |
selectQuery(TableLike<R> table)
Create a new
SelectQuery |
SelectSelectStep<Record1<Integer>> |
selectZero()
Create a new DSL select statement for a constant
0 literal. |
Query |
setCatalog(Catalog catalog)
Set the current catalog to a new value.
|
Query |
setCatalog(Name catalog)
Set the current catalog to a new value.
|
Query |
setCatalog(String catalog)
Set the current catalog to a new value.
|
Query |
setSchema(Name schema)
Set the current schema to a new value.
|
Query |
setSchema(Schema schema)
Set the current schema to a new value.
|
Query |
setSchema(String schema)
Set the current schema to a new value.
|
Settings |
settings()
The settings wrapped by this context.
|
String |
toString() |
void |
transaction(ContextTransactionalRunnable transactional)
Run a
ContextTransactionalRunnable in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.transactionProvider(). |
void |
transaction(TransactionalRunnable transactional)
Run a
TransactionalRunnable in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.transactionProvider(). |
CompletionStage<Void> |
transactionAsync(Executor executor,
TransactionalRunnable transactional)
Run a
TransactionalRunnable asynchronously. |
CompletionStage<Void> |
transactionAsync(TransactionalRunnable transactional)
Run a
TransactionalRunnable asynchronously. |
<T> T |
transactionResult(ContextTransactionalCallable<T> transactional)
Run a
ContextTransactionalRunnable in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.transactionProvider(), and return the
transactional's outcome. |
<T> T |
transactionResult(TransactionalCallable<T> transactional)
Run a
TransactionalCallable in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.transactionProvider(), and return the
transactional's outcome. |
<T> CompletionStage<T> |
transactionResultAsync(Executor executor,
TransactionalCallable<T> transactional)
Run a
TransactionalCallable asynchronously. |
<T> CompletionStage<T> |
transactionResultAsync(TransactionalCallable<T> transactional)
Run a
TransactionalCallable asynchronously. |
TruncateIdentityStep<Record> |
truncate(Name table)
Create a new DSL truncate statement.
|
TruncateIdentityStep<Record> |
truncate(String table)
Create a new DSL truncate statement.
|
<R extends Record> |
truncate(Table<R> table)
Create a new DSL truncate statement.
|
<R extends Record> |
update(Table<R> table)
Create a new DSL update statement.
|
<R extends Record> |
updateQuery(Table<R> table)
Create a new
UpdateQuery |
WithStep |
with(CommonTableExpression<?>... tables)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
with(Name alias)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
with(Name alias,
Name... fieldAliases)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep1 |
with(Name alias,
Name fieldAlias1)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep2 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep3 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep4 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep5 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep6 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep7 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep8 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep9 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep10 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep11 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep12 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep13 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep14 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep15 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep16 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep17 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep18 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep19 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep20 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep21 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20,
Name fieldAlias21)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep22 |
with(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20,
Name fieldAlias21,
Name fieldAlias22)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
with(String alias)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
with(String alias,
BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
with(String alias,
Function<? super Field<?>,? extends String> fieldNameFunction)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
with(String alias,
String... fieldAliases)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep1 |
with(String alias,
String fieldAlias1)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep2 |
with(String alias,
String fieldAlias1,
String fieldAlias2)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep3 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep4 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep5 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep6 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep7 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep8 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep9 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep10 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep11 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep12 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep13 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep14 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep15 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep16 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep17 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16,
String fieldAlias17)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep18 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16,
String fieldAlias17,
String fieldAlias18)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep19 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16,
String fieldAlias17,
String fieldAlias18,
String fieldAlias19)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep20 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16,
String fieldAlias17,
String fieldAlias18,
String fieldAlias19,
String fieldAlias20)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep21 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16,
String fieldAlias17,
String fieldAlias18,
String fieldAlias19,
String fieldAlias20,
String fieldAlias21)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep22 |
with(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16,
String fieldAlias17,
String fieldAlias18,
String fieldAlias19,
String fieldAlias20,
String fieldAlias21,
String fieldAlias22)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithStep |
withRecursive(CommonTableExpression<?>... tables)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
withRecursive(Name alias)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
withRecursive(Name alias,
Name... fieldAliases)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep1 |
withRecursive(Name alias,
Name fieldAlias1)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep2 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep3 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep4 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep5 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep6 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep7 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep8 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep9 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep10 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep11 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep12 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep13 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep14 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep15 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep16 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep17 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep18 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep19 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep20 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep21 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20,
Name fieldAlias21)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep22 |
withRecursive(Name alias,
Name fieldAlias1,
Name fieldAlias2,
Name fieldAlias3,
Name fieldAlias4,
Name fieldAlias5,
Name fieldAlias6,
Name fieldAlias7,
Name fieldAlias8,
Name fieldAlias9,
Name fieldAlias10,
Name fieldAlias11,
Name fieldAlias12,
Name fieldAlias13,
Name fieldAlias14,
Name fieldAlias15,
Name fieldAlias16,
Name fieldAlias17,
Name fieldAlias18,
Name fieldAlias19,
Name fieldAlias20,
Name fieldAlias21,
Name fieldAlias22)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
withRecursive(String alias)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
withRecursive(String alias,
BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
withRecursive(String alias,
Function<? super Field<?>,? extends String> fieldNameFunction)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep |
withRecursive(String alias,
String... fieldAliases)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep1 |
withRecursive(String alias,
String fieldAlias1)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep2 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep3 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep4 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep5 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep6 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep7 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep8 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep9 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep10 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep11 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep12 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep13 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep14 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep15 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep16 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep17 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16,
String fieldAlias17)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep18 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16,
String fieldAlias17,
String fieldAlias18)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep19 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16,
String fieldAlias17,
String fieldAlias18,
String fieldAlias19)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep20 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16,
String fieldAlias17,
String fieldAlias18,
String fieldAlias19,
String fieldAlias20)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep21 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16,
String fieldAlias17,
String fieldAlias18,
String fieldAlias19,
String fieldAlias20,
String fieldAlias21)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
WithAsStep22 |
withRecursive(String alias,
String fieldAlias1,
String fieldAlias2,
String fieldAlias3,
String fieldAlias4,
String fieldAlias5,
String fieldAlias6,
String fieldAlias7,
String fieldAlias8,
String fieldAlias9,
String fieldAlias10,
String fieldAlias11,
String fieldAlias12,
String fieldAlias13,
String fieldAlias14,
String fieldAlias15,
String fieldAlias16,
String fieldAlias17,
String fieldAlias18,
String fieldAlias19,
String fieldAlias20,
String fieldAlias21,
String fieldAlias22)
Create a
WITH clause to supply subsequent
SELECT, UPDATE, INSERT,
DELETE, and MERGE statements with
CommonTableExpressions. |
public DefaultDSLContext(SQLDialect dialect)
public DefaultDSLContext(SQLDialect dialect, Settings settings)
public DefaultDSLContext(Connection connection, SQLDialect dialect)
public DefaultDSLContext(Connection connection, SQLDialect dialect, Settings settings)
public DefaultDSLContext(DataSource datasource, SQLDialect dialect)
public DefaultDSLContext(DataSource datasource, SQLDialect dialect, Settings settings)
public DefaultDSLContext(ConnectionProvider connectionProvider, SQLDialect dialect)
public DefaultDSLContext(ConnectionProvider connectionProvider, SQLDialect dialect, Settings settings)
public DefaultDSLContext(Configuration configuration)
public void close()
DSLContextDSLContext.
Some DSLContext constructors, such as DSL.using(String),
DSL.using(String, Properties), or
DSL.using(String, String, String) allocate a Connection
resource, which is inaccessible to the outside of the DSLContext
implementation. Proper resource management must thus be done via this
DSLContext.close() method.
close in interface AutoCloseableclose in interface DSLContextpublic Schema map(Schema schema)
DSLContext
This will map a schema onto another one, depending on configured schema
mapping in this DSLContext. If no applicable schema mapping
can be found, the schema itself is returned.
map in interface DSLContextschema - A schemapublic <R extends Record> Table<R> map(Table<R> table)
DSLContext
This will map a table onto another one, depending on configured table
mapping in this DSLContext. If no applicable table mapping can
be found, the table itself is returned.
map in interface DSLContexttable - A tablepublic Parser parser()
DSLContextThis is experimental functionality.
parser in interface DSLContextpublic Connection parsingConnection()
DSLContextDSLContext.parser()
first, prior to re-generating and running the SQL.
The resulting Connection wraps an underlying JDBC connection that
has been obtained from ConnectionProvider.acquire() and must be
released by calling Connection.close().
This is experimental functionality:
Statement executions, bind
variables and their position calculation might cause issues when the
generated SQL output involves more complex SQL transformation. See also
https://github.com/jOOQ/jOOQ/issues/5759.parsingConnection in interface DSLContextpublic DataSource parsingDataSource()
DSLContextDSLContext.parser()
first, prior to re-generating and running the SQL.
This simply wraps the DSLContext.parsingConnection() in a DataSource.
parsingDataSource in interface DSLContextpublic Connection diagnosticsConnection()
DSLContextThis is experimental functionality.
diagnosticsConnection in interface DSLContextpublic DataSource diagnosticsDataSource()
DSLContext
This simply wraps the DSLContext.diagnosticsConnection() in a DataSource.
diagnosticsDataSource in interface DSLContextpublic Meta meta()
DSLContext
This method returns meta information provided by
Configuration.metaProvider(), which defaults to a wrapper type
that gives access to your JDBC connection's DatabaseMetaData as
obtained from your ConnectionProvider.
meta in interface DSLContextDSLContext.meta(DatabaseMetaData)public Meta meta(DatabaseMetaData meta)
DSLContextDatabaseMetaData.meta in interface DSLContextpublic Meta meta(Catalog... catalogs)
DSLContext
This will not connect to your database to get live meta information,
unlike DSLContext.meta() and DSLContext.meta(DatabaseMetaData).
meta in interface DSLContextpublic Meta meta(Schema... schemas)
DSLContext
This will not connect to your database to get live meta information,
unlike DSLContext.meta() and DSLContext.meta(DatabaseMetaData).
meta in interface DSLContextpublic Meta meta(Table<?>... tables)
DSLContext
This will not connect to your database to get live meta information,
unlike DSLContext.meta() and DSLContext.meta(DatabaseMetaData).
meta in interface DSLContextpublic Meta meta(InformationSchema schema)
DSLContext
This will not connect to your database to get live meta information,
unlike DSLContext.meta() and DSLContext.meta(DatabaseMetaData).
meta in interface DSLContextpublic InformationSchema informationSchema(Catalog catalog)
DSLContextInformationSchema format.
This allows for serialising schema meta information as XML using JAXB.
See also Constants.XSD_META for details.
informationSchema in interface DSLContextpublic InformationSchema informationSchema(Catalog... catalogs)
DSLContextInformationSchema format.
This allows for serialising schema meta information as XML using JAXB.
See also Constants.XSD_META for details.
informationSchema in interface DSLContextpublic InformationSchema informationSchema(Schema schema)
DSLContextInformationSchema format.
This allows for serialising schema meta information as XML using JAXB.
See also Constants.XSD_META for details.
informationSchema in interface DSLContextpublic InformationSchema informationSchema(Schema... schemas)
DSLContextInformationSchema format.
This allows for serialising schema meta information as XML using JAXB.
See also Constants.XSD_META for details.
informationSchema in interface DSLContextpublic InformationSchema informationSchema(Table<?> table)
DSLContextInformationSchema format.
Exporting a single table will not include any foreign key definitions in the exported data.
This allows for serialising schema meta information as XML using JAXB.
See also Constants.XSD_META for details.
informationSchema in interface DSLContextpublic InformationSchema informationSchema(Table<?>... tables)
DSLContextInformationSchema format.
Only those foreign keys whose referenced table is also included in the export will be exported.
This allows for serialising schema meta information as XML using JAXB.
See also Constants.XSD_META for details.
informationSchema in interface DSLContextpublic Explain explain(Query query)
DSLContextEXPLAIN statement in the database to estimate the
cardinality of the query.explain in interface DSLContextpublic <T> T transactionResult(ContextTransactionalCallable<T> transactional)
DSLContextContextTransactionalRunnable in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.transactionProvider(), and return the
transactional's outcome.
The argument transactional code may capture scope to derive its
Configuration from the "context" in order to create new
statements. This context can be provided, for instance, by
ThreadLocalTransactionProvider automatically.
transactionResult in interface DSLContexttransactional - The transactional codepublic <T> T transactionResult(TransactionalCallable<T> transactional)
DSLContextTransactionalCallable in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.transactionProvider(), and return the
transactional's outcome.
The argument transactional code should not capture any scope but derive
its Configuration from the
TransactionalCallable.run(Configuration) argument in order to
create new statements.
transactionResult in interface DSLContexttransactional - The transactional codepublic void transaction(ContextTransactionalRunnable transactional)
DSLContextContextTransactionalRunnable in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.transactionProvider().
The argument transactional code may capture scope to derive its
Configuration from the "context" in order to create new
statements. This context can be provided, for instance, by
ThreadLocalTransactionProvider automatically.
transaction in interface DSLContexttransactional - The transactional codepublic void transaction(TransactionalRunnable transactional)
DSLContextTransactionalRunnable in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.transactionProvider().
The argument transactional code should not capture any scope but derive
its Configuration from the
TransactionalCallable.run(Configuration) argument in order to
create new statements.
transaction in interface DSLContexttransactional - The transactional codepublic CompletionStage<Void> transactionAsync(TransactionalRunnable transactional)
DSLContextTransactionalRunnable asynchronously.
The TransactionRunnable is run in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.transactionProvider(), and returns the
transactional's outcome in a new CompletionStage
that is asynchronously completed by a task run by an Executor
provided by the underlying Scope.configuration()'s
Configuration.executorProvider().
transactionAsync in interface DSLContexttransactional - The transactional codepublic CompletionStage<Void> transactionAsync(Executor executor, TransactionalRunnable transactional)
DSLContextTransactionalRunnable asynchronously.
The TransactionRunnable is run in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.transactionProvider(), and returns the
transactional's outcome in a new CompletionStage
that is asynchronously completed by a task run by a given
Executor.
transactionAsync in interface DSLContexttransactional - The transactional codepublic <T> CompletionStage<T> transactionResultAsync(TransactionalCallable<T> transactional)
DSLContextTransactionalCallable asynchronously.
The TransactionCallable is run in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.transactionProvider(), and returns the
transactional's outcome in a new CompletionStage
that is asynchronously completed by a task run by an Executor
provided by the underlying Scope.configuration()'s
Configuration.executorProvider().
transactionResultAsync in interface DSLContexttransactional - The transactional codepublic <T> CompletionStage<T> transactionResultAsync(Executor executor, TransactionalCallable<T> transactional)
DSLContextTransactionalCallable asynchronously.
The TransactionCallable is run in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.transactionProvider(), and returns the
transactional's outcome in a new CompletionStage
that is asynchronously completed by a task run by a given
Executor.
transactionResultAsync in interface DSLContexttransactional - The transactional codepublic <T> T connectionResult(ConnectionCallable<T> callable)
DSLContextConnectionCallable in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.connectionProvider().connectionResult in interface DSLContextcallable - The code running statements against the
connection.public void connection(ConnectionRunnable runnable)
DSLContextConnectionRunnable in the context of this
DSLContext's underlying Scope.configuration()'s
Configuration.connectionProvider().connection in interface DSLContextrunnable - The code running statements against the
connection.public <T> T mockResult(MockDataProvider provider, MockCallable<T> mockable)
DSLContextMockRunnable in the context of this DSLContext
's underlying Scope.configuration()'s, and of a
MockDataProvider and return the mockable's outcome.mockResult in interface DSLContextpublic void mock(MockDataProvider provider, MockRunnable mockable)
DSLContextMockRunnable in the context of this DSLContext
's underlying Scope.configuration()'s, and of a
MockDataProvider.mock in interface DSLContextpublic RenderContext renderContext()
DSLContextRenderContext for the context of this DSLContext.
This will return an initialised render context as such:
RenderContext.castMode() == DEFAULTContext.declareFields() == falseContext.declareTables() == falseRenderContext.format() == falseRenderContext.paramType() == ParamType.INDEXEDRenderContext.qualify() == trueContext.subquery() == falserenderContext in interface DSLContextpublic String render(QueryPart part)
DSLContextDSLContext.
This is the same as calling renderContext().render(part)
render in interface DSLContextpart - The QueryPart to be renderedpublic String renderNamedParams(QueryPart part)
DSLContextDSLContext, rendering bind
variables as named parameters.
This is the same as calling
renderContext().paramType(NAMED).render(part)
renderNamedParams in interface DSLContextpart - The QueryPart to be renderedpublic String renderNamedOrInlinedParams(QueryPart part)
DSLContextDSLContext, rendering bind
variables as named parameters, or inlined parameters if they have no name.
This is the same as calling
renderContext().paramType(NAMED_OR_INLINED).render(part)
renderNamedOrInlinedParams in interface DSLContextpart - The QueryPart to be renderedpublic String renderInlined(QueryPart part)
DSLContextDSLContext, inlining all bind
variables.
This is the same as calling
renderContext().inline(true).render(part)
renderInlined in interface DSLContextpart - The QueryPart to be renderedpublic List<Object> extractBindValues(QueryPart part)
DSLContextQueryPart.
The returned List is immutable. To modify bind values, use
DSLContext.extractParams(QueryPart) instead.
Unlike DSLContext.extractParams(QueryPart), which returns also inlined
parameters, this returns only actual bind values that will render an
actual bind value as a question mark "?"
extractBindValues in interface DSLContextpublic Map<String,Param<?>> extractParams(QueryPart part)
DSLContextMap of named parameters.
The Map itself is immutable, but the Param elements
allow for modifying bind values on an existing Query (or any
other QueryPart).
Bind values created with DSL.val(Object) will have their bind
index as name.
extractParams in interface DSLContextParam,
DSL.param(String, Object)public Param<?> extractParam(QueryPart part, String name)
DSLContextQueryPart, provided its name.
Bind values created with DSL.val(Object) will have their bind
index as name.
extractParam in interface DSLContextParam,
DSL.param(String, Object)public BindContext bindContext(PreparedStatement stmt)
DSLContextBindContext for the context of this
DSLContext.
This will return an initialised bind context as such:
Context.declareFields() == falseContext.declareTables() == falseBindContext for JOOQ INTERNAL USE only. Avoid referencing it directly
bindContext in interface DSLContext@Deprecated public int bind(QueryPart part, PreparedStatement stmt)
bind in interface DSLContextpublic void attach(Attachable... attachables)
DSLContextDSLContext's underlying Scope.configuration()
to some attachables.attach in interface DSLContextpublic void attach(Collection<? extends Attachable> attachables)
DSLContextDSLContext's underlying Scope.configuration()
to some attachables.attach in interface DSLContextpublic <R extends Record> LoaderOptionsStep<R> loadInto(Table<R> table)
DSLContextLoader object to load data from a CSV or XML
source.loadInto in interface DSLContextpublic Queries queries(Query... queries)
DSLContextqueries in interface DSLContextDSL.queries(Query...)public Queries queries(Collection<? extends Query> queries)
DSLContextqueries in interface DSLContextDSL.queries(Collection)public Block begin(Statement... statements)
DSLContextbegin in interface DSLContextDSL.begin(Statement...)public Block begin(Collection<? extends Statement> statements)
DSLContextbegin in interface DSLContextDSL.begin(Collection)public Query query(SQL sql)
DSLContextExample:
String sql = "SET SCHEMA 'abc'";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
query in interface DSLContextsql - The SQLSQLpublic Query query(String sql)
DSLContextExample:
String sql = "SET SCHEMA 'abc'";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
query in interface DSLContextsql - The SQLSQLpublic Query query(String sql, Object... bindings)
DSLContextExample:
String sql = "SET SCHEMA 'abc'";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
query in interface DSLContextsql - The SQLbindings - The bindingsSQL,
DSL.sql(String, Object...)public Query query(String sql, QueryPart... parts)
DSLContext
Unlike DSLContext.query(String, Object...), the SQL passed to this method
should not contain any bind variables. Instead, you can pass
QueryPart objects to the method which will be rendered at indexed
locations of your SQL string as such:
// The following query
query("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));
// Will render this SQL on an Oracle database with RenderNameStyle.QUOTED:
select ?, 'test' from "DUAL"
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses! One way to escape
literals is to use DSL.name(String...) and similar methods
query in interface DSLContextsql - The SQL clause, containing {numbered placeholders} where query
parts can be injectedparts - The QueryPart objects that are rendered at the
{numbered placeholder} locationsSQL,
DSL.sql(String, QueryPart...)public Result<Record> fetch(SQL sql)
DSLContextExample (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetch in interface DSLContextsql - The SQLnull.SQLpublic Result<Record> fetch(String sql)
DSLContextExample (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetch in interface DSLContextsql - The SQLnull.SQLpublic Result<Record> fetch(String sql, Object... bindings)
DSLContextThere must be as many bind variables contained in the SQL, as passed in the bindings parameter
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetch in interface DSLContextsql - The SQLbindings - The bindingsnull.SQL,
DSL.sql(String, Object...)public Result<Record> fetch(String sql, QueryPart... parts)
DSLContext
Unlike DSLContext.fetch(String, Object...), the SQL passed to this method
should not contain any bind variables. Instead, you can pass
QueryPart objects to the method which will be rendered at indexed
locations of your SQL string as such:
// The following query
fetch("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));
// Will execute this SQL on an Oracle database with RenderNameStyle.QUOTED:
select ?, 'test' from "DUAL"
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses! One way to escape
literals is to use DSL.name(String...) and similar methods
fetch in interface DSLContextsql - The SQL clause, containing {numbered placeholders} where query
parts can be injectedparts - The QueryPart objects that are rendered at the
{numbered placeholder} locationsnull.SQL,
DSL.sql(String, QueryPart...)public Cursor<Record> fetchLazy(SQL sql)
DSLContext
The returned Cursor holds a reference to the executed
PreparedStatement and the associated ResultSet. Data can
be fetched (or iterated over) lazily, fetching records from the
ResultSet one by one.
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchLazy in interface DSLContextsql - The SQLnull.SQLpublic Cursor<Record> fetchLazy(String sql)
DSLContext
The returned Cursor holds a reference to the executed
PreparedStatement and the associated ResultSet. Data can
be fetched (or iterated over) lazily, fetching records from the
ResultSet one by one.
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchLazy in interface DSLContextsql - The SQLnull.SQLpublic Cursor<Record> fetchLazy(String sql, Object... bindings)
DSLContextThere must be as many bind variables contained in the SQL, as passed in the bindings parameter
The returned Cursor holds a reference to the executed
PreparedStatement and the associated ResultSet. Data can
be fetched (or iterated over) lazily, fetching records from the
ResultSet one by one.
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchLazy in interface DSLContextsql - The SQLbindings - The bindingsnull.SQL,
DSL.sql(String, Object...)public Cursor<Record> fetchLazy(String sql, QueryPart... parts)
DSLContext
The returned Cursor holds a reference to the executed
PreparedStatement and the associated ResultSet. Data can
be fetched (or iterated over) lazily, fetching records from the
ResultSet one by one.
Unlike DSLContext.fetchLazy(String, Object...), the SQL passed to this
method should not contain any bind variables. Instead, you can pass
QueryPart objects to the method which will be rendered at indexed
locations of your SQL string as such:
// The following query
fetchLazy("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));
// Will execute this SQL on an Oracle database with RenderNameStyle.QUOTED:
select ?, 'test' from "DUAL"
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses! One way to escape
literals is to use DSL.name(String...) and similar methods
fetchLazy in interface DSLContextsql - The SQL clause, containing {numbered placeholders} where query
parts can be injectedparts - The QueryPart objects that are rendered at the
{numbered placeholder} locationsnull.SQL,
DSL.sql(String, QueryPart...)public CompletionStage<Result<Record>> fetchAsync(SQL sql)
DSLContextCompletionStage.
The result is asynchronously completed by a task running in an
Executor provided by the Scope.configuration()'s
Configuration.executorProvider().
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchAsync in interface DSLContextsql - The SQLnull.SQLpublic CompletionStage<Result<Record>> fetchAsync(String sql)
DSLContextCompletionStage.
The result is asynchronously completed by a task running in an
Executor provided by the Scope.configuration()'s
Configuration.executorProvider().
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchAsync in interface DSLContextsql - The SQLnull.SQLpublic CompletionStage<Result<Record>> fetchAsync(String sql, Object... bindings)
DSLContextCompletionStage.
The result is asynchronously completed by a task running in an
Executor provided by the Scope.configuration()'s
Configuration.executorProvider().
There must be as many bind variables contained in the SQL, as passed in the bindings parameter
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchAsync in interface DSLContextsql - The SQLbindings - The bindingsnull.SQL,
DSL.sql(String, Object...)public CompletionStage<Result<Record>> fetchAsync(String sql, QueryPart... parts)
DSLContextCompletionStage.
The result is asynchronously completed by a task running in an
Executor provided by the Scope.configuration()'s
Configuration.executorProvider().
Unlike DSLContext.fetchLazy(String, Object...), the SQL passed to this
method should not contain any bind variables. Instead, you can pass
QueryPart objects to the method which will be rendered at indexed
locations of your SQL string as such:
// The following query
fetchLazy("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));
// Will execute this SQL on an Oracle database with RenderNameStyle.QUOTED:
select ?, 'test' from "DUAL"
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses! One way to escape
literals is to use DSL.name(String...) and similar methods
fetchAsync in interface DSLContextsql - The SQL clause, containing {numbered placeholders} where query
parts can be injectedparts - The QueryPart objects that are rendered at the
{numbered placeholder} locationsnull.SQL,
DSL.sql(String, QueryPart...)public CompletionStage<Result<Record>> fetchAsync(Executor executor, SQL sql)
DSLContextCompletionStage that is asynchronously
completed by a task running in the given executor.
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchAsync in interface DSLContextsql - The SQLnull.SQLpublic CompletionStage<Result<Record>> fetchAsync(Executor executor, String sql)
DSLContextCompletionStage that is asynchronously
completed by a task running in the given executor.
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchAsync in interface DSLContextsql - The SQLnull.SQLpublic CompletionStage<Result<Record>> fetchAsync(Executor executor, String sql, Object... bindings)
DSLContextCompletionStage that is asynchronously
completed by a task running in the given executor.
There must be as many bind variables contained in the SQL, as passed in the bindings parameter
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchAsync in interface DSLContextsql - The SQLbindings - The bindingsnull.SQL,
DSL.sql(String, Object...)public CompletionStage<Result<Record>> fetchAsync(Executor executor, String sql, QueryPart... parts)
DSLContextCompletionStage that is asynchronously
completed by a task running in the given executor.
Unlike DSLContext.fetchLazy(String, Object...), the SQL passed to this
method should not contain any bind variables. Instead, you can pass
QueryPart objects to the method which will be rendered at indexed
locations of your SQL string as such:
// The following query
fetchLazy("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));
// Will execute this SQL on an Oracle database with RenderNameStyle.QUOTED:
select ?, 'test' from "DUAL"
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses! One way to escape
literals is to use DSL.name(String...) and similar methods
fetchAsync in interface DSLContextsql - The SQL clause, containing {numbered placeholders} where query
parts can be injectedparts - The QueryPart objects that are rendered at the
{numbered placeholder} locationsnull.SQL,
DSL.sql(String, QueryPart...)public Stream<Record> fetchStream(SQL sql)
DSLContext
The returned Stream holds a reference to the executed
PreparedStatement and the associated ResultSet. Data can
be fetched (or iterated over) lazily, fetching records from the
ResultSet one by one.
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchStream in interface DSLContextsql - The SQLnull, even if the database returns no
ResultSetSQLpublic Stream<Record> fetchStream(String sql)
DSLContext
The returned Stream holds a reference to the executed
PreparedStatement and the associated ResultSet. Data can
be fetched (or iterated over) lazily, fetching records from the
ResultSet one by one.
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchStream in interface DSLContextsql - The SQLnull, even if the database returns no
ResultSetSQLpublic Stream<Record> fetchStream(String sql, Object... bindings)
DSLContextThere must be as many bind variables contained in the SQL, as passed in the bindings parameter
The returned Stream holds a reference to the executed
PreparedStatement and the associated ResultSet. Data can
be fetched (or iterated over) lazily, fetching records from the
ResultSet one by one.
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchStream in interface DSLContextsql - The SQLbindings - The bindingsnull, even if the database returns no
ResultSetSQL,
DSL.sql(String, Object...)public Stream<Record> fetchStream(String sql, QueryPart... parts)
DSLContext
The returned Stream holds a reference to the executed
PreparedStatement and the associated ResultSet. Data can
be fetched (or iterated over) lazily, fetching records from the
ResultSet one by one.
Unlike DSLContext.fetchStream(String, Object...), the SQL passed to this
method should not contain any bind variables. Instead, you can pass
QueryPart objects to the method which will be rendered at indexed
locations of your SQL string as such:
// The following query
fetchLazy("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));
// Will execute this SQL on an Oracle database with RenderNameStyle.QUOTED:
select ?, 'test' from "DUAL"
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses! One way to escape
literals is to use DSL.name(String...) and similar methods
fetchStream in interface DSLContextsql - The SQL clause, containing {numbered placeholders} where query
parts can be injectedparts - The QueryPart objects that are rendered at the
{numbered placeholder} locationsnull, even if the database returns no
ResultSetSQL,
DSL.sql(String, QueryPart...)public Results fetchMany(SQL sql)
DSLContextExample (Sybase ASE):
String sql = "sp_help 'my_table'";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchMany in interface DSLContextsql - The SQLnull.SQLpublic Results fetchMany(String sql)
DSLContextExample (Sybase ASE):
String sql = "sp_help 'my_table'";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchMany in interface DSLContextsql - The SQLnull.SQLpublic Results fetchMany(String sql, Object... bindings)
DSLContextThere must be as many bind variables contained in the SQL, as passed in the bindings parameter
Example (Sybase ASE):
String sql = "sp_help 'my_table'";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchMany in interface DSLContextsql - The SQLbindings - The bindingsnull.SQL,
DSL.sql(String, Object...)public Results fetchMany(String sql, QueryPart... parts)
DSLContext
Unlike DSLContext.fetchMany(String, Object...), the SQL passed to this
method should not contain any bind variables. Instead, you can pass
QueryPart objects to the method which will be rendered at indexed
locations of your SQL string as such:
// The following query
fetchMany("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));
// Will execute this SQL on an Oracle database with RenderNameStyle.QUOTED:
select ?, 'test' from "DUAL"
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses! One way to escape
literals is to use DSL.name(String...) and similar methods
fetchMany in interface DSLContextsql - The SQL clause, containing {numbered placeholders} where query
parts can be injectedparts - The QueryPart objects that are rendered at the
{numbered placeholder} locationsnull.SQL,
DSL.sql(String, QueryPart...)public Record fetchOne(SQL sql)
DSLContextExample (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchOne in interface DSLContextsql - The SQLnull, if no record was found.SQLpublic Record fetchOne(String sql)
DSLContextExample (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchOne in interface DSLContextsql - The SQLnull, if no record was found.SQLpublic Record fetchOne(String sql, Object... bindings)
DSLContextThere must be as many bind variables contained in the SQL, as passed in the bindings parameter
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchOne in interface DSLContextsql - The SQLbindings - The bindingsnull, if no record was found.SQL,
DSL.sql(String, Object...)public Record fetchOne(String sql, QueryPart... parts)
DSLContext
Unlike DSLContext.fetchOne(String, Object...), the SQL passed to this
method should not contain any bind variables. Instead, you can pass
QueryPart objects to the method which will be rendered at indexed
locations of your SQL string as such:
// The following query
fetchOne("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));
// Will execute this SQL on an Oracle database with RenderNameStyle.QUOTED:
select ?, 'test' from "DUAL"
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses! One way to escape
literals is to use DSL.name(String...) and similar methods
fetchOne in interface DSLContextsql - The SQL clause, containing {numbered placeholders} where query
parts can be injectedparts - The QueryPart objects that are rendered at the
{numbered placeholder} locationsnull, if no record was found.SQL,
DSL.sql(String, QueryPart...)public Record fetchSingle(SQL sql)
DSLContextExample (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchSingle in interface DSLContextsql - The SQLnull.SQLpublic Record fetchSingle(String sql)
DSLContextExample (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchSingle in interface DSLContextsql - The SQLnull.SQLpublic Record fetchSingle(String sql, Object... bindings)
DSLContextThere must be as many bind variables contained in the SQL, as passed in the bindings parameter
Example (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchSingle in interface DSLContextsql - The SQLbindings - The bindingsnull.SQL,
DSL.sql(String, Object...)public Record fetchSingle(String sql, QueryPart... parts)
DSLContext
Unlike DSLContext.fetchOne(String, Object...), the SQL passed to this
method should not contain any bind variables. Instead, you can pass
QueryPart objects to the method which will be rendered at indexed
locations of your SQL string as such:
// The following query
fetchOne("select {0}, {1} from {2}", val(1), inline("test"), name("DUAL"));
// Will execute this SQL on an Oracle database with RenderNameStyle.QUOTED:
select ?, 'test' from "DUAL"
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses! One way to escape
literals is to use DSL.name(String...) and similar methods
fetchSingle in interface DSLContextsql - The SQL clause, containing {numbered placeholders} where query
parts can be injectedparts - The QueryPart objects that are rendered at the
{numbered placeholder} locationsnull.SQL,
DSL.sql(String, QueryPart...)public Optional<Record> fetchOptional(SQL sql)
DSLContextExample (Postgres):
String sql = "FETCH ALL IN \"
String sql = "pragma table_info('my_table')";
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fetchOptional in interface DSLContextsql - The SQLSQLpublic Optional<