UpdatableRecordImpl (jOOQ 3.5.0 API)

java.lang.Object
- org.jooq.impl.TableRecordImpl<R>
- - org.jooq.impl.UpdatableRecordImpl<R>

All Implemented Interfaces:

java.io.Serializable, java.lang.Comparable<Record>, Attachable, AttachableInternal, Record, TableRecord<R>, UpdatableRecord<R>
```
public class UpdatableRecordImpl<R extends UpdatableRecord<R>>
extends TableRecordImpl<R>
implements UpdatableRecord<R>
```
A record implementation for a record holding a primary key
This type is for JOOQ INTERNAL USE only. Do not reference directly

Author:

Lukas Eder

See Also:

Serialized Form

Constructor Summary

Constructors
Constructor and Description

UpdatableRecordImpl(Table<R> table)

Constructors
Constructor and Description
`UpdatableRecordImpl(Table<R> table)`

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`void`	`attach(Configuration c)` Attach this object to a new `Configuration`.
`boolean`	`changed()` Check if this record has been changed from its original as fetched from the database.
`void`	`changed(boolean c)` Set all of this record's internal changed flags to the supplied value.
`boolean`	`changed(Field<?> field)` Check if a field's value has been changed from its original as fetched from the database.
`void`	`changed(Field<?> field, boolean c)` Set this record's internal changed flag to the supplied value for a given field.
`boolean`	`changed(int fieldIndex)` Check if a field's value has been changed from its original as fetched from the database.
`void`	`changed(int fieldIndex, boolean c)` Set this record's internal changed flag to the supplied value for a given field.
`boolean`	`changed(java.lang.String fieldName)` Check if a field's value has been changed from its original as fetched from the database.
`void`	`changed(java.lang.String fieldName, boolean c)` Set this record's internal changed flag to the supplied value for a given field.
`int`	`compareTo(Record that)` Compares this `Record` with another `Record` according to their natural ordering.
`Configuration`	`configuration()` Get the underlying configuration
`R`	`copy()` Duplicate this record (in memory) and reset all fields from the primary key or main unique key, such that a subsequent call to `UpdatableRecord.store()` will result in an `INSERT` statement.
`protected DSLContext`	`create()` This method is used in generated code!
`int`	`delete()` Deletes this record from the database, based on the value of the primary key or main unique key.
`void`	`detach()` Detach this object from its current `Configuration`.
`boolean`	`equals(java.lang.Object obj)`
`<O extends TableRecord<O>> O`	`fetchChild(ForeignKey<O,R> key)` Fetch a child record of this record, given a foreign key This returns a child record referencing this record through a given foreign key.
`<O extends TableRecord<O>> Result<O>`	`fetchChildren(ForeignKey<O,R> key)` Fetch child records of this record, given a foreign key This returns childs record referencing this record through a given foreign key.
`<T> Field<T>`	`field(Field<T> field)` Get a specific field from this Record.
`Field<?>`	`field(int index)` Get a specific field from this Record.
`Field<?>`	`field(java.lang.String name)` Get a specific field from this Record.
`Field<?>[]`	`fields()` Get all fields from this Record.
`Field<?>[]`	`fields(Field<?>... f)` Get all fields from this Record, providing some fields.
`Field<?>[]`	`fields(int... fieldIndexes)` Get all fields from this Record, providing some field indexes.
`Field<?>[]`	`fields(java.lang.String... fieldNames)` Get all fields from this Record, providing some field names.
`void`	`from(java.lang.Object source)` Load data into this record from a source.
`void`	`from(java.lang.Object source, Field<?>... f)` Load data into this record from a source, providing some fields.
`void`	`from(java.lang.Object source, int... fieldIndexes)` Load data into this record from a source, providing some field indexes.
`void`	`from(java.lang.Object source, java.lang.String... fieldNames)` Load data into this record from a source, providing some field names.
`protected void`	`from(Record source)` This method was implemented with [#799].
`void`	`fromArray(java.lang.Object... array)` Load data from an array into this record.
`void`	`fromArray(java.lang.Object[] array, Field<?>... f)` Load data from an array into this record, providing some fields.
`void`	`fromArray(java.lang.Object[] array, int... fieldIndexes)` Load data from an array into this record, providing some fields indexes.
`void`	`fromArray(java.lang.Object[] array, java.lang.String... fieldNames)` Load data from an array into this record, providing some fields names.
`void`	`fromMap(java.util.Map<java.lang.String,?> map)` Load data from a map into this record.
`void`	`fromMap(java.util.Map<java.lang.String,?> map, Field<?>... f)` Load data from a map into this record, providing some fields.
`void`	`fromMap(java.util.Map<java.lang.String,?> map, int... fieldIndexes)` Load data from a map into this record, providing some field indexes.
`void`	`fromMap(java.util.Map<java.lang.String,?> map, java.lang.String... fieldNames)` Load data from a map into this record, providing some field names.
`<T> T`	`getValue(Field<?> field, java.lang.Class<? extends T> type)` Get a converted value from this Record, providing a field.
`<T> T`	`getValue(Field<?> field, java.lang.Class<? extends T> type, T defaultValue)` Deprecated.
`<T> T`	`getValue(Field<T> field)` Get a value from this Record, providing a field.
`<T,U> U`	`getValue(Field<T> field, Converter<? super T,U> converter)` Get a converted value from this Record, providing a field.
`<T,U> U`	`getValue(Field<T> field, Converter<? super T,U> converter, U defaultValue)` Deprecated.
`<T> T`	`getValue(Field<T> field, T defaultValue)` Deprecated.
`java.lang.Object`	`getValue(int index)` This method coincides with `Record.getValue(int)` and `ArrayRecordImpl.getValue(int)`
`<T> T`	`getValue(int index, java.lang.Class<? extends T> type)` Get a converted value from this record, providing a field index.
`<T> T`	`getValue(int index, java.lang.Class<? extends T> type, T defaultValue)` Deprecated.
`<U> U`	`getValue(int index, Converter<?,U> converter)` Get a converted value from this record, providing a field index.
`<U> U`	`getValue(int index, Converter<?,U> converter, U defaultValue)` Deprecated.
`java.lang.Object`	`getValue(int index, java.lang.Object defaultValue)` Deprecated.
`java.lang.Object`	`getValue(java.lang.String fieldName)` Get a value from this Record, providing a field name.
`<T> T`	`getValue(java.lang.String fieldName, java.lang.Class<? extends T> type)` Get a converted value from this Record, providing a field name.
`<T> T`	`getValue(java.lang.String fieldName, java.lang.Class<? extends T> type, T defaultValue)` Deprecated.
`<U> U`	`getValue(java.lang.String fieldName, Converter<?,U> converter)` Get a converted value from this Record, providing a field name.
`<U> U`	`getValue(java.lang.String fieldName, Converter<?,U> converter, U defaultValue)` Deprecated.
`java.lang.Object`	`getValue(java.lang.String fieldName, java.lang.Object defaultValue)` Deprecated.
`int`	`hashCode()`
`<E> E`	`into(java.lang.Class<? extends E> type)` Map resulting records onto a custom type.
`<E> E`	`into(E object)` Map resulting records onto a custom type.
`Record`	`into(Field<?>... f)` Copy this record into a new record holding only a subset of the previous fields.
`<T1> Record1<T1>`	`into(Field<T1> field1)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2> Record2<T1,T2>`	`into(Field<T1> field1, Field<T2> field2)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3> Record3<T1,T2,T3>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4> Record4<T1,T2,T3,T4>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5> Record5<T1,T2,T3,T4,T5>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6> Record6<T1,T2,T3,T4,T5,T6>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7> Record7<T1,T2,T3,T4,T5,T6,T7>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8> Record8<T1,T2,T3,T4,T5,T6,T7,T8>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9> Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)` Copy this record into a new record holding only a subset of the previous fields.
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>`	`into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)` Copy this record into a new record holding only a subset of the previous fields.
`<R extends Record> R`	`into(Table<R> table)` Map resulting records onto a custom record type.
`java.lang.Object[]`	`intoArray()` Convert this record into an array.
`java.util.List<java.lang.Object>`	`intoList()` Convert this record into a list.
`java.util.Map<java.lang.String,java.lang.Object>`	`intoMap()` Return this record as a name/value map.
`java.sql.ResultSet`	`intoResultSet()` Generate an in-memory JDBC `ResultSet` containing the data of this `Record`.
`Record`	`key()` A Record copy holding values for the `Table.getPrimaryKey()`.
`<E> E`	`map(RecordMapper<Record,E> mapper)` Map this record into a custom mapper callback.
`<T> T`	`original(Field<T> field)` Get an original value from this record as fetched from the database.
`java.lang.Object`	`original(int fieldIndex)` Get an original value from this record as fetched from the database.
`java.lang.Object`	`original(java.lang.String fieldName)` Get an original value from this record as fetched from the database.
`void`	`refresh()` Refresh this record from the database.
`void`	`refresh(Field<?>... refreshFields)` Refresh parts of this record from the database.
`void`	`reset()` Reset all values to their `Record.original()` values and all `Record.changed()` flags to `false`.
`void`	`reset(Field<?> field)` Reset a given value to its `Record.original(Field)` value and its `Record.changed(Field)` flag to `false`.
`void`	`reset(int fieldIndex)` Reset a given value to its `Record.original(int)` value and its `Record.changed(int)` flag to `false`.
`void`	`reset(java.lang.String fieldName)` Reset a given value to its `Record.original(String)` value and its `Record.changed(String)` flag to `false`.
`<T> void`	`setValue(Field<T> field, T value)` Set a value into this record.
`<T,U> void`	`setValue(Field<T> field, U value, Converter<T,? super U> converter)` Set a value into this record.
`protected void`	`setValue(int index, java.lang.Object value)` Subclasses may type-unsafely set a value to a record index.
`int`	`size()` This method coincides with `Record.size()` and `ArrayRecord.size()`
`int`	`store()` Store this record back to the database.
`int`	`store(Field<?>... storeFields)` Store parts of this record to the database.
`java.lang.String`	`toString()`
`int`	`update()` Store this record back to the database using an `UPDATE` statement.
`int`	`update(Field<?>... storeFields)` Store parts of this record to the database using an `UPDATE` statement.

Methods inherited from class org.jooq.impl.TableRecordImpl
fetchParent, fieldsRow, getTable, insert, insert, original, valuesRow

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.jooq.UpdatableRecord
insert, insert

Methods inherited from interface org.jooq.TableRecord
fetchParent, getTable, original

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

Constructor Detail

UpdatableRecordImpl

public UpdatableRecordImpl(Table<R> table)

Method Detail

key
```
public Record key()
```
Description copied from interface: UpdatableRecord

A Record copy holding values for the Table.getPrimaryKey().
The returned record consists exactly of those fields as returned by the table's primary key: Key.getFields().
Generated subtypes may covariantly override this method to add more record type information. For instance, they may return Record1, Record2, ...

Specified by:

key in interface UpdatableRecord<R extends UpdatableRecord<R>>

fetchChild
```
public final <O extends TableRecord<O>> O fetchChild(ForeignKey<O,R> key)
```
Description copied from interface: UpdatableRecord

Fetch a child record of this record, given a foreign key
This returns a child record referencing this record through a given foreign key. If no child record was found, this returns null

Specified by:

fetchChild in interface UpdatableRecord<R extends UpdatableRecord<R>>

See Also:

ForeignKey.fetchChildren(java.util.Collection), ForeignKey.fetchChildren(Record), ForeignKey.fetchChildren(Record...)

fetchChildren
```
public final <O extends TableRecord<O>> Result<O> fetchChildren(ForeignKey<O,R> key)
```
Description copied from interface: UpdatableRecord

Fetch child records of this record, given a foreign key
This returns childs record referencing this record through a given foreign key.

Specified by:

fetchChildren in interface UpdatableRecord<R extends UpdatableRecord<R>>

See Also:

ForeignKey.fetchChildren(java.util.Collection), ForeignKey.fetchChildren(Record), ForeignKey.fetchChildren(Record...)

store
```
public final int store()
```
Description copied from interface: UpdatableRecord
Store this record back to the database.
Depending on the state of the primary key's value, an UpdatableRecord.insert() or an UpdatableRecord.update() statement is executed.

Statement type
- If this record was created by client code, an INSERT statement is executed
- If this record was loaded by jOOQ and the primary key value was changed, an INSERT statement is executed (unless Settings.isUpdatablePrimaryKeys() is set). jOOQ expects that primary key values will never change due to the principle of normalisation in RDBMS. So if client code changes primary key values, this is interpreted by jOOQ as client code wanting to duplicate this record.
- If this record was loaded by jOOQ, and the primary key value was not changed, an UPDATE statement is executed.
In either statement type, only those fields are inserted/updated, which had been explicitly set by client code, in order to allow for DEFAULT values to be applied by the underlying RDBMS. If no fields were modified, neither an UPDATE nor an INSERT will be executed.

Automatic value generation

Use UpdatableRecord.insert() or UpdatableRecord.update() to explicitly force either statement type.
- IDENTITY columns
  If there is an IDENTITY column defined on the record's underlying table (see Table.getIdentity()), then the auto-generated IDENTITY value is refreshed automatically on INSERT's. Refreshing is done using Statement.getGeneratedKeys(), where this is supported by the JDBC driver. See also InsertQuery.getReturnedRecord() for more details
- VERSION and TIMESTAMP columns
  jOOQ can auto-generate "version" and "timestamp" values that can be used for optimistic locking. If this is an UpdatableRecord and if this record returns fields for either Table.getRecordVersion() or Table.getRecordTimestamp(), then these values are set onto the INSERT or UPDATE statement being executed. On execution success, the generated values are set to this record. Use the code-generation configuration to specify naming patterns for auto-generated "version" and "timestamp" columns.
  Should you want to circumvent jOOQ-generated updates to these columns, you can render an INSERT or UPDATE statement manually using the various DSLContext.insertInto(Table), DSLContext.update(Table) methods.
Optimistic locking

If an UPDATE statement is executed and Settings.isExecuteWithOptimisticLocking() is set to true, then this record will first be compared with the latest state in the database. There are two modes of operation for optimistic locking:
- With VERSION and/or TIMESTAMP columns configured
  This is the preferred way of using optimistic locking in jOOQ. If this is an UpdatableRecord and if this record returns fields for either Table.getRecordVersion() or Table.getRecordTimestamp(), then these values are compared to the corresponding value in the database in the WHERE clause of the executed DELETE statement.
- Without any specific column configurations
  In order to compare this record with the latest state, the database record will be locked pessimistically using a SELECT .. FOR UPDATE statement. Not all databases support the FOR UPDATE clause natively. Namely, the following databases will show slightly different behaviour:
  - SQLDialect.CUBRID and SQLDialect.SQLSERVER: jOOQ will try to lock the database record using JDBC's ResultSet.TYPE_SCROLL_SENSITIVE and ResultSet.CONCUR_UPDATABLE.
  - SQLDialect.SQLITE: No pessimistic locking is possible. Client code must assure that no race-conditions can occur between jOOQ's checking of database record state and the actual UPDATE
  See SelectQuery.setForUpdate(boolean) for more details
Statement examples

Possible statements are
- INSERT INTO [table] ([modified fields, including keys]) VALUES ([modified values, including keys])
- UPDATE [table] SET [modified fields = modified values, excluding keys] WHERE [key fields = key values] AND [version/timestamp fields = version/timestamp values]
Statement execution enforcement

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 storing.
This is the same as calling record.store(record.fields())
Specified by:

store in interface UpdatableRecord<R extends UpdatableRecord<R>>

Returns:

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

See Also:

UpdatableRecord.insert(), UpdatableRecord.update()

store
```
public final int store(Field<?>... storeFields)
                throws DataAccessException,
                       DataChangedException
```
Description copied from interface: UpdatableRecord

Store parts of this record to the database.

Specified by:

store in interface UpdatableRecord<R extends UpdatableRecord<R>>

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

DataChangedException - If optimistic locking is enabled and the record has already been changed/deleted in the database

See Also:

UpdatableRecord.store(), UpdatableRecord.insert(Field...), UpdatableRecord.update(Field...)

update
```
public final int update()
```
Description copied from interface: UpdatableRecord

Store this record back to the database using an UPDATE statement.
This is the same as UpdatableRecord.store(), except that an UPDATE statement (or no statement) will always be executed.
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 updating.
This is the same as calling record.update(record.fields())

Specified by:

update in interface UpdatableRecord<R extends UpdatableRecord<R>>

Returns:

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

See Also:

UpdatableRecord.store()

update
```
public int update(Field<?>... storeFields)
           throws DataAccessException,
                  DataChangedException
```
Description copied from interface: UpdatableRecord

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

Specified by:

update in interface UpdatableRecord<R extends UpdatableRecord<R>>

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

DataChangedException - If optimistic locking is enabled and the record has already been changed/deleted in the database

See Also:

UpdatableRecord.update()

delete
```
public final int delete()
```
Description copied from interface: UpdatableRecord
Deletes this record from the database, based on the value of the primary key or main unique key.

Optimistic locking

If a DELETE statement is executed and Settings.isExecuteWithOptimisticLocking() is set to true, then this record will first be compared with the latest state in the database. There are two modes of operation for optimistic locking:
- With VERSION and/or TIMESTAMP columns configured
  This is the preferred way of using optimistic locking in jOOQ. If this is an UpdatableRecord and if this record returns fields for either Table.getRecordVersion() or Table.getRecordTimestamp(), then these values are compared to the corresponding value in the database in the WHERE clause of the executed DELETE statement.
- Without any specific column configurations
  In order to compare this record with the latest state, the database record will be locked pessimistically using a SELECT .. FOR UPDATE statement. Not all databases support the FOR UPDATE clause natively. Namely, the following databases will show slightly different behaviour:
  - SQLDialect.CUBRID and SQLDialect.SQLSERVER: jOOQ will try to lock the database record using JDBC's ResultSet.TYPE_SCROLL_SENSITIVE and ResultSet.CONCUR_UPDATABLE.
  - SQLDialect.SQLITE: No pessimistic locking is possible. Client code must assure that no race-conditions can occur between jOOQ's checking of database record state and the actual DELETE
  See SelectQuery.setForUpdate(boolean) for more details
Statement examples

The executed statement is
```
 DELETE FROM [table]
 WHERE [key fields = key values]
 AND [version/timestamp fields = version/timestamp values]
```
This is in fact the same as calling delete(getTable().getPrimaryKey().getFieldsArray())
Specified by:

delete in interface UpdatableRecord<R extends UpdatableRecord<R>>

Returns:

1 if the record was deleted from the database. 0 if deletion was not necessary.

refresh
```
public final void refresh()
```
Description copied from interface: UpdatableRecord
Refresh this record from the database.
A successful refresh results in the following:
- Record.valuesRow() will have been restored to the respective values from the database
- TableRecord.original() will match this record
- Record.changed() will be false
Refreshing can trigger any of the following actions:
- Executing a new SELECT statement, if this is an UpdatableRecord.
- Failing, otherwise
This is the same as calling record.refresh(record.fields())
Specified by:

refresh in interface UpdatableRecord<R extends UpdatableRecord<R>>

refresh
```
public final void refresh(Field<?>... refreshFields)
```
Description copied from interface: UpdatableRecord
Refresh parts of this record from the database.
A successful refresh results in the following:
- Record.valuesRow() will have been restored to the respective values from the database
- TableRecord.original() will match this record
- Record.changed() will be false
Refreshing can trigger any of the following actions:
- Executing a new SELECT statement, if this is an UpdatableRecord.
- Failing, otherwise
This is the same as calling record.refresh(record.fields())
Specified by:

refresh in interface UpdatableRecord<R extends UpdatableRecord<R>>

copy
```
public final R copy()
```
Description copied from interface: UpdatableRecord

Duplicate this record (in memory) and reset all fields from the primary key or main unique key, such that a subsequent call to UpdatableRecord.store() will result in an INSERT statement.

Specified by:

copy in interface UpdatableRecord<R extends UpdatableRecord<R>>

Returns:

A new record, distinct from this record.

field
```
public final <T> Field<T> field(Field<T> field)
```
Description copied from interface: Record

Get a specific field from this Record.

Specified by:

field in interface Record

See Also:

Row.field(Field)

field
```
public final Field<?> field(java.lang.String name)
```
Description copied from interface: Record

Get a specific field from this Record.

Specified by:

field in interface Record

See Also:

Row.field(String)

field
```
public final Field<?> field(int index)
```
Description copied from interface: Record

Get a specific field from this Record.

Specified by:

field in interface Record

See Also:

Row.field(int)

fields
```
public final Field<?>[] fields()
```
Description copied from interface: Record

Get all fields from this Record.

Specified by:

fields in interface Record

See Also:

Row.fields()

fields
```
public final Field<?>[] fields(Field<?>... f)
```
Description copied from interface: Record

Get all fields from this Record, providing some fields.

Specified by:

fields in interface Record

Returns:

All available fields

See Also:

Row.fields(Field...)

fields
```
public final Field<?>[] fields(java.lang.String... fieldNames)
```
Description copied from interface: Record

Get all fields from this Record, providing some field names.

Specified by:

fields in interface Record

Returns:

All available fields

See Also:

Row.fields(String...)

fields
```
public final Field<?>[] fields(int... fieldIndexes)
```
Description copied from interface: Record

Get all fields from this Record, providing some field indexes.

Specified by:

fields in interface Record

Returns:

All available fields

See Also:

Row.fields(int...)

size
```
public final int size()
```
This method coincides with Record.size() and ArrayRecord.size()

Specified by:

size in interface Record

getValue
```
public final <T> T getValue(Field<T> field)
```
Description copied from interface: Record

Get a value from this Record, providing a field.

Specified by:

getValue in interface Record

Type Parameters:

T - The generic field parameter

Parameters:

field - The field

Returns:

The value of a field contained in this record

getValue
```
@Deprecated
public final <T> T getValue(Field<T> field,
                                         T defaultValue)
```
Deprecated.

Description copied from interface: Record

Get a value from this record, providing a field.

Specified by:

getValue in interface Record

Type Parameters:

T - The generic field parameter

Parameters:

field - The field

defaultValue - The default value instead of null

Returns:

The value of a field contained in this record, or defaultValue, if null

getValue
```
public final <T> T getValue(Field<?> field,
                            java.lang.Class<? extends T> type)
```
Description copied from interface: Record

Get a converted value from this Record, providing a field.

Specified by:

getValue in interface Record

Type Parameters:

T - The conversion type parameter

Parameters:

field - The field

type - The conversion type

Returns:

The value of a field contained in this record

See Also:

Convert.convert(Object, Class)

getValue
```
@Deprecated
public final <T> T getValue(Field<?> field,
                                         java.lang.Class<? extends T> type,
                                         T defaultValue)
```
Deprecated.

Description copied from interface: Record

Get a converted value from this record, providing a field.

Specified by:

getValue in interface Record

Type Parameters:

T - The conversion type parameter

Parameters:

field - The field

type - The conversion type

defaultValue - The default value instead of null

Returns:

The value of a field contained in this record, or defaultValue, if null

See Also:

Convert.convert(Object, Class)

getValue
```
public final <T,U> U getValue(Field<T> field,
                              Converter<? super T,U> converter)
```
Description copied from interface: Record

Get a converted value from this Record, providing a field.

Specified by:

getValue in interface Record

Type Parameters:

T - The database type parameter

U - The conversion type parameter

Parameters:

field - The field

converter - The data type converter

Returns:

The value of a field contained in this record

See Also:

Convert.convert(Object, Converter)

getValue
```
@Deprecated
public final <T,U> U getValue(Field<T> field,
                                           Converter<? super T,U> converter,
                                           U defaultValue)
```
Deprecated.

Description copied from interface: Record

Get a converted value from this record, providing a field.

Specified by:

getValue in interface Record

Type Parameters:

T - The database type parameter

U - The conversion type parameter

Parameters:

field - The field

converter - The data type converter

defaultValue - The default value instead of null

Returns:

The value of a field contained in this record, or defaultValue, if null

See Also:

Convert.convert(Object, Converter)

getValue
```
public final java.lang.Object getValue(int index)
```
This method coincides with Record.getValue(int) and ArrayRecordImpl.getValue(int)

Specified by:

getValue in interface Record

Parameters:

index - The field's index

Returns:

The value of a field's index contained in this record

getValue
```
@Deprecated
public final java.lang.Object getValue(int index,
                                                    java.lang.Object defaultValue)
```
Deprecated.

Description copied from interface: Record

Get a value from this record, providing a field index.

Specified by:

getValue in interface Record

Parameters:

index - The field's index

defaultValue - The default value instead of null

Returns:

The value of a field's index contained in this record, or defaultValue, if null

getValue
```
public final <T> T getValue(int index,
                            java.lang.Class<? extends T> type)
```
Description copied from interface: Record

Get a converted value from this record, providing a field index.

Specified by:

getValue in interface Record

Type Parameters:

T - The conversion type parameter

Parameters:

index - The field's index

type - The conversion type

Returns:

The value of a field's index contained in this record

See Also:

Convert.convert(Object, Class)

getValue
```
@Deprecated
public final <T> T getValue(int index,
                                         java.lang.Class<? extends T> type,
                                         T defaultValue)
```
Deprecated.

Description copied from interface: Record

Get a converted value from this record, providing a field index.

Specified by:

getValue in interface Record

Type Parameters:

T - The conversion type parameter

Parameters:

index - The field's index

type - The conversion type

defaultValue - The default value instead of null

Returns:

The value of a field's index contained in this record, or defaultValue, if null

See Also:

Convert.convert(Object, Class)

getValue
```
public final <U> U getValue(int index,
                            Converter<?,U> converter)
```
Description copied from interface: Record

Get a converted value from this record, providing a field index.

Specified by:

getValue in interface Record

Type Parameters:

U - The conversion type parameter

Parameters:

index - The field's index

converter - The data type converter

Returns:

The value of a field's index contained in this record

See Also:

Convert.convert(Object, Converter)

getValue
```
@Deprecated
public final <U> U getValue(int index,
                                         Converter<?,U> converter,
                                         U defaultValue)
```
Deprecated.

Description copied from interface: Record

Get a converted value from this record, providing a field index.

Specified by:

getValue in interface Record

Type Parameters:

U - The conversion type parameter

Parameters:

index - The field's index

converter - The data type converter

defaultValue - The default value instead of null

Returns:

The value of a field's index contained in this record, or defaultValue, if null

See Also:

Convert.convert(Object, Converter)

getValue
```
public final java.lang.Object getValue(java.lang.String fieldName)
```
Description copied from interface: Record

Get a value from this Record, providing a field name.

Specified by:

getValue in interface Record

Parameters:

fieldName - The field's name

Returns:

The value of a field's name contained in this record

getValue
```
@Deprecated
public final java.lang.Object getValue(java.lang.String fieldName,
                                                    java.lang.Object defaultValue)
```
Deprecated.

Description copied from interface: Record

Get a value from this record, providing a field name.

Specified by:

getValue in interface Record

Parameters:

fieldName - The field's name

defaultValue - The default value instead of null

Returns:

The value of a field's name contained in this record, or defaultValue, if null

getValue
```
public final <T> T getValue(java.lang.String fieldName,
                            java.lang.Class<? extends T> type)
```
Description copied from interface: Record

Get a converted value from this Record, providing a field name.

Specified by:

getValue in interface Record

Type Parameters:

T - The conversion type parameter

Parameters:

fieldName - The field's name

type - The conversion type

Returns:

The value of a field's name contained in this record

See Also:

Convert.convert(Object, Class)

getValue
```
@Deprecated
public final <T> T getValue(java.lang.String fieldName,
                                         java.lang.Class<? extends T> type,
                                         T defaultValue)
```
Deprecated.

Description copied from interface: Record

Get a converted value from this record, providing a field name.

Specified by:

getValue in interface Record

Type Parameters:

T - The conversion type parameter

Parameters:

fieldName - The field's name

type - The conversion type

defaultValue - The default value instead of null

Returns:

The value of a field's name contained in this record, or defaultValue, if null

See Also:

Convert.convert(Object, Class)

getValue
```
public final <U> U getValue(java.lang.String fieldName,
                            Converter<?,U> converter)
```
Description copied from interface: Record

Get a converted value from this Record, providing a field name.

Specified by:

getValue in interface Record

Type Parameters:

U - The conversion type parameter

Parameters:

fieldName - The field's name

converter - The data type converter

Returns:

The value of a field's name contained in this record

See Also:

Convert.convert(Object, Converter)

getValue
```
@Deprecated
public final <U> U getValue(java.lang.String fieldName,
                                         Converter<?,U> converter,
                                         U defaultValue)
```
Deprecated.

Description copied from interface: Record

Get a converted value from this record, providing a field name.

Specified by:

getValue in interface Record

Type Parameters:

U - The conversion type parameter

Parameters:

fieldName - The field's name

converter - The data type converter

defaultValue - The default value instead of null

Returns:

The value of a field's name contained in this record, or defaultValue, if null

See Also:

Convert.convert(Object, Converter)

setValue
```
protected final void setValue(int index,
                              java.lang.Object value)
```
Subclasses may type-unsafely set a value to a record index. This method takes care of converting the value to the appropriate type.

setValue
```
public final <T> void setValue(Field<T> field,
                               T value)
```
Description copied from interface: Record

Set a value into this record.
This will always set the Record.changed(Field) flag for the given field, no matter if setting the value actually changes the value.
Changing Table.getPrimaryKey() values will set all Record.changed() flags to true, in order to produce complete INSERT statements on subsequent UpdatableRecord.store() operations.

Specified by:

setValue in interface Record

Type Parameters:

T - The generic field parameter

Parameters:

field - The field

value - The value

setValue
```
public final <T,U> void setValue(Field<T> field,
                                 U value,
                                 Converter<T,? super U> converter)
```
Description copied from interface: Record

Set a value into this record.
This will always set the Record.changed(Field) flag for the given field, no matter if setting the value actually changes the value.
Changing Table.getPrimaryKey() values will set all Record.changed() flags to true, in order to produce complete INSERT statements on subsequent UpdatableRecord.store() operations.

Specified by:

setValue in interface Record

Type Parameters:

T - The generic field parameter

U - The conversion type parameter

Parameters:

field - The field

value - The value

converter - The converter used to convert value into an appropriate type

original
```
public final <T> T original(Field<T> field)
```
Description copied from interface: Record

Get an original value from this record 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 such an original value for a field.

Specified by:

original in interface Record

See Also:

Record.original()

original
```
public final java.lang.Object original(int fieldIndex)
```
Description copied from interface: Record

Get an original value from this record 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 such an original value for a field.

Specified by:

original in interface Record

See Also:

Record.original()

original
```
public final java.lang.Object original(java.lang.String fieldName)
```
Description copied from interface: Record

Get an original value from this record 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 such an original value for a field.

Specified by:

original in interface Record

See Also:

Record.original()

changed
```
public final boolean changed()
```
Description copied from interface: Record

Check if this record has been changed from its original as fetched from the database.
If this returns false, then it can be said that record.equals(record.original()) is true.

Specified by:

changed in interface Record

See Also:

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

changed
```
public final boolean changed(Field<?> field)
```
Description copied from interface: Record

Check if a field's value has been changed from its original as fetched from the database.

Specified by:

changed in interface Record

See Also:

Record.changed(), Record.original(Field)

changed
```
public final boolean changed(int fieldIndex)
```
Description copied from interface: Record

Check if a field's value has been changed from its original as fetched from the database.

Specified by:

changed in interface Record

See Also:

Record.changed(), Record.original(int)

changed
```
public final boolean changed(java.lang.String fieldName)
```
Description copied from interface: Record

Check if a field's value has been changed from its original as fetched from the database.

Specified by:

changed in interface Record

See Also:

Record.changed(), Record.original(String)

changed
```
public final void changed(boolean c)
```
Description copied from interface: Record

Set all of this record's internal changed flags to the supplied value.
If the changed argument is false, the Record.original() values will be reset to the corresponding "current" values as well

Specified by:

changed in interface Record

See Also:

Record.changed(), Record.changed(Field, boolean), Record.changed(int, boolean), Record.changed(String, boolean)

changed
```
public final void changed(Field<?> field,
                          boolean c)
```
Description copied from interface: Record

Set this record's internal changed flag to the supplied value for a given field.
If the changed argument is false, the Record.original(Field) value will be reset to the corresponding "current" value as well

Specified by:

changed in interface Record

See Also:

Record.changed(), Record.changed(Field)

changed
```
public final void changed(int fieldIndex,
                          boolean c)
```
Description copied from interface: Record

Set this record's internal changed flag to the supplied value for a given field.
If the changed argument is false, the Record.original(int) value will be reset to the corresponding "current" value as well

Specified by:

changed in interface Record

See Also:

Record.changed(), Record.changed(int)

changed
```
public final void changed(java.lang.String fieldName,
                          boolean c)
```
Description copied from interface: Record

Set this record's internal changed flag to the supplied value for a given field.
If the changed argument is false, the Record.original(String) value will be reset to the corresponding "current" value as well

Specified by:

changed in interface Record

See Also:

Record.changed(), Record.changed(String)

reset
```
public final void reset()
```
Description copied from interface: Record

Reset all values to their Record.original() values and all Record.changed() flags to false.

Specified by:

reset in interface Record

reset
```
public final void reset(Field<?> field)
```
Description copied from interface: Record

Reset a given value to its Record.original(Field) value and its Record.changed(Field) flag to false.

Specified by:

reset in interface Record

reset
```
public final void reset(int fieldIndex)
```
Description copied from interface: Record

Reset a given value to its Record.original(int) value and its Record.changed(int) flag to false.

Specified by:

reset in interface Record

reset
```
public final void reset(java.lang.String fieldName)
```
Description copied from interface: Record

Reset a given value to its Record.original(String) value and its Record.changed(String) flag to false.

Specified by:

reset in interface Record

intoArray
```
public final java.lang.Object[] intoArray()
```
Description copied from interface: Record
Convert this record into an array.
The resulting array has the same number of elements as this record has fields. The resulting array contains data as such:
```
 // For arbitrary values of i
 record.getValue(i) == record.intoArray()[i]
 
```
This is the same as calling into(Object[].class)
Specified by:

intoArray in interface Record

Returns:

This record as an array

See Also:

Record.fromArray(Object...)

intoList
```
public final java.util.List<java.lang.Object> intoList()
```
Description copied from interface: Record
Convert this record into a list.
The resulting list has the same number of elements as this record has fields. The resulting array contains data as such:
```
 // For arbitrary values of i
 record.getValue(i) == record.intoList().get(i)
 
```
This is the same as calling Arrays.asList(intoArray())
Specified by:

intoList in interface Record

intoMap
```
public final java.util.Map<java.lang.String,java.lang.Object> intoMap()
```
Description copied from interface: Record

Return this record as a name/value map.
This is the inverse operation to Record.fromMap(Map)

Specified by:

intoMap in interface Record

Returns:

This record as a map

See Also:

Record.fromMap(Map)

into
```
public final Record into(Field<?>... f)
```
Description copied from interface: Record

Copy this record into a new record holding only a subset of the previous fields.

Specified by:

into in interface Record

Parameters:

f - The fields of the new record

Returns:

The new record

into
```
public final <T1> Record1<T1> into(Field<T1> field1)
```
Description copied from interface: Record

Copy this record into a new record holding only a subset of the previous fields.

Specified by:

into in interface Record

Returns:

The new record

See Also:

#into(Record)

into
```
public final <T1,T2> Record2<T1,T2> into(Field<T1> field1,
                                         Field<T2> field2)
```
Description copied from interface: Record

Copy this record into a new record holding only a subset of the previous fields.

Specified by:

into in interface Record

Returns:

The new record

See Also:

#into(Record)