List of addForeignKey() Examples

Examples of addForeignKey()

er.extensions.migration.ERXMigrationTable.addForeignKey()
Executes the SQL operations to add this foreign key constraint (only supports single attribute FK's right now). @param sourceColumnName the source column name of the relationship @param destinationTableName the destination table of the relationship (should be the PK of the destination table) @param destinationColumnName the destination column of the relationship (should be the PK of the destination table) @throws SQLException if the add fails
nexj.core.meta.persistence.AttributeMapping.addForeignKey()
nexj.core.meta.persistence.PersistenceMapping.addForeignKey()
Adds a foreign key with a given name to this mapping and sets the association mapping in a class mapping. @param sName The name of the foreign key to add. Can be null. @param mapping The class mapping to update. Can be null. @return The added foreign key. @throws MetadataException if the key cannot be added.
org.apache.openjpa.jdbc.schema.Table.addForeignKey()
Add a foreign key to the table.
org.apache.torque.map.TableMap.addForeignKey()
Add a foreign key column to the table. @param columnName A String with the column name. @param type An Object specifying the type. @param fkTable A String with the foreign key table name. @param fkColumn A String with the foreign key column name.
org.datanucleus.metadata.AbstractClassMetaData.addForeignKey()
Method to add an foreign-key to this class. @param fkmd Meta-Data for the foreign-key.
org.datanucleus.metadata.ClassMetaData.addForeignKey()
org.exolab.castor.builder.info.nature.relation.JDOOneToManyNature.addForeignKey()
Adds a column to the foreign key. By contract, the order of the key columns is not guaranteed and depends on the returned List implementation the {@link BaseNature} is using. @param column The column name.
org.exolab.castor.builder.info.nature.relation.JDOOneToOneNature.addForeignKey()
Adds a column to the foreign key. By contract, the order of the key columns is not guaranteed and depends on the returned List implementation the {@link BaseNature} is using. @param column The column name.
org.jpox.metadata.AbstractClassMetaData.addForeignKey()
Method to add an foreign-key to this class. @param fkmd Meta-Data for the foreign-key.
org.jpox.metadata.ClassMetaData.addForeignKey()

Examples of er.extensions.migration.ERXMigrationTable.addForeignKey()

    partial_EmployeePersonTable.newStringColumn("employeeNumber", 255, true);
    partial_EmployeePersonTable.newIntegerColumn("employeeTypeID", true);
    partial_EmployeePersonTable.newBigDecimalColumn("salary", 38, 2, true);


    partial_EmployeePersonTable.addForeignKey("departmentID", "Department", "id");
    partial_EmployeePersonTable.addForeignKey("employeeTypeID", "EmployeeType", "id");
    departmentTable.addForeignKey("companyID", "Company", "id");
  }


  public void postUpgrade(EOEditingContext ec, EOModel model) throws Throwable {
    EmployeeType employee = EmployeeType.createEmployeeType(ec, "Employee");

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.addForeignKey()


  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable table = database.existingTableNamed(_tableName);
    table.newIntegerColumn(_columnName, _allowsNull);
    table.addForeignKey(_columnName, database.existingTableNamed("ERAttachment").existingColumnNamed("id"));
  }


}

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.addForeignKey()

    feeTable.addForeignKey("RENTAL_ID", "rental", "RENTAL_ID");
    //unitTable.addForeignKey("VIDEO_ID", "video", "VIDEO_ID");
    videoTable.addForeignKey("MOVIE_ID", "movie", "MOVIE_ID");
    videoTable.addForeignKey("RENTAL_TERMS_ID", "rentalterms", "RENTAL_TERMS_ID");
    customerTable.addForeignKey("CUSTOMER_ID", "creditcard", "CUSTOMER_ID");
    creditCardTable.addForeignKey("CUSTOMER_ID", "customer", "CUSTOMER_ID");
    
    //talentPhotoTable.addForeignKey("TALENT_ID", "talent", "TALENT_ID");
    directorTable.addForeignKey("MOVIE_ID", "movie", "MOVIE_ID");
    //directorTable.addForeignKey("TALENT_ID", "talent", "TALENT_ID");
    votingTable.addForeignKey("MOVIE_ID", "movie", "MOVIE_ID");

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.addForeignKey()

        eRCAuditTrailEntryTable.newStringColumn("TYPE", 50, NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("USER_GLOBAL_ID", 255, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newBlobColumn("USER_INFO", ALLOWS_NULL);
        eRCAuditTrailEntryTable.create();
        eRCAuditTrailEntryTable.setPrimaryKey("ID");
        eRCAuditTrailEntryTable.addForeignKey("NEW_BLOB_VALUE_ID", "ERCAuditBlob", "id");
        eRCAuditTrailEntryTable.addForeignKey("OLD_BLOB_VALUE_ID", "ERCAuditBlob", "id");
        eRCAuditTrailEntryTable.addForeignKey("TRAIL_ID", "ERCAuditTrail", "id");


        ERXMigrationTable eRCHelpTextTable = database.newTableNamed("ERCHELP_TEXT");
        eRCHelpTextTable.newIntegerColumn("ID", NOT_NULL);

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.addForeignKey()

        eRCAuditTrailEntryTable.newStringColumn("USER_GLOBAL_ID", 255, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newBlobColumn("USER_INFO", ALLOWS_NULL);
        eRCAuditTrailEntryTable.create();
        eRCAuditTrailEntryTable.setPrimaryKey("ID");
        eRCAuditTrailEntryTable.addForeignKey("NEW_BLOB_VALUE_ID", "ERCAuditBlob", "id");
        eRCAuditTrailEntryTable.addForeignKey("OLD_BLOB_VALUE_ID", "ERCAuditBlob", "id");
        eRCAuditTrailEntryTable.addForeignKey("TRAIL_ID", "ERCAuditTrail", "id");


        ERXMigrationTable eRCHelpTextTable = database.newTableNamed("ERCHELP_TEXT");
        eRCHelpTextTable.newIntegerColumn("ID", NOT_NULL);
        eRCHelpTextTable.newStringColumn("KEY_", 100, NOT_NULL);

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.addForeignKey()

        eRCAuditTrailEntryTable.newBlobColumn("USER_INFO", ALLOWS_NULL);
        eRCAuditTrailEntryTable.create();
        eRCAuditTrailEntryTable.setPrimaryKey("ID");
        eRCAuditTrailEntryTable.addForeignKey("NEW_BLOB_VALUE_ID", "ERCAuditBlob", "id");
        eRCAuditTrailEntryTable.addForeignKey("OLD_BLOB_VALUE_ID", "ERCAuditBlob", "id");
        eRCAuditTrailEntryTable.addForeignKey("TRAIL_ID", "ERCAuditTrail", "id");


        ERXMigrationTable eRCHelpTextTable = database.newTableNamed("ERCHELP_TEXT");
        eRCHelpTextTable.newIntegerColumn("ID", NOT_NULL);
        eRCHelpTextTable.newStringColumn("KEY_", 100, NOT_NULL);
        eRCHelpTextTable.newLocalizedClobColumns("VALUE_", ALLOWS_NULL);

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.addForeignKey()

    xBugTestItemTable.addForeignKey("ID", "TEST_ITEM", "ID");
    frameworkTable.addForeignKey("USER_ID", "PEOPLE", "ID");
    testItemTable.addForeignKey("MODULE_ID", "COMPONENT", "ID");
    testItemTable.addForeignKey("TESTED_BY_ID", "PEOPLE", "ID");
    testItemTable.addForeignKey("STATE_ID", "TEST_ITEM_STATE", "ID");
    requirementTable.addForeignKey("DIFFICULTY_ID", "DIFFICULTY", "ID");
    requirementTable.addForeignKey("SUB_TYPE_ID", "REQ_SUB_TYPE", "REQ_SUB_TYPE_ID");
    requirementTable.addForeignKey("REQ_TYPE_ID", "REQ_TYPE", "REQ_TYPE_ID");
  }


  public void postUpgrade(EOEditingContext editingContext, EOModel model) throws Throwable {

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.addForeignKey()

    frameworkTable.addForeignKey("USER_ID", "PEOPLE", "ID");
    testItemTable.addForeignKey("MODULE_ID", "COMPONENT", "ID");
    testItemTable.addForeignKey("TESTED_BY_ID", "PEOPLE", "ID");
    testItemTable.addForeignKey("STATE_ID", "TEST_ITEM_STATE", "ID");
    requirementTable.addForeignKey("DIFFICULTY_ID", "DIFFICULTY", "ID");
    requirementTable.addForeignKey("SUB_TYPE_ID", "REQ_SUB_TYPE", "REQ_SUB_TYPE_ID");
    requirementTable.addForeignKey("REQ_TYPE_ID", "REQ_TYPE", "REQ_TYPE_ID");
  }


  public void postUpgrade(EOEditingContext editingContext, EOModel model) throws Throwable {
    Priority critical = Priority.clazz.createAndInsertObject(editingContext);

View Full Code Here

Examples of er.extensions.migration.ERXMigrationTable.addForeignKey()

    testItemTable.addForeignKey("MODULE_ID", "COMPONENT", "ID");
    testItemTable.addForeignKey("TESTED_BY_ID", "PEOPLE", "ID");
    testItemTable.addForeignKey("STATE_ID", "TEST_ITEM_STATE", "ID");
    requirementTable.addForeignKey("DIFFICULTY_ID", "DIFFICULTY", "ID");
    requirementTable.addForeignKey("SUB_TYPE_ID", "REQ_SUB_TYPE", "REQ_SUB_TYPE_ID");
    requirementTable.addForeignKey("REQ_TYPE_ID", "REQ_TYPE", "REQ_TYPE_ID");
  }


  public void postUpgrade(EOEditingContext editingContext, EOModel model) throws Throwable {
    Priority critical = Priority.clazz.createAndInsertObject(editingContext);
    critical._setValueForPrimaryKey("crtl", "id");

View Full Code Here

Examples of nexj.core.meta.persistence.AttributeMapping.addForeignKey()

                                       {
                                          throw new MetadataException("err.meta.missingAssocPersistenceMapping",
                                             new Object[]{attribute.getName(), metaclass.getName(), type.getName()});
                                       }


                                       classMapping.setDestinationKey(mapping.addForeignKey(sDestinationKeyName, classMapping));
                                    }
                                 });
                              }


                              mapping = classMapping;

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.