kodo.jdbc.schema
Class ForeignKey

java.lang.Object
  |
  +--kodo.jdbc.schema.ReferenceCounter
        |
        +--kodo.jdbc.schema.Constraint
              |
              +--kodo.jdbc.schema.ForeignKey

public class ForeignKey

extends Constraint

Represents a database foreign key; may be a logical key with no database representation.

Field Summary

static int	ACTION_CASCADE Cascade any modification of the joined primary key columns to this table.
static int	ACTION_DEFAULT Set the local columns to their default values if the primary key columns are modified.
static int	ACTION_EXCEPTION Throw an exception if joined primary key columns are modified.
static int	ACTION_NONE Logical foreign key; links columns, but does not perform any action when the joined primary key columns are modified.
static int	ACTION_NULL Null the local columns if the joined primary key columns are modified.

Constructor Summary

ForeignKey(String name, Table table)
Constructor.

Method Summary

boolean	columnsMatch(Column[] fkCols, Column[] fkPKCols, Column[] fkConstantCols, Column[] fkConstantPKCols) Return true if the given local and foreign columns match those on this key.
boolean	containsColumn(Column col) Return true if the fk includes the given local column.
boolean	containsConstantColumn(Column col) Return true if the fk includes the given local column.
boolean	containsConstantPrimaryKeyColumn(Column col) Return true if the fk includes the given primary key column.
boolean	containsPrimaryKeyColumn(Column col) Return true if the fk includes the given primary key column.
void	derefColumns() Deref all columns in this key.
boolean	equals(Object other) Foreign keys are equal if the satisfy the equality constraints of Constraint and they have the same local and primary key columns and action.
Column	getColumn(Column pk) Return the local column joined to the given primary key column.
Column[]	getColumns() Return the local columns in the foreign key local table order.
Object	getConstant(Column local) Return the constant value assigned to the given local column.
Column[]	getConstantColumns() Return the local columns that we link to using constant values.
Column[]	getConstantPrimaryKeyColumns() Return the primary key columns that we link to using constant values.
Object[]	getConstants() Return the constant values assigned to the local columns returned by getConstantColumns().
int	getDeleteAction() Return the delete action for the key.
int	getIndex() Return the foreign key's 0-based index in the owning table.
Column	getPrimaryKeyColumn(Column local) Return the primary key column joined to the given local column.
Column[]	getPrimaryKeyColumns() Return the foreign columns in the foreign key, in join-order with the result of getColumns().
Object	getPrimaryKeyConstant(Column pk) Return the constant value assigned to the given primary key column.
Object[]	getPrimaryKeyConstants() Return the constant values assigned to the primary key columns returned by getConstantPrimaryKeyColumns().
Table	getPrimaryKeyTable() Returns the table this foreign key is linking to, if it is known yet.
boolean	isLogical() Return whether this constraint is a logical constraint only; i.e.
void	join(Column local, Column toPK) Join a local column to a primary key column of another table.
void	joinConstant(Column col, Object val) Join a constant value to a local column of this table.
void	joinConstant(Object val, Column toPK) Join a constant value to a primary key column of another table.
void	refColumns() Ref all columns in this key.
boolean	removeJoin(Column col) Remove any joins inolving the given column.
void	setConstantJoins(Column[] cols, Object[] consts) Set the foreign key's constant joins.
void	setConstantJoins(Object[] consts, Column[] pkCols) Set the foreign key's constant joins.
void	setDeleteAction(int action) Set the delete action for the key.
void	setJoins(Column[] cols, Column[] pkCols) Set the foreign key's joins.

Methods inherited from class kodo.jdbc.schema.Constraint

deref, getFullName, getName, getRefCount, getTable, isDeferred, ref, setDeferred, toString

Methods inherited from class java.lang.Object

clone, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

ACTION_NONE

public static final int ACTION_NONE

Logical foreign key; links columns, but does not perform any action when the joined primary key columns are modified.

ACTION_EXCEPTION

public static final int ACTION_EXCEPTION

Throw an exception if joined primary key columns are modified.

ACTION_CASCADE

public static final int ACTION_CASCADE

Cascade any modification of the joined primary key columns to this table. If the joined primary key row is deleted, the row in this table will also be deleted.

ACTION_NULL

public static final int ACTION_NULL

Null the local columns if the joined primary key columns are modified.

ACTION_DEFAULT

public static final int ACTION_DEFAULT

Set the local columns to their default values if the primary key columns are modified.

Constructor Detail

ForeignKey

public ForeignKey(String name,
                  Table table)

Constructor.

Parameters:

name - the foreign key name, if any

table - the local table of the foreign key

Method Detail

isLogical

public boolean isLogical()

Description copied from class: Constraint

Return whether this constraint is a logical constraint only; i.e. if it does not exist in the database.

Overrides:

isLogical in class Constraint

getDeleteAction

public int getDeleteAction()

Return the delete action for the key. Will be one of: ACTION_NONE, ACTION_EXCEPTION, ACTION_CASCADE, ACTION_NULL, ACTION_DEFAULT.

setDeleteAction

public void setDeleteAction(int action)

Set the delete action for the key. Must be one of: ACTION_NONE, ACTION_EXCEPTION, ACTION_CASCADE, ACTION_NULL, ACTION_DEFAULT.

getIndex

public int getIndex()

Return the foreign key's 0-based index in the owning table.

getPrimaryKeyColumn

public Column getPrimaryKeyColumn(Column local)

Return the primary key column joined to the given local column.

getColumn

public Column getColumn(Column pk)

Return the local column joined to the given primary key column.

getConstant

public Object getConstant(Column local)

Return the constant value assigned to the given local column.

getPrimaryKeyConstant

public Object getPrimaryKeyConstant(Column pk)

Return the constant value assigned to the given primary key column.

getColumns

public Column[] getColumns()

Return the local columns in the foreign key local table order.

getConstants

public Object[] getConstants()

Return the constant values assigned to the local columns returned by getConstantColumns().

getPrimaryKeyConstants

public Object[] getPrimaryKeyConstants()

Return the constant values assigned to the primary key columns returned by getConstantPrimaryKeyColumns().

containsColumn

public boolean containsColumn(Column col)

Return true if the fk includes the given local column.

containsPrimaryKeyColumn

public boolean containsPrimaryKeyColumn(Column col)

Return true if the fk includes the given primary key column.

containsConstantColumn

public boolean containsConstantColumn(Column col)

Return true if the fk includes the given local column.

containsConstantPrimaryKeyColumn

public boolean containsConstantPrimaryKeyColumn(Column col)

Return true if the fk includes the given primary key column.

getPrimaryKeyColumns

public Column[] getPrimaryKeyColumns()

Return the foreign columns in the foreign key, in join-order with the result of getColumns().

getConstantColumns

public Column[] getConstantColumns()

Return the local columns that we link to using constant values.

getConstantPrimaryKeyColumns

public Column[] getConstantPrimaryKeyColumns()

Return the primary key columns that we link to using constant values.

setJoins

public void setJoins(Column[] cols,
                     Column[] pkCols)

Set the foreign key's joins.

setConstantJoins

public void setConstantJoins(Object[] consts,
                             Column[] pkCols)

Set the foreign key's constant joins.

setConstantJoins

public void setConstantJoins(Column[] cols,
                             Object[] consts)

Set the foreign key's constant joins.

join

public void join(Column local,
                 Column toPK)

Join a local column to a primary key column of another table.

joinConstant

public void joinConstant(Object val,
                         Column toPK)

Join a constant value to a primary key column of another table. The constant must be either a string or a number. If the column is compatible with a number and the value is a string, it will be parsed into a number.

joinConstant

public void joinConstant(Column col,
                         Object val)

Join a constant value to a local column of this table. The constant must be either a string or a number. If the column is compatible with a number and the value is a string, it will be parsed into a number.

removeJoin

public boolean removeJoin(Column col)

Remove any joins inolving the given column.

Returns:

true if the join was removed, false if not part of the key

getPrimaryKeyTable

public Table getPrimaryKeyTable()

Returns the table this foreign key is linking to, if it is known yet.

refColumns

public void refColumns()

Ref all columns in this key.

derefColumns

public void derefColumns()

Deref all columns in this key.

equals

public boolean equals(Object other)

Foreign keys are equal if the satisfy the equality constraints of Constraint and they have the same local and primary key columns and action.

Overrides:

equals in class Constraint

columnsMatch

public boolean columnsMatch(Column[] fkCols,
                            Column[] fkPKCols,
                            Column[] fkConstantCols,
                            Column[] fkConstantPKCols)

Return true if the given local and foreign columns match those on this key. This can be used to find foreign keys given only column linking information.