Package org.databene.jdbacl.model

Examples of org.databene.jdbacl.model.DBTable

118
119
120
121
122
123
124
125
126
127
128
  }

  @Test
  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);
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
  }

  @Test
  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);
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
  }
 
  @Test
  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);
View Full Code Here
169
170
171
172
173
174
175
176
177
178
179
  }

  @Test
  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);
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
54
55
public class TableColumnComparatorTest extends AbstractComparatorTest {
 
  @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
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
70
71
  }

  @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
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
  public void testUnchanged() {
    // given two identical table versions
    Database db1 = new Database("db1", "hsql", "1.5.8", null);
    DBCatalog cat1 = new DBCatalog("cat1", db1);
    DBSchema schema1 = new DBSchema("public", cat1);
    DBTable table1 = createTableWithColumns("tbl", 3);
    schema1.addTable(table1);

    Database db2 = new Database("db1", "hsql", "1.5.8", null);
    DBCatalog cat2 = new DBCatalog("cat2", db2);
    DBSchema schema2 = new DBSchema("public", cat2);
    DBTable table2 = createTableWithColumns("tbl", 3);
    schema2.addTable(table2);
   
    // when comparing the tables
    SchemaChange schemaChange = new SchemaComparator(config).compare(db1, db2);
   
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
82
  }

  @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);
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
  }

  @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);
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
52
53
  public NotNullConstraintCreation(DBNotNullConstraint constraint) {
    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.DBTable

  • org.databene.mad4db.ChangeByAffectedObjectFilterTest
  • org.databene.mad4db.cmd.NotNullConstraintCreation
  • org.databene.mad4db.compare.AbstractComparatorTest
  • org.databene.mad4db.compare.IndexComparatorTest
  • org.databene.mad4db.compare.SchemaComparatorTest
  • org.databene.mad4db.compare.TableColumnComparatorTest
  • org.databene.mad4db.compare.TableComparatorTest
  • org.databene.mad4db.proc.TableCreationValuatorTest
  • org.databene.mad4db.report.html.PriorityReporter
  • org.databene.mad4db.report.html.TableDetailsExporter
    • 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.