- java.lang.Object
-
- org.jooq.impl.DefaultDSLContext
-
- All Implemented Interfaces:
Serializable
,AutoCloseable
,DSLContext
,Scope
public class DefaultDSLContext extends Object implements DSLContext, Serializable
A default implementation forDSLContext
.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.- Author:
- Lukas Eder
- See Also:
- Serialized Form
-
-
Constructor Summary
Constructors Constructor Description 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(Configuration configuration)
DefaultDSLContext(ConnectionProvider connectionProvider, SQLDialect dialect)
DefaultDSLContext(ConnectionProvider connectionProvider, SQLDialect dialect, Settings settings)
DefaultDSLContext(SQLDialect dialect)
DefaultDSLContext(SQLDialect dialect, Settings settings)
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description AlterIndexOnStep
alterIndex(String index)
Create a new DSLALTER INDEX
statement.AlterIndexOnStep
alterIndex(Index index)
Create a new DSLALTER INDEX
statement.AlterIndexOnStep
alterIndex(Name index)
Create a new DSLALTER INDEX
statement.AlterIndexStep
alterIndexIfExists(String index)
Create a new DSLALTER INDEX
statement.AlterIndexStep
alterIndexIfExists(Index index)
Create a new DSLALTER INDEX
statement.AlterIndexStep
alterIndexIfExists(Name index)
Create a new DSLALTER INDEX
statement.AlterSchemaStep
alterSchema(String schema)
Create a new DSLALTER SCHEMA
statement.AlterSchemaStep
alterSchema(Name schema)
Create a new DSLALTER SCHEMA
statement.AlterSchemaStep
alterSchema(Schema schema)
Create a new DSLALTER SCHEMA
statement.AlterSchemaStep
alterSchemaIfExists(String schema)
Create a new DSLALTER SCHEMA
statement.AlterSchemaStep
alterSchemaIfExists(Name schema)
Create a new DSLALTER SCHEMA
statement.AlterSchemaStep
alterSchemaIfExists(Schema schema)
Create a new DSLALTER SCHEMA
statement.AlterSequenceStep<BigInteger>
alterSequence(String sequence)
Create a new DSLALTER SEQUENCE
statement.AlterSequenceStep<BigInteger>
alterSequence(Name sequence)
Create a new DSLALTER SEQUENCE
statement.<T extends Number>
AlterSequenceStep<T>alterSequence(Sequence<T> sequence)
Create a new DSLALTER SEQUENCE
statement.AlterSequenceStep<BigInteger>
alterSequenceIfExists(String sequence)
Create a new DSLALTER SEQUENCE
statement.AlterSequenceStep<BigInteger>
alterSequenceIfExists(Name sequence)
Create a new DSLALTER SEQUENCE
statement.<T extends Number>
AlterSequenceStep<T>alterSequenceIfExists(Sequence<T> sequence)
Create a new DSLALTER SEQUENCE
statement.AlterTableStep
alterTable(String table)
Create a new DSLALTER TABLE
statement.AlterTableStep
alterTable(Name table)
Create a new DSLALTER TABLE
statement.AlterTableStep
alterTable(Table<?> table)
Create a new DSLALTER TABLE
statement.AlterTableStep
alterTableIfExists(String table)
Create a new DSLALTER TABLE
statement.AlterTableStep
alterTableIfExists(Name table)
Create a new DSLALTER TABLE
statement.AlterTableStep
alterTableIfExists(Table<?> table)
Create a new DSLALTER TABLE
statement.AlterTypeStep
alterType(String type)
Create a new DSLALTER TYPE
statement.AlterTypeStep
alterType(Name type)
Create a new DSLALTER TYPE
statement.AlterViewStep
alterView(String table)
Create a new DSLALTER VIEW
statement.AlterViewStep
alterView(Name table)
Create a new DSLALTER VIEW
statement.AlterViewStep
alterView(Table<?> table)
Create a new DSLALTER VIEW
statement.AlterViewStep
alterViewIfExists(String table)
Create a new DSLALTER VIEW
statement.AlterViewStep
alterViewIfExists(Name table)
Create a new DSLALTER VIEW
statement.AlterViewStep
alterViewIfExists(Table<?> table)
Create a new DSLALTER VIEW
statement.void
attach(Collection<? extends Attachable> attachables)
Attach thisDSLContext
's underlyingScope.configuration()
to some attachables.void
attach(Attachable... attachables)
Attach thisDSLContext
's underlyingScope.configuration()
to some attachables.BatchBindStep
batch(String sql)
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).Batch
batch(String sql, Object[]... bindings)
Create a batch statement to execute a set of queries in batch mode (with bind values).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).BatchBindStep
batch(Query query)
Create a batch statement to execute a set of queries in batch mode (with bind values).Batch
batch(Query... queries)
Create a batch statement to execute a set of queries in batch mode (without 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
batchDelete(Collection<? extends UpdatableRecord<?>> records)
Create a batch statement to execute a set ofDELETE
queries in batch mode (with bind values) according toUpdatableRecord.delete()
sematics.Batch
batchDelete(UpdatableRecord<?>... records)
Create a batch statement to execute a set ofDELETE
queries in batch mode (with bind values) according toUpdatableRecord.delete()
sematics.Batch
batchInsert(Collection<? extends TableRecord<?>> records)
Create a batch statement to execute a set ofINSERT
queries in batch mode (with bind values) according toTableRecord.insert()
semantics.Batch
batchInsert(TableRecord<?>... records)
Create a batch statement to execute a set ofINSERT
queries in batch mode (with bind values) according toTableRecord.insert()
semantics.Batch
batchStore(Collection<? extends UpdatableRecord<?>> records)
Create a batch statement to execute a set ofINSERT
andUPDATE
queries in batch mode (with bind values) according toUpdatableRecord.store()
semantics.Batch
batchStore(UpdatableRecord<?>... records)
Create a batch statement to execute a set ofINSERT
andUPDATE
queries in batch mode (with bind values) according toUpdatableRecord.store()
semantics.Batch
batchUpdate(Collection<? extends UpdatableRecord<?>> records)
Create a batch statement to execute a set ofUPDATE
queries in batch mode (with bind values) according toUpdatableRecord.update()
semantics.Batch
batchUpdate(UpdatableRecord<?>... records)
Create a batch statement to execute a set ofUPDATE
queries in batch mode (with bind values) according toUpdatableRecord.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 newBindContext
for the context of thisDSLContext
.void
close()
Close the underlying resources, if any resources have been allocated when constructing thisDSLContext
.CommentOnIsStep
commentOnColumn(Field<?> field)
Create a new DSLCOMMENT ON COLUMN
statement.CommentOnIsStep
commentOnColumn(Name columnName)
Create a new DSLCOMMENT ON COLUMN
statement.CommentOnIsStep
commentOnTable(String tableName)
Create a new DSLCOMMENT ON TABLE
statement.CommentOnIsStep
commentOnTable(Name tableName)
Create a new DSLCOMMENT ON TABLE
statement.CommentOnIsStep
commentOnTable(Table<?> table)
Create a new DSLCOMMENT ON TABLE
statement.CommentOnIsStep
commentOnView(String viewName)
Create a new DSLCOMMENT ON VIEW
statement.CommentOnIsStep
commentOnView(Name viewName)
Create a new DSLCOMMENT ON VIEW
statement.CommentOnIsStep
commentOnView(Table<?> view)
Create a new DSLCOMMENT ON VIEW
statement.Configuration
configuration()
The configuration of the current scope.void
connection(ConnectionRunnable runnable)
Run aConnectionRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.connectionProvider()
.<T> T
connectionResult(ConnectionCallable<T> callable)
Run aConnectionCallable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.connectionProvider()
.CreateTableColumnStep
createGlobalTemporaryTable(String table)
Create a new DSLCREATE GLOBAL TEMPORARY TABLE
statement.CreateTableColumnStep
createGlobalTemporaryTable(Name table)
Create a new DSLCREATE GLOBAL TEMPORARY TABLE
statement.CreateTableColumnStep
createGlobalTemporaryTable(Table<?> table)
Create a new DSLCREATE GLOBAL TEMPORARY TABLE
statement.CreateIndexStep
createIndex()
Create a new DSLCREATE INDEX
statement.CreateIndexStep
createIndex(String index)
Create a new DSLCREATE INDEX
statement.CreateIndexStep
createIndex(Index index)
Create a new DSLCREATE INDEX
statement.CreateIndexStep
createIndex(Name index)
Create a new DSLCREATE INDEX
statement.CreateIndexStep
createIndexIfNotExists(String index)
Create a new DSLCREATE INDEX IF NOT EXISTS
statement.CreateIndexStep
createIndexIfNotExists(Index index)
Create a new DSLCREATE INDEX IF NOT EXISTS
statement.CreateIndexStep
createIndexIfNotExists(Name index)
Create a new DSLCREATE INDEX IF NOT EXISTS
statement.CreateViewAsStep<Record>
createOrReplaceView(String view, String... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
createOrReplaceView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
createOrReplaceView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
createOrReplaceView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
createOrReplaceView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
createOrReplaceView(Name view, Name... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
createOrReplaceView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateSchemaFinalStep
createSchema(String schema)
Create a new DSLCREATE SCHEMA
statement.CreateSchemaFinalStep
createSchema(Name schema)
Create a new DSLCREATE SCHEMA
statement.CreateSchemaFinalStep
createSchema(Schema schema)
Create a new DSLCREATE SCHEMA
statement.CreateSchemaFinalStep
createSchemaIfNotExists(String schema)
Create a new DSLCREATE SCHEMA
statement.CreateSchemaFinalStep
createSchemaIfNotExists(Name schema)
Create a new DSLCREATE SCHEMA
statement.CreateSchemaFinalStep
createSchemaIfNotExists(Schema schema)
Create a new DSLCREATE SCHEMA
statement.CreateSequenceFlagsStep
createSequence(String sequence)
Create a new DSLCREATE SEQUENCE
statement.CreateSequenceFlagsStep
createSequence(Name sequence)
Create a new DSLCREATE SEQUENCE
statement.CreateSequenceFlagsStep
createSequence(Sequence<?> sequence)
Create a new DSLCREATE SEQUENCE
statement.CreateSequenceFlagsStep
createSequenceIfNotExists(String sequence)
Create a new DSLCREATE SEQUENCE
statement.CreateSequenceFlagsStep
createSequenceIfNotExists(Name sequence)
Create a new DSLCREATE SEQUENCE
statement.CreateSequenceFlagsStep
createSequenceIfNotExists(Sequence<?> sequence)
Create a new DSLCREATE SEQUENCE
statement.CreateTableColumnStep
createTable(String table)
Create a new DSLCREATE TABLE
statement.CreateTableColumnStep
createTable(Name table)
Create a new DSLCREATE TABLE
statement.CreateTableColumnStep
createTable(Table<?> table)
Create a new DSLCREATE TABLE
statement.CreateTableColumnStep
createTableIfNotExists(String table)
Create a new DSLCREATE TABLE
statement.CreateTableColumnStep
createTableIfNotExists(Name table)
Create a new DSLCREATE TABLE
statement.CreateTableColumnStep
createTableIfNotExists(Table<?> table)
Create a new DSLCREATE TABLE
statement.CreateTableColumnStep
createTemporaryTable(String table)
Create a new DSLCREATE TEMPORARY TABLE
statement.CreateTableColumnStep
createTemporaryTable(Name table)
Create a new DSLCREATE TEMPORARY TABLE
statement.CreateTableColumnStep
createTemporaryTable(Table<?> table)
Create a new DSLCREATE TEMPORARY TABLE
statement.CreateTableColumnStep
createTemporaryTableIfNotExists(String table)
Create a new DSLCREATE TEMPORARY TABLE IF NOT EXISTS
statement.CreateTableColumnStep
createTemporaryTableIfNotExists(Name table)
Create a new DSLCREATE TEMPORARY TABLE IF NOT EXISTS
statement.CreateTableColumnStep
createTemporaryTableIfNotExists(Table<?> table)
Create a new DSLCREATE TEMPORARY TABLE IF NOT EXISTS
statement.CreateTypeStep
createType(String type)
Create a new DSLCREATE TYPE
statement.CreateTypeStep
createType(Name type)
Create a new DSLCREATE TYPE
statement.CreateIndexStep
createUniqueIndex()
Create a new DSLCREATE UNIQUE INDEX
statement.CreateIndexStep
createUniqueIndex(String index)
Create a new DSLCREATE UNIQUE INDEX
statement.CreateIndexStep
createUniqueIndex(Index index)
Create a new DSLCREATE UNIQUE INDEX
statement.CreateIndexStep
createUniqueIndex(Name index)
Create a new DSLCREATE UNIQUE INDEX
statement.CreateIndexStep
createUniqueIndexIfNotExists(String index)
Create a new DSLCREATE UNIQUE INDEX
statement.CreateIndexStep
createUniqueIndexIfNotExists(Index index)
Create a new DSLCREATE UNIQUE INDEX
statement.CreateIndexStep
createUniqueIndexIfNotExists(Name index)
Create a new DSLCREATE UNIQUE INDEX
statement.CreateViewAsStep<Record>
createView(String view, String... fields)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createView(Name view, Name... fields)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createViewIfNotExists(String view, String... fields)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createViewIfNotExists(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createViewIfNotExists(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createViewIfNotExists(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createViewIfNotExists(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createViewIfNotExists(Name view, Name... fields)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
createViewIfNotExists(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW
statement.BigInteger
currval(String sequence)
Convenience method to fetch the CURRVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.BigInteger
currval(Name sequence)
Convenience method to fetch the CURRVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.<T extends Number>
Tcurrval(Sequence<T> sequence)
Convenience method to fetch the CURRVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.Map<Object,Object>
data()
Get all custom data from thisScope
.Object
data(Object key)
Get some custom data from thisScope
.Object
data(Object key, Object value)
Set some custom data to thisScope
.Queries
ddl(Collection<? extends Table<?>> tables)
Convenience method forMeta.ddl()
.Queries
ddl(Collection<? extends Table<?>> tables, DDLExportConfiguration exportConfiguration)
Convenience method forMeta.ddl(DDLExportConfiguration)
.Queries
ddl(Collection<? extends Table<?>> tables, DDLFlag... flags)
Convenience method forMeta.ddl(DDLExportConfiguration)
.Queries
ddl(Catalog catalog)
Convenience method forMeta.ddl()
.Queries
ddl(Catalog catalog, DDLExportConfiguration exportConfiguration)
Convenience method forMeta.ddl(DDLExportConfiguration)
.Queries
ddl(Catalog catalog, DDLFlag... flags)
Convenience method forMeta.ddl(DDLExportConfiguration)
.Queries
ddl(Schema schema)
Convenience method forMeta.ddl()
.Queries
ddl(Schema schema, DDLExportConfiguration exportConfiguration)
Convenience method forMeta.ddl(DDLExportConfiguration)
.Queries
ddl(Schema schema, DDLFlag... flags)
Convenience method forMeta.ddl(DDLExportConfiguration)
.Queries
ddl(Table... tables)
Convenience method forMeta.ddl()
.Queries
ddl(Table[] tables, DDLExportConfiguration exportConfiguration)
Convenience method forMeta.ddl(DDLExportConfiguration)
.Queries
ddl(Table[] tables, DDLFlag... flags)
Convenience method forMeta.ddl(DDLExportConfiguration)
.Queries
ddl(Table<?> table)
Convenience method forMeta.ddl()
.Queries
ddl(Table<?> table, DDLExportConfiguration exportConfiguration)
Convenience method forMeta.ddl(DDLExportConfiguration)
.Queries
ddl(Table<?> table, DDLFlag... flags)
Convenience method forMeta.ddl(DDLExportConfiguration)
.<R extends Record>
DeleteUsingStep<R>delete(Table<R> table)
Create a new DSL delete statement.<R extends Record>
DeleteUsingStep<R>deleteFrom(Table<R> table)
Create a new DSL delete statement.<R extends Record>
DeleteQuery<R>deleteQuery(Table<R> table)
Create a newDeleteQuery
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()
TheSQLDialect
wrapped by this context.DropIndexOnStep
dropIndex(String index)
Create a new DSLDROP INDEX
statement.DropIndexOnStep
dropIndex(Index index)
Create a new DSLDROP INDEX
statement.DropIndexOnStep
dropIndex(Name index)
Create a new DSLDROP INDEX
statement.DropIndexOnStep
dropIndexIfExists(String index)
Create a new DSLDROP INDEX IF EXISTS
statement.DropIndexOnStep
dropIndexIfExists(Index index)
Create a new DSLDROP INDEX IF EXISTS
statement.DropIndexOnStep
dropIndexIfExists(Name index)
Create a new DSLDROP INDEX IF EXISTS
statement.DropSchemaStep
dropSchema(String schema)
Create a new DSLDROP SCHEMA
statement.DropSchemaStep
dropSchema(Name schema)
Create a new DSLDROP SCHEMA
statement.DropSchemaStep
dropSchema(Schema schema)
Create a new DSLDROP SCHEMA
statement.DropSchemaStep
dropSchemaIfExists(String schema)
Create a new DSLDROP SCHEMA
statement.DropSchemaStep
dropSchemaIfExists(Name schema)
Create a new DSLDROP SCHEMA
statement.DropSchemaStep
dropSchemaIfExists(Schema schema)
Create a new DSLDROP SCHEMA
statement.DropSequenceFinalStep
dropSequence(String sequence)
Create a new DSLDROP SEQUENCE
statement.DropSequenceFinalStep
dropSequence(Name sequence)
Create a new DSLDROP SEQUENCE
statement.DropSequenceFinalStep
dropSequence(Sequence<?> sequence)
Create a new DSLDROP SEQUENCE
statement.DropSequenceFinalStep
dropSequenceIfExists(String sequence)
Create a new DSLDROP SEQUENCE IF EXISTS
statement.DropSequenceFinalStep
dropSequenceIfExists(Name sequence)
Create a new DSLDROP SEQUENCE IF EXISTS
statement.DropSequenceFinalStep
dropSequenceIfExists(Sequence<?> sequence)
Create a new DSLDROP SEQUENCE IF EXISTS
statement.DropTableStep
dropTable(String table)
Create a new DSLDROP TABLE
statement.DropTableStep
dropTable(Name table)
Create a new DSLDROP TABLE
statement.DropTableStep
dropTable(Table<?> table)
Create a new DSLDROP TABLE
statement.DropTableStep
dropTableIfExists(String table)
Create a new DSLDROP TABLE IF EXISTS
statement.DropTableStep
dropTableIfExists(Name table)
Create a new DSLDROP TABLE IF EXISTS
statement.DropTableStep
dropTableIfExists(Table<?> table)
Create a new DSLDROP TABLE IF EXISTS
statement.DropTableStep
dropTemporaryTable(String table)
Create a new DSLDROP TEMPORARY TABLE
statement.DropTableStep
dropTemporaryTable(Name table)
Create a new DSLDROP TEMPORARY TABLE
statement.DropTableStep
dropTemporaryTable(Table<?> table)
Create a new DSLDROP TEMPORARY TABLE
statement.DropTableStep
dropTemporaryTableIfExists(String table)
Create a new DSLDROP TEMPORARY TABLE IF EXISTS
statement.DropTableStep
dropTemporaryTableIfExists(Name table)
Create a new DSLDROP TEMPORARY TABLE IF EXISTS
statement.DropTableStep
dropTemporaryTableIfExists(Table<?> table)
Create a new DSLDROP TEMPORARY TABLE IF EXISTS
statement.DropTypeStep
dropType(String type)
Create a new DSLDROP TYPE
statement.DropTypeStep
dropType(String... type)
Create a new DSLDROP TYPE
statement.DropTypeStep
dropType(Collection<?> type)
Create a new DSLDROP TYPE
statement.DropTypeStep
dropType(Name type)
Create a new DSLDROP TYPE
statement.DropTypeStep
dropType(Name... type)
Create a new DSLDROP TYPE
statement.DropTypeStep
dropTypeIfExists(String type)
Create a new DSLDROP TYPE
statement.DropTypeStep
dropTypeIfExists(String... type)
Create a new DSLDROP TYPE
statement.DropTypeStep
dropTypeIfExists(Collection<?> type)
Create a new DSLDROP TYPE
statement.DropTypeStep
dropTypeIfExists(Name type)
Create a new DSLDROP TYPE
statement.DropTypeStep
dropTypeIfExists(Name... type)
Create a new DSLDROP TYPE
statement.DropViewFinalStep
dropView(String view)
Create a new DSLDROP VIEW
statement.DropViewFinalStep
dropView(Name view)
Create a new DSLDROP VIEW
statement.DropViewFinalStep
dropView(Table<?> view)
Create a new DSLDROP VIEW
statement.DropViewFinalStep
dropViewIfExists(String view)
Create a new DSLDROP VIEW IF EXISTS
statement.DropViewFinalStep
dropViewIfExists(Name view)
Create a new DSLDROP VIEW IF EXISTS
statement.DropViewFinalStep
dropViewIfExists(Table<?> view)
Create a new DSLDROP VIEW IF EXISTS
statement.DSLContext
dsl()
Wrap theScope.configuration()
in aDSLContext
, providing access to the configuration-contextual DSL to construct executable queries.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.int
execute(Query query)
Execute aQuery
in the context of thisDSLContext
.int
execute(SQL sql)
Execute a query holding plain SQL.int
executeDelete(TableRecord<?> record, Condition condition)
Delete a record from a table.int
executeDelete(UpdatableRecord<?> record)
Delete a record from a table.int
executeInsert(TableRecord<?> record)
Insert one record.int
executeUpdate(TableRecord<?> record, Condition condition)
Update a table.int
executeUpdate(UpdatableRecord<?> record)
Update a table.Explain
explain(Query query)
Run anEXPLAIN
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 givenQueryPart
.Param<?>
extractParam(QueryPart part, String name)
Get a named parameter from aQueryPart
, provided its name.Map<String,Param<?>>
extractParams(QueryPart part)
Get aMap
of named parameters.SQLDialect
family()
TheSQLDialect.family()
wrapped by this context.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.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)
<R extends Record>
Result<R>fetch(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return results.Result<Record>
fetch(SQL sql)
Execute a new query holding plain SQL.<R extends Record>
Result<R>fetch(Table<R> table)
Execute and return all records for<R extends Record>
Result<R>fetch(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records for<R extends Record>
Result<R>fetch(Table<R> table, Condition condition)
Execute and return all records for<R extends Record>
Result<R>fetch(Table<R> table, Condition... conditions)
Execute and return all records for<R extends Record>
RfetchAny(Table<R> table)
Execute and return zero or one record for<R extends Record>
RfetchAny(Table<R> table, Collection<? extends Condition> conditions)
Execute and return zero or one record for<R extends Record>
RfetchAny(Table<R> table, Condition condition)
Execute and return zero or one record for<R extends Record>
RfetchAny(Table<R> table, Condition... conditions)
Execute and return zero or one record forCompletionStage<Result<Record>>
fetchAsync(String sql)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
fetchAsync(String sql, Object... bindings)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
fetchAsync(String sql, QueryPart... parts)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
fetchAsync(ResultSet rs)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
fetchAsync(ResultSet rs, Class<?>... types)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
fetchAsync(ResultSet rs, DataType<?>... types)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
fetchAsync(ResultSet rs, Field<?>... fields)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
fetchAsync(Executor executor, String sql)
Fetch results in a newCompletionStage
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 newCompletionStage
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 newCompletionStage
that is asynchronously completed by a task running in the given executor.CompletionStage<Result<Record>>
fetchAsync(Executor executor, ResultSet rs)
Fetch results in a newCompletionStage
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 newCompletionStage
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 newCompletionStage
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 newCompletionStage
that is asynchronously completed by a task running in the given executor.<R extends Record>
CompletionStage<Result<R>>fetchAsync(Executor executor, ResultQuery<R> query)
Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.CompletionStage<Result<Record>>
fetchAsync(Executor executor, SQL sql)
Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.<R extends Record>
CompletionStage<Result<R>>fetchAsync(Executor executor, Table<R> table)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>fetchAsync(Executor executor, Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>fetchAsync(Executor executor, Table<R> table, Condition condition)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>fetchAsync(Executor executor, Table<R> table, Condition... conditions)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>fetchAsync(ResultQuery<R> query)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
fetchAsync(SQL sql)
Fetch results in a newCompletionStage
.<R extends Record>
CompletionStage<Result<R>>fetchAsync(Table<R> table)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>fetchAsync(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>fetchAsync(Table<R> table, Condition condition)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>fetchAsync(Table<R> table, Condition... conditions)
Execute and return all records asynchronously for<R extends TableRecord<R>>
Result<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, Collection<? extends Condition> conditions)
Count the number of records in a table that satisfy a condition.int
fetchCount(Table<?> table, Condition condition)
Count the number of records in a table that satisfy a condition.int
fetchCount(Table<?> table, Condition... conditions)
Count the number of records in a table that satisfy a condition.boolean
fetchExists(Select<?> query)
Check if aSelect
would return any records, if it were executed.boolean
fetchExists(Table<?> table)
Check if a table has any records.boolean
fetchExists(Table<?> table, Collection<? extends Condition> conditions)
Check if a table has any records that satisfy a condition.boolean
fetchExists(Table<?> table, Condition condition)
Check if a table has any records that satisfy a condition.boolean
fetchExists(Table<?> table, Condition... conditions)
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 jOOQResult
.Result<Record>
fetchFromJSON(String string)
Fetch all data from a JSON string.Result<Record>
fetchFromStringData(String[]... strings)
Fetch all data from a list of strings.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>
fetchFromTXT(String string)
Fetch all data from a formatted string.Result<Record>
fetchFromTXT(String string, String nullLiteral)
Fetch all data from a formatted string.Result<Record>
fetchFromXML(String string)
Fetch all data from an XML string.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.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)
<R extends Record>
Cursor<R>fetchLazy(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a cursor.Cursor<Record>
fetchLazy(SQL sql)
Execute a new query holding plain SQL and "lazily" return the generated result.<R extends Record>
Cursor<R>fetchLazy(Table<R> table)
Execute and return all records lazily for<R extends Record>
Cursor<R>fetchLazy(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records lazily for<R extends Record>
Cursor<R>fetchLazy(Table<R> table, Condition condition)
Execute and return all records lazily for<R extends Record>
Cursor<R>fetchLazy(Table<R> table, Condition... conditions)
Execute and return all records lazily forResults
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>
ResultsfetchMany(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a cursor.Results
fetchMany(SQL sql)
Execute a new query holding plain SQL, possibly returning several result sets.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.Record
fetchOne(ResultSet rs)
Record
fetchOne(ResultSet rs, Class<?>... types)
Record
fetchOne(ResultSet rs, DataType<?>... types)
Record
fetchOne(ResultSet rs, Field<?>... fields)
<R extends Record>
RfetchOne(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a record.Record
fetchOne(SQL sql)
Execute a new query holding plain SQL.<R extends Record>
RfetchOne(Table<R> table)
Execute and return zero or one record for<R extends Record>
RfetchOne(Table<R> table, Collection<? extends Condition> conditions)
Execute and return zero or one record for<R extends Record>
RfetchOne(Table<R> table, Condition condition)
Execute and return zero or one record for<R extends Record>
RfetchOne(Table<R> table, Condition... conditions)
Execute and return zero or one record forOptional<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.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)
<R extends Record>
Optional<R>fetchOptional(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a record.Optional<Record>
fetchOptional(SQL sql)
Execute a new query holding plain SQL.<R extends Record>
Optional<R>fetchOptional(Table<R> table)
Execute and return zero or one record for<R extends Record>
Optional<R>fetchOptional(Table<R> table, Collection<? extends Condition> conditions)
Execute and return zero or one record for<R extends Record>
Optional<R>fetchOptional(Table<R> table, Condition condition)
Execute and return zero or one record for<R extends Record>
Optional<R>fetchOptional(Table<R> table, Condition... conditions)
Execute and return zero or one record forOptional<?>
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.Optional<?>
fetchOptionalValue(ResultSet rs)
Fetch a record from a JDBCResultSet
and return the only contained value.<T> Optional<T>
fetchOptionalValue(ResultSet rs, Class<T> type)
Fetch a record from a JDBCResultSet
and return the only contained value.<T> Optional<T>
fetchOptionalValue(ResultSet rs, DataType<T> type)
Fetch a record from a JDBCResultSet
and return the only contained value.<T> Optional<T>
fetchOptionalValue(ResultSet rs, Field<T> field)
Fetch a record from a JDBCResultSet
and return the only contained value.<T,R extends Record1<T>>
Optional<T>fetchOptionalValue(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a single value.Optional<?>
fetchOptionalValue(SQL sql)
Execute a new query holding plain SQL.<T> Optional<T>
fetchOptionalValue(TableField<?,T> field)
Execute aResultQuery
in the context of thisDSLContext
and return a single value.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.Record
fetchSingle(ResultSet rs)
Record
fetchSingle(ResultSet rs, Class<?>... types)
Record
fetchSingle(ResultSet rs, DataType<?>... types)
Record
fetchSingle(ResultSet rs, Field<?>... fields)
Record
fetchSingle(Collection<? extends SelectField<?>> fields)
Execute and return exactly one record for<R extends Record>
RfetchSingle(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a record.Record
fetchSingle(SelectField<?>... fields)
Execute and return exactly one record for<T1> Record1<T1>
fetchSingle(SelectField<T1> field1)
Execute and return exactly one record for<T1,T2>
Record2<T1,T2>fetchSingle(SelectField<T1> field1, SelectField<T2> field2)
Execute and return exactly one record for<T1,T2,T3>
Record3<T1,T2,T3>fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)
Execute and return exactly one record for<T1,T2,T3,T4>
Record4<T1,T2,T3,T4>fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)
Execute and return exactly one record for<T1,T2,T3,T4,T5>
Record5<T1,T2,T3,T4,T5>fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6>
Record6<T1,T2,T3,T4,T5,T6>fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7>
Record7<T1,T2,T3,T4,T5,T6,T7>fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8>
Record8<T1,T2,T3,T4,T5,T6,T7,T8>fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>fetchSingle(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)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>fetchSingle(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)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>fetchSingle(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)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>fetchSingle(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)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>fetchSingle(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)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>fetchSingle(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)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>fetchSingle(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)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>fetchSingle(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)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>fetchSingle(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)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>fetchSingle(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)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>fetchSingle(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)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>fetchSingle(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)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>fetchSingle(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)
Execute and return exactly one record for<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>fetchSingle(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)
Execute and return exactly one record forRecord
fetchSingle(SQL sql)
Execute a new query holding plain SQL.<R extends Record>
RfetchSingle(Table<R> table)
Execute and return exactly one record for<R extends Record>
RfetchSingle(Table<R> table, Collection<? extends Condition> conditions)
Execute and return exactly one record for<R extends Record>
RfetchSingle(Table<R> table, Condition condition)
Execute and return exactly one record for<R extends Record>
RfetchSingle(Table<R> table, Condition... conditions)
Execute and return exactly one record forStream<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.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)
<R extends Record>
Stream<R>fetchStream(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a stream.Stream<Record>
fetchStream(SQL sql)
Execute a new query holding plain SQL and "lazily" return the generated result.<R extends Record>
Stream<R>fetchStream(Table<R> table)
Execute and return all records lazily for<R extends Record>
Stream<R>fetchStream(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records lazily for<R extends Record>
Stream<R>fetchStream(Table<R> table, Condition condition)
Execute and return all records lazily for<R extends Record>
Stream<R>fetchStream(Table<R> table, Condition... conditions)
Execute and return all records lazily forObject
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.Object
fetchValue(ResultSet rs)
Fetch a record from a JDBCResultSet
and return the only contained value.<T> T
fetchValue(ResultSet rs, Class<T> type)
Fetch a record from a JDBCResultSet
and return the only contained value.<T> T
fetchValue(ResultSet rs, DataType<T> type)
Fetch a record from a JDBCResultSet
and return the only contained value.<T> T
fetchValue(ResultSet rs, Field<T> field)
Fetch a record from a JDBCResultSet
and return the only contained value.<T> T
fetchValue(Field<T> field)
Execute aResultQuery
in the context of thisDSLContext
and return a single value.<T,R extends Record1<T>>
TfetchValue(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a single value.Object
fetchValue(SQL sql)
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 aResultQuery
in the context of thisDSLContext
and return a single value.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.List<?>
fetchValues(ResultSet rs)
Fetch a result from a JDBCResultSet
and return the only contained column's values.<T> List<T>
fetchValues(ResultSet rs, Class<T> type)
Fetch a result from a JDBCResultSet
and return the only contained column's values.<T> List<T>
fetchValues(ResultSet rs, DataType<T> type)
Fetch a result from a JDBCResultSet
and return the only contained column's values.<T> List<T>
fetchValues(ResultSet rs, Field<T> field)
Fetch a result from a JDBCResultSet
and return the only contained column's values.<T,R extends Record1<T>>
List<T>fetchValues(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return all values for the only column.List<?>
fetchValues(SQL sql)
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 givenTable
'sTableField
.GrantOnStep
grant(Collection<? extends 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.GrantOnStep
grant(Privilege... privileges)
Grant privileges on a table to user or role.InformationSchema
informationSchema(Catalog catalog)
Convenience method forMeta.informationSchema()
.InformationSchema
informationSchema(Catalog... catalogs)
Convenience method forMeta.informationSchema()
.InformationSchema
informationSchema(Schema schema)
Convenience method forMeta.informationSchema()
.InformationSchema
informationSchema(Schema... schemas)
Convenience method forMeta.informationSchema()
.InformationSchema
informationSchema(Table<?> table)
Convenience method forMeta.informationSchema()
.InformationSchema
informationSchema(Table<?>... tables)
Convenience method forMeta.informationSchema()
.<R extends Record>
InsertSetStep<R>insertInto(Table<R> into)
Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>insertInto(Table<R> into, Collection<? extends Field<?>> fields)
Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>insertInto(Table<R> into, Field<?>... fields)
Create a new DSL insert statement.<R extends Record,T1>
InsertValuesStep1<R,T1>insertInto(Table<R> into, Field<T1> field1)
Create a new DSL insert statement.<R extends Record,T1,T2>
InsertValuesStep2<R,T1,T2>insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)
Create a new DSL insert statement.<R extends Record,T1,T2,T3>
InsertValuesStep3<R,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>
InsertValuesStep4<R,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>
InsertValuesStep5<R,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>
InsertValuesStep6<R,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>
InsertValuesStep7<R,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>
InsertValuesStep8<R,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>
InsertValuesStep9<R,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>
InsertValuesStep10<R,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>
InsertValuesStep11<R,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>
InsertValuesStep12<R,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>
InsertValuesStep13<R,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>
InsertValuesStep14<R,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>
InsertValuesStep15<R,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>
InsertValuesStep16<R,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>
InsertValuesStep17<R,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>
InsertValuesStep18<R,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>
InsertValuesStep19<R,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>
InsertValuesStep20<R,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>
InsertValuesStep21<R,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>
InsertValuesStep22<R,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<R>insertQuery(Table<R> into)
Create a newInsertQuery
BigInteger
lastID()
Retrieve the last inserted ID.<R extends Record>
LoaderOptionsStep<R>loadInto(Table<R> table)
Create a newLoader
object to load data from a CSV or XML source.Schema
map(Schema schema)
Map a schema to another one.<R extends Record>
Table<R>map(Table<R> table)
Map a table to another one.<R extends Record>
MergeUsingStep<R>mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.<R extends Record>
MergeKeyStepN<R>mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).<R extends Record>
MergeKeyStepN<R>mergeInto(Table<R> table, Field<?>... fields)
<R extends Record,T1>
MergeKeyStep1<R,T1>mergeInto(Table<R> table, Field<T1> field1)
<R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
<R extends Record,T1,T2,T3>
MergeKeyStep3<R,T1,T2,T3>mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
<R extends Record,T1,T2,T3,T4>
MergeKeyStep4<R,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>
MergeKeyStep5<R,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>
MergeKeyStep6<R,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>
MergeKeyStep7<R,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>
MergeKeyStep8<R,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>
MergeKeyStep9<R,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>
MergeKeyStep10<R,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>
MergeKeyStep11<R,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>
MergeKeyStep12<R,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>
MergeKeyStep13<R,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>
MergeKeyStep14<R,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>
MergeKeyStep15<R,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>
MergeKeyStep16<R,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>
MergeKeyStep17<R,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>
MergeKeyStep18<R,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>
MergeKeyStep19<R,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>
MergeKeyStep20<R,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>
MergeKeyStep21<R,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>
MergeKeyStep22<R,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(String... sources)
Create meta data from a set of sources.Meta
meta(DatabaseMetaData meta)
Access the database meta data from an explicit JDBCDatabaseMetaData
.Meta
meta(Catalog... catalogs)
Access the database meta data from explicit catalog information.Meta
meta(Query... queries)
Create meta data from a set of DDL queries.Meta
meta(Schema... schemas)
Access the database meta data from explicit schema information.Meta
meta(Source... sources)
Create meta data from a set of sources.Meta
meta(Table<?>... tables)
Access the database meta data from explicit table information.Meta
meta(InformationSchema schema)
Access the database meta data from an explicit JAXB-annotated meta model.Migration
migrateTo(Version to)
Create a migration from the currently installed version to a new version.void
mock(MockDataProvider provider, MockRunnable mockable)
Run aMockRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
's, and of aMockDataProvider
.<T> T
mockResult(MockDataProvider provider, MockCallable<T> mockable)
Run aMockRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
's, and of aMockDataProvider
and return themockable
's outcome.Record
newRecord(Collection<? extends Field<?>> fields)
Create a new emptyRecord
.Record
newRecord(Field<?>... fields)
Create a new emptyRecord
.<T1> Record1<T1>
newRecord(Field<T1> field1)
Create a new emptyRecord
.<T1,T2>
Record2<T1,T2>newRecord(Field<T1> field1, Field<T2> field2)
Create a new emptyRecord
.<T1,T2,T3>
Record3<T1,T2,T3>newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3)
Create a new emptyRecord
.<T1,T2,T3,T4>
Record4<T1,T2,T3,T4>newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Create a new emptyRecord
.<T1,T2,T3,T4,T5>
Record5<T1,T2,T3,T4,T5>newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Create a new emptyRecord
.<T1,T2,T3,T4,T5,T6>
Record6<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7>
Record7<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8>
Record8<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Record9<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
Record10<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
Record11<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
Record12<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
Record13<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
Record14<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
Record15<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
Record16<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
Record17<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
Record18<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
Record19<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
Record20<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
Record21<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 emptyRecord
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
Record22<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 emptyRecord
.<R extends Record>
RnewRecord(Table<R> table)
Create a newRecord
that can be inserted into the corresponding table.<R extends Record>
RnewRecord(Table<R> table, Object source)
Create a new pre-filledRecord
that can be inserted into the corresponding table.<R extends UDTRecord<R>>
RnewRecord(UDT<R> type)
Create a newUDTRecord
.Result<Record>
newResult(Collection<? extends Field<?>> fields)
Create a new emptyRecord
.Result<Record>
newResult(Field<?>... fields)
Create a new emptyRecord
.<T1> Result<Record1<T1>>
newResult(Field<T1> field1)
Create a new emptyResult
.<T1,T2>
Result<Record2<T1,T2>>newResult(Field<T1> field1, Field<T2> field2)
Create a new emptyResult
.<T1,T2,T3>
Result<Record3<T1,T2,T3>>newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3)
Create a new emptyResult
.<T1,T2,T3,T4>
Result<Record4<T1,T2,T3,T4>>newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Create a new emptyResult
.<T1,T2,T3,T4,T5>
Result<Record5<T1,T2,T3,T4,T5>>newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Create a new emptyResult
.<T1,T2,T3,T4,T5,T6>
Result<Record6<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7>
Result<Record7<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8>
Result<Record8<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Result<Record9<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
Result<Record10<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
Result<Record11<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
Result<Record12<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
Result<Record13<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
Result<Record14<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
Result<Record15<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
Result<Record16<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
Result<Record17<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
Result<Record18<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
Result<Record19<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
Result<Record20<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
Result<Record21<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 emptyResult
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
Result<Record22<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 emptyResult
.<R extends Record>
Result<R>newResult(Table<R> table)
Create a new emptyResult
.BigInteger
nextval(String sequence)
Convenience method to fetch the NEXTVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.BigInteger
nextval(Name sequence)
Convenience method to fetch the NEXTVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.<T extends Number>
Tnextval(Sequence<T> sequence)
Convenience method to fetch the NEXTVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.Parser
parser()
Access the parser API.Connection
parsingConnection()
A JDBC connection that runs each statement through theDSLContext.parser()
first, prior to re-generating and running the SQL.DataSource
parsingDataSource()
A JDBC data source that runs each statement through theDSLContext.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.RowCountQuery
query(String sql)
Create a new query holding plain SQL.RowCountQuery
query(String sql, Object... bindings)
Create a new query holding plain SQL.RowCountQuery
query(String sql, QueryPart... parts)
Create a new query holding plain SQL.RowCountQuery
query(SQL sql)
Create a new query holding plain SQL.String
render(QueryPart part)
Render a QueryPart in the context of thisDSLContext
.RenderContext
renderContext()
Get a newRenderContext
for the context of thisDSLContext
.String
renderInlined(QueryPart part)
Render a QueryPart in the context of thisDSLContext
, inlining all bind variables.String
renderNamedOrInlinedParams(QueryPart part)
Render a QueryPart in the context of thisDSLContext
, 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 thisDSLContext
, rendering bind variables as named parameters.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.ResultQuery<Record>
resultQuery(SQL sql)
Create a new query holding plain SQL.RevokeOnStep
revoke(Collection<? extends Privilege> privileges)
Revoke privileges on table from user or role.RevokeOnStep
revoke(Privilege privilege)
Revoke a privilege on table from user or role.RevokeOnStep
revoke(Privilege... privileges)
Revoke privileges 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 privilege)
Revoke grant option for a privilege on a table from user or role.RevokeOnStep
revokeGrantOptionFor(Privilege... privileges)
Revoke grant option for some privileges 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>
SelectSelectStep<Record4<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>
SelectSelectStep<Record5<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>
SelectSelectStep<Record6<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>
SelectSelectStep<Record7<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>
SelectSelectStep<Record8<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>
SelectSelectStep<Record9<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>
SelectSelectStep<Record10<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>
SelectSelectStep<Record11<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>
SelectSelectStep<Record12<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>
SelectSelectStep<Record13<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>
SelectSelectStep<Record14<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>
SelectSelectStep<Record15<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>
SelectSelectStep<Record16<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>
SelectSelectStep<Record17<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>
SelectSelectStep<Record18<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>
SelectSelectStep<Record19<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>
SelectSelectStep<Record20<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>
SelectSelectStep<Record21<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>
SelectSelectStep<Record22<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 forCOUNT(*)
.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>
SelectSelectStep<Record4<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>
SelectSelectStep<Record5<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>
SelectSelectStep<Record6<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>
SelectSelectStep<Record7<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>
SelectSelectStep<Record8<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>
SelectSelectStep<Record9<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>
SelectSelectStep<Record10<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>
SelectSelectStep<Record11<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>
SelectSelectStep<Record12<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>
SelectSelectStep<Record13<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>
SelectSelectStep<Record14<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>
SelectSelectStep<Record15<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>
SelectSelectStep<Record16<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>
SelectSelectStep<Record17<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>
SelectSelectStep<Record18<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>
SelectSelectStep<Record19<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>
SelectSelectStep<Record20<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>
SelectSelectStep<Record21<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>
SelectSelectStep<Record22<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.SelectWhereStep<Record>
selectFrom(String sql)
Create a new DSL select statement, projecting*
.SelectWhereStep<Record>
selectFrom(String sql, Object... bindings)
Create a new DSL select statement, projecting*
.SelectWhereStep<Record>
selectFrom(String sql, QueryPart... parts)
Create a new DSL select statement, projecting*
.SelectWhereStep<Record>
selectFrom(Name table)
Create a new DSL select statement, projecting*
.SelectWhereStep<Record>
selectFrom(SQL sql)
Create a new DSL select statement, projecting*
.<R extends Record>
SelectWhereStep<R>selectFrom(Table<R> table)
Create a new DSL select statement, projecting the known columns from a table.SelectSelectStep<Record1<Integer>>
selectOne()
Create a new DSL select statement for a constant1
literal.SelectQuery<Record>
selectQuery()
Create a newSelectQuery
<R extends Record>
SelectQuery<R>selectQuery(TableLike<R> table)
Create a newSelectQuery
SelectSelectStep<Record1<Integer>>
selectZero()
Create a new DSL select statement for a constant0
literal.RowCountQuery
set(Name name, Param<?> param)
Set a vendor specific flag to a new value.RowCountQuery
setCatalog(String catalog)
Set the current catalog to a new value.RowCountQuery
setCatalog(Catalog catalog)
Set the current catalog to a new value.RowCountQuery
setCatalog(Name catalog)
Set the current catalog to a new value.RowCountQuery
setSchema(String schema)
Set the current schema to a new value.RowCountQuery
setSchema(Name schema)
Set the current schema to a new value.RowCountQuery
setSchema(Schema schema)
Set the current schema to a new value.Settings
settings()
The settings wrapped by this context.Block
statements(Collection<? extends Statement> statements)
Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN ..
Block
statements(Statement... statements)
Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN ..
String
toString()
void
transaction(ContextTransactionalRunnable transactional)
Run aContextTransactionalRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
.void
transaction(TransactionalRunnable transactional)
Run aTransactionalRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
.CompletionStage<Void>
transactionAsync(Executor executor, TransactionalRunnable transactional)
Run aTransactionalRunnable
asynchronously.CompletionStage<Void>
transactionAsync(TransactionalRunnable transactional)
Run aTransactionalRunnable
asynchronously.<T> T
transactionResult(ContextTransactionalCallable<T> transactional)
Run aContextTransactionalRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
, and return thetransactional
's outcome.<T> T
transactionResult(TransactionalCallable<T> transactional)
Run aTransactionalCallable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
, and return thetransactional
's outcome.<T> CompletionStage<T>
transactionResultAsync(Executor executor, TransactionalCallable<T> transactional)
Run aTransactionalCallable
asynchronously.<T> CompletionStage<T>
transactionResultAsync(TransactionalCallable<T> transactional)
Run aTransactionalCallable
asynchronously.TruncateIdentityStep<Record>
truncate(String table)
Create a new DSL truncate statement.TruncateIdentityStep<Record>
truncate(Name table)
Create a new DSL truncate statement.<R extends Record>
TruncateIdentityStep<R>truncate(Table<R> table)
Create a new DSL truncate statement.TruncateIdentityStep<Record>
truncateTable(String table)
Create a new DSL truncate statement.TruncateIdentityStep<Record>
truncateTable(Name table)
Create a new DSL truncate statement.<R extends Record>
TruncateIdentityStep<R>truncateTable(Table<R> table)
Create a new DSL truncate statement.<R extends Record>
UpdateSetFirstStep<R>update(Table<R> table)
Create a new DSL update statement.<R extends Record>
UpdateQuery<R>updateQuery(Table<R> table)
Create a newUpdateQuery
Version
version(String id)
Initialise aVersion
.WithAsStep
with(String alias)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep1
with(String alias, String fieldAlias1)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep
with(String alias, String... fieldAliases)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep2
with(String alias, String fieldAlias1, String fieldAlias2)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep3
with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep4
with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep5
with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep6
with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep7
with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep8
with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep9
with(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep
with(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep
with(String alias, Function<? super Field<?>,? extends String> fieldNameFunction)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithStep
with(CommonTableExpression<?>... tables)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep
with(Name alias)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep1
with(Name alias, Name fieldAlias1)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep
with(Name alias, Name... fieldAliases)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep2
with(Name alias, Name fieldAlias1, Name fieldAlias2)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep3
with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep4
with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep5
with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep6
with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep7
with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep8
with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep9
with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep
withRecursive(String alias)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep1
withRecursive(String alias, String fieldAlias1)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep
withRecursive(String alias, String... fieldAliases)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep2
withRecursive(String alias, String fieldAlias1, String fieldAlias2)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep3
withRecursive(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep4
withRecursive(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep5
withRecursive(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep6
withRecursive(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep7
withRecursive(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep8
withRecursive(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep9
withRecursive(String alias, String fieldAlias1, String fieldAlias2, String fieldAlias3, String fieldAlias4, String fieldAlias5, String fieldAlias6, String fieldAlias7, String fieldAlias8, String fieldAlias9)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep
withRecursive(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep
withRecursive(String alias, Function<? super Field<?>,? extends String> fieldNameFunction)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithStep
withRecursive(CommonTableExpression<?>... tables)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep
withRecursive(Name alias)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep1
withRecursive(Name alias, Name fieldAlias1)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep
withRecursive(Name alias, Name... fieldAliases)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep2
withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep3
withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep4
withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep5
withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep6
withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep7
withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep8
withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.WithAsStep9
withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9)
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.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 aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.
-
-
-
Constructor Detail
-
DefaultDSLContext
public DefaultDSLContext(SQLDialect dialect)
-
DefaultDSLContext
public DefaultDSLContext(SQLDialect dialect, Settings settings)
-
DefaultDSLContext
public DefaultDSLContext(Connection connection, SQLDialect dialect)
-
DefaultDSLContext
public DefaultDSLContext(Connection connection, SQLDialect dialect, Settings settings)
-
DefaultDSLContext
public DefaultDSLContext(DataSource datasource, SQLDialect dialect)
-
DefaultDSLContext
public DefaultDSLContext(DataSource datasource, SQLDialect dialect, Settings settings)
-
DefaultDSLContext
public DefaultDSLContext(ConnectionProvider connectionProvider, SQLDialect dialect)
-
DefaultDSLContext
public DefaultDSLContext(ConnectionProvider connectionProvider, SQLDialect dialect, Settings settings)
-
DefaultDSLContext
public DefaultDSLContext(Configuration configuration)
-
-
Method Detail
-
close
public void close()
Description copied from interface:DSLContext
Close the underlying resources, if any resources have been allocated when constructing thisDSLContext
.Some
DSLContext
constructors, such asDSL.using(String)
,DSL.using(String, Properties)
, orDSL.using(String, String, String)
allocate aConnection
resource, which is inaccessible to the outside of theDSLContext
implementation. Proper resource management must thus be done via thisDSLContext.close()
method.- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceDSLContext
-
map
public Schema map(Schema schema)
Description copied from interface:DSLContext
Map a schema to another one.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.- Specified by:
map
in interfaceDSLContext
- Parameters:
schema
- A schema- Returns:
- The mapped schema
-
map
public <R extends Record> Table<R> map(Table<R> table)
Description copied from interface:DSLContext
Map a table to another one.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.- Specified by:
map
in interfaceDSLContext
- Parameters:
table
- A table- Returns:
- The mapped table
-
parser
public Parser parser()
Description copied from interface:DSLContext
Access the parser API.This is experimental functionality.
- Specified by:
parser
in interfaceDSLContext
-
parsingConnection
public Connection parsingConnection()
Description copied from interface:DSLContext
A JDBC connection that runs each statement through theDSLContext.parser()
first, prior to re-generating and running the SQL.The resulting
Connection
wraps an underlying JDBC connection that has been obtained fromConnectionProvider.acquire()
and must be released by callingConnection.close()
.This is experimental functionality:
- While this works well for static
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. - Batching statements is currently not supported. See also https://github.com/jOOQ/jOOQ/issues/5757.
- Specified by:
parsingConnection
in interfaceDSLContext
- While this works well for static
-
parsingDataSource
public DataSource parsingDataSource()
Description copied from interface:DSLContext
A JDBC data source that runs each statement through theDSLContext.parser()
first, prior to re-generating and running the SQL.This simply wraps the
DSLContext.parsingConnection()
in aDataSource
.- Specified by:
parsingDataSource
in interfaceDSLContext
-
diagnosticsConnection
public Connection diagnosticsConnection()
Description copied from interface:DSLContext
A JDBC connection that proxies the underlying connection to run the jOOQ Diagnostics Pack on executed queries.This is experimental functionality.
- Specified by:
diagnosticsConnection
in interfaceDSLContext
-
diagnosticsDataSource
public DataSource diagnosticsDataSource()
Description copied from interface:DSLContext
A JDBC connection that proxies the underlying connection to run the jOOQ Diagnostics Pack on executed queries.This simply wraps the
DSLContext.diagnosticsConnection()
in aDataSource
.- Specified by:
diagnosticsDataSource
in interfaceDSLContext
-
version
public Version version(String id)
Description copied from interface:DSLContext
Initialise aVersion
.This is EXPERIMENTAL functionality and subject to change in future jOOQ versions.
- Specified by:
version
in interfaceDSLContext
-
migrateTo
public Migration migrateTo(Version to)
Description copied from interface:DSLContext
Create a migration from the currently installed version to a new version.This is EXPERIMENTAL functionality and subject to change in future jOOQ versions.
- Specified by:
migrateTo
in interfaceDSLContext
-
meta
public Meta meta()
Description copied from interface:DSLContext
Access the database meta data.This method returns meta information provided by
Configuration.metaProvider()
, which defaults to a wrapper type that gives access to your JDBC connection'sDatabaseMetaData
as obtained from yourConnectionProvider
.- Specified by:
meta
in interfaceDSLContext
- See Also:
DSLContext.meta(DatabaseMetaData)
-
meta
public Meta meta(DatabaseMetaData meta)
Description copied from interface:DSLContext
Access the database meta data from an explicit JDBCDatabaseMetaData
.- Specified by:
meta
in interfaceDSLContext
-
meta
public Meta meta(Catalog... catalogs)
Description copied from interface:DSLContext
Access the database meta data from explicit catalog information.This will not connect to your database to get live meta information, unlike
DSLContext.meta()
andDSLContext.meta(DatabaseMetaData)
.- Specified by:
meta
in interfaceDSLContext
-
meta
public Meta meta(Schema... schemas)
Description copied from interface:DSLContext
Access the database meta data from explicit schema information.This will not connect to your database to get live meta information, unlike
DSLContext.meta()
andDSLContext.meta(DatabaseMetaData)
.- Specified by:
meta
in interfaceDSLContext
-
meta
public Meta meta(Table<?>... tables)
Description copied from interface:DSLContext
Access the database meta data from explicit table information.This will not connect to your database to get live meta information, unlike
DSLContext.meta()
andDSLContext.meta(DatabaseMetaData)
.- Specified by:
meta
in interfaceDSLContext
-
meta
public Meta meta(InformationSchema schema)
Description copied from interface:DSLContext
Access the database meta data from an explicit JAXB-annotated meta model.This will not connect to your database to get live meta information, unlike
DSLContext.meta()
andDSLContext.meta(DatabaseMetaData)
.- Specified by:
meta
in interfaceDSLContext
-
meta
public Meta meta(String... sources)
Description copied from interface:DSLContext
Create meta data from a set of sources.This is convenience for wrapping all argument
String
s inSource
. The same set of content types are supported as inDSLContext.meta(Source...)
.- Specified by:
meta
in interfaceDSLContext
-
meta
public Meta meta(Source... sources)
Description copied from interface:DSLContext
Create meta data from a set of sources.This method creates a
Meta
representation from a set of source content, which can be any of:- A set of DDL scripts, which will be parsed using
DSLContext.parser()
. - A set of XML files, which will be unmarshalled into
InformationSchema
objects.
This will not connect to your database to get live meta information, unlike
DSLContext.meta()
andDSLContext.meta(DatabaseMetaData)
.- Specified by:
meta
in interfaceDSLContext
- A set of DDL scripts, which will be parsed using
-
meta
public Meta meta(Query... queries)
Description copied from interface:DSLContext
Create meta data from a set of DDL queries.This works the same way as
DSLContext.meta(Source...)
, without the need of parsing the DDL scripts.- Specified by:
meta
in interfaceDSLContext
-
informationSchema
public InformationSchema informationSchema(Catalog catalog)
Description copied from interface:DSLContext
Convenience method forMeta.informationSchema()
.- Specified by:
informationSchema
in interfaceDSLContext
- See Also:
DSLContext.meta(Catalog...)
,Meta.informationSchema()
-
informationSchema
public InformationSchema informationSchema(Catalog... catalogs)
Description copied from interface:DSLContext
Convenience method forMeta.informationSchema()
.- Specified by:
informationSchema
in interfaceDSLContext
- See Also:
DSLContext.meta(Catalog...)
,Meta.informationSchema()
-
informationSchema
public InformationSchema informationSchema(Schema schema)
Description copied from interface:DSLContext
Convenience method forMeta.informationSchema()
.- Specified by:
informationSchema
in interfaceDSLContext
- See Also:
DSLContext.meta(Schema...)
,Meta.informationSchema()
-
informationSchema
public InformationSchema informationSchema(Schema... schemas)
Description copied from interface:DSLContext
Convenience method forMeta.informationSchema()
.- Specified by:
informationSchema
in interfaceDSLContext
- See Also:
DSLContext.meta(Schema...)
,Meta.informationSchema()
-
informationSchema
public InformationSchema informationSchema(Table<?> table)
Description copied from interface:DSLContext
Convenience method forMeta.informationSchema()
.- Specified by:
informationSchema
in interfaceDSLContext
- See Also:
DSLContext.meta(Table...)
,Meta.informationSchema()
-
informationSchema
public InformationSchema informationSchema(Table<?>... tables)
Description copied from interface:DSLContext
Convenience method forMeta.informationSchema()
.- Specified by:
informationSchema
in interfaceDSLContext
- See Also:
DSLContext.meta(Table...)
,Meta.informationSchema()
-
explain
public Explain explain(Query query)
Description copied from interface:DSLContext
Run anEXPLAIN
statement in the database to estimate the cardinality of the query.- Specified by:
explain
in interfaceDSLContext
-
transactionResult
public <T> T transactionResult(ContextTransactionalCallable<T> transactional)
Description copied from interface:DSLContext
Run aContextTransactionalRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
, and return thetransactional
'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, byThreadLocalTransactionProvider
automatically.- Specified by:
transactionResult
in interfaceDSLContext
- Parameters:
transactional
- The transactional code- Returns:
- The transactional outcome
-
transactionResult
public <T> T transactionResult(TransactionalCallable<T> transactional)
Description copied from interface:DSLContext
Run aTransactionalCallable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
, and return thetransactional
's outcome.The argument transactional code should not capture any scope but derive its
Configuration
from theTransactionalCallable.run(Configuration)
argument in order to create new statements.- Specified by:
transactionResult
in interfaceDSLContext
- Parameters:
transactional
- The transactional code- Returns:
- The transactional outcome
-
transaction
public void transaction(ContextTransactionalRunnable transactional)
Description copied from interface:DSLContext
Run aContextTransactionalRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.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, byThreadLocalTransactionProvider
automatically.- Specified by:
transaction
in interfaceDSLContext
- Parameters:
transactional
- The transactional code
-
transaction
public void transaction(TransactionalRunnable transactional)
Description copied from interface:DSLContext
Run aTransactionalRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
.The argument transactional code should not capture any scope but derive its
Configuration
from theTransactionalCallable.run(Configuration)
argument in order to create new statements.- Specified by:
transaction
in interfaceDSLContext
- Parameters:
transactional
- The transactional code
-
transactionAsync
public CompletionStage<Void> transactionAsync(TransactionalRunnable transactional)
Description copied from interface:DSLContext
Run aTransactionalRunnable
asynchronously.The
TransactionRunnable
is run in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
, and returns thetransactional
's outcome in a newCompletionStage
that is asynchronously completed by a task run by anExecutor
provided by the underlyingScope.configuration()
'sConfiguration.executorProvider()
.- Specified by:
transactionAsync
in interfaceDSLContext
- Parameters:
transactional
- The transactional code
-
transactionAsync
public CompletionStage<Void> transactionAsync(Executor executor, TransactionalRunnable transactional)
Description copied from interface:DSLContext
Run aTransactionalRunnable
asynchronously.The
TransactionRunnable
is run in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
, and returns thetransactional
's outcome in a newCompletionStage
that is asynchronously completed by a task run by a givenExecutor
.- Specified by:
transactionAsync
in interfaceDSLContext
transactional
- The transactional code
-
transactionResultAsync
public <T> CompletionStage<T> transactionResultAsync(TransactionalCallable<T> transactional)
Description copied from interface:DSLContext
Run aTransactionalCallable
asynchronously.The
TransactionCallable
is run in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
, and returns thetransactional
's outcome in a newCompletionStage
that is asynchronously completed by a task run by anExecutor
provided by the underlyingScope.configuration()
'sConfiguration.executorProvider()
.- Specified by:
transactionResultAsync
in interfaceDSLContext
- Parameters:
transactional
- The transactional code- Returns:
- The transactional outcome
-
transactionResultAsync
public <T> CompletionStage<T> transactionResultAsync(Executor executor, TransactionalCallable<T> transactional)
Description copied from interface:DSLContext
Run aTransactionalCallable
asynchronously.The
TransactionCallable
is run in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.transactionProvider()
, and returns thetransactional
's outcome in a newCompletionStage
that is asynchronously completed by a task run by a givenExecutor
.- Specified by:
transactionResultAsync
in interfaceDSLContext
transactional
- The transactional code- Returns:
- The transactional outcome
-
connectionResult
public <T> T connectionResult(ConnectionCallable<T> callable)
Description copied from interface:DSLContext
Run aConnectionCallable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.connectionProvider()
.- Specified by:
connectionResult
in interfaceDSLContext
- Parameters:
callable
- The code running statements against theconnection
.- Returns:
- The outcome of the callable
-
connection
public void connection(ConnectionRunnable runnable)
Description copied from interface:DSLContext
Run aConnectionRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
'sConfiguration.connectionProvider()
.- Specified by:
connection
in interfaceDSLContext
- Parameters:
runnable
- The code running statements against theconnection
.
-
mockResult
public <T> T mockResult(MockDataProvider provider, MockCallable<T> mockable)
Description copied from interface:DSLContext
Run aMockRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
's, and of aMockDataProvider
and return themockable
's outcome.- Specified by:
mockResult
in interfaceDSLContext
-
mock
public void mock(MockDataProvider provider, MockRunnable mockable)
Description copied from interface:DSLContext
Run aMockRunnable
in the context of thisDSLContext
's underlyingScope.configuration()
's, and of aMockDataProvider
.- Specified by:
mock
in interfaceDSLContext
-
renderContext
public RenderContext renderContext()
Description copied from interface:DSLContext
Get a newRenderContext
for the context of thisDSLContext
.This will return an initialised render context as such:
-
RenderContext.castMode()
==DEFAULT
-
Context.declareFields()
== false -
Context.declareTables()
== false -
RenderContext.format()
== false -
RenderContext.paramType()
==ParamType.INDEXED
-
RenderContext.qualify()
== true -
Context.subquery()
== false
- Specified by:
renderContext
in interfaceDSLContext
-
-
render
public String render(QueryPart part)
Description copied from interface:DSLContext
Render a QueryPart in the context of thisDSLContext
.This is the same as calling
renderContext().render(part)
- Specified by:
render
in interfaceDSLContext
- Parameters:
part
- TheQueryPart
to be rendered- Returns:
- The rendered SQL
-
renderNamedParams
public String renderNamedParams(QueryPart part)
Description copied from interface:DSLContext
Render a QueryPart in the context of thisDSLContext
, rendering bind variables as named parameters.This is the same as calling
renderContext().paramType(NAMED).render(part)
- Specified by:
renderNamedParams
in interfaceDSLContext
- Parameters:
part
- TheQueryPart
to be rendered- Returns:
- The rendered SQL
-
renderNamedOrInlinedParams
public String renderNamedOrInlinedParams(QueryPart part)
Description copied from interface:DSLContext
Render a QueryPart in the context of thisDSLContext
, 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)
- Specified by:
renderNamedOrInlinedParams
in interfaceDSLContext
- Parameters:
part
- TheQueryPart
to be rendered- Returns:
- The rendered SQL
-
renderInlined
public String renderInlined(QueryPart part)
Description copied from interface:DSLContext
Render a QueryPart in the context of thisDSLContext
, inlining all bind variables.This is the same as calling
renderContext().inline(true).render(part)
- Specified by:
renderInlined
in interfaceDSLContext
- Parameters:
part
- TheQueryPart
to be rendered- Returns:
- The rendered SQL
-
extractBindValues
public List<Object> extractBindValues(QueryPart part)
Description copied from interface:DSLContext
Retrieve the bind values that will be bound by a givenQueryPart
.The returned
List
is immutable. To modify bind values, useDSLContext.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"?"
- Specified by:
extractBindValues
in interfaceDSLContext
-
extractParams
public Map<String,Param<?>> extractParams(QueryPart part)
Description copied from interface:DSLContext
Get aMap
of named parameters.The
Map
itself is immutable, but theParam
elements allow for modifying bind values on an existingQuery
(or any otherQueryPart
).Bind values created with
DSL.val(Object)
will have their bind index as name.- Specified by:
extractParams
in interfaceDSLContext
- See Also:
Param
,DSL.param(String, Object)
-
extractParam
public Param<?> extractParam(QueryPart part, String name)
Description copied from interface:DSLContext
Get a named parameter from aQueryPart
, provided its name.Bind values created with
DSL.val(Object)
will have their bind index as name.- Specified by:
extractParam
in interfaceDSLContext
- See Also:
Param
,DSL.param(String, Object)
-
bindContext
public BindContext bindContext(PreparedStatement stmt)
Description copied from interface:DSLContext
Get a newBindContext
for the context of thisDSLContext
.This will return an initialised bind context as such:
Context.declareFields()
== falseContext.declareTables()
== false
BindContext for JOOQ INTERNAL USE only. Avoid referencing it directly
- Specified by:
bindContext
in interfaceDSLContext
-
bind
@Deprecated public int bind(QueryPart part, PreparedStatement stmt)
Deprecated.- Specified by:
bind
in interfaceDSLContext
-
attach
public void attach(Attachable... attachables)
Description copied from interface:DSLContext
Attach thisDSLContext
's underlyingScope.configuration()
to some attachables.- Specified by:
attach
in interfaceDSLContext
-
attach
public void attach(Collection<? extends Attachable> attachables)
Description copied from interface:DSLContext
Attach thisDSLContext
's underlyingScope.configuration()
to some attachables.- Specified by:
attach
in interfaceDSLContext
-
loadInto
public <R extends Record> LoaderOptionsStep<R> loadInto(Table<R> table)
Description copied from interface:DSLContext
Create a newLoader
object to load data from a CSV or XML source.- Specified by:
loadInto
in interfaceDSLContext
-
queries
public Queries queries(Query... queries)
Description copied from interface:DSLContext
Wrap a collection of queries.- Specified by:
queries
in interfaceDSLContext
- See Also:
DSL.queries(Query...)
-
queries
public Queries queries(Collection<? extends Query> que
-
-