コード例 #1
0
  private void checkOtherTable(Schema schema, Table otherTable) {
    assertNotNull("Couldn't find table export_test_other", otherTable);
    assertSame("Incorrect parent or no parent set", schema, otherTable.getParent());

    Iterator<Column> colIt = otherTable.getColumns().iterator();
    Column col = colIt.next();
    assertSame("Incorrect parent or no parent set", otherTable, col.getParent());
    assertEquals("id", col.getName());
    assertEquals("bigint", col.getType());
    assertEquals(false, col.isNullable());
    assertEquals(1, col.getOrder());
    assertEquals(false, col.isAutoIncrement());

    col = colIt.next();
    assertSame("Incorrect parent or no parent set", otherTable, col.getParent());
    assertEquals("version", col.getName());
    assertEquals("bigint", col.getType());
    assertEquals(false, col.isNullable());
    assertEquals(2, col.getOrder());

    col = colIt.next();
    assertSame("Incorrect parent or no parent set", otherTable, col.getParent());
    assertEquals("ex_id", col.getName());
    assertEquals("bigint", col.getType());
    assertEquals(false, col.isNullable());
    assertEquals(3, col.getOrder());

    col = colIt.next();
    assertSame("Incorrect parent or no parent set", otherTable, col.getParent());
    assertSame("Incorrect parent or no parent set", otherTable, col.getParent());
    assertEquals("local_name", col.getName());
    assertEquals("varchar(200)", col.getType());
    assertEquals(false, col.isNullable());
    assertEquals(4, col.getOrder());

    assertEquals(2, otherTable.getIndexes().size());
    Iterator<Index> indexIt = otherTable.getIndexes().iterator();

    Index index = indexIt.next();
    assertSame("Incorrect parent or no parent set", otherTable, index.getParent());
    assertEquals("export_test_idx_other_1", index.getName());
    assertEquals(true, index.isUnique());
    assertEquals(2, index.getColumnNames().size());
    assertEquals("ex_id", index.getColumnNames().get(0));
    assertEquals("local_name", index.getColumnNames().get(1));

    index = indexIt.next();
    assertSame("Incorrect parent or no parent set", otherTable, index.getParent());
    assertEquals("export_test_idx_other_2", index.getName());
    assertEquals(1, index.getColumnNames().size());
    assertEquals("ex_id", index.getColumnNames().get(0));

    PrimaryKey pk = otherTable.getPrimaryKey();
    assertSame("Incorrect parent or no parent set", otherTable, pk.getParent());
    assertEquals("id", pk.getColumnNames().get(0));
    assertEquals(1, pk.getColumnOrders().get(0).intValue());

    assertEquals(1, otherTable.getForeignKeys().size());
    ForeignKey fk = otherTable.getForeignKeys().get(0);
    assertSame("Incorrect parent or no parent set", otherTable, fk.getParent());
    assertEquals("export_test_fk_example", fk.getName());
    assertEquals("ex_id", fk.getLocalColumn());
    assertEquals("export_test_example", fk.getTargetTable());
    assertEquals("id", fk.getTargetColumn());
  }
コード例 #2
0
  private void checkExampleTable(Schema schema, Table exampleTable) {
    assertNotNull("Couldn't find export_test_example", exampleTable);

    assertSame("Incorrect parent or no parent set", schema, exampleTable.getParent());
    assertEquals("export_test_example", exampleTable.getName());
    Iterator<Column> colIt = exampleTable.getColumns().iterator();
    Column col = colIt.next();
    assertSame("Incorrect parent or no parent set", exampleTable, col.getParent());
    assertEquals("id", col.getName());
    assertEquals("bigint", col.getType());
    assertEquals(false, col.isNullable());
    assertEquals(1, col.getOrder());
    assertEquals(true, col.isAutoIncrement());

    col = colIt.next();
    assertSame("Incorrect parent or no parent set", exampleTable, col.getParent());
    assertEquals("description", col.getName());
    assertEquals("text", col.getType());
    assertEquals(true, col.isNullable());
    assertEquals(2, col.getOrder());

    col = colIt.next();
    assertSame("Incorrect parent or no parent set", exampleTable, col.getParent());
    assertEquals("fixes_from_schema", col.getName());
    assertEquals("int", col.getType());
    assertEquals(true, col.isNullable());
    assertEquals(3, col.getOrder());

    col = colIt.next();
    assertSame("Incorrect parent or no parent set", exampleTable, col.getParent());
    assertEquals("fixes_to_schema", col.getName());
    assertEquals("int", col.getType());
    assertEquals(true, col.isNullable());
    assertEquals(4, col.getOrder());

    col = colIt.next();
    assertSame("Incorrect parent or no parent set", exampleTable, col.getParent());
    assertEquals("applied_to_schema", col.getName());
    assertEquals("int", col.getType());
    assertEquals(true, col.isNullable());
    assertEquals(5, col.getOrder());

    col = colIt.next();
    assertSame("Incorrect parent or no parent set", exampleTable, col.getParent());
    assertEquals("target_schema", col.getName());
    assertEquals("int", col.getType());
    assertEquals(true, col.isNullable());
    assertEquals(6, col.getOrder());

    col = colIt.next();
    assertSame("Incorrect parent or no parent set", exampleTable, col.getParent());
    assertEquals("applied_on_date", col.getName());
    assertEquals("datetime", col.getType());
    assertEquals(true, col.isNullable());
    assertEquals(7, col.getOrder());

    col = colIt.next();
    assertSame("Incorrect parent or no parent set", exampleTable, col.getParent());
    assertEquals("applied_to_server", col.getName());
    assertEquals("varchar(64)", col.getType());
    assertEquals(true, col.isNullable());
    assertEquals(8, col.getOrder());

    col = colIt.next();
    assertSame("Incorrect parent or no parent set", exampleTable, col.getParent());
    assertEquals("was_executed", col.getName());
    assertEquals("bit", col.getType());
    assertEquals(true, col.isNullable());
    assertEquals(9, col.getOrder());

    col = colIt.next();
    assertSame("Incorrect parent or no parent set", exampleTable, col.getParent());
    assertEquals("succeeded", col.getName());
    assertEquals("bit", col.getType());
    assertEquals(true, col.isNullable());
    assertEquals(10, col.getOrder());

    col = colIt.next();
    assertSame("Incorrect parent or no parent set", exampleTable, col.getParent());
    assertEquals("report", col.getName());
    assertEquals("text", col.getType());
    assertEquals(true, col.isNullable());
    assertEquals(11, col.getOrder());

    PrimaryKey pk = exampleTable.getPrimaryKey();
    assertSame("Incorrect parent or no parent set", exampleTable, pk.getParent());
    assertEquals("id", pk.getColumnNames().get(0));
    assertEquals(1, pk.getColumnOrders().get(0).intValue());
  }