org.jooq

Interface TableRecord<R extends TableRecord<R>>

Type Parameters:

R - The record type

All Superinterfaces:

Attachable, java.lang.Comparable<Record>, Record, java.io.Serializable

All Known Subinterfaces:

UpdatableRecord<R>

All Known Implementing Classes:

CustomRecord, TableRecordImpl, UpdatableRecordImpl

public interface TableRecord<R extends TableRecord<R>>
extends Record

A record originating from a single table

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
<O extends UpdatableRecord<O>> O	fetchParent(ForeignKey<R,O> key) Fetch a parent record of this record, given a foreign key This returns a parent record referenced by this record through a given foreign key.
Table<R>	getTable() The table from which this record was read
int	insert() Store this record to the database using an INSERT statement.
int	insert(Field<?>... fields) Store parts of this record to the database using an INSERT statement.
R	original() Get this record containing the original values as fetched from the database.

Methods inherited from interface org.jooq.Record

changed, changed, changed, changed, changed, changed, changed, changed, compareTo, equals, field, field, field, fields, fields, fields, fields, fieldsRow, from, from, from, from, fromArray, fromArray, fromArray, fromArray, fromMap, fromMap, fromMap, fromMap, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, getValue, hashCode, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, into, intoArray, intoList, intoMap, intoResultSet, map, original, original, original, reset, reset, reset, reset, setValue, setValue, size, valuesRow

Methods inherited from interface org.jooq.Attachable

attach, detach

Method Detail

getTable

Table<R> getTable()

The table from which this record was read

original

R original()

Get this record containing the original values as fetched from the database.

Record values can be freely modified after having fetched a record from the database. Every record also references the originally fetched values. This method returns a new record containing those original values.

Specified by:

original in interface Record

See Also:

Record.original(Field), Record.original(int), Record.original(String)

insert

int insert()
    throws DataAccessException

Store this record to the database using an INSERT statement.

If you want to enforce statement execution, regardless if the values in this record were changed, you can explicitly set the changed flags for all values with Record.changed(boolean) or for single values with Record.changed(Field, boolean), prior to insertion.

Returns:

1 if the record was stored to the database. 0 if storing was not necessary.

Throws:

DataAccessException - if something went wrong executing the query

insert

int insert(Field<?>... fields)
    throws DataAccessException

Store parts of this record to the database using an INSERT statement.

Returns:

1 if the record was stored to the database. 0 if storing was not necessary.

Throws:

DataAccessException - if something went wrong executing the query

See Also:

insert()

fetchParent

<O extends UpdatableRecord<O>> O fetchParent(ForeignKey<R,O> key)
                                      throws DataAccessException

Fetch a parent record of this record, given a foreign key

This returns a parent record referenced by this record through a given foreign key. If no parent record was found, this returns null

Throws:

DataAccessException - if something went wrong executing the query

See Also:

ForeignKey.fetchParent(Record), ForeignKey.fetchParents(java.util.Collection), ForeignKey.fetchParents(Record...)