Package org.databene.jdbacl.model

Examples of org.databene.jdbacl.model.DBColumn

68
69
70
71
72
73
74
75
76
77
78
79
  private SchemaChange createSchemaChange(boolean nullableFk) {
    SchemaChange schemaChange = new SchemaChange(new ComparisonConfig(null, null, null));
    DBTable refereeTable = new DBTable("referee");
    DBTable refererTable = new DBTable("referer");
    DBColumn fkColumn = new DBColumn("ref", refererTable, DBDataType.getInstance(Types.INTEGER, "int"));
    fkColumn.setNullable(nullableFk);
    refereeTable.addColumn(fkColumn);
    schemaChange.addSubChange(new TableCreation(refereeTable));
    DBForeignKeyConstraint fk = new DBForeignKeyConstraint("new_fk", true, refererTable, new String[] { "ref" }, refereeTable, new String[] { "id" });
    schemaChange.addSubChange(new ForeignKeyConstraintCreation(fk));
    return schemaChange;
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
public class ChangeByAffectedObjectFilterTest {
 
  @Test
  public void testNotNullConstraintCreation() {
    DBTable oldTable = new DBTable("T");
    DBColumn oldColumn = new DBColumn("C1", oldTable, DBDataType.getInstance("INTEGER"));
    DBColumn oldColumn2 = new DBColumn("C2", oldTable, DBDataType.getInstance("INTEGER"));
   
    DBTable newTable = new DBTable("T");
    DBColumn newColumn = new DBColumn("C1", newTable, DBDataType.getInstance("INTEGER"));
    DBColumn newColumn2 = new DBColumn("C2", newTable, DBDataType.getInstance("INTEGER"));
    DBNotNullConstraint constraint = new DBNotNullConstraint(newTable, "T_C1_NOT_NULL", true, "C1");
    newColumn.setNotNullConstraint(constraint);
   
    NotNullConstraintCreation constraintCreation = new NotNullConstraintCreation(constraint);
    ColumnChange columnChange = new ColumnChange(newColumn);
View Full Code Here
42
43
44
45
46
47
48
49
50
    checkSeverity("NUMBER", 6, null, "NUMBER", 6, 3, ChangeSeverity.EASE);
  }

  private void checkSeverity(String oldType, Integer oldSize, Integer oldFractionDigits,
      String newType, Integer newSize, Integer newFractionDigits, ChangeSeverity expectedSeverity) {
    DBColumn oldColumn = new DBColumn("VAL", null, DBDataType.getInstance(1, oldType), oldSize, oldFractionDigits);
    ColumnTypeChange change = new ColumnTypeChange(oldColumn, DBDataType.getInstance(1, newType), newSize, newFractionDigits);
    assertEquals(expectedSeverity, change.getSeverity());
  }
View Full Code Here
75
76
77
78
79
80
81
      createIntColumn(columnNames[i], table);
    return table;
  }

  protected DBColumn createIntColumn(String name, DBTable table) {
    return new DBColumn(name, table, DBDataType.getInstance(Types.INTEGER, "INT"));
  }
View Full Code Here
79
80
81
82
83
84
85
  protected DBColumn createIntColumn(String name, DBTable table) {
    return new DBColumn(name, table, DBDataType.getInstance(Types.INTEGER, "INT"));
  }

  protected DBColumn createVarcharColumn(String name, DBTable table) {
    return new DBColumn(name, table, DBDataType.getInstance(Types.VARCHAR, "VARCHAR"));
  }
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
56
 
  @Test
  public void testUnchanged() {
    // given a column that did not change
    DBTable table1 = new DBTable("tbl");
    DBColumn col1 = createIntColumn("col1", table1);
    DBTable table2 = new DBTable("tbl");
    DBColumn col2 = createIntColumn("col1", table2);
    // when performing a comparison
    TableChange tableChange = new TableChange(table1, null);
    new TableColumnComparator(config).compareObjects(col1, col2, tableChange);
    // then the result must be empty
    System.out.println(tableChange);
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
71
72
  @Test
  public void testTypeChangedFromVarcharToInt() {
    // given a column that of which the type changed from int to varchar(1)
    DBTable table1 = new DBTable("tbl");
    DBColumn col1 = createVarcharColumn("col1", table1);
    DBTable table2 = new DBTable("tbl");
    DBColumn col2 = createIntColumn("col1", table2);
    // when performing a comparison
    TableChange tableChange = new TableChange(table1, null);
    new TableColumnComparator(config).compareObjects(col1, col2, tableChange);
    // then the result must be empty
    System.out.println(tableChange);
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
    super(constraint, "created " + constraint.getObjectType(), MadUtil.details(constraint));
  }

  public boolean createCheck(SimpleXMLWriter writer) {
    DBTable table = affectedObject.getTable();
    DBColumn column = table.getColumn(affectedObject.getColumnNames()[0]);
    checkName = "NOT NULL " + table.getName() + "." + column.getName();
    CheckDefinitionUtil.renderNotNullCheck(checkName,
        table.getName(), column.getName(),
        Mad4DB.APP_INFO, "not-null", "migration", writer);
    return true;
  }
View Full Code Here
TOP

Related Classes of org.databene.jdbacl.model.DBColumn

  • org.databene.mad4db.ChangeByAffectedObjectFilterTest
  • org.databene.mad4db.cmd.ColumnTypeChangeTest
  • org.databene.mad4db.cmd.NotNullConstraintCreation
  • org.databene.mad4db.compare.AbstractComparatorTest
  • org.databene.mad4db.compare.TableColumnComparatorTest
  • org.databene.mad4db.proc.TableCreationValuatorTest
    • Copyright © 2018 www.massapicom. 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.