|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
R
- The record type of the tablepublic interface UpdatableTable<R extends Record>
A common interface for tables whose records can be stored back to the database again.
UpdatableRecord
Method Summary | ||
---|---|---|
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. |
|
|
getReferencesFrom(Table<O> other)
Get a list of FOREIGN KEY 's of a specific table, referencing
a this table. |
Methods inherited from interface org.jooq.NamedQueryPart |
---|
getName |
Methods inherited from interface org.jooq.QueryPart |
---|
attach |
Methods inherited from interface org.jooq.Adapter |
---|
internalAPI |
Methods inherited from interface java.lang.Comparable |
---|
compareTo |
Methods inherited from interface org.jooq.FieldProvider |
---|
getField, getField, getField, getFields, getIndex |
Methods inherited from interface org.jooq.AliasProvider |
---|
as |
Methods inherited from interface org.jooq.TableLike |
---|
asTable, asTable |
Method Detail |
---|
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 relationship
FOREIGN 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()
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |