Examples of TableChange

Examples of org.databene.mad4db.cmd.TableChange

87
88
89
90
91
92
93
94
95
96
97
  public void testIndexMadeNonUnique() {
    // given an index which was unique before but is not now
    DBTable table = createTableWithColumns("tbl", 3);
    DBIndex index1 = new DBUniqueIndex("idx", true, new DBUniqueConstraint(table, "uk1", false, "col1"));
    DBIndex index2 = new DBNonUniqueIndex("idx", true, table, "col1");
    TableChange tableChange = new TableChange(table, null);
    // when performing a comparison
    new IndexComparator(config).compareObjects(index1, index2, tableChange);
    // then the result must be an IndexUniquenessChange
    System.out.println(tableChange);
    List<StructuralChange<?>> indexSubChanges = assertSingleSubChangeAndGetItsSubChanges(IndexChange.class,
View Full Code Here

Examples of org.databene.mad4db.cmd.TableChange

104
105
106
107
108
109
110
111
112
113
114
  public void testColumnOrderChanged() {
    // given a table with an index of which the column order changed
    DBTable table = createTableWithColumns("tbl", 2);
    DBIndex index1 = new DBNonUniqueIndex("idx", true, table, "col1", "col2");
    DBIndex index2 = new DBNonUniqueIndex("idx", true, table, "col2", "col1");
    TableChange tableChange = new TableChange(table, null);
    // when performing a comparison
    new IndexComparator(config).compareObjects(index1, index2, tableChange);
    // then the result must be a ColumnOrderChange
    System.out.println(tableChange);
    List<StructuralChange<?>> indexSubChanges = assertSingleSubChangeAndGetItsSubChanges(IndexChange.class,
View Full Code Here

Examples of org.databene.mad4db.cmd.TableChange

121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
  public void testSingleIndexColumnReplaced() {
    // given an index consisting of exactly one column which was replaced in a newer index version
    DBTable table = createTableWithColumns("tbl", 2);
    DBIndex index1 = new DBNonUniqueIndex("idx", true, table, "col1");
    DBIndex index2 = new DBNonUniqueIndex("idx", true, table, "col2");
    TableChange tableChange = new TableChange(table, null);
    // when performing a comparison
    new IndexComparator(config).compareObjects(index1, index2, tableChange);
    // then the result must be deletion of the former index version and creation of the new one
    System.out.println(tableChange);
    List<StructuralChange<?>> indexChanges = tableChange.getSubChanges();
    assertEquals(2, indexChanges.size());
    assertChange(IndexDeletion.class, DBIndex.class, "idx", ChangeSeverity.REORGANIZATION, indexChanges.get(0));
    assertChange(IndexCreation.class, DBIndex.class, "idx", ChangeSeverity.REORGANIZATION, indexChanges.get(1));
  }
View Full Code Here

Examples of org.databene.mad4db.cmd.TableChange

138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
  public void testAllIndexColumnsReplaced() {
    // given an index consisting of two columns which are replaced in a newer index version
    DBTable table = createTableWithColumns("tbl", 4);
    DBIndex index1 = new DBNonUniqueIndex("idx", true, table, "col1", "col2");
    DBIndex index2 = new DBNonUniqueIndex("idx", true, table, "col3", "col4");
    TableChange tableChange = new TableChange(table, null);
    // when performing a comparison
    new IndexComparator(config).compareObjects(index1, index2, tableChange);
    // then the result must be deletion of the former index version and creation of the new one
    System.out.println(tableChange);
    List<StructuralChange<?>> indexChanges = tableChange.getSubChanges();
    assertEquals(2, indexChanges.size());
    assertChange(IndexDeletion.class, DBIndex.class, "idx", ChangeSeverity.REORGANIZATION, indexChanges.get(0));
    assertChange(IndexCreation.class, DBIndex.class, "idx", ChangeSeverity.REORGANIZATION, indexChanges.get(1));
  }
View Full Code Here

Examples of org.databene.mad4db.cmd.TableChange

155
156
157
158
159
160
161
162
163
164
165
  public void testIndexColumnAdded() {
    // given a tbale with an index to which one more column has been added
    DBTable table = createTableWithColumns("tbl", 2);
    DBIndex index1 = new DBNonUniqueIndex("idx", true, table, "col1");
    DBIndex index2 = new DBNonUniqueIndex("idx", true, table, "col1", "col2");
    TableChange tableChange = new TableChange(table, null);
    // when performing a comparison
    new IndexComparator(config).compareObjects(index1, index2, tableChange);
    // then the result must be a ColumnsAddition
    System.out.println(tableChange);
    List<StructuralChange<?>> indexSubChanges = assertSingleSubChangeAndGetItsSubChanges(IndexChange.class,
View Full Code Here

Examples of org.databene.mad4db.cmd.TableChange

172
173
174
175
176
177
178
179
180
181
182
  public void testIndexColumnRemoved() {
    // given a table with an index of which one column was removed
    DBTable table = createTableWithColumns("tbl", 2);
    DBIndex index1 = new DBNonUniqueIndex("idx", true, table, "col1", "col2");
    DBIndex index2 = new DBNonUniqueIndex("idx", true, table, "col1");
    TableChange tableChange = new TableChange(table, null);
    // when performing a comparison
    new IndexComparator(config).compareObjects(index1, index2, tableChange);
    // then the result must be a ColumnsRemoval
    System.out.println(tableChange);
    List<StructuralChange<?>> indexSubChanges = assertSingleSubChangeAndGetItsSubChanges(IndexChange.class,
View Full Code Here

Examples of org.databene.mad4db.cmd.TableChange

48
49
50
51
52
53
54
55
56
57
58
59
    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);
    List<StructuralChange<?>> subChanges = tableChange.getSubChanges();
    assertEquals(0, subChanges.size());
  }
View Full Code Here

Examples of org.databene.mad4db.cmd.TableChange

64
65
66
67
68
69
70
71
72
73
74
    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);
    List<StructuralChange<?>> subChanges = assertSingleSubChangeAndGetItsSubChanges(
        ColumnChange.class, DBColumn.class, "col1", ChangeSeverity.RESTRICTION, tableChange);
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.