public abstract class CustomTable<R extends TableRecord<R>> extends TableImpl<R>
Table
implementations in client code.
Client code may provide proper Table
implementations extending this
useful base class. All necessary parts of the Table
interface are
already implemented. Only this method needs further implementation:
Use this base class when providing custom tables to any of the following methods:
parameters
Modifier | Constructor and Description |
---|---|
protected |
CustomTable(Name name) |
protected |
CustomTable(Name name,
Schema schema) |
protected |
CustomTable(String name)
Deprecated.
- 3.10 - [#5996] - Use
CustomTable(Name) instead. |
protected |
CustomTable(String name,
Schema schema)
Deprecated.
- 3.10 - [#5996] - Use
CustomTable(Name, Schema) instead. |
Modifier and Type | Method and Description |
---|---|
Table<R> |
as(Name alias,
BiFunction<? super Field<?>,? super Integer,? extends Name> aliasFunction)
Create an alias for this table and its fields.
|
Table<R> |
as(Name alias,
Function<? super Field<?>,? extends Name> aliasFunction)
Create an alias for this table and its fields.
|
Table<R> |
as(String alias)
Create an alias for this table.
|
Table<R> |
as(String alias,
BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)
Create an alias for this table and its fields.
|
Table<R> |
as(String alias,
Function<? super Field<?>,? extends String> aliasFunction)
Create an alias for this table and its fields.
|
Table<R> |
as(String alias,
String... fieldAliases)
Create an alias for this table and its fields.
|
Table<R> |
as(Table<?> otherTable)
Create an alias for this table based on another table's name.
|
Table<R> |
as(Table<?> otherTable,
BiFunction<? super Field<?>,? super Integer,? extends Field<?>> aliasFunction)
Create an alias for this table and its fields.
|
Table<R> |
as(Table<?> otherTable,
Field<?>... otherFields)
Create an alias for this table based on another table's name.
|
Table<R> |
as(Table<?> otherTable,
Function<? super Field<?>,? extends Field<?>> aliasFunction)
Create an alias for this table and its fields.
|
Table<R> |
asOfScn(Field<? extends Number> scn)
Create an
SQLDialect.ORACLE flashback query clause from this
table. |
Table<R> |
asOfScn(Number scn)
Create an
SQLDialect.ORACLE flashback query clause from this
table. |
Table<R> |
asOfTimestamp(Field<Timestamp> timestamp)
Create an
SQLDialect.ORACLE flashback query clause from this
table. |
Table<R> |
asOfTimestamp(Timestamp timestamp)
Create an
SQLDialect.ORACLE flashback query clause from this
table. |
Table<R> |
asTable()
The underlying table representation of this object.
|
Table<R> |
asTable(String alias)
The underlying aliased table representation of this object.
|
Table<R> |
asTable(String alias,
BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)
The underlying aliased table representation of this object.
|
Table<R> |
asTable(String alias,
Function<? super Field<?>,? extends String> aliasFunction)
The underlying aliased table representation of this object.
|
Table<R> |
asTable(String alias,
String... fieldAliases)
The underlying aliased table representation of this object.
|
QualifiedAsterisk |
asterisk()
Create a qualified asterisk expression from this table
(
table. |
Table<R> |
at(Link link)
A table reference of this table at a given
Link . |
Table<R> |
at(Name link)
A table reference of this table at a given
Link . |
Table<R> |
at(String link)
A table reference of this table at a given
Link . |
void |
bind(BindContext context)
Deprecated.
- 3.4.0 - [#2694] - Use
QueryPartInternal.accept(Context) instead. |
protected DSLContext |
create()
Deprecated.
- 3.11.0 - [#6722] - Use
Attachable.configuration()
and Configuration.dsl() instead. |
protected DSLContext |
create(Configuration configuration)
Deprecated.
- 3.11.0 - [#6722] - Use
Attachable.configuration()
and Configuration.dsl() instead. |
protected DSLContext |
create(Context<?> ctx)
Deprecated.
- 3.11.0 - [#6722] - Use
Attachable.configuration()
and Configuration.dsl() instead. |
protected <T> TableField<R,T> |
createField(String name,
DataType<T> type)
Subclasses may call this method to create
TableField objects that
are linked to this table. |
protected <T> TableField<R,T> |
createField(String name,
DataType<T> type,
String comment)
Subclasses may call this method to create
TableField objects that
are linked to this table. |
protected <T,U> TableField<R,U> |
createField(String name,
DataType<T> type,
String comment,
Binding<T,U> binding)
Subclasses may call this method to create
TableField objects that
are linked to this table. |
protected <T,U> TableField<R,U> |
createField(String name,
DataType<T> type,
String comment,
Converter<T,U> converter)
Subclasses may call this method to create
TableField objects that
are linked to this table. |
protected <T,X,U> TableField<R,U> |
createField(String name,
DataType<T> type,
String comment,
Converter<X,U> converter,
Binding<T,X> binding)
Subclasses may call this method to create
TableField objects that
are linked to this table. |
protected static <R extends Record,T> |
createField(String name,
DataType<T> type,
Table<R> table)
Subclasses may call this method to create
TableField objects that
are linked to this table. |
protected static <R extends Record,T> |
createField(String name,
DataType<T> type,
Table<R> table,
String comment)
Subclasses may call this method to create
TableField objects that
are linked to this table. |
protected static <R extends Record,T,U> |
createField(String name,
DataType<T> type,
Table<R> table,
String comment,
Binding<T,U> binding)
Subclasses may call this method to create
TableField objects that
are linked to this table. |
protected static <R extends Record,T,U> |
createField(String name,
DataType<T> type,
Table<R> table,
String comment,
Converter<T,U> converter)
Subclasses may call this method to create
TableField objects that
are linked to this table. |
protected static <R extends Record,T,X,U> |
createField(String name,
DataType<T> type,
Table<R> table,
String comment,
Converter<X,U> converter,
Binding<T,X> binding)
Subclasses may call this method to create
TableField objects that
are linked to this table. |
Table<Record> |
crossApply(Name name)
CROSS APPLY a table to this table. |
Table<Record> |
crossApply(SQL sql)
CROSS APPLY a table to this table. |
Table<Record> |
crossApply(String sql)
CROSS APPLY a table to this table. |
Table<Record> |
crossApply(String sql,
Object... bindings)
CROSS APPLY a table to this table. |
Table<Record> |
crossApply(String sql,
QueryPart... parts)
CROSS APPLY a table to this table. |
Table<Record> |
crossApply(TableLike<?> table)
CROSS APPLY a table to this table. |
Table<Record> |
crossJoin(Name name)
CROSS JOIN a table to this table. |
Table<Record> |
crossJoin(SQL sql)
CROSS JOIN a table to this table. |
Table<Record> |
crossJoin(String sql)
CROSS JOIN a table to this table. |
Table<Record> |
crossJoin(String sql,
Object... bindings)
CROSS JOIN a table to this table. |
Table<Record> |
crossJoin(String sql,
QueryPart... parts)
CROSS JOIN a table to this table. |
Table<Record> |
crossJoin(TableLike<?> table)
CROSS JOIN a table to this table. |
boolean |
declaresCTE()
Subclasses may override this
|
boolean |
declaresFields()
Subclasses may override this
|
boolean |
declaresTables()
Subclasses may override this
|
boolean |
declaresWindows()
Subclasses may override this
|
DivideByOnStep |
divideBy(Table<?> divisor)
Create a new
TABLE reference from this table, applying
relational division. |
Condition |
eq(Table<R> that)
Create a predicate comparing records from self-joined tables.
|
Condition |
equal(Table<R> that)
Create a predicate comparing records from self-joined tables.
|
<T> Field<T> |
field(Field<T> field)
Get a specific field from this table, if this table knows its field
references.
|
Field<?> |
field(int index)
Get a specific field from this table, if this table knows its field
references.
|
<T> Field<T> |
field(int index,
Class<T> type)
Get a specific field from this table and coerce it to
type ,
if this table knows its field references. |
<T> Field<T> |
field(int index,
DataType<T> dataType)
Get a specific field from this table and coerce it to
dataType , if this table knows its field references. |
Field<?> |
field(Name name)
Get a specific field from this table, if this table knows its field
references.
|
<T> Field<T> |
field(Name name,
Class<T> type)
Get a specific field from this table and coerce it to
type ,
if this table knows its field references. |
<T> Field<T> |
field(Name name,
DataType<T> dataType)
Get a specific field from this table and coerce it to
dataType , if this table knows its field references. |
Field<?> |
field(String string)
Get a specific field from this table, if this table knows its field
references.
|
<T> Field<T> |
field(String name,
Class<T> type)
Get a specific field from this table and coerce it to
type ,
if this table knows its field references. |
<T> Field<T> |
field(String name,
DataType<T> dataType)
Get a specific field from this table and coerce it to
dataType , if this table knows its field references. |
Field<?>[] |
fields()
Get all fields from this table, if this table knows its field references,
or an empty array otherwise.
|
Field<?>[] |
fields(Field<?>... fields)
Get all fields from this table, providing some fields, if this table
knows its field references.
|
Field<?>[] |
fields(int... fieldIndexes)
Get all fields from this table, providing some field indexes, if this
table knows its field references.
|
Field<?>[] |
fields(Name... fieldNames)
Get all fields from this table, providing some field names, if this table
knows its field references.
|
Field<?>[] |
fields(String... fieldNames)
Get all fields from this table, providing some field names, if this table
knows its field references.
|
Row |
fieldsRow()
Get this table's fields as a
Row , if this table knows its field
references. |
Stream<Field<?>> |
fieldStream()
Get this table's fields as a
Stream , if this table knows its
field references. |
Table<R> |
forceIndex(String... indexes)
Specify a MySQL style table hint for query optimisation.
|
Table<R> |
forceIndexForGroupBy(String... indexes)
Specify a MySQL style table hint for query optimisation.
|
Table<R> |
forceIndexForJoin(String... indexes)
Specify a MySQL style table hint for query optimisation.
|
Table<R> |
forceIndexForOrderBy(String... indexes)
Specify a MySQL style table hint for query optimisation.
|
R |
from(Record record)
The inverse operation of
Record.into(Table) . |
TableOnStep<Record> |
fullJoin(Name name)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
fullJoin(SQL sql)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
fullJoin(String sql)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
fullJoin(String sql,
Object... bindings)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
fullJoin(String sql,
QueryPart... parts)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
fullJoin(TableLike<?> table)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
fullOuterJoin(Name name)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
fullOuterJoin(SQL sql)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
fullOuterJoin(String sql)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
fullOuterJoin(String sql,
Object... bindings)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
fullOuterJoin(String sql,
QueryPart... parts)
FULL OUTER JOIN a table to this table. |
TableOnStep<Record> |
fullOuterJoin(TableLike<?> table)
FULL OUTER JOIN a table to this table. |
boolean |
generatesCast()
Subclasses may override this
|
Catalog |
getCatalog()
Get the table catalog.
|
String |
getComment()
The comment on this object.
|
DataType<R> |
getDataType()
The table's record type as a UDT data type, in case the underlying
database supports table records as UDT records.
|
Identity<R,?> |
getIdentity()
Retrieve the table's
IDENTITY information, if available. |
List<Index> |
getIndexes()
Retrieve all of the table's indexes.
|
List<UniqueKey<R>> |
getKeys()
Retrieve all of the table's unique keys.
|
String |
getName()
The unqualified name of this object.
|
UniqueKey<R> |
getPrimaryKey()
Retrieve the table's primary key
|
Name |
getQualifiedName()
The qualified name of this object.
|
TableField<R,?> |
getRecordTimestamp()
A "timestamp" field holding record timestamp information used for
optimistic locking
jOOQ supports optimistic locking in
UpdatableRecord.store() and
UpdatableRecord.delete() if
Settings.isExecuteWithOptimisticLocking() is enabled. |
abstract Class<? extends R> |
getRecordType()
Subclasses must implement this method
Subclasses must override this method if they use the generic type parameter Record
The record type produced by this table. |
TableField<R,?> |
getRecordVersion()
A "version" field holding record version information used for optimistic
locking
jOOQ supports optimistic locking in
UpdatableRecord.store() and
UpdatableRecord.delete() if
Settings.isExecuteWithOptimisticLocking() is enabled. |
List<ForeignKey<R,?>> |
getReferences()
Get the list of
FOREIGN KEY 's of this table |
<O extends Record> |
getReferencesFrom(Table<O> other)
Get a list of
FOREIGN KEY 's of a specific table, referencing
a this table. |
<O extends Record> |
getReferencesTo(Table<O> other)
Get a list of
FOREIGN KEY 's of this table, referencing a
specific table. |
Schema |
getSchema()
Get the table schema.
|
Name |
getUnqualifiedName()
The unqualified name of this object.
|
int |
hashCode()
Generate a hash code from this
QueryPart . |
Table<R> |
ignoreIndex(String... indexes)
Specify a MySQL style table hint for query optimisation.
|
Table<R> |
ignoreIndexForGroupBy(String... indexes)
Specify a MySQL style table hint for query optimisation.
|
Table<R> |
ignoreIndexForJoin(String... indexes)
Specify a MySQL style table hint for query optimisation.
|
Table<R> |
ignoreIndexForOrderBy(String... indexes)
Specify a MySQL style table hint for query optimisation.
|
TableOnStep<Record> |
innerJoin(Name name)
INNER JOIN a table to this table. |
TableOnStep<Record> |
innerJoin(SQL sql)
INNER JOIN a table to this table. |
TableOnStep<Record> |
innerJoin(String sql)
INNER JOIN a table to this table. |
TableOnStep<Record> |
innerJoin(String sql,
Object... bindings)
INNER JOIN a table to this table. |
TableOnStep<Record> |
innerJoin(String sql,
QueryPart... parts)
INNER JOIN a table to this table. |
TableOnStep<Record> |
innerJoin(TableLike<?> table)
INNER JOIN a table to this table. |
TableOnStep<Record> |
join(Name name)
INNER JOIN a table to this table. |
TableOnStep<Record> |
join(SQL sql)
INNER JOIN a table to this table. |
TableOnStep<Record> |
join(String sql)
INNER JOIN a table to this table. |
TableOnStep<Record> |
join(String sql,
Object... bindings)
INNER JOIN a table to this table. |
TableOnStep<Record> |
join(String sql,
QueryPart... parts)
INNER JOIN a table to this table. |
TableOnStep<Record> |
join(TableLike<?> table)
INNER JOIN a table to this table. |
TableOptionalOnStep<Record> |
join(TableLike<?> table,
JoinType type)
Join a table to this table using a
JoinType
Depending on the JoinType , a subsequent
TableOnStep.on(Condition) or
TableOnStep.using(Field...) clause is required. |
TableOnStep<R> |
leftAntiJoin(TableLike<?> table)
A synthetic
LEFT ANTI JOIN clause that translates to an
equivalent NOT EXISTS predicate. |
TablePartitionByStep<Record> |
leftJoin(Name name)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
leftJoin(SQL sql)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
leftJoin(String sql)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
leftJoin(String sql,
Object... bindings)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
leftJoin(String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
leftJoin(TableLike<?> table)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
leftOuterJoin(Name name)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
leftOuterJoin(SQL sql)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
leftOuterJoin(String sql)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
leftOuterJoin(String sql,
Object... bindings)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
leftOuterJoin(String sql,
QueryPart... parts)
LEFT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN a table to this table. |
TableOnStep<R> |
leftSemiJoin(TableLike<?> table)
A synthetic
LEFT SEMI JOIN clause that translates to an
equivalent EXISTS predicate. |
Table<Record> |
naturalJoin(Name name)
NATURAL JOIN a table to this table. |
Table<Record> |
naturalJoin(SQL sql)
NATURAL JOIN a table to this table. |
Table<Record> |
naturalJoin(String sql)
NATURAL JOIN a table to this table. |
Table<Record> |
naturalJoin(String sql,
Object... bindings)
NATURAL JOIN a table to this table. |
Table<Record> |
naturalJoin(String sql,
QueryPart... parts)
NATURAL JOIN a table to this table. |
Table<Record> |
naturalJoin(TableLike<?> table)
NATURAL JOIN a table to this table. |
Table<Record> |
naturalLeftOuterJoin(Name name)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
naturalLeftOuterJoin(SQL sql)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
naturalLeftOuterJoin(String sql)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
naturalLeftOuterJoin(String sql,
Object... bindings)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
naturalLeftOuterJoin(String sql,
QueryPart... parts)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
naturalLeftOuterJoin(TableLike<?> table)
NATURAL LEFT OUTER JOIN a table to this table. |
Table<Record> |
naturalRightOuterJoin(Name name)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
naturalRightOuterJoin(SQL sql)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
naturalRightOuterJoin(String sql)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
naturalRightOuterJoin(String sql,
Object... bindings)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
naturalRightOuterJoin(String sql,
QueryPart... parts)
NATURAL RIGHT OUTER JOIN a table to this table. |
Table<Record> |
naturalRightOuterJoin(TableLike<?> table)
NATURAL RIGHT OUTER JOIN a table to this table. |
Condition |
ne(Table<R> that)
Create a predicate comparing records from self-non-equi-joined tables.
|
R |
newRecord()
Create a new
Record of this table's type. |
Condition |
notEqual(Table<R> that)
Create a predicate comparing records from self-non-equi-joined tables.
|
Table<Record> |
outerApply(Name name)
OUTER APPLY a table to this table. |
Table<Record> |
outerApply(SQL sql)
OUTER APPLY a table to this table. |
Table<Record> |
outerApply(String sql)
OUTER APPLY a table to this table. |
Table<Record> |
outerApply(String sql,
Object... bindings)
OUTER APPLY a table to this table. |
Table<Record> |
outerApply(String sql,
QueryPart... parts)
OUTER APPLY a table to this table. |
Table<Record> |
outerApply(TableLike<?> table)
OUTER APPLY a table to this table. |
TableOuterJoinStep<Record> |
partitionBy(Collection<? extends Field<?>> fields)
Add a
PARTITION BY clause to the left hand side of the
OUTER JOIN keywords |
TableOuterJoinStep<Record> |
partitionBy(Field<?>... fields)
Add a
PARTITION BY clause to the left hand side of the
OUTER JOIN keywords |
PivotForStep |
pivot(Collection<? extends Field<?>> aggregateFunctions)
Create a new
TABLE reference from this table, pivoting it
into another form. |
PivotForStep |
pivot(Field<?>... aggregateFunctions)
Create a new
TABLE reference from this table, pivoting it
into another form. |
RecordType<R> |
recordType()
The record type produced by this table.
|
TablePartitionByStep<Record> |
rightJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
rightJoin(SQL sql)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
rightJoin(String sql)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
rightJoin(String sql,
Object... bindings)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
rightJoin(String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
rightJoin(TableLike<?> table)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
rightOuterJoin(Name name)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
rightOuterJoin(SQL sql)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
rightOuterJoin(String sql)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
rightOuterJoin(String sql,
Object... bindings)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
rightOuterJoin(String sql,
QueryPart... parts)
RIGHT OUTER JOIN a table to this table. |
TablePartitionByStep<Record> |
rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN a table to this table. |
TableOptionalOnStep<Record> |
straightJoin(Name name)
STRAIGHT_JOIN a table to this table. |
TableOptionalOnStep<Record> |
straightJoin(SQL sql)
STRAIGHT_JOIN a table to this table. |
TableOptionalOnStep<Record> |
straightJoin(String sql)
STRAIGHT_JOIN a table to this table. |
TableOptionalOnStep<Record> |
straightJoin(String sql,
Object... bindings)
STRAIGHT_JOIN a table to this table. |
TableOptionalOnStep<Record> |
straightJoin(String sql,
QueryPart... parts)
STRAIGHT_JOIN a table to this table. |
TableOptionalOnStep<Record> |
straightJoin(TableLike<?> table)
STRAIGHT_JOIN a table to this table. |
void |
toSQL(RenderContext context)
Deprecated.
- 3.4.0 - [#2694] - Use
QueryPartInternal.accept(Context) instead. |
String |
toString()
Render a SQL string representation of this
QueryPart . |
protected DataAccessException |
translate(String sql,
SQLException e)
Internal convenience method
|
Table<R> |
useIndex(String... indexes)
Specify a MySQL style table hint for query optimisation.
|
Table<R> |
useIndexForGroupBy(String... indexes)
Specify a MySQL style table hint for query optimisation.
|
Table<R> |
useIndexForJoin(String... indexes)
Specify a MySQL style table hint for query optimisation.
|
Table<R> |
useIndexForOrderBy(String... indexes)
Specify a MySQL style table hint for query optimisation.
|
VersionsBetweenAndStep<R,Number> |
versionsBetweenScn(Field<? extends Number> scn)
Create an
SQLDialect.ORACLE flashback versions query clause from
this table. |
VersionsBetweenAndStep<R,Number> |
versionsBetweenScn(Number scn)
Create an
SQLDialect.ORACLE flashback versions query clause from
this table. |
VersionsBetweenAndStep<R,Number> |
versionsBetweenScnMinvalue()
Create an
SQLDialect.ORACLE flashback versions query clause from
this table. |
VersionsBetweenAndStep<R,Timestamp> |
versionsBetweenTimestamp(Field<Timestamp> timestamp)
Create an
SQLDialect.ORACLE flashback versions query clause from
this table. |
VersionsBetweenAndStep<R,Timestamp> |
versionsBetweenTimestamp(Timestamp timestamp)
Create an
SQLDialect.ORACLE flashback versions query clause from
this table. |
VersionsBetweenAndStep<R,Timestamp> |
versionsBetweenTimestampMinvalue()
Create an
SQLDialect.ORACLE flashback versions query clause from
this table. |
Table<R> |
with(String hint)
Specify a SQL Server style table hint for query optimisation.
|
accept, as, as, clauses, equals, rename, rename
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
getComment
getName, getQualifiedName, getUnqualifiedName
protected CustomTable(Name name)
@Deprecated protected CustomTable(String name)
CustomTable(Name)
instead.@Deprecated protected CustomTable(String name, Schema schema)
CustomTable(Name, Schema)
instead.public abstract Class<? extends R> getRecordType()
Record
The record type produced by this table.
getRecordType
in interface Table<R extends TableRecord<R>>
getRecordType
in class TableImpl<R extends TableRecord<R>>
public Identity<R,?> getIdentity()
IDENTITY
information, if available.
With SQL:2003, the concept of IDENTITY
columns was
introduced in most RDBMS. These are special kinds of columns that have
auto-increment functionality when INSERT
statements are
performed.
An IDENTITY
column is usually part of the
PRIMARY KEY
or of a UNIQUE KEY
in the table,
although in some RDBMS, this is not required. There can only be at most
one IDENTITY
column.
Note: Unfortunately, this is not supported in the Oracle dialect, where identities emulated by triggers cannot be formally detected.
Subclasses should override this method
getIdentity
in interface Table<R extends TableRecord<R>>
IDENTITY
information, or
null
, if no such information is available.public UniqueKey<R> getPrimaryKey()
Subclasses may override this method
getPrimaryKey
in interface Table<R extends TableRecord<R>>
null
for an updatable
table.public List<UniqueKey<R>> getKeys()
Subclasses should override this method
getKeys
in interface Table<R extends TableRecord<R>>
null
. This is never empty
for a Table
with a Table.getPrimaryKey()
. This
method returns an unmodifiable list.public List<ForeignKey<R,?>> getReferences()
FOREIGN KEY
's of this table
Subclasses should override this method
getReferences
in interface Table<R extends TableRecord<R>>
FOREIGN KEY
's. This is never
null
.public final boolean declaresFields()
declaresFields
in interface QueryPartInternal
public final boolean declaresTables()
declaresTables
in interface QueryPartInternal
declaresTables
in class TableImpl<R extends TableRecord<R>>
public final R from(Record record)
Table
Record.into(Table)
.
This method can be used in its method reference form conveniently on a
generated table, for instance, when mapping records in a stream:
DSL.using(configuration)
.fetch("select * from t")
.stream()
.map(MY_TABLE::into)
.forEach(System.out::println);
public final QualifiedAsterisk asterisk()
Table
table.*
) for use with SELECT
.public final DataType<R> getDataType()
Table
getDataType
in interface Table<R extends Record>
public final RecordType<R> recordType()
Table
recordType
in interface Table<R extends Record>
public final R newRecord()
Table
Record
of this table's type.newRecord
in interface Table<R extends Record>
DSLContext.newRecord(Table)
public final Row fieldsRow()
TableLike
Row
, if this table knows its field
references.public final Stream<Field<?>> fieldStream()
TableLike
Stream
, if this table knows its
field references.fieldStream
in interface TableLike<R extends Record>
public final <T> Field<T> field(Field<T> field)
TableLike
This will return:
null
otherwise.
field
in interface TableLike<R extends Record>
Row.field(Field)
public final Field<?> field(String string)
TableLike
field
in interface TableLike<R extends Record>
Row.field(String)
public final <T> Field<T> field(String name, Class<T> type)
TableLike
type
,
if this table knows its field references.field
in interface TableLike<R extends Record>
Row.field(String, Class)
public final <T> Field<T> field(String name, DataType<T> dataType)
TableLike
dataType
, if this table knows its field references.field
in interface TableLike<R extends Record>
Row.field(String, DataType)
public final Field<?> field(Name name)
TableLike
field
in interface TableLike<R extends Record>
Row.field(Name)
public final <T> Field<T> field(Name name, Class<T> type)
TableLike
type
,
if this table knows its field references.field
in interface TableLike<R extends Record>
Row.field(Name, Class)
public final <T> Field<T> field(Name name, DataType<T> dataType)
TableLike
dataType
, if this table knows its field references.field
in interface TableLike<R extends Record>
Row.field(Name, DataType)
public final Field<?> field(int index)
TableLike
field
in interface TableLike<R extends Record>
Row.field(int)
public final <T> Field<T> field(int index, Class<T> type)
TableLike
type
,
if this table knows its field references.field
in interface TableLike<R extends Record>
Row.field(int, Class)
public final <T> Field<T> field(int index, DataType<T> dataType)
TableLike
dataType
, if this table knows its field references.field
in interface TableLike<R extends Record>
Row.field(int, DataType)
public final Field<?>[] fields()
TableLike
fields
in interface TableLike<R extends Record>
Row.fields()
public final Field<?>[] fields(Field<?>... fields)
TableLike
fields
in interface TableLike<R extends Record>
Row.fields(Field...)
public final Field<?>[] fields(String... fieldNames)
TableLike
fields
in interface TableLike<R extends Record>
Row.fields(String...)
public final Field<?>[] fields(Name... fieldNames)
TableLike
fields
in interface TableLike<R extends Record>
Row.fields(Name...)
public final Field<?>[] fields(int... fieldIndexes)
TableLike
fields
in interface TableLike<R extends Record>
Row.fields(int...)
public final Table<R> asTable()
TableLike
This method is useful for things like
SELECT * FROM (SELECT * FROM x WHERE x.a = '1') WHERE ...
public final Table<R> asTable(String alias)
TableLike
asTable
in interface TableLike<R extends Record>
Table.as(String)
public final Table<R> asTable(String alias, String... fieldAliases)
TableLike
asTable
in interface TableLike<R extends Record>
Table.as(String, String...)
public final Table<R> asTable(String alias, Function<? super Field<?>,? extends String> aliasFunction)
TableLike
asTable
in interface TableLike<R extends Record>
Table.as(String, Function)
public final Table<R> asTable(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)
TableLike
asTable
in interface TableLike<R extends Record>
Table.as(String, BiFunction)
public Table<R> as(String alias)
Table
Note that the case-sensitivity of the returned table depends on
Settings.getRenderNameStyle()
. By default, table aliases are
quoted, and thus case-sensitive!
public Table<R> as(String alias, String... fieldAliases)
Table
Note that the case-sensitivity of the returned table and columns depends
on Settings.getRenderNameStyle()
. By default, table aliases are
quoted, and thus case-sensitive!
Note, not all databases support derived column lists for their table
aliases. On the other hand, some databases do support derived column
lists, but only for derived tables. jOOQ will try to turn table
references into derived tables to make this syntax work. In other words,
the following statements are equivalent:
-- Using derived column lists to rename columns (e.g. Postgres)
SELECT t.a, t.b
FROM my_table t(a, b)
-- Nesting table references within derived tables (e.g. SQL Server)
SELECT t.a, t.b
FROM (
SELECT * FROM my_table
) t(a, b)
Other databases may not support derived column lists at all, but they do
support common table expressions. The following statements are
equivalent:
-- Using derived column lists to rename columns (e.g. Postgres)
SELECT t.a, t.b
FROM (
SELECT 1, 2
) AS t(a, b)
-- Using UNION ALL to produce column names (e.g. MySQL)
SELECT t.a, t.b
FROM (
SELECT null a, null b FROM DUAL WHERE 1 = 0
UNION ALL
SELECT 1, 2 FROM DUAL
) t
public final Table<R> as(String alias, Function<? super Field<?>,? extends String> aliasFunction)
Table
This works like Table.as(String, String...)
, except that field aliases
are provided by a function. This is useful, for instance, to prefix all
columns with a common prefix:
MY_TABLE.as("t1", f -> "prefix_" + f.getName());
public final Table<R> as(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)
Table
This works like Table.as(String, String...)
, except that field aliases
are provided by a function. This is useful, for instance, to prefix all
columns with a common prefix:
MY_TABLE.as("t1", (f, i) -> "column" + i);
public final Table<R> as(Name alias, Function<? super Field<?>,? extends Name> aliasFunction)
Table
This works like Table.as(Name, Name...)
, except that field aliases
are provided by a function. This is useful, for instance, to prefix all
columns with a common prefix:
MY_TABLE.as("t1", f -> "prefix_" + f.getName());
public final Table<R> as(Name alias, BiFunction<? super Field<?>,? super Integer,? extends Name> aliasFunction)
Table
This works like Table.as(Name, Name...)
, except that field aliases
are provided by a function. This is useful, for instance, to prefix all
columns with a common prefix:
MY_TABLE.as("t1", (f, i) -> "column" + i);
public final Catalog getCatalog()
Table
getCatalog
in interface Table<R extends Record>
public TableField<R,?> getRecordVersion()
jOOQ supports optimistic locking in UpdatableRecord.store()
and
UpdatableRecord.delete()
if
Settings.isExecuteWithOptimisticLocking()
is enabled. Optimistic
locking is performed in a single UPDATE
or
DELETE
statement if tables provide a "version" or
"timestamp" field, or in two steps using an additional
SELECT .. FOR UPDATE
statement otherwise.
This method is overridden in generated subclasses if their corresponding tables have been configured accordingly. A table may have both a "version" and a "timestamp" field.
Subclasses may override this method
getRecordVersion
in interface Table<R extends Record>
null
, if this table has no
"version" field.Table.getRecordTimestamp()
,
UpdatableRecord.store()
,
UpdatableRecord.delete()
,
Settings.isExecuteWithOptimisticLocking()
public TableField<R,?> getRecordTimestamp()
jOOQ supports optimistic locking in UpdatableRecord.store()
and
UpdatableRecord.delete()
if
Settings.isExecuteWithOptimisticLocking()
is enabled. Optimistic
locking is performed in a single UPDATE
or
DELETE
statement if tables provide a "version" or
"timestamp" field, or in two steps using an additional
SELECT .. FOR UPDATE
statement otherwise.
This method is overridden in generated subclasses if their corresponding tables have been configured accordingly. A table may have both a "version" and a "timestamp" field.
Subclasses may override this method
getRecordTimestamp
in interface Table<R extends Record>
null
, if this table has no
"timestamp" field.Table.getRecordVersion()
,
UpdatableRecord.store()
,
UpdatableRecord.delete()
,
Settings.isExecuteWithOptimisticLocking()
public List<Index> getIndexes()
Subclasses should override this method
getIndexes
in interface Table<R extends Record>
null
. This method returns
an unmodifiable list.public final <O extends Record> List<ForeignKey<O,R>> getReferencesFrom(Table<O> other)
FOREIGN KEY
's of a specific table, referencing
a this table.getReferencesFrom
in interface Table<R extends Record>
O
- The other table's record typeother
- The other table of the foreign key relationshipFOREIGN KEY
's towards an this
table. This is never null
. This method returns an
unmodifiable list.public final <O extends Record> List<ForeignKey<R,O>> getReferencesTo(Table<O> other)
FOREIGN KEY
's of this table, referencing a
specific table.getReferencesTo
in interface Table<R extends Record>
O
- The other table's record typeother
- The other table of the foreign key relationshipFOREIGN KEY
's towards an other table.
This is never null
.protected static final <R extends Record,T> TableField<R,T> createField(String name, DataType<T> type, Table<R> table)
TableField
objects that
are linked to this table.name
- The name of the field (case-sensitive!)type
- The data type of the fieldprotected static final <R extends Record,T> TableField<R,T> createField(String name, DataType<T> type, Table<R> table, String comment)
TableField
objects that
are linked to this table.name
- The name of the field (case-sensitive!)type
- The data type of the fieldprotected static final <R extends Record,T,U> TableField<R,U> createField(String name, DataType<T> type, Table<R> table, String comment, Converter<T,U> converter)
TableField
objects that
are linked to this table.name
- The name of the field (case-sensitive!)type
- The data type of the fieldprotected static final <R extends Record,T,U> TableField<R,U> createField(String name, DataType<T> type, Table<R> table, String comment, Binding<T,U> binding)
TableField
objects that
are linked to this table.name
- The name of the field (case-sensitive!)type
- The data type of the fieldprotected static final <R extends Record,T,X,U> TableField<R,U> createField(String name, DataType<T> type, Table<R> table, String comment, Converter<X,U> converter, Binding<T,X> binding)
TableField
objects that
are linked to this table.name
- The name of the field (case-sensitive!)type
- The data type of the fieldprotected final <T> TableField<R,T> createField(String name, DataType<T> type)
TableField
objects that
are linked to this table.name
- The name of the field (case-sensitive!)type
- The data type of the fieldprotected final <T> TableField<R,T> createField(String name, DataType<T> type, String comment)
TableField
objects that
are linked to this table.name
- The name of the field (case-sensitive!)type
- The data type of the fieldprotected final <T,U> TableField<R,U> createField(String name, DataType<T> type, String comment, Converter<T,U> converter)
TableField
objects that
are linked to this table.name
- The name of the field (case-sensitive!)type
- The data type of the fieldprotected final <T,U> TableField<R,U> createField(String name, DataType<T> type, String comment, Binding<T,U> binding)
TableField
objects that
are linked to this table.name
- The name of the field (case-sensitive!)type
- The data type of the fieldprotected final <T,X,U> TableField<R,U> createField(String name, DataType<T> type, String comment, Converter<X,U> converter, Binding<T,X> binding)
TableField
objects that
are linked to this table.name
- The name of the field (case-sensitive!)type
- The data type of the fieldpublic final Condition eq(Table<R> that)
Table
This is a convenience method for self-joins, comparing complete records between tables.
For example:
MyTable a = MY_TABLE.as("a");
MyTable b = MY_TABLE.as("b");
DSL.using(configuration)
.select()
.from(a)
.join(b).on(a.eq(b));
eq
in interface Table<R extends Record>
Table.equal(Table)
public final Condition equal(Table<R> that)
Table
This is a convenience method for self-joins, comparing complete records between tables.
For example:
MyTable a = MY_TABLE.as("a");
MyTable b = MY_TABLE.as("b");
DSL.using(configuration)
.select()
.from(a)
.join(b).on(a.equal(b));
public final Condition ne(Table<R> that)
Table
For example:
MyTable a = MY_TABLE.as("a");
MyTable b = MY_TABLE.as("b");
DSL.using(configuration)
.select()
.from(a)
.join(b).on(a.ne(b));
ne
in interface Table<R extends Record>
Table.notEqual(Table)
public final Condition notEqual(Table<R> that)
Table
This is a convenience method for self-joins, comparing complete records between tables.
For example:
MyTable a = MY_TABLE.as("a");
MyTable b = MY_TABLE.as("b");
DSL.using(configuration)
.select()
.from(a)
.join(b).on(a.notEqual(b));
public final Table<R> useIndex(String... indexes)
Table
Example:
create.select()
.from(BOOK.as("b").useIndex("MY_INDEX")
.fetch();
useIndex
in interface Table<R extends Record>
public final Table<R> useIndexForJoin(String... indexes)
Table
Example:
create.select()
.from(BOOK.as("b").useIndexForJoin("MY_INDEX")
.fetch();
useIndexForJoin
in interface Table<R extends Record>
public final Table<R> useIndexForOrderBy(String... indexes)
Table
Example:
create.select()
.from(BOOK.as("b").useIndexForOrderBy("MY_INDEX")
.fetch();
useIndexForOrderBy
in interface Table<R extends Record>
public final Table<R> useIndexForGroupBy(String... indexes)
Table
Example:
create.select()
.from(BOOK.as("b").useIndexForGroupBy("MY_INDEX")
.fetch();
useIndexForGroupBy
in interface Table<R extends Record>
public final Table<R> ignoreIndex(String... indexes)
Table
Example:
create.select()
.from(BOOK.as("b").useIndex("MY_INDEX")
.fetch();
ignoreIndex
in interface Table<R extends Record>
public final Table<R> ignoreIndexForJoin(String... indexes)
Table
Example:
create.select()
.from(BOOK.as("b").useIndexForJoin("MY_INDEX")
.fetch();
ignoreIndexForJoin
in interface Table<R extends Record>
public final Table<R> ignoreIndexForOrderBy(String... indexes)
Table
Example:
create.select()
.from(BOOK.as("b").useIndexForOrderBy("MY_INDEX")
.fetch();
ignoreIndexForOrderBy
in interface Table<R extends Record>
public final Table<R> ignoreIndexForGroupBy(String... indexes)
Table
Example:
create.select()
.from(BOOK.as("b").useIndexForGroupBy("MY_INDEX")
.fetch();
ignoreIndexForGroupBy
in interface Table<R extends Record>
public final Table<R> forceIndex(String... indexes)
Table
Example:
create.select()
.from(BOOK.as("b").useIndex("MY_INDEX")
.fetch();
forceIndex
in interface Table<R extends Record>
public final Table<R> forceIndexForJoin(String... indexes)
Table
Example:
create.select()
.from(BOOK.as("b").useIndexForJoin("MY_INDEX")
.fetch();
forceIndexForJoin
in interface Table<R extends Record>
public final Table<R> forceIndexForOrderBy(String... indexes)
Table
Example:
create.select()
.from(BOOK.as("b").useIndexForOrderBy("MY_INDEX")
.fetch();
forceIndexForOrderBy
in interface Table<R extends Record>
public final Table<R> forceIndexForGroupBy(String... indexes)
Table
Example:
create.select()
.from(BOOK.as("b").useIndexForGroupBy("MY_INDEX")
.fetch();
forceIndexForGroupBy
in interface Table<R extends Record>
public final Table<R> as(Table<?> otherTable)
Table
Note that the case-sensitivity of the returned table depends on
Settings.getRenderNameStyle()
. By default, table aliases are
quoted, and thus case-sensitive!
public final Table<R> as(Table<?> otherTable, Field<?>... otherFields)
Table
Note that the case-sensitivity of the returned table depends on
Settings.getRenderNameStyle()
. By default, table aliases are
quoted, and thus case-sensitive!
public final Table<R> as(Table<?> otherTable, Function<? super Field<?>,? extends Field<?>> aliasFunction)
Table
This works like Table.as(Table, Field...)
, except that field aliases
are provided by a function. This is useful, for instance, to prefix all
columns with a common prefix:
MY_TABLE.as(MY_OTHER_TABLE, f -> MY_OTHER_TABLE.field(f));
public final Table<R> as(Table<?> otherTable, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> aliasFunction)
Table
This works like Table.as(Table, Field...)
, except that field aliases
are provided by a function. This is useful, for instance, to prefix all
columns with a common prefix:
MY_TABLE.as("t1", (f, i) -> "column" + i);
public final Table<R> with(String hint)
Table
This makes sense only on an actual database table or view, not on other composed table sources.
Example:
create.select()
.from(BOOK.as("b").with("READUNCOMMITTED")
.fetch();
For SQLDialect.ORACLE
style hints, see
SelectFromStep.hint(String)
and SelectQuery.addHint(String)
with
in interface Table<R extends Record>
SelectFromStep.hint(String)
,
SelectQuery.addHint(String)
public final Table<R> at(String link)
Table
Link
.at
in interface Table<R extends Record>
DSL.link(String)
public final Table<R> at(Name link)
Table
Link
.at
in interface Table<R extends Record>
DSL.link(Name)
public final Table<R> at(Link link)
Table
Link
.public final PivotForStep pivot(Field<?>... aggregateFunctions)
Table
TABLE
reference from this table, pivoting it
into another form.
This has been observed to work with
SQLDialect.ORACLE11G
upwardsSQLDialect.SQLSERVER
(not yet officially supported)public final PivotForStep pivot(Collection<? extends Field<?>> aggregateFunctions)
Table
TABLE
reference from this table, pivoting it
into another form.
For more details, see Table.pivot(Field...)
pivot
in interface Table<R extends Record>
aggregateFunctions
- The aggregate functions used for pivoting.PIVOT
expressionTable.pivot(Field...)
public final VersionsBetweenAndStep<R,Number> versionsBetweenScn(Number scn)
Table
SQLDialect.ORACLE
flashback versions query clause from
this table.versionsBetweenScn
in interface Table<R extends Record>
public final VersionsBetweenAndStep<R,Number> versionsBetweenScn(Field<? extends Number> scn)
Table
SQLDialect.ORACLE
flashback versions query clause from
this table.versionsBetweenScn
in interface Table<R extends Record>
public final VersionsBetweenAndStep<R,Number> versionsBetweenScnMinvalue()
Table
SQLDialect.ORACLE
flashback versions query clause from
this table.versionsBetweenScnMinvalue
in interface Table<R extends Record>
public final VersionsBetweenAndStep<R,Timestamp> versionsBetweenTimestamp(Timestamp timestamp)
Table
SQLDialect.ORACLE
flashback versions query clause from
this table.versionsBetweenTimestamp
in interface Table<R extends Record>
public final VersionsBetweenAndStep<R,Timestamp> versionsBetweenTimestamp(Field<Timestamp> timestamp)
Table
SQLDialect.ORACLE
flashback versions query clause from
this table.versionsBetweenTimestamp
in interface Table<R extends Record>
public final VersionsBetweenAndStep<R,Timestamp> versionsBetweenTimestampMinvalue()
Table
SQLDialect.ORACLE
flashback versions query clause from
this table.versionsBetweenTimestampMinvalue
in interface Table<R extends Record>
public final Table<R> asOfScn(Number scn)
Table
SQLDialect.ORACLE
flashback query clause from this
table.public final Table<R> asOfScn(Field<? extends Number> scn)
Table
SQLDialect.ORACLE
flashback query clause from this
table.public final Table<R> asOfTimestamp(Timestamp timestamp)
Table
SQLDialect.ORACLE
flashback query clause from this
table.asOfTimestamp
in interface Table<R extends Record>
public final Table<R> asOfTimestamp(Field<Timestamp> timestamp)
Table
SQLDialect.ORACLE
flashback query clause from this
table.asOfTimestamp
in interface Table<R extends Record>
public final DivideByOnStep divideBy(Table<?> divisor)
Table
TABLE
reference from this table, applying
relational division.
Relational division is the inverse of a cross join operation. The
following is an approximate definition of a relational division:
Assume the following cross join / cartesian product
C = A × B
Then it can be said that
A = C ÷ B
B = C ÷ A
With jOOQ, you can simplify using relational divisions by using the
following syntax:
C.divideBy(B).on(C.ID.equal(B.C_ID)).returning(C.TEXT)
The above roughly translates to
SELECT DISTINCT C.TEXT FROM C "c1"
WHERE NOT EXISTS (
SELECT 1 FROM B
WHERE NOT EXISTS (
SELECT 1 FROM C "c2"
WHERE "c2".TEXT = "c1".TEXT
AND "c2".ID = B.C_ID
)
)
Or in plain text: Find those TEXT values in C whose ID's correspond to
all ID's in B. Note that from the above SQL statement, it is immediately
clear that proper indexing is of the essence. Be sure to have indexes on
all columns referenced from the on(...)
and
returning(...)
clauses.
For more information about relational division and some nice, real-life examples, see
This has been observed to work with all dialects
public final TableOnStep<R> leftSemiJoin(TableLike<?> table)
Table
LEFT SEMI JOIN
clause that translates to an
equivalent EXISTS
predicate.
The following two SQL snippets are semantically equivalent:
-- Using LEFT SEMI JOIN
FROM A
LEFT SEMI JOIN B
ON A.ID = B.ID
-- Using WHERE EXISTS
FROM A
WHERE EXISTS (
SELECT 1 FROM B WHERE A.ID = B.ID
)
leftSemiJoin
in interface Table<R extends Record>
public final TableOnStep<R> leftAntiJoin(TableLike<?> table)
Table
LEFT ANTI JOIN
clause that translates to an
equivalent NOT EXISTS
predicate.
The following two SQL snippets are semantically equivalent:
-- Using LEFT ANTI JOIN
FROM A
LEFT ANTI JOIN B
ON A.ID = B.ID
-- Using WHERE NOT EXISTS
FROM A
WHERE NOT EXISTS (
SELECT 1 FROM B WHERE A.ID = B.ID
)
leftAntiJoin
in interface Table<R extends Record>
public final TableOptionalOnStep<Record> join(TableLike<?> table, JoinType type)
Table
JoinType
Depending on the JoinType
, a subsequent
TableOnStep.on(Condition)
or
TableOnStep.using(Field...)
clause is required. If it is required
but omitted, a DSL.trueCondition()
, i.e. 1 = 1
condition will be rendered
public final TableOnStep<Record> join(TableLike<?> table)
Table
INNER JOIN
a table to this table.
A synonym for Table.innerJoin(TableLike)
.
join
in interface Table<R extends Record>
Table.innerJoin(TableLike)
public final TableOnStep<Record> join(SQL sql)
Table
INNER JOIN
a table to this table.
A synonym for Table.innerJoin(String)
.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
join
in interface Table<R extends Record>
DSL.table(SQL)
,
Table.innerJoin(SQL)
,
SQL
public final TableOnStep<Record> join(String sql)
Table
INNER JOIN
a table to this table.
A synonym for Table.innerJoin(String)
.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
join
in interface Table<R extends Record>
DSL.table(String)
,
Table.innerJoin(String)
,
SQL
public final TableOnStep<Record> join(String sql, Object... bindings)
Table
INNER JOIN
a table to this table.
A synonym for Table.innerJoin(String, Object...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
join
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
Table.innerJoin(String, Object...)
,
SQL
public final TableOnStep<Record> join(String sql, QueryPart... parts)
Table
INNER JOIN
a table to this table.
A synonym for Table.innerJoin(String, QueryPart...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
join
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
Table.innerJoin(String, QueryPart...)
,
SQL
public final TableOnStep<Record> join(Name name)
Table
INNER JOIN
a table to this table.
A synonym for Table.innerJoin(Name)
.
join
in interface Table<R extends Record>
DSL.table(Name)
,
Table.innerJoin(Name)
public final TableOnStep<Record> innerJoin(TableLike<?> table)
Table
INNER JOIN
a table to this table.public final TableOnStep<Record> innerJoin(SQL sql)
Table
INNER JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
innerJoin
in interface Table<R extends Record>
DSL.table(SQL)
,
SQL
public final TableOnStep<Record> innerJoin(String sql)
Table
INNER JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
innerJoin
in interface Table<R extends Record>
DSL.table(String)
,
SQL
public final TableOnStep<Record> innerJoin(String sql, Object... bindings)
Table
INNER JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
innerJoin
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
SQL
public final TableOnStep<Record> innerJoin(String sql, QueryPart... parts)
Table
INNER JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
innerJoin
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
SQL
public final TableOnStep<Record> innerJoin(Name name)
Table
INNER JOIN
a table to this table.innerJoin
in interface Table<R extends Record>
DSL.table(Name)
public TableOuterJoinStep<Record> partitionBy(Field<?>... fields)
Table
PARTITION BY
clause to the left hand side of the
OUTER JOIN
keywordspartitionBy
in interface Table<R extends Record>
public TableOuterJoinStep<Record> partitionBy(Collection<? extends Field<?>> fields)
Table
PARTITION BY
clause to the left hand side of the
OUTER JOIN
keywordspartitionBy
in interface Table<R extends Record>
public final TablePartitionByStep<Record> leftJoin(TableLike<?> table)
Table
LEFT OUTER JOIN
a table to this table.
A synonym for Table.leftOuterJoin(TableLike)
.
leftJoin
in interface Table<R extends Record>
Table.leftOuterJoin(TableLike)
public final TablePartitionByStep<Record> leftJoin(SQL sql)
Table
LEFT OUTER JOIN
a table to this table.
A synonym for Table.leftOuterJoin(String)
.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
leftJoin
in interface Table<R extends Record>
DSL.table(SQL)
,
Table.leftOuterJoin(SQL)
,
SQL
public final TablePartitionByStep<Record> leftJoin(String sql)
Table
LEFT OUTER JOIN
a table to this table.
A synonym for Table.leftOuterJoin(String)
.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
leftJoin
in interface Table<R extends Record>
DSL.table(String)
,
Table.leftOuterJoin(String)
,
SQL
public final TablePartitionByStep<Record> leftJoin(String sql, Object... bindings)
Table
LEFT OUTER JOIN
a table to this table.
A synonym for Table.leftOuterJoin(String, Object...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
leftJoin
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
Table.leftOuterJoin(String, Object...)
,
SQL
public final TablePartitionByStep<Record> leftJoin(String sql, QueryPart... parts)
Table
LEFT OUTER JOIN
a table to this table.
A synonym for Table.leftOuterJoin(String, QueryPart...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
leftJoin
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
Table.leftOuterJoin(String, QueryPart...)
,
SQL
public final TablePartitionByStep<Record> leftJoin(Name name)
Table
LEFT OUTER JOIN
a table to this table.
A synonym for Table.leftOuterJoin(Name)
.
leftJoin
in interface Table<R extends Record>
DSL.table(Name)
,
Table.leftOuterJoin(Name)
public final TablePartitionByStep<Record> leftOuterJoin(TableLike<?> table)
Table
LEFT OUTER JOIN
a table to this table.leftOuterJoin
in interface Table<R extends Record>
public final TablePartitionByStep<Record> leftOuterJoin(SQL sql)
Table
LEFT OUTER JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
leftOuterJoin
in interface Table<R extends Record>
DSL.table(SQL)
,
SQL
public final TablePartitionByStep<Record> leftOuterJoin(String sql)
Table
LEFT OUTER JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
leftOuterJoin
in interface Table<R extends Record>
DSL.table(String)
,
SQL
public final TablePartitionByStep<Record> leftOuterJoin(String sql, Object... bindings)
Table
LEFT OUTER JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
leftOuterJoin
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
SQL
public final TablePartitionByStep<Record> leftOuterJoin(String sql, QueryPart... parts)
Table
LEFT OUTER JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
leftOuterJoin
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
SQL
public final TablePartitionByStep<Record> leftOuterJoin(Name name)
Table
LEFT OUTER JOIN
a table to this table.leftOuterJoin
in interface Table<R extends Record>
DSL.table(Name)
,
SQL
public final TablePartitionByStep<Record> rightJoin(TableLike<?> table)
Table
RIGHT OUTER JOIN
a table to this table.
A synonym for Table.rightOuterJoin(TableLike)
.
This is only possible where the underlying RDBMS supports it.
rightJoin
in interface Table<R extends Record>
Table.rightOuterJoin(TableLike)
public final TablePartitionByStep<Record> rightJoin(SQL sql)
Table
RIGHT OUTER JOIN
a table to this table.
A synonym for Table.rightOuterJoin(String)
.
This is only possible where the underlying RDBMS supports it.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
rightJoin
in interface Table<R extends Record>
DSL.table(SQL)
,
Table.rightOuterJoin(SQL)
,
SQL
public final TablePartitionByStep<Record> rightJoin(String sql)
Table
RIGHT OUTER JOIN
a table to this table.
A synonym for Table.rightOuterJoin(String)
.
This is only possible where the underlying RDBMS supports it.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
rightJoin
in interface Table<R extends Record>
DSL.table(String)
,
Table.rightOuterJoin(String)
,
SQL
public final TablePartitionByStep<Record> rightJoin(String sql, Object... bindings)
Table
RIGHT OUTER JOIN
a table to this table.
A synonym for Table.rightOuterJoin(String, Object...)
.
This is only possible where the underlying RDBMS supports it.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
rightJoin
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
Table.rightOuterJoin(String, Object...)
,
SQL
public final TablePartitionByStep<Record> rightJoin(String sql, QueryPart... parts)
Table
RIGHT OUTER JOIN
a table to this table.
A synonym for Table.rightOuterJoin(String, QueryPart...)
.
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
rightJoin
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
Table.rightOuterJoin(String, QueryPart...)
,
SQL
public final TablePartitionByStep<Record> rightJoin(Name name)
Table
RIGHT OUTER JOIN
a table to this table.
A synonym for Table.rightOuterJoin(Name)
.
This is only possible where the underlying RDBMS supports it
rightJoin
in interface Table<R extends Record>
DSL.table(Name)
,
Table.rightOuterJoin(Name)
public final TablePartitionByStep<Record> rightOuterJoin(TableLike<?> table)
Table
RIGHT OUTER JOIN
a table to this table.
This is only possible where the underlying RDBMS supports it
rightOuterJoin
in interface Table<R extends Record>
public final TablePartitionByStep<Record> rightOuterJoin(SQL sql)
Table
RIGHT OUTER JOIN
a table to this table.
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
rightOuterJoin
in interface Table<R extends Record>
DSL.table(SQL)
,
SQL
public final TablePartitionByStep<Record> rightOuterJoin(String sql)
Table
RIGHT OUTER JOIN
a table to this table.
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
rightOuterJoin
in interface Table<R extends Record>
DSL.table(String)
,
SQL
public final TablePartitionByStep<Record> rightOuterJoin(String sql, Object... bindings)
Table
RIGHT OUTER JOIN
a table to this table.
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
rightOuterJoin
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
SQL
public final TablePartitionByStep<Record> rightOuterJoin(String sql, QueryPart... parts)
Table
RIGHT OUTER JOIN
a table to this table.
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
rightOuterJoin
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
SQL
public final TablePartitionByStep<Record> rightOuterJoin(Name name)
Table
RIGHT OUTER JOIN
a table to this table.
This is only possible where the underlying RDBMS supports it
rightOuterJoin
in interface Table<R extends Record>
DSL.table(Name)
public final TableOnStep<Record> fullOuterJoin(TableLike<?> table)
Table
FULL OUTER JOIN
a table to this table.
This is only possible where the underlying RDBMS supports it
fullOuterJoin
in interface Table<R extends Record>
public final TableOnStep<Record> fullOuterJoin(SQL sql)
Table
FULL OUTER JOIN
a table to this table.
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fullOuterJoin
in interface Table<R extends Record>
DSL.table(SQL)
,
SQL
public final TableOnStep<Record> fullOuterJoin(String sql)
Table
FULL OUTER JOIN
a table to this table.
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fullOuterJoin
in interface Table<R extends Record>
DSL.table(String)
,
SQL
public final TableOnStep<Record> fullOuterJoin(String sql, Object... bindings)
Table
FULL OUTER JOIN
a table to this table.
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fullOuterJoin
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
SQL
public final TableOnStep<Record> fullOuterJoin(String sql, QueryPart... parts)
Table
FULL OUTER JOIN
a table to this table.
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
fullOuterJoin
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
SQL
public final TableOnStep<Record> fullOuterJoin(Name name)
Table
FULL OUTER JOIN
a table to this table.
This is only possible where the underlying RDBMS supports it
fullOuterJoin
in interface Table<R extends Record>
DSL.table(Name)
public final TableOnStep<Record> fullJoin(TableLike<?> table)
Table
FULL OUTER JOIN
a table to this table.
A synonym for Table.fullOuterJoin(TableLike)
.
public final TableOnStep<Record> fullJoin(SQL sql)
Table
FULL OUTER JOIN
a table to this table.
A synonym for Table.fullOuterJoin(SQL)
.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
public final TableOnStep<Record> fullJoin(String sql)
Table
FULL OUTER JOIN
a table to this table.
A synonym for Table.fullOuterJoin(String)
.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
public final TableOnStep<Record> fullJoin(String sql, Object... bindings)
Table
FULL OUTER JOIN
a table to this table.
A synonym for Table.fullOuterJoin(String, Object...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
public final TableOnStep<Record> fullJoin(String sql, QueryPart... parts)
Table
FULL OUTER JOIN
a table to this table.
A synonym for Table.fullOuterJoin(String, QueryPart...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
public final TableOnStep<Record> fullJoin(Name name)
Table
FULL OUTER JOIN
a table to this table.
A synonym for Table.fullOuterJoin(Name)
.
public final Table<Record> crossJoin(TableLike<?> table)
Table
CROSS JOIN
a table to this table.
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:
A cross join B
A join B on 1 = 1
public final Table<Record> crossJoin(SQL sql)
Table
CROSS JOIN
a table to this table.
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:
A cross join B
A join B on 1 = 1
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
crossJoin
in interface Table<R extends Record>
DSL.table(SQL)
,
SQL
public final Table<Record> crossJoin(String sql)
Table
CROSS JOIN
a table to this table.
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:
A cross join B
A join B on 1 = 1
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
crossJoin
in interface Table<R extends Record>
DSL.table(String)
,
SQL
public final Table<Record> crossJoin(String sql, Object... bindings)
Table
CROSS JOIN
a table to this table.
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:
A cross join B
A join B on 1 = 1
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
crossJoin
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
SQL
public final Table<Record> crossJoin(String sql, QueryPart... parts)
Table
CROSS JOIN
a table to this table.
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:
A cross join B
A join B on 1 = 1
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
crossJoin
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
SQL
public final Table<Record> crossJoin(Name name)
Table
CROSS JOIN
a table to this table.
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:
A cross join B
A join B on 1 = 1
crossJoin
in interface Table<R extends Record>
DSL.table(Name)
public final Table<Record> naturalJoin(TableLike<?> table)
Table
NATURAL JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
naturalJoin
in interface Table<R extends Record>
public final Table<Record> naturalJoin(SQL sql)
Table
NATURAL JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
naturalJoin
in interface Table<R extends Record>
DSL.table(SQL)
,
SQL
public final Table<Record> naturalJoin(String sql)
Table
NATURAL JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
naturalJoin
in interface Table<R extends Record>
DSL.table(String)
,
SQL
public final Table<Record> naturalJoin(String sql, Object... bindings)
Table
NATURAL JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
naturalJoin
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
SQL
public final Table<Record> naturalJoin(String sql, QueryPart... parts)
Table
NATURAL JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
naturalJoin
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
SQL
public final Table<Record> naturalJoin(Name name)
Table
NATURAL JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
naturalJoin
in interface Table<R extends Record>
DSL.table(Name)
public final Table<Record> naturalLeftOuterJoin(TableLike<?> table)
Table
NATURAL LEFT OUTER JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
naturalLeftOuterJoin
in interface Table<R extends Record>
public final Table<Record> naturalLeftOuterJoin(SQL sql)
Table
NATURAL LEFT OUTER JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
naturalLeftOuterJoin
in interface Table<R extends Record>
DSL.table(SQL)
,
SQL
public final Table<Record> naturalLeftOuterJoin(String sql)
Table
NATURAL LEFT OUTER JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
naturalLeftOuterJoin
in interface Table<R extends Record>
DSL.table(String)
,
SQL
public final Table<Record> naturalLeftOuterJoin(String sql, Object... bindings)
Table
NATURAL LEFT OUTER JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
naturalLeftOuterJoin
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
SQL
public final Table<Record> naturalLeftOuterJoin(String sql, QueryPart... parts)
Table
NATURAL LEFT OUTER JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
naturalLeftOuterJoin
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
SQL
public final Table<Record> naturalLeftOuterJoin(Name name)
Table
NATURAL LEFT OUTER JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
naturalLeftOuterJoin
in interface Table<R extends Record>
DSL.table(Name)
public final Table<Record> naturalRightOuterJoin(TableLike<?> table)
Table
NATURAL RIGHT OUTER JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
naturalRightOuterJoin
in interface Table<R extends Record>
public final Table<Record> naturalRightOuterJoin(SQL sql)
Table
NATURAL RIGHT OUTER JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
naturalRightOuterJoin
in interface Table<R extends Record>
DSL.table(SQL)
,
SQL
public final Table<Record> naturalRightOuterJoin(String sql)
Table
NATURAL RIGHT OUTER JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
naturalRightOuterJoin
in interface Table<R extends Record>
DSL.table(String)
,
SQL
public final Table<Record> naturalRightOuterJoin(String sql, Object... bindings)
Table
NATURAL RIGHT OUTER JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
naturalRightOuterJoin
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
SQL
public final Table<Record> naturalRightOuterJoin(String sql, QueryPart... parts)
Table
NATURAL RIGHT OUTER JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
naturalRightOuterJoin
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
SQL
public final Table<Record> naturalRightOuterJoin(Name name)
Table
NATURAL RIGHT OUTER JOIN
a table to this table.
If this is not supported by your RDBMS, then jOOQ will try to emulate this behaviour using the information provided in this query.
naturalRightOuterJoin
in interface Table<R extends Record>
DSL.table(Name)
public final Table<Record> crossApply(TableLike<?> table)
Table
CROSS APPLY
a table to this table.crossApply
in interface Table<R extends Record>
public final Table<Record> crossApply(SQL sql)
Table
CROSS APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
crossApply
in interface Table<R extends Record>
DSL.table(SQL)
,
SQL
public final Table<Record> crossApply(String sql)
Table
CROSS APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
crossApply
in interface Table<R extends Record>
DSL.table(String)
,
SQL
public final Table<Record> crossApply(String sql, Object... bindings)
Table
CROSS APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
crossApply
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
SQL
public final Table<Record> crossApply(String sql, QueryPart... parts)
Table
CROSS APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
crossApply
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
SQL
public final Table<Record> crossApply(Name name)
Table
CROSS APPLY
a table to this table.crossApply
in interface Table<R extends Record>
DSL.table(Name)
public final Table<Record> outerApply(TableLike<?> table)
Table
OUTER APPLY
a table to this table.outerApply
in interface Table<R extends Record>
public final Table<Record> outerApply(SQL sql)
Table
OUTER APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
outerApply
in interface Table<R extends Record>
DSL.table(SQL)
,
SQL
public final Table<Record> outerApply(String sql)
Table
OUTER APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
outerApply
in interface Table<R extends Record>
DSL.table(String)
,
SQL
public final Table<Record> outerApply(String sql, Object... bindings)
Table
OUTER APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
outerApply
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
SQL
public final Table<Record> outerApply(String sql, QueryPart... parts)
Table
OUTER APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
outerApply
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
SQL
public final Table<Record> outerApply(Name name)
Table
OUTER APPLY
a table to this table.outerApply
in interface Table<R extends Record>
DSL.table(Name)
public final TableOptionalOnStep<Record> straightJoin(TableLike<?> table)
Table
STRAIGHT_JOIN
a table to this table.straightJoin
in interface Table<R extends Record>
public final TableOptionalOnStep<Record> straightJoin(SQL sql)
Table
STRAIGHT_JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
straightJoin
in interface Table<R extends Record>
DSL.table(SQL)
,
SQL
public final TableOptionalOnStep<Record> straightJoin(String sql)
Table
STRAIGHT_JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
straightJoin
in interface Table<R extends Record>
DSL.table(String)
,
SQL
public final TableOptionalOnStep<Record> straightJoin(String sql, Object... bindings)
Table
STRAIGHT_JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
straightJoin
in interface Table<R extends Record>
DSL.table(String, Object...)
,
DSL.sql(String, Object...)
,
SQL
public final TableOptionalOnStep<Record> straightJoin(String sql, QueryPart... parts)
Table
STRAIGHT_JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
straightJoin
in interface Table<R extends Record>
DSL.table(String, QueryPart...)
,
DSL.sql(String, QueryPart...)
,
SQL
public final TableOptionalOnStep<Record> straightJoin(Name name)
Table
STRAIGHT_JOIN
a table to this table.straightJoin
in interface Table<R extends Record>
DSL.table(Name)
public final String getName()
Named
public final Name getQualifiedName()
Named
getQualifiedName
in interface Named
public final Name getUnqualifiedName()
Named
getUnqualifiedName
in interface Named
public final String getComment()
Named
getComment
in interface Named
public int hashCode()
QueryPart
QueryPart
.
In general, QueryPart
hash codes are the same as the hash
codes generated from QueryPart.toString()
. This guarantees consistent
behaviour with QueryPart.equals(Object)
Some QueryPart
implementations may choose to override this
behaviour for improved performance, as QueryPart.toString()
is an
expensive operation, if called many times.
@Deprecated public final void toSQL(RenderContext context)
QueryPartInternal.accept(Context)
instead.QueryPartInternal
QueryPart
to a SQL string contained in
context.sql()
. The context
will contain
additional information about how to render this QueryPart
,
e.g. whether this QueryPart
should be rendered as a
declaration or reference, whether this QueryPart
's contained
bind variables should be inlined or replaced by '?'
, etc.toSQL
in interface QueryPartInternal
@Deprecated public final void bind(BindContext context) throws DataAccessException
QueryPartInternal.accept(Context)
instead.QueryPartInternal
QueryPart
to a PreparedStatement
This method is for JOOQ INTERNAL USE only. Do not reference directly
bind
in interface QueryPartInternal
context
- The context holding the next bind index and other information
for variable bindingDataAccessException
- If something went wrong while binding a
variablepublic boolean declaresWindows()
declaresWindows
in interface QueryPartInternal
public boolean declaresCTE()
declaresCTE
in interface QueryPartInternal
public boolean generatesCast()
generatesCast
in interface QueryPartInternal
public String toString()
QueryPart
QueryPart
.
For improved debugging, this renders a SQL string of this
QueryPart
with inlined bind variables. If this
QueryPart
is Attachable
, then the attached
Configuration
may be used for rendering the SQL string, including
SQLDialect
and Settings
. Do note that most
QueryPart
instances are not attached to a
Configuration
, and thus there is no guarantee that the SQL string
will make sense in the context of a specific database.
If you wish to gain more control over the concrete SQL rendering of this
QueryPart
, use DSLContext.renderContext()
to obtain
a configurable render context for SQL rendering.
@Deprecated protected final DSLContext create()
Attachable.configuration()
and Configuration.dsl()
instead.@Deprecated protected final DSLContext create(Configuration configuration)
Attachable.configuration()
and Configuration.dsl()
instead.@Deprecated protected final DSLContext create(Context<?> ctx)
Attachable.configuration()
and Configuration.dsl()
instead.protected final DataAccessException translate(String sql, SQLException e)
Copyright © 2019. All rights reserved.