Revision 46494 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.h2spatial/org.gvsig.h2spatial.h2gis132/org.gvsig.h2spatial.h2gis132.provider/src/test/java/org/gvsig/fmap/dal/store/h2/operations/sql/TestCreateTable.java

View differences:

TestCreateTable.java
37 37
  // public void testHello() {}
38 38
  
39 39
  public void testCreateTable() throws Exception {
40
    JDBCHelper helper = TestUtils.createJDBCHelper();
41
    JDBCSQLBuilderBase sqlbuilder = helper.createSQLBuilder();
42
    OperationsFactory operations = helper.getOperations();
40
      try {
41
        JDBCHelper helper = TestUtils.createJDBCHelper();
42
        JDBCSQLBuilderBase sqlbuilder = helper.createSQLBuilder();
43
        OperationsFactory operations = helper.getOperations();
43 44

  
44
    List<String> expectedSQLs = TestUtils.getSQLs("createTable.sql");
45
    
46
    FeatureStore sourceStore = TestUtils.openSourceStore1();
45
        List<String> expectedSQLs = TestUtils.getSQLs("createTable.sql");
47 46

  
48
    TableReference table = operations.createTableReference(
49
            "dbtest", 
50
            sqlbuilder.default_schema(), 
51
            "test", 
52
            null
53
    );
54
    FeatureType featureType = sourceStore.getDefaultFeatureType();
55
    CreateTableOperation createTable = operations.createTable(
56
            table,
57
            featureType,
58
            null,
59
            null
60
    );
61
    List<String> SQLs = createTable.getSQLs();
62
    assertEquals("CreateTable num. SQLs", expectedSQLs.size(), SQLs.size());
63
    for (int i = 0; i < expectedSQLs.size(); i++) {
64
      assertEquals("CreateTable SQL "+i, expectedSQLs.get(i), SQLs.get(i));
65
    }
47
        FeatureStore sourceStore = TestUtils.openSourceStore1();
66 48

  
49
        TableReference table = operations.createTableReference(
50
                "dbtest", 
51
                sqlbuilder.default_schema(), 
52
                "test", 
53
                null
54
        );
55
        FeatureType featureType = sourceStore.getDefaultFeatureType();
56
        CreateTableOperation createTable = operations.createTable(
57
                table,
58
                featureType,
59
                null,
60
                null
61
        );
62
        List<String> SQLs = createTable.getSQLs();
63
        assertEquals("CreateTable num. SQLs", expectedSQLs.size(), SQLs.size());
64
        for (int i = 0; i < expectedSQLs.size(); i++) {
65
          assertEquals("CreateTable SQL "+i, expectedSQLs.get(i), SQLs.get(i));
66
        }
67
      } catch(Exception ex) {
68
          LOGGER.warn("Error",ex);
69
          throw ex;
70
      }
67 71
  }
68 72

  
69 73
}

Also available in: Unified diff