Examples of addForeignKey()


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

    versionDigestTable.setPrimaryKey("pk");

    envJoinTable.addForeignKey("env_pk", "environments", "pk");
    envJoinTable.addForeignKey("result_pk", "results", "pk");
    failureTable.addForeignKey("result_pk", "results", "pk");
    versionDigestTable.addForeignKey("result_pk", "results", "pk");
  }
}
View Full Code Here

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

    personTable.newIntegerColumn("id", false);
    personTable.newStringColumn("lastName", 255, false);
    personTable.create();
     personTable.setPrimaryKey("id");

    personTable.addForeignKey("genderTypeID", "GenderType", "id");
  }

  public void postUpgrade(EOEditingContext ec, EOModel model) throws Throwable {
    GenderType female = GenderType.createGenderType(ec, "Female");
    GenderType male = GenderType.createGenderType(ec, "Male");
View Full Code Here

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

    petTable.newIntegerColumn("ownerID", false);
    petTable.create();
    petTable.setPrimaryKey("id");

    personTable.addForeignKey("companyID", "Company", "id");
    petTable.addForeignKey("ownerID", "Person", "id");
  }

  public void postUpgrade(EOEditingContext editingContext, EOModel model) throws Throwable {
    Company c1 = Company.createCompany(editingContext, "mDT");
    Company c2 = Company.createCompany(editingContext, "Apple");
View Full Code Here

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

    sPSecretPalTable.addForeignKey("receiverID", "SPPerson", "id");
    sPWishTable.addForeignKey("suggestedByID", "SPPerson", "id");
    sPWishTable.addForeignKey("suggestedForID", "SPPerson", "id");
    sPMembershipTable.addForeignKey("groupID", "SPGroup", "id");
    sPMembershipTable.addForeignKey("personID", "SPPerson", "id");
    sPEventTable.addForeignKey("groupID", "SPGroup", "id");
   
    sPPersonTable.addUniqueIndex("uniqueEmailAddress", "emailAddress");
 
    sPSecretPalTable.addUniqueIndex("uniqueSecretPal", sPSecretPalTable.existingColumnNamed("eventID"), sPSecretPalTable.existingColumnNamed("giverID"), sPSecretPalTable.existingColumnNamed("receiverID"));
  }
View Full Code Here

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

    employeeTable.newBigDecimalColumn("salary", 38, 4, true);
    employeeTable.newStringColumn("status", 50, false);
    employeeTable.create();
    employeeTable.setPrimaryKey("id");

    employeeTable.addForeignKey("companyID", "Company", "id");
    employeeTable.addForeignKey("photoID", "ERAttachment", "id");
  }

  public void postUpgrade(EOEditingContext editingContext, EOModel model) throws Throwable {
    Company c1 = Company.createCompany(editingContext, "ABC Corp");
View Full Code Here

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

    employeeTable.newStringColumn("status", 50, false);
    employeeTable.create();
    employeeTable.setPrimaryKey("id");

    employeeTable.addForeignKey("companyID", "Company", "id");
    employeeTable.addForeignKey("photoID", "ERAttachment", "id");
  }

  public void postUpgrade(EOEditingContext editingContext, EOModel model) throws Throwable {
    Company c1 = Company.createCompany(editingContext, "ABC Corp");
    c1.setLocation("Richmond, VA");
View Full Code Here

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

    spNoNoPalTable.newIntegerColumn("id", false);
    spNoNoPalTable.newIntegerColumn("receiverID", false);
    spNoNoPalTable.create();
    spNoNoPalTable.setPrimaryKey("id");

    spNoNoPalTable.addForeignKey("eventID", "SPEvent", "id");
    spNoNoPalTable.addForeignKey("giverID", "SPPerson", "id");
    spNoNoPalTable.addForeignKey("receiverID", "SPPerson", "id");

    spNoNoPalTable.addUniqueIndex("uniqueNoNoPal", spNoNoPalTable.existingColumnNamed("eventID"), spNoNoPalTable.existingColumnNamed("giverID"), spNoNoPalTable.existingColumnNamed("receiverID"));
  }
View Full Code Here

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

    spNoNoPalTable.newIntegerColumn("receiverID", false);
    spNoNoPalTable.create();
    spNoNoPalTable.setPrimaryKey("id");

    spNoNoPalTable.addForeignKey("eventID", "SPEvent", "id");
    spNoNoPalTable.addForeignKey("giverID", "SPPerson", "id");
    spNoNoPalTable.addForeignKey("receiverID", "SPPerson", "id");

    spNoNoPalTable.addUniqueIndex("uniqueNoNoPal", spNoNoPalTable.existingColumnNamed("eventID"), spNoNoPalTable.existingColumnNamed("giverID"), spNoNoPalTable.existingColumnNamed("receiverID"));
  }
}
View Full Code Here

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

    partial_EmployeePersonTable.newIntegerColumn("departmentID", true);
    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 {
View Full Code Here

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

    spNoNoPalTable.create();
    spNoNoPalTable.setPrimaryKey("id");

    spNoNoPalTable.addForeignKey("eventID", "SPEvent", "id");
    spNoNoPalTable.addForeignKey("giverID", "SPPerson", "id");
    spNoNoPalTable.addForeignKey("receiverID", "SPPerson", "id");

    spNoNoPalTable.addUniqueIndex("uniqueNoNoPal", spNoNoPalTable.existingColumnNamed("eventID"), spNoNoPalTable.existingColumnNamed("giverID"), spNoNoPalTable.existingColumnNamed("receiverID"));
  }
}
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.