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

Class er.extensions.migration.ERXMigrationTable

Examples of er.extensions.migration.ERXMigrationTable.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

    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


  @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

    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

        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

        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

        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

    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

    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

    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

    employeeTable.newStringColumn("lastName", 255, false);
    employeeTable.newStringColumn("state", 255, true);
    employeeTable.newStringColumn("zipcode", 255, true);
    employeeTable.create();
    employeeTable.setPrimaryKey("id");
    employeeTable.addForeignKey("companyID", "Company", "id");


    ERXMigrationTable roleTable = database.newTableNamed("Role");
    roleTable.newIntegerColumn("id", false);
    roleTable.create();
    roleTable.setPrimaryKey("id");

View Full Code Here

0 1 2

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.