コード例 #1
0
  private PropertyValueModel buildRelationalPlatformHolderImp() {
    PreferencePropertyValueModel adapter =
        new PreferencePropertyValueModel(
            preferences(),
            SCPlugin.DATABASE_PLATFORM_PREFERENCE,
            DatabasePlatformRepository.getDefault()
                .platformNamed(SCPlugin.DATABASE_PLATFORM_PREFERENCE_DEFAULT));

    adapter.setConverter(
        new BidiStringConverter() {
          public Object convertToObject(String value) {
            if (value == null) return null;

            return DatabasePlatformRepository.getDefault().platformNamed(value);
          }

          public String convertToString(Object value) {
            if (value == null) return null;

            DatabasePlatform platform = (DatabasePlatform) value;
            return platform.getName();
          }
        });

    return adapter;
  }
コード例 #2
0
  protected void setUp() throws Exception {
    super.setUp();

    this.databasePlatform = DatabasePlatformRepository.getDefault().platformNamed("MySQL");
    String projectName = ClassTools.shortClassNameForObject(this);
    this.project =
        new MWRelationalProject(
            projectName, MappingsModelTestTools.buildSPIManager(), this.databasePlatform);
    this.database = this.project.getDatabase();
    this.loginSpec = TestDatabases.mySQLLoginSpec(this.database);
    this.catalogName = null;
    this.schemaName = null;

    // EMP
    this.table_EMP = this.database.addTable(this.catalogName, this.schemaName, "emp");

    this.field_EMP_ID = this.table_EMP.addColumn("emp_id");
    this.field_EMP_ID.setDatabaseType(this.databasePlatform.databaseTypeNamed("integer"));
    this.field_EMP_ID.setSize(0);
    this.field_EMP_ID.setPrimaryKey(true);

    this.field_ADDR_ID1_FK = this.table_EMP.addColumn("addr_id1");
    this.field_ADDR_ID1_FK.setDatabaseType(this.databasePlatform.databaseTypeNamed("integer"));
    this.field_ADDR_ID1_FK.setSize(0);

    this.field_ADDR_ID2_FK = this.table_EMP.addColumn("addr_id2");
    this.field_ADDR_ID2_FK.setDatabaseType(this.databasePlatform.databaseTypeNamed("integer"));
    this.field_ADDR_ID2_FK.setSize(0);

    this.field_PHONE = this.table_EMP.addColumn("phone");
    this.field_PHONE.setDatabaseType(this.databasePlatform.databaseTypeNamed("varchar"));
    this.field_PHONE.setSize(20);

    this.field_BOSS_ID_FK = this.table_EMP.addColumn("boss_id");
    this.field_BOSS_ID_FK.setDatabaseType(this.databasePlatform.databaseTypeNamed("integer"));
    this.field_BOSS_ID_FK.setSize(0);

    // ADDR
    this.table_ADDR = this.database.addTable(this.catalogName, this.schemaName, "addr");

    this.field_ADDR_ID1 = this.table_ADDR.addColumn("addr_id1");
    this.field_ADDR_ID1.setDatabaseType(this.databasePlatform.databaseTypeNamed("integer"));
    this.field_ADDR_ID1.setSize(0);
    this.field_ADDR_ID1.setPrimaryKey(true);

    this.field_ADDR_ID2 = this.table_ADDR.addColumn("addr_id2");
    this.field_ADDR_ID2.setDatabaseType(this.databasePlatform.databaseTypeNamed("integer"));
    this.field_ADDR_ID2.setSize(0);
    this.field_ADDR_ID2.setPrimaryKey(true);

    this.field_STREET = this.table_ADDR.addColumn("street");
    this.field_STREET.setSize(20);
    this.field_CITY = this.table_ADDR.addColumn("city");
    this.field_CITY.setSize(20);

    this.field_STATE_ID1_FK = this.table_ADDR.addColumn("state_id1");
    this.field_STATE_ID1_FK.setDatabaseType(this.databasePlatform.databaseTypeNamed("integer"));
    this.field_STATE_ID1_FK.setSize(0);

    this.field_STATE_ID2_FK = this.table_ADDR.addColumn("state_id2");
    this.field_STATE_ID2_FK.setDatabaseType(this.databasePlatform.databaseTypeNamed("integer"));
    this.field_STATE_ID2_FK.setSize(0);

    this.field_ZIP = this.table_ADDR.addColumn("zip");
    this.field_ZIP.setDatabaseType(this.databasePlatform.databaseTypeNamed("varchar"));
    this.field_ZIP.setSize(9);

    // STATE
    this.table_STATE = this.database.addTable(this.catalogName, this.schemaName, "state");
    this.field_STATE_ID1 = this.table_STATE.addColumn("state_id1");
    this.field_STATE_ID1.setDatabaseType(this.databasePlatform.databaseTypeNamed("integer"));
    this.field_STATE_ID1.setSize(0);
    this.field_STATE_ID1.setPrimaryKey(true);

    this.field_STATE_ID2 = this.table_STATE.addColumn("state_id2");
    this.field_STATE_ID2.setDatabaseType(this.databasePlatform.databaseTypeNamed("integer"));
    this.field_STATE_ID2.setSize(0);
    this.field_STATE_ID2.setPrimaryKey(true);

    this.field_STATE_CODE = this.table_STATE.addColumn("code");
    this.field_STATE_CODE.setDatabaseType(this.databasePlatform.databaseTypeNamed("varchar"));
    this.field_STATE_CODE.setSize(2);

    this.field_STATE_NAME = this.table_STATE.addColumn("name");
    this.field_STATE_NAME.setDatabaseType(this.databasePlatform.databaseTypeNamed("varchar"));
    this.field_STATE_NAME.setSize(20);

    // constraints
    this.reference_EMP_ADDR = this.table_EMP.addReference("emp_addr", this.table_ADDR);
    this.reference_EMP_ADDR.setOnDatabase(true);
    this.reference_EMP_ADDR.addColumnPair(this.field_ADDR_ID1_FK, this.field_ADDR_ID1);
    this.reference_EMP_ADDR.addColumnPair(this.field_ADDR_ID2_FK, this.field_ADDR_ID2);

    this.reference_EMP_BOSS = this.table_EMP.addReference("emp_boss", this.table_EMP);
    this.reference_EMP_BOSS.setOnDatabase(true);
    this.reference_EMP_BOSS.addColumnPair(this.field_BOSS_ID_FK, this.field_EMP_ID);

    this.reference_ADDR_STATE = this.table_ADDR.addReference("addr_state", this.table_STATE);
    this.reference_ADDR_STATE.setOnDatabase(true);
    this.reference_ADDR_STATE.addColumnPair(this.field_STATE_ID1_FK, this.field_STATE_ID1);
    this.reference_ADDR_STATE.addColumnPair(this.field_STATE_ID2_FK, this.field_STATE_ID2);
  }