R
- The record type of the tablepublic interface UpdatableTable<R extends Record> extends Updatable<R>, Table<R>
UpdatableRecord
Modifier and Type | Method and Description |
---|---|
List<UniqueKey<R>> |
getKeys()
Retrieve all of the table's unique keys.
|
UniqueKey<R> |
getMainKey()
Retrieve the table's main unique key.
|
TableField<R,? extends Date> |
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. |
TableField<R,? extends Number> |
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. |
<O extends Record> |
getReferencesFrom(Table<O> other)
Get a list of
FOREIGN KEY 's of a specific table, referencing
a this table. |
as, crossJoin, crossJoin, crossJoin, crossJoin, divideBy, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, getIdentity, getName, getRecordType, getReferences, getReferencesTo, getSchema, join, join, join, join, join, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, pivot, pivot, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin
internalAPI
compareTo
UniqueKey<R> getMainKey()
PRIMARY KEY
in the table, the PRIMARY KEY
is
returned. Otherwise, the most suitable UNIQUE KEY
is
returned.null
because
UpdatableTable
's always have at least one key.List<UniqueKey<R>> getKeys()
null
or empty, because
UpdatableTable
's always have at least one key. This
method returns an unmodifiable list.<O extends Record> List<ForeignKey<O,R>> getReferencesFrom(Table<O> other)
FOREIGN KEY
's of a specific table, referencing
a this table.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.TableField<R,? extends Number> 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.
null
, if this table has no
"version" field.getRecordTimestamp()
,
UpdatableRecord.store()
,
UpdatableRecord.delete()
,
Settings.isExecuteWithOptimisticLocking()
TableField<R,? extends Date> 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.
null
, if this table has no
"timestamp" field.getRecordVersion()
,
UpdatableRecord.store()
,
UpdatableRecord.delete()
,
Settings.isExecuteWithOptimisticLocking()
Copyright © 2013. All Rights Reserved.