Package org.databene.mad4db.cmd

Examples of org.databene.mad4db.cmd.SchemaChange

50
51
52
53
54
55
56
57
58
59
60
  }
 
  // interface -------------------------------------------------------------------------------------------------------

  public SchemaChange compare(Database db1, Database db2) {
    SchemaChange change = new SchemaChange(config);
    compareTables(db1, db2, change);
    if (!config.isIgnoringSequences())
      compareSequences(db1, db2, change);
    compareTriggers(db1, db2, change);
    comparePackages(db1, db2, change);
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
56
public class TableCreationValuatorTest {

  @Test
  public void testNewMandatoryFkInOldTableReferencesNewTable() {
    // given a new table which will be referenced by a new mandatory FK in an old table
    SchemaChange schemaChange = createSchemaChange(false);
    // when performing check
    new TableCreationValuator().process(schemaChange);
    // then expect AUGMENTAION
    assertEquals(ChangeSeverity.AUGMENTATION, schemaChange.getSubChange(TableCreation.class, "referee").getSeverity());
    assertEquals(ChangeSeverity.AUGMENTATION, schemaChange.getSubChange(ForeignKeyConstraintCreation.class, "new_fk").getSeverity());
  }
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
67
  }

  @Test
  public void testNewOptionalFkInOldTableReferencesNewTable() {
    // given a new table which will be referenced by a new optional FK in an old table
    SchemaChange schemaChange = createSchemaChange(true);
    // when performing check
    new TableCreationValuator().process(schemaChange);
    // then expect EXTENSION
    assertEquals(ChangeSeverity.EXTENSION, schemaChange.getSubChange(TableCreation.class, "referee").getSeverity());
    assertEquals(ChangeSeverity.RESTRICTION, schemaChange.getSubChange(ForeignKeyConstraintCreation.class, "new_fk").getSeverity());
  }
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
71
72
  @Test
  public void testUnchanged() {
    // given two identical table versions
    DBTable table1 = createTableWithColumns("tbl", 3);
    DBTable table2 = createTableWithColumns("tbl", 3);
    SchemaChange schemaChange = new SchemaChange(config);
    // when comparing the tables
    new TableComparator(config).compareObjects(table1, table2, schemaChange);
    // then the result must be empty
    System.out.println(schemaChange);
    List<StructuralChange<?>> tableChanges = schemaChange.getSubChanges();
    assertEquals(0, tableChanges.size());
  }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
    assertEquals(ChangeSeverity.EXTENSION, schemaChange.getSubChange(TableCreation.class, "referee").getSeverity());
    assertEquals(ChangeSeverity.RESTRICTION, schemaChange.getSubChange(ForeignKeyConstraintCreation.class, "new_fk").getSeverity());
  }

  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
74
75
76
77
78
79
80
81
82
83
84
  @Test
  public void testColumnsAdded() {
    // given a table which got two additional columns
    DBTable table1 = createTableWithColumns("tbl", 2);
    DBTable table2 = createTableWithColumns("tbl", 4);
    SchemaChange schemaChange = new SchemaChange(config);
    // when comparing the tables
    new TableComparator(config).compareObjects(table1, table2, schemaChange);
    // then the result must be two ColumnCreations
    System.out.println(schemaChange);
    List<StructuralChange<?>> tableChanges = assertSingleSubChangeAndGetItsSubChanges(TableChange.class, DBTable.class, "tbl", ChangeSeverity.EXTENSION, schemaChange);
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
  @Test
  public void testColumnsRemoved() {
    // given a table of which two columns were removed
    DBTable table1 = createTableWithColumns("tbl", 4);
    DBTable table2 = createTableWithColumns("tbl", 2);
    SchemaChange schemaChange = new SchemaChange(config);
    // when comparing the tables
    new TableComparator(config).compareObjects(table1, table2, schemaChange);
    // then the result must be two ColumnDeletions
    System.out.println(schemaChange);
    List<StructuralChange<?>> tableChanges = assertSingleSubChangeAndGetItsSubChanges(TableChange.class, DBTable.class, "tbl", ChangeSeverity.DELETION, schemaChange);
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
  @Test
  public void testColumnOrderChanged() {
    // given a table in which the column order was reversed
    DBTable table1 = createTableWithColumns("tbl", 3);
    DBTable table2 = createTableWithColumns("tbl", "col3", "col2", "col1");
    SchemaChange schemaChange = new SchemaChange(config);
    // when comparing the tables
    new TableComparator(config).compareObjects(table1, table2, schemaChange);
    // then the result must be a ColumnOrderChange
    System.out.println(schemaChange);
    List<StructuralChange<?>> tableChanges = assertSingleSubChangeAndGetItsSubChanges(TableChange.class, DBTable.class, "tbl", ChangeSeverity.REORGANIZATION, schemaChange);
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
  public void testColumnsRemovedAddedAndReordered() {
    // given a table in which the the first column (col1) is removed,
    // col2 and col3 swapped and a new column (col4) appended
    DBTable table1 = createTableWithColumns("tbl", "col1", "col2", "col3");
    DBTable table2 = createTableWithColumns("tbl", "col3", "col2", "col4");
    SchemaChange schemaChange = new SchemaChange(config);
    // when comparing the tables
    new TableComparator(config).compareObjects(table1, table2, schemaChange);
    // then the result must be a ColumnOrderChange
    System.out.println(schemaChange);
    List<StructuralChange<?>> tableChanges = assertSingleSubChangeAndGetItsSubChanges(TableChange.class, DBTable.class, "tbl", ChangeSeverity.EXTENSION, schemaChange);
View Full Code Here
140
141
142
143
144
145
146
147
148
149
150
  public void testPKCreated() {
    // given a table to which a primary key was added
    DBTable table1 = createTableWithColumns("tbl", 2);
    DBTable table2 = createTableWithColumns("tbl", 2);
    new DBPrimaryKeyConstraint(table2, "pk1", false, "col1");
    SchemaChange schemaChange = new SchemaChange(config);
    // when comparing the tables
    new TableComparator(config).compareObjects(table1, table2, schemaChange);
    // then the result must be an primary key creation creation
    System.out.println(schemaChange);
    List<StructuralChange<?>> tableChanges = assertSingleSubChangeAndGetItsSubChanges(TableChange.class, DBTable.class, "tbl", ChangeSeverity.RESTRICTION, schemaChange);
View Full Code Here
TOP

Related Classes of org.databene.mad4db.cmd.SchemaChange

  • org.databene.mad4db.compare.SchemaComparator
  • org.databene.mad4db.compare.SchemaComparatorTest
  • org.databene.mad4db.compare.TableComparatorTest
  • org.databene.mad4db.Mad4DB
  • 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.