Module org.jooq

Package org.jooq

Interface ForeignKey<R extends Record,O extends Record>

Type Parameters:

R - The FOREIGN KEY's owner table record

O - The referenced KEY's owner table record

All Superinterfaces:

Key<R>, Named, QueryPart, Serializable

public interface ForeignKey<R extends Record,O extends Record>
extends Key<R>

A ForeignKey is an object referencing a UniqueKey. It represents a FOREIGN KEY relationship between two tables.

Instances of this type cannot be created directly. They are available from generated code.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull Table<R>	children(Collection<? extends O> records)	Get a table expression representing the children of a record, given this foreign key.
@NotNull Table<R>	children(O record)	Get a table expression representing the children of a record, given this foreign key.
@NotNull Table<R>	children(O... records)	Get a table expression representing the children of a record, given this foreign key.
@NotNull Result<R>	fetchChildren(Collection<? extends O> records)	Fetch child records of a given set of records through this foreign key
@NotNull Result<R>	fetchChildren(O record)	Fetch child records of a given record through this foreign key
@NotNull Result<R>	fetchChildren(O... records)	Fetch child records of a given set of records through this foreign key
O	fetchParent(R record)	Fetch a parent record of a given record through this foreign key
@NotNull Result<O>	fetchParents(Collection<? extends R> records)	Fetch parent records of a given set of record through this foreign key
@NotNull Result<O>	fetchParents(R... records)	Fetch parent records of a given set of record through this foreign key
@NotNull UniqueKey<O>	getKey()	The referenced UniqueKey.
@NotNull List<TableField<O,?>>	getKeyFields()	The fields that make up the referenced UniqueKey.
@NotNull TableField<O,?> @NotNull []	getKeyFieldsArray()	The fields that make up the referenced UniqueKey.
@NotNull Table<O>	parent(R record)	Get a table expression representing the parent of a record, given this foreign key.
@NotNull Table<O>	parents(Collection<? extends R> records)	Get a table expression representing the parents of a record, given this foreign key.
@NotNull Table<O>	parents(R... records)	Get a table expression representing the parents of a record, given this foreign key.

Methods inherited from interface org.jooq.Key

constraint, enforced, getFields, getFieldsArray, getTable, nullable

Methods inherited from interface org.jooq.Named

$name, getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart

$replace, $replace, $traverse, $traverse, equals, hashCode, toString

Method Details

getKey

@NotNull
@NotNull UniqueKey<O> getKey()

The referenced UniqueKey.

getKeyFields

@NotNull
@NotNull List<TableField<O,?>> getKeyFields()

The fields that make up the referenced UniqueKey.

This returns the order in which the fields of getKey() are referenced, which is usually the same as the fields of Key.getFields(), but not necessarily so.

getKeyFieldsArray

@NotNull
@NotNull TableField<O,?> @NotNull [] getKeyFieldsArray()

The fields that make up the referenced UniqueKey.

This returns the order in which the fields of getKey() are referenced, which is usually the same as the fields of Key.getFieldsArray(), but not necessarily so.

See Also:

• getKeyFields()

fetchParent

@Nullable
O fetchParent(R record)
       throws DataAccessException

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

This returns a parent record referenced by a given record through this foreign key, as if fetching from parent(Record). If no parent record was found, this returns null

Throws:

DataAccessException - if something went wrong executing the query

See Also:

• TableRecord.fetchParent(ForeignKey)

fetchParents

@NotNull
@NotNull Result<O> fetchParents(R... records)
                         throws DataAccessException

Fetch parent records of a given set of record through this foreign key

This returns parent records referenced by any record in a given set of records through this foreign key, as if fetching from parents(Record...).

Throws:

DataAccessException - if something went wrong executing the query

See Also:

• TableRecord.fetchParent(ForeignKey)

fetchParents

@NotNull
@NotNull Result<O> fetchParents(Collection<? extends R> records)
                         throws DataAccessException

Fetch parent records of a given set of record through this foreign key

This returns parent records referenced by any record in a given set of records through this foreign key, as if fetching from parents(Collection).

Throws:

DataAccessException - if something went wrong executing the query

See Also:

• TableRecord.fetchParent(ForeignKey)

fetchChildren

@NotNull
@NotNull Result<R> fetchChildren(O record)
                          throws DataAccessException

Fetch child records of a given record through this foreign key

This returns childs record referencing a given record through this foreign key, as if fetching from children(Record).

Throws:

DataAccessException - if something went wrong executing the query

See Also:

• UpdatableRecord.fetchChild(ForeignKey)
• UpdatableRecord.fetchChildren(ForeignKey)

fetchChildren

@NotNull
@NotNull Result<R> fetchChildren(O... records)
                          throws DataAccessException

Fetch child records of a given set of records through this foreign key

This returns childs record referencing any record in a given set of records through this foreign key, as if fetching from children(Record...).

Throws:

DataAccessException - if something went wrong executing the query

See Also:

• UpdatableRecord.fetchChild(ForeignKey)
• UpdatableRecord.fetchChildren(ForeignKey)

fetchChildren

@NotNull
@NotNull Result<R> fetchChildren(Collection<? extends O> records)
                          throws DataAccessException

Fetch child records of a given set of records through this foreign key

This returns childs record referencing any record in a given set of records through this foreign key, as if fetching from children(Collection).

Throws:

DataAccessException - if something went wrong executing the query

See Also:

• UpdatableRecord.fetchChild(ForeignKey)
• UpdatableRecord.fetchChildren(ForeignKey)

parent

@NotNull
@NotNull Table<O> parent(R record)

Get a table expression representing the parent of a record, given this foreign key.

parents

@NotNull
@NotNull Table<O> parents(R... records)

Get a table expression representing the parents of a record, given this foreign key.

parents

@NotNull
@NotNull Table<O> parents(Collection<? extends R> records)

Get a table expression representing the parents of a record, given this foreign key.

children

@NotNull
@NotNull Table<R> children(O record)

Get a table expression representing the children of a record, given this foreign key.

children

@NotNull
@NotNull Table<R> children(O... records)

Get a table expression representing the children of a record, given this foreign key.

children

@NotNull
@NotNull Table<R> children(Collection<? extends O> records)

Get a table expression representing the children of a record, given this foreign key.