Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes. |
Modifier and Type | Method and Description |
---|---|
AlterTableFinalStep |
AlterTableStep.add(Name field,
DataType<?> type)
Add an
ADD COLUMN clause to the ALTER TABLE
statement. |
AlterTableFinalStep |
AlterTableStep.addColumn(Name field,
DataType<?> type)
Add an
ADD COLUMN clause to the ALTER TABLE
statement. |
AlterTableAlterStep<Object> |
AlterTableStep.alter(Name field)
Add an
ALTER COLUMN clause to the ALTER TABLE
statement. |
AlterTableAlterStep<Object> |
AlterTableStep.alterColumn(Name field)
Add an
ALTER COLUMN clause to the ALTER TABLE
statement. |
AlterSequenceRestartStep<BigInteger> |
DSLContext.alterSequence(Name sequence)
Create a new DSL
ALTER SEQUENCE statement. |
AlterTableStep |
DSLContext.alterTable(Name table)
Create a new DSL
ALTER TABLE statement. |
Table<R> |
Table.at(Name link)
A table reference of this table at a given
Link . |
boolean |
Record.changed(Name fieldName)
Check if a field's value has been changed from its original as fetched
from the database.
|
void |
Record.changed(Name fieldName,
boolean changed)
Set this record's internal changed flag to the supplied value for a given
field.
|
CreateTableColumnStep |
CreateTableColumnStep.column(Name field,
DataType<?> type)
Add a column to the column list of the
CREATE TABLE statement. |
CreateTableColumnStep |
CreateTableAsStep.column(Name field,
DataType<?> type)
Add a column to the column list of the
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createGlobalTemporaryTable(Name table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateIndexStep |
DSLContext.createIndex(Name index)
Create a new DSL
CREATE INDEX statement. |
CreateIndexStep |
DSLContext.createIndexIfNotExists(Name index)
Create a new DSL
CREATE INDEX IF NOT EXISTS statement. |
CreateSequenceFinalStep |
DSLContext.createSequence(Name sequence)
Create a new DSL
CREATE SEQUENCE statement. |
CreateSequenceFinalStep |
DSLContext.createSequenceIfNotExists(Name sequence)
Create a new DSL
CREATE SEQUENCE statement. |
CreateTableAsStep<Record> |
DSLContext.createTable(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createTableIfNotExists(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DSLContext.createTemporaryTable(Name table)
Create a new DSL
CREATE TEMPORARY TABLE statement. |
CreateIndexStep |
DSLContext.createUniqueIndex(Name index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
CreateIndexStep |
DSLContext.createUniqueIndexIfNotExists(Name index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createView(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DSLContext.createViewIfNotExists(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
Table<Record> |
Table.crossApply(Name name)
CROSS APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossApply(Name name)
CROSS APPLY a table to this table. |
Table<Record> |
Table.crossJoin(Name name)
CROSS JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.crossJoin(Name name)
Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(Name)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN . |
DataType<?> |
Row.dataType(Name fieldName)
Get the data type for a given field name.
|
DataType<?> |
RecordType.dataType(Name fieldName)
Get the data type for a given field name.
|
AlterTableDropStep |
AlterTableStep.drop(Name field)
Add an
DROP COLUMN clause to the ALTER TABLE
statement. |
AlterTableDropStep |
AlterTableStep.dropColumn(Name field)
Add an
DROP COLUMN clause to the ALTER TABLE
statement. |
AlterTableFinalStep |
AlterTableStep.dropConstraint(Name constraint)
Add a
DROP CONSTRAINT clause to the ALTER TABLE
statement. |
DropIndexOnStep |
DSLContext.dropIndex(Name index)
Create a new DSL
DROP INDEX statement. |
DropIndexOnStep |
DSLContext.dropIndexIfExists(Name index)
Create a new DSL
DROP INDEX IF EXISTS statement. |
DropSequenceFinalStep |
DSLContext.dropSequence(Name sequence)
Create a new DSL
DROP SEQUENCE statement. |
DropSequenceFinalStep |
DSLContext.dropSequenceIfExists(Name sequence)
Create a new DSL
DROP SEQUENCE IF EXISTS statement. |
DropTableStep |
DSLContext.dropTable(Name table)
Create a new DSL
ALTER TABLE statement. |
DropTableStep |
DSLContext.dropTableIfExists(Name table)
Create a new DSL
ALTER TABLE IF EXISTS statement. |
DropViewFinalStep |
DSLContext.dropView(Name view)
Create a new DSL
DROP VIEW statement. |
DropViewFinalStep |
DSLContext.dropViewIfExists(Name view)
Create a new DSL
DROP VIEW IF EXISTS statement. |
List<?> |
ResultQuery.fetch(Name fieldName)
Execute the query and return all values for a field name from the
generated result.
|
<T> List<T> |
ResultQuery.fetch(Name fieldName,
Class<? extends T> type)
Execute the query and return all values for a field name from the
generated result.
|
<U> List<U> |
ResultQuery.fetch(Name fieldName,
Converter<?,U> converter)
Execute the query and return all values for a field name from the
generated result.
|
Object |
ResultQuery.fetchAny(Name fieldName)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchAny(Name fieldName,
Class<? extends T> type)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchAny(Name fieldName,
Converter<?,U> converter)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
Object[] |
ResultQuery.fetchArray(Name fieldName)
Execute the query and return all values for a field name from the
generated result.
|
<T> T[] |
ResultQuery.fetchArray(Name fieldName,
Class<? extends T> type)
Execute the query and return all values for a field name from the
generated result.
|
<U> U[] |
ResultQuery.fetchArray(Name fieldName,
Converter<?,U> converter)
Execute the query and return all values for a field name from the
generated result.
|
Map<?,Result<R>> |
ResultQuery.fetchGroups(Name keyFieldName)
Execute the query and return a
Map with one of the result's
columns as key and a list of corresponding records as value. |
Map<Record,Result<R>> |
ResultQuery.fetchGroups(Name[] keyFieldNames)
Execute the query and return a
Map with the result grouped by the
given keys. |
<E> Map<Record,List<E>> |
ResultQuery.fetchGroups(Name[] keyFieldNames,
Class<? extends E> type)
Execute the query and return a
Map with results grouped by the
given keys and mapped into the given entity type. |
<E> Map<Record,List<E>> |
ResultQuery.fetchGroups(Name[] keyFieldNames,
RecordMapper<? super R,E> mapper)
Execute the query and return a
Map with results grouped by the
given keys and mapped by the given mapper. |
<E> Map<?,List<E>> |
ResultQuery.fetchGroups(Name keyFieldName,
Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
Map<?,List<?>> |
ResultQuery.fetchGroups(Name keyFieldName,
Name valueFieldName)
Execute the query and return a
Map with one of the result's
columns as key and another one of the result's columns as value
Unlike ResultQuery.fetchMap(Name, Name) , this method allows for
non-unique keys in the result set. |
<E> Map<?,List<E>> |
ResultQuery.fetchGroups(Name keyFieldName,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given key and mapped by
the given mapper. |
Map<?,R> |
ResultQuery.fetchMap(Name keyFieldName)
Execute the query and return a
Map with one of the result's
columns as key and the corresponding records as value. |
Map<Record,R> |
ResultQuery.fetchMap(Name[] keyFieldNames)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
<E> Map<List<?>,E> |
ResultQuery.fetchMap(Name[] keyFieldNames,
Class<? extends E> type)
Execute the query and return a
Map with results grouped by the
given keys and mapped into the given entity type. |
<E> Map<List<?>,E> |
ResultQuery.fetchMap(Name[] keyFieldNames,
RecordMapper<? super R,E> mapper)
Execute the query and return a
Map with results grouped by the
given keys and mapped by the given mapper. |
<E> Map<?,E> |
ResultQuery.fetchMap(Name keyFieldName,
Class<? extends E> type)
Execute the query and return a
Map with results grouped by the
given key and mapped into the given entity type. |
Map<?,?> |
ResultQuery.fetchMap(Name keyFieldName,
Name valueFieldName)
Execute the query and return a
Map with one of the result's
columns as key and another one of the result's columns as value
An exception is thrown, if the key turns out to be non-unique in the
result set. |
<E> Map<?,E> |
ResultQuery.fetchMap(Name keyFieldName,
RecordMapper<? super R,E> mapper)
Execute the query and return a
Map with results grouped by the
given key and mapped by the given mapper. |
Object |
ResultQuery.fetchOne(Name fieldName)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> T |
ResultQuery.fetchOne(Name fieldName,
Class<? extends T> type)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchOne(Name fieldName,
Converter<?,U> converter)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
Optional<?> |
ResultQuery.fetchOptional(Name fieldName)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<T> Optional<T> |
ResultQuery.fetchOptional(Name fieldName,
Class<? extends T> type)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
<U> Optional<U> |
ResultQuery.fetchOptional(Name fieldName,
Converter<?,U> converter)
Execute the query and return at most one resulting value for a
field name from the generated result.
|
Set<?> |
ResultQuery.fetchSet(Name fieldName)
Execute the query and return all values for a field name from the
generated result.
|
<T> Set<T> |
ResultQuery.fetchSet(Name fieldName,
Class<? extends T> type)
Execute the query and return all values for a field name from the
generated result.
|
<U> Set<U> |
ResultQuery.fetchSet(Name fieldName,
Converter<?,U> converter)
Execute the query and return all values for a field name from the
generated result.
|
Field<?> |
UDT.field(Name name)
Get a specific field from this UDT.
|
Field<?> |
TableLike.field(Name name)
Get a specific field from this table.
|
Field<?> |
Row.field(Name fieldName)
Get a specific field from this row.
|
Field<?> |
Result.field(Name name)
Get a specific field from this Result.
|
Field<?> |
RecordType.field(Name fieldName)
Get a specific qualified field from this record type.
|
Field<?> |
Record.field(Name name)
Get a specific qualified field from this Record.
|
Field<?> |
Cursor.field(Name name)
Get a specific qualified field from this Cursor.
|
<T> Field<T> |
TableLike.field(Name name,
Class<T> type)
Get a specific field from this table and coerce it to
type . |
<T> Field<T> |
Row.field(Name fieldName,
Class<T> type)
Get a specific field from this row and coerce it to
type . |
<T> Field<T> |
Result.field(Name name,
Class<T> type)
Get a specific field from this Result, coerced to
type . |
<T> Field<T> |
RecordType.field(Name fieldName,
Class<T> type)
Get a specific field from this record type coerced to
type . |
<T> Field<T> |
TableLike.field(Name name,
DataType<T> dataType)
Get a specific field from this table and coerce it to
dataType . |
<T> Field<T> |
Row.field(Name fieldName,
DataType<T> dataType)
Get a specific field from this row and coerce it to
dataType . |
<T> Field<T> |
Result.field(Name name,
DataType<T> dataType)
Get a specific field from this Result, coerced to
dataType . |
<T> Field<T> |
RecordType.field(Name fieldName,
DataType<T> dataType)
Get a specific field from this record type coerced to
dataType . |
Field<?>[] |
UDT.fields(Name... fieldNames)
Get all fields from this UDT, providing some field names.
|
Field<?>[] |
TableLike.fields(Name... fieldNames)
Get all fields from this table, providing some field names.
|
Field<?>[] |
Row.fields(Name... fieldNames)
Get all fields from this row, providing some field names.
|
Field<?>[] |
Result.fields(Name... fieldNames)
Get all fields from this Result, providing some field names.
|
Field<?>[] |
RecordType.fields(Name... fieldNames)
Get all fields from this record type, providing some field names.
|
Field<?>[] |
Record.fields(Name... fieldNames)
Get all fields from this Record, providing some field names.
|
Field<?>[] |
Cursor.fields(Name... fieldNames)
Get all fields from this Cursor, providing some field names.
|
UpdateWhereStep<R> |
UpdateFromStep.from(Name name)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
SelectFromStep.from(Name name)
Add a
FROM clause to the query. |
void |
Record.from(Object source,
Name... fieldNames)
Load data into this record from a source, providing some field names.
|
void |
Record.fromArray(Object[] array,
Name... fieldNames)
Load data from an array into this record, providing some fields names.
|
void |
Record.fromMap(Map<String,?> map,
Name... fieldNames)
Load data from a map into this record, providing some field names.
|
TableOnStep<Record> |
Table.fullOuterJoin(Name name)
FULL OUTER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(Name name)
Convenience method to
FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table.fullOuterJoin(Name)
This is only possible where the underlying RDBMS supports it |
Object |
Record.get(Name fieldName)
Get a value from this Record, providing a field name.
|
<T> T |
Record.get(Name fieldName,
Class<? extends T> type)
Get a converted value from this Record, providing a field name.
|
<U> U |
Record.get(Name fieldName,
Converter<?,? extends U> converter)
Get a converted value from this Record, providing a field name.
|
Object |
Record.getValue(Name fieldName)
Get a value from this Record, providing a field name.
|
<T> T |
Record.getValue(Name fieldName,
Class<? extends T> type)
Get a converted value from this Record, providing a field name.
|
<U> U |
Record.getValue(Name fieldName,
Converter<?,U> converter)
Get a converted value from this Record, providing a field name.
|
List<?> |
Result.getValues(Name fieldName)
Convenience method to fetch all values for a given field.
|
<T> List<T> |
Result.getValues(Name fieldName,
Class<? extends T> type)
Convenience method to fetch all values for a given field.
|
<U> List<U> |
Result.getValues(Name fieldName,
Converter<?,U> converter)
Convenience method to fetch all values for a given field.
|
int |
Row.indexOf(Name fieldName)
Get a field's index from this row.
|
int |
RecordType.indexOf(Name fieldName)
Get a field's index from this record type.
|
TableOnStep<Record> |
Table.innerJoin(Name name)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.innerJoin(Name name)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(Name) . |
ResultQuery<R> |
ResultQuery.intern(Name... fieldNames)
Specify a set of field names whose values should be interned.
|
Result<R> |
Result.intern(Name... fieldNames)
Specify a set of field names whose values should be interned.
|
Object[] |
Result.intoArray(Name fieldName)
Return all values for a field name from the result.
|
<T> T[] |
Result.intoArray(Name fieldName,
Class<? extends T> type)
Return all values for a field name from the result.
|
<U> U[] |
Result.intoArray(Name fieldName,
Converter<?,U> converter)
Return all values for a field name from the result.
|
Map<?,Result<R>> |
Result.intoGroups(Name keyFieldName)
Return a
Map with one of the result's columns as key and a list
of corresponding records as value. |
Map<Record,Result<R>> |
Result.intoGroups(Name[] keyFieldNames)
Return a
Map with the result grouped by the given keys. |
<E> Map<Record,List<E>> |
Result.intoGroups(Name[] keyFieldNames,
Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
<E> Map<Record,List<E>> |
Result.intoGroups(Name[] keyFieldNames,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
<E> Map<?,List<E>> |
Result.intoGroups(Name keyFieldName,
Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
Map<?,List<?>> |
Result.intoGroups(Name keyFieldName,
Name valueFieldName)
Return a
Map with one of the result's columns as key and another
one of the result's columns as value. |
<E> Map<?,List<E>> |
Result.intoGroups(Name keyFieldName,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given key and mapped by
the given mapper. |
Map<?,R> |
Result.intoMap(Name keyFieldName)
Return a
Map with one of the result's columns as key and the
corresponding records as value. |
Map<Record,R> |
Result.intoMap(Name[] keyFieldNames)
Return a
Map with the given keys as a map key and the
corresponding record as value. |
<E> Map<List<?>,E> |
Result.intoMap(Name[] keyFieldNames,
Class<? extends E> type)
Return a
Map with results grouped by the given keys and mapped
into the given entity type. |
<E> Map<List<?>,E> |
Result.intoMap(Name[] keyFieldNames,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given keys and mapped by
the given mapper. |
<E> Map<?,E> |
Result.intoMap(Name keyFieldName,
Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
Map<?,?> |
Result.intoMap(Name keyFieldName,
Name valueFieldName)
Return a
Map with one of the result's columns as key and another
one of the result's columns as value
An InvalidResultException is thrown, if the key turns out to be
non-unique in the result set. |
<E> Map<?,E> |
Result.intoMap(Name keyFieldName,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given key and mapped by
the given mapper. |
Set<?> |
Result.intoSet(Name fieldName)
Return all values for a field name from the result.
|
<T> Set<T> |
Result.intoSet(Name fieldName,
Class<? extends T> type)
Return all values for a field name from the result.
|
<U> Set<U> |
Result.intoSet(Name fieldName,
Converter<?,U> converter)
Return all values for a field name from the result.
|
TableOnStep<Record> |
Table.join(Name name)
INNER JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.join(Name name)
Convenience method to
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(Name) . |
TablePartitionByStep<Record> |
Table.leftJoin(Name name)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(Name name)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(Name) . |
TablePartitionByStep<Record> |
Table.leftOuterJoin(Name name)
LEFT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(Name name)
Convenience method to
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(Name) |
Table<Record> |
Table.naturalJoin(Name name)
NATURAL JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalJoin(Name name)
Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(Name)
Natural joins are supported by most RDBMS. |
Table<Record> |
Table.naturalLeftOuterJoin(Name name)
NATURAL LEFT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(Name name)
Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(Name)
Natural joins are supported by most RDBMS. |
Table<Record> |
Table.naturalRightOuterJoin(Name name)
NATURAL RIGHT OUTER JOIN a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(Name name)
Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(Name)
Natural joins are supported by most RDBMS. |
DropIndexFinalStep |
DropIndexOnStep.on(Name tableName)
Specify the table and column expressions on which to drop an index.
|
Object |
Record.original(Name fieldName)
Get an original value from this record as fetched from the database.
|
Table<Record> |
Table.outerApply(Name name)
OUTER APPLY a table to this table. |
SelectJoinStep<R> |
SelectJoinStep.outerApply(Name name)
OUTER APPLY a table to this table. |
WindowFinalStep<T> |
WindowOverStep.over(Name name)
Turn this aggregate function into a window function referencing a window
name.
|
AlterTableRenameColumnToStep |
AlterTableStep.renameColumn(Name oldName)
Add a
RENAME COLUMN clause to the ALTER TABLE
statement. |
AlterTableRenameConstraintToStep |
AlterTableStep.renameConstraint(Name oldName)
Add a
RENAME CONSTRAINT clause to the ALTER TABLE
statement. |
AlterTableFinalStep |
AlterTableStep.renameTo(Name newName)
Add a
RENAME TO clause to the ALTER TABLE
statement. |
void |
Record.reset(Name fieldName)
|
TablePartitionByStep<Record> |
Table.rightJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(Name name)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(Name) . |
TablePartitionByStep<Record> |
Table.rightOuterJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(Name name)
Convenience method to
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(Name)
This is only possible where the underlying RDBMS supports it |
Result<R> |
Result.sortAsc(Name fieldName)
Sort this result by one of its contained fields.
|
Result<R> |
Result.sortAsc(Name fieldName,
Comparator<?> comparator)
Sort this result by one of its contained fields using a comparator.
|
Result<R> |
Result.sortDesc(Name fieldName)
Reverse-sort this result by one of its contained fields.
|
Result<R> |
Result.sortDesc(Name fieldName,
Comparator<?> comparator)
Reverse-sort this result by one of its contained fields using a
comparator.
|
TableOnStep<Record> |
Table.straightJoin(Name name)
STRAIGHT_JOIN a table to this table. |
SelectOnStep<R> |
SelectJoinStep.straightJoin(Name name)
STRAIGHT_JOIN a table to this table. |
AlterTableFinalStep |
AlterTableRenameConstraintToStep.to(Name newName)
Specify a new column name.
|
AlterTableFinalStep |
AlterTableRenameColumnToStep.to(Name newName)
Specify a new column name.
|
TruncateIdentityStep<Record> |
DSLContext.truncate(Name table)
Create a new DSL truncate statement.
|
Class<?> |
Row.type(Name fieldName)
Get the type for a given field name.
|
Class<?> |
RecordType.type(Name fieldName)
Get the type for a given field name.
|
Modifier and Type | Method and Description |
---|---|
static Name |
DSL.name(String... qualifiedName)
Create a new SQL identifier using a qualified name.
|
Modifier and Type | Method and Description |
---|---|
static AlterSequenceRestartStep<BigInteger> |
DSL.alterSequence(Name sequence)
Create a new DSL
ALTER SEQUENCE statement. |
AlterSequenceRestartStep<BigInteger> |
DefaultDSLContext.alterSequence(Name sequence) |
static AlterTableStep |
DSL.alterTable(Name table)
Create a new DSL
ALTER TABLE statement. |
AlterTableStep |
DefaultDSLContext.alterTable(Name table) |
static Catalog |
DSL.catalog(Name name)
Create a qualified catalog, given its catalog name.
|
static ConstraintTypeStep |
DSL.constraint(Name name)
Create a
CONSTRAINT specification. |
static CreateTableAsStep<Record> |
DSL.createGlobalTemporaryTable(Name table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createGlobalTemporaryTable(Name table) |
static CreateIndexStep |
DSL.createIndex(Name index)
Create a new DSL
CREATE INDEX statement. |
CreateIndexStep |
DefaultDSLContext.createIndex(Name index) |
static CreateIndexStep |
DSL.createIndexIfNotExists(Name index)
Create a new DSL
CREATE INDEX IF NOT EXISTS statement. |
CreateIndexStep |
DefaultDSLContext.createIndexIfNotExists(Name index) |
static CreateSequenceFinalStep |
DSL.createSequence(Name sequence)
Create a new DSL
CREATE SEQUENCE statement. |
CreateSequenceFinalStep |
DefaultDSLContext.createSequence(Name sequence) |
static CreateSequenceFinalStep |
DSL.createSequenceIfNotExists(Name sequence)
Create a new DSL
CREATE SEQUENCE IF NOT EXISTS statement. |
CreateSequenceFinalStep |
DefaultDSLContext.createSequenceIfNotExists(Name sequence) |
static CreateTableAsStep<Record> |
DSL.createTable(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTable(Name table) |
static CreateTableAsStep<Record> |
DSL.createTableIfNotExists(Name table)
Create a new DSL
CREATE TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTableIfNotExists(Name table) |
static CreateTableAsStep<Record> |
DSL.createTemporaryTable(Name table)
Create a new DSL
CREATE GLOBAL TEMPORARY TABLE statement. |
CreateTableAsStep<Record> |
DefaultDSLContext.createTemporaryTable(Name table) |
static CreateIndexStep |
DSL.createUniqueIndex(Name index)
Create a new DSL
CREATE UNIQUE INDEX statement. |
CreateIndexStep |
DefaultDSLContext.createUniqueIndex(Name index) |
static CreateIndexStep |
DSL.createUniqueIndexIfNotExists(Name index)
Create a new DSL
CREATE UNIQUE INDEX IF NOT EXISTS statement. |
CreateIndexStep |
DefaultDSLContext.createUniqueIndexIfNotExists(Name index) |
static CreateViewAsStep |
DSL.createView(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
static CreateViewAsStep |
DSL.createView(Name view,
Name... fields)
Create a new DSL
CREATE VIEW statement. |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Name view,
Name... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createView(Name view,
Name... fields) |
static CreateViewAsStep |
DSL.createViewIfNotExists(Name view,
Name... fields)
Create a new DSL
CREATE VIEW IF NOT EXISTS statement. |
static CreateViewAsStep |
DSL.createViewIfNotExists(Name view,
Name... fields)
Create a new DSL
CREATE VIEW IF NOT EXISTS statement. |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Name view,
Name... fields) |
CreateViewAsStep<Record> |
DefaultDSLContext.createViewIfNotExists(Name view,
Name... fields) |
static DropIndexOnStep |
DSL.dropIndex(Name index)
Create a new DSL
DROP INDEX statement. |
DropIndexOnStep |
DefaultDSLContext.dropIndex(Name index) |
static DropIndexOnStep |
DSL.dropIndexIfExists(Name index)
Create a new DSL
DROP INDEX IF EXISTS statement. |
DropIndexOnStep |
DefaultDSLContext.dropIndexIfExists(Name index) |
DropSequenceFinalStep |
DefaultDSLContext.dropSequence(Name sequence) |
static <T extends Number> |
DSL.dropSequence(Name sequence)
Create a new DSL
DROP SEQUENCE statement. |
DropSequenceFinalStep |
DefaultDSLContext.dropSequenceIfExists(Name sequence) |
static <T extends Number> |
DSL.dropSequenceIfExists(Name sequence)
Create a new DSL
DROP SEQUENCE IF EXISTS statement. |
static DropTableStep |
DSL.dropTable(Name table)
Create a new DSL
DROP TABLE IF EXISTS statement. |
DropTableStep |
DefaultDSLContext.dropTable(Name table) |
static DropTableStep |
DSL.dropTableIfExists(Name table)
Create a new DSL
DROP TABLE statement. |
DropTableStep |
DefaultDSLContext.dropTableIfExists(Name table) |
static DropViewFinalStep |
DSL.dropView(Name view)
Create a new DSL
DROP VIEW statement. |
DropViewFinalStep |
DefaultDSLContext.dropView(Name view) |
static DropViewFinalStep |
DSL.dropViewIfExists(Name view)
Create a new DSL
DROP VIEW IF EXISTS statement. |
DropViewFinalStep |
DefaultDSLContext.dropViewIfExists(Name view) |
Field<?> |
UDTImpl.field(Name fieldName) |
static Field<Object> |
DSL.field(Name name)
Create a qualified field, given its (qualified) field name.
|
static <T> Field<T> |
DSL.field(Name name,
Class<T> type)
Create a qualified field, given its (qualified) field name.
|
static <T> Field<T> |
DSL.field(Name name,
DataType<T> type)
Create a qualified field, given its (qualified) field name.
|
Field<?>[] |
UDTImpl.fields(Name... fieldNames) |
static <T> Field<T> |
DSL.function(Name name,
Class<T> type,
Field<?>... arguments)
function() can be used to access native or user-defined
functions that are not yet or insufficiently supported by jOOQ. |
static <T> Field<T> |
DSL.function(Name name,
DataType<T> type,
Field<?>... arguments)
function() can be used to access native or user-defined
functions that are not yet or insufficiently supported by jOOQ. |
static Link |
DSL.link(Name name)
Create a database link reference.
|
static Schema |
DSL.schema(Name name)
Create a qualified schema, given its schema name.
|
static Sequence<BigInteger> |
DSL.sequence(Name name)
Create a qualified sequence, given its sequence name.
|
static <T extends Number> |
DSL.sequence(Name name,
Class<T> type)
Create a qualified sequence, given its sequence name.
|
static <T extends Number> |
DSL.sequence(Name name,
DataType<T> type)
Create a qualified sequence, given its sequence name.
|
static Table<Record> |
DSL.table(Name name)
Create a qualified table, given its table name.
|
static TruncateIdentityStep<Record> |
DSL.truncate(Name table)
Create a new DSL truncate statement.
|
TruncateIdentityStep<Record> |
DefaultDSLContext.truncate(Name table) |
Copyright © 2016. All Rights Reserved.