net.sf.jailer.datamodel

Class Association

java.lang.Object

net.sf.jailer.datamodel.ModelElement

net.sf.jailer.datamodel.Association

public class Association
extends ModelElement

An association between database-tables.

Author:

Ralf Wisser

Field Summary

Fields

Modifier and Type	Field and Description
Table	destination The destination table.
static java.lang.String	NULL_FILTER_COMMENT_PREFIX
Association	reversalAssociation The counterpart of the association for the reversal direction.
boolean	reversed true for reversed association.
Table	source The source table.

Constructor Summary

Constructors

Constructor and Description
Association(Table source, Table destination, boolean insertSourceBeforeDestination, boolean insertDestinationBeforeSource, java.lang.String joinCondition, DataModel dataModel, boolean reversed, Cardinality cardinality) Constructor.
Association(Table source, Table destination, boolean insertSourceBeforeDestination, boolean insertDestinationBeforeSource, java.lang.String joinCondition, DataModel dataModel, boolean reversed, Cardinality cardinality, java.lang.String author) Constructor.

Method Summary

Modifier and Type	Method and Description
void	appendCondition(java.lang.String condition) Appends condition to join-condition.
java.util.Map<Column,Column>	createSourceToDestinationKeyMapping() Maps source-columns to destination-columns, if this represents an equi-join.
java.util.Map<Column,Column>	createSourceToDestinationKeyMapping(java.util.Set<Pair<Column,Column>> assignments) Maps source-columns to destination-columns, if this represents an equi-join.
boolean	fkHasExcludeFilter()
boolean	fkHasNullFilter()
AggregationSchema	getAggregationSchema() Gets the XML aggregation schema.
java.lang.String	getAggregationTagName() Gets name of XML-tag used for aggregation.
Cardinality	getCardinality() Gets the cardinality.
DataModel	getDataModel() Gets data-model to which this association belongs to.
int	getId() Gets unique ID.
java.lang.String	getJoinCondition() Gets the restricted join-condition for joining source with destination table.
java.lang.String	getName() Gets the name of the association.
java.lang.String	getRestrictionCondition() Gets restriction-condition.
java.lang.String	getUnrestrictedJoinCondition() Gets join-condition without any restrictions.
boolean	hasNullableFK()
boolean	isIgnored() Is this association ignored?
boolean	isInsertDestinationBeforeSource() Whether or not to insert destination-rows before source-rows in order to prevent foreign-key-constraint violation.
boolean	isInsertSourceBeforeDestination() Whether or not to insert source-rows before destination rows in order to prevent foreign-key-constraint violation.
boolean	isRestricted() Whether there is any restriction of this association.
boolean	isRestrictedDependencyWithNulledFK()
java.lang.String	renderJoinCondition(java.lang.String restrictionSeparator) Stringifies the join condition.
void	setAggregationSchema(AggregationSchema aggregationSchema) Sets the XML aggregation schema.
void	setAggregationTagName(java.lang.String aggregationTagName) Sets name of XML-tag used for aggregation.
void	setName(java.lang.String name) Sets the name of the association.
boolean	setOrResetFKNullFilter(boolean set)
java.lang.String	toString() Stringifies the association.
java.lang.String	toString(int maxGab, boolean useDisplayName) Stringifies the association.

Methods inherited from class net.sf.jailer.datamodel.ModelElement

getAuthor, setAuthor

Methods inherited from class java.lang.Object

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

Field Detail

source

public final Table source

The source table.

destination

public final Table destination

The destination table.

reversed

public final boolean reversed

true for reversed association.

reversalAssociation

public Association reversalAssociation

The counterpart of the association for the reversal direction.

NULL_FILTER_COMMENT_PREFIX

public static final java.lang.String NULL_FILTER_COMMENT_PREFIX

See Also:

Constant Field Values

Constructor Detail

Association

public Association(Table source,
                   Table destination,
                   boolean insertSourceBeforeDestination,
                   boolean insertDestinationBeforeSource,
                   java.lang.String joinCondition,
                   DataModel dataModel,
                   boolean reversed,
                   Cardinality cardinality)

Constructor.

Parameters:

source - the source table

destination - the destination table

joinCondition - the join-condition for join with destination table

insertSourceBeforeDestination - whether or not to insert source-rows before destination rows in order to prevent foreign-key-constraint violation

insertDestinationBeforeSource - whether or not to insert destination-rows before source-rows in order to prevent foreign-key-constraint violation

dataModel - data-model containing this association

reversed - true for reversed association

cardinality - the cardinality (optional)

Association

public Association(Table source,
                   Table destination,
                   boolean insertSourceBeforeDestination,
                   boolean insertDestinationBeforeSource,
                   java.lang.String joinCondition,
                   DataModel dataModel,
                   boolean reversed,
                   Cardinality cardinality,
                   java.lang.String author)

Constructor.

Parameters:

source - the source table

destination - the destination table

joinCondition - the join-condition for join with destination table

insertSourceBeforeDestination - whether or not to insert source-rows before destination rows in order to prevent foreign-key-constraint violation

insertDestinationBeforeSource - whether or not to insert destination-rows before source-rows in order to prevent foreign-key-constraint violation

dataModel - data-model containing this association

reversed - true for reversed association

cardinality - the cardinality (optional)

author - the author

Method Detail

getJoinCondition

public java.lang.String getJoinCondition()

Gets the restricted join-condition for joining source with destination table.

Returns:

the restricted join-condition for joining source with destination table, null if association must be ignored

isIgnored

public boolean isIgnored()

Is this association ignored?

Returns:

true iff this association is ignored

getCardinality

public Cardinality getCardinality()

Gets the cardinality.

Returns:

the cardinality. null if cardinality is not known.

toString

public java.lang.String toString()

Stringifies the association.

Overrides:

toString in class java.lang.Object

toString

public java.lang.String toString(int maxGab,
                                 boolean useDisplayName)

Stringifies the association.

renderJoinCondition

public java.lang.String renderJoinCondition(java.lang.String restrictionSeparator)

Stringifies the join condition.

Parameters:

restrictionSeparator - separates join-condition from restriction condition in the result

getUnrestrictedJoinCondition

public java.lang.String getUnrestrictedJoinCondition()

Gets join-condition without any restrictions.

Returns:

join-condition as defined in data model

getRestrictionCondition

public java.lang.String getRestrictionCondition()

Gets restriction-condition.

Returns:

restriction-condition, null if association is not restricted

setName

public void setName(java.lang.String name)

Sets the name of the association.

Parameters:

name - the name of the association

getName

public java.lang.String getName()

Gets the name of the association.

Returns:

the name of the association

isInsertSourceBeforeDestination

public boolean isInsertSourceBeforeDestination()

Whether or not to insert source-rows before destination rows in order to prevent foreign-key-constraint violation.

Returns:

the insertSourceBeforeDestination

isInsertDestinationBeforeSource

public boolean isInsertDestinationBeforeSource()

Whether or not to insert destination-rows before source-rows in order to prevent foreign-key-constraint violation.

Returns:

the insertDestinationBeforeSource

isRestricted

public boolean isRestricted()

Whether there is any restriction of this association.

appendCondition

public void appendCondition(java.lang.String condition)

Appends condition to join-condition.

Parameters:

condition - the condition

getAggregationSchema

public AggregationSchema getAggregationSchema()

Gets the XML aggregation schema.

Returns:

the XML aggregation schema

getAggregationTagName

public java.lang.String getAggregationTagName()

Gets name of XML-tag used for aggregation.

Returns:

name of XML-tag used for aggregation

setAggregationSchema

public void setAggregationSchema(AggregationSchema aggregationSchema)

Sets the XML aggregation schema.

Parameters:

aggregationSchema - the XML aggregation schema

setAggregationTagName

public void setAggregationTagName(java.lang.String aggregationTagName)

Sets name of XML-tag used for aggregation.

Parameters:

aggregationTagName - name of XML-tag used for aggregation

getId

public int getId()

Gets unique ID.

Returns:

unique ID

getDataModel

public DataModel getDataModel()

Gets data-model to which this association belongs to.

createSourceToDestinationKeyMapping

public java.util.Map<Column,Column> createSourceToDestinationKeyMapping()

Maps source-columns to destination-columns, if this represents an equi-join. Otherwise it returns an empty map.

Returns:

map from source-columns to destination-columns, if this represents an equi-join

createSourceToDestinationKeyMapping

public java.util.Map<Column,Column> createSourceToDestinationKeyMapping(java.util.Set<Pair<Column,Column>> assignments)

Maps source-columns to destination-columns, if this represents an equi-join. Otherwise it returns an empty map.

Parameters:

assignments - if not null, put column assignments into it

Returns:

map from source-columns to destination-columns, if this represents an equi-join

hasNullableFK

public boolean hasNullableFK()

fkHasNullFilter

public boolean fkHasNullFilter()

fkHasExcludeFilter

public boolean fkHasExcludeFilter()

setOrResetFKNullFilter

public boolean setOrResetFKNullFilter(boolean set)

isRestrictedDependencyWithNulledFK

public boolean isRestrictedDependencyWithNulledFK()