Package de.mid.innovator.srv2api.icw2db

Class DBForeignKeyHelper

java.lang.Object

de.mid.innovator.srv2api.icw2db.DBForeignKeyHelper

public abstract class DBForeignKeyHelper
extends Object

This is a utility class for DBForeignKey that provides static methods for creation or other purposes.

See Also:

• DBForeignKey

Method Summary

Modifier and Type	Method	Description
static DBForeignKey	create(SrvContext srvCtx, MMCreateTemplate ohTemplate, ELContainerAble ohContainer, ELElement ohRequirement)	Create a new Foreign Key (of Table) with template and container with requirement.
static DBForeignKey	create(SrvContext srvCtx, MMStereotype ohStereotype, ELContainerAble ohContainer, ELElement ohRequirement)	Create a new Foreign Key (of Table) with stereotype and container with requirement.
static DBForeignKey	createAndMaintain(SrvContext srvCtx, MMCreateTemplate ohTemplate, ELContainerAble ohContainer, ELElement ohRequirement)	Create a new Foreign Key (of Table) with template and container with requirement.
static DBForeignKey	createAndMaintain(SrvContext srvCtx, MMStereotype ohStereotype, ELContainerAble ohContainer, ELElement ohRequirement)	Create a new Foreign Key (of Table) with stereotype and container with requirement.
static List<DBForeignKey>	createByER(SrvContext srvCtx, ELContainerAble ohDBElement, MENamedElement ohERElement)	This method creates (if possible) a DBForeignKey for the given ERForeignKey (ER element) in the given DBTable (DB element).
static DBTable	mergeSiblingTables(SrvContext srvCtx, List<? extends ELElement> seq)	Merges two or more sibling database tables of the given foreign keys.
static List<DBTable>	mergeToForeign(SrvContext srvCtx, List<? extends ELElement> seq)	Merges the DBTable which contains the DBUniqueKey corresponding to the selected DBForeignKey into the DBTable which contains the foreign key. This action creates a DBMergedTable in the modified table.
static List<DBTable>	mergeToUnique(SrvContext srvCtx, List<? extends DBForeignKey> seqForeign, List<Integer> seqCard)	Merges the DBTable of the selected DBForeignKey into the DBTable which contains the corresponding DBUniqueKey. This action creates a DBMergedTable in the modified table.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

createByER

public static List<DBForeignKey> createByER(SrvContext srvCtx,
 ELContainerAble ohDBElement,
 MENamedElement ohERElement)
                                     throws InoNetException,
SrvErrorException

This method creates (if possible) a DBForeignKey for the given ERForeignKey (ER element) in the given DBTable (DB element). It could be impossible to create the foreign key, if the referenced unique key does not exist in the DB model.
This standard mapping creates a MEMappingDependency with the ER key as requirement element and with the newly created DB key as implementation element. The mapping dependency is marked as 'maintaining' for further automatic mapping maintenance.

Parameters:

srvCtx - The context of the related innovator server.

ohDBElement - Target DB Element for evaluating the owner for the new element

ohERElement - Requirement element of the ER Model

Throws:

InoNetException

SrvErrorException

mergeSiblingTables

public static DBTable mergeSiblingTables(SrvContext srvCtx,
 List<? extends ELElement> seq)
                                  throws InoNetException,
SrvErrorException

Merges two or more sibling database tables of the given foreign keys. The foreign keys must be identifying and maximum 1, and must reference the same primary key.
This action creates a DBMergedTable in the modified table.

Parameters:

srvCtx - The context of the related innovator server.

seq - List of ELElement

Throws:

InoNetException

SrvErrorException

mergeToForeign

public static List<DBTable> mergeToForeign(SrvContext srvCtx,
 List<? extends ELElement> seq)
                                    throws InoNetException,
SrvErrorException

Merges the DBTable which contains the DBUniqueKey corresponding to the selected DBForeignKey into the DBTable which contains the foreign key.
This action creates a DBMergedTable in the modified table.

Parameters:

srvCtx - The context of the related innovator server.

seq - List of ELElement

Throws:

InoNetException

SrvErrorException

mergeToUnique

public static List<DBTable> mergeToUnique(SrvContext srvCtx,
 List<? extends DBForeignKey> seqForeign,
 List<Integer> seqCard)
                                   throws InoNetException,
SrvErrorException

Merges the DBTable of the selected DBForeignKey into the DBTable which contains the corresponding DBUniqueKey.
This action creates a DBMergedTable in the modified table.

Parameters:

srvCtx - The context of the related innovator server.

seqForeign - foreign keys

seqCard - cardinalities for merge

Throws:

InoNetException

SrvErrorException

create

public static DBForeignKey create(SrvContext srvCtx,
 MMStereotype ohStereotype,
 ELContainerAble ohContainer,
 ELElement ohRequirement)
                           throws InoNetException,
SrvErrorException

Create a new Foreign Key (of Table) with stereotype and container with requirement.

Parameters:

srvCtx - The context of the related innovator server.

ohStereotype - Stereotype for the new element

ohContainer - Container for the new element

ohRequirement - Additional required element

Throws:

InoNetException

SrvErrorException

create

public static DBForeignKey create(SrvContext srvCtx,
 MMCreateTemplate ohTemplate,
 ELContainerAble ohContainer,
 ELElement ohRequirement)
                           throws InoNetException,
SrvErrorException

Create a new Foreign Key (of Table) with template and container with requirement.

Parameters:

srvCtx - The context of the related innovator server.

ohTemplate - Template for the new element

ohContainer - Container for the new element

ohRequirement - Additional required element

Throws:

InoNetException

SrvErrorException

createAndMaintain

public static DBForeignKey createAndMaintain(SrvContext srvCtx,
 MMStereotype ohStereotype,
 ELContainerAble ohContainer,
 ELElement ohRequirement)
                                      throws InoNetException,
SrvErrorException

Create a new Foreign Key (of Table) with stereotype and container with requirement. The created element is maintained.

Parameters:

srvCtx - The context of the related innovator server.

ohStereotype - Stereotype for the new element

ohContainer - Container for the new element

ohRequirement - Additional required element

Throws:

InoNetException

SrvErrorException

createAndMaintain

public static DBForeignKey createAndMaintain(SrvContext srvCtx,
 MMCreateTemplate ohTemplate,
 ELContainerAble ohContainer,
 ELElement ohRequirement)
                                      throws InoNetException,
SrvErrorException

Create a new Foreign Key (of Table) with template and container with requirement. The created element is maintained.

Parameters:

srvCtx - The context of the related innovator server.

ohTemplate - Template for the new element

ohContainer - Container for the new element

ohRequirement - Additional required element

Throws:

InoNetException

SrvErrorException