Package org.apache.ddlutils.model

Examples of org.apache.ddlutils.model.Database

47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
            "  </table>\n"+
            "</database>";

        TestPlatform platform   = new TestPlatform();
        SqlBuilder   sqlBuilder = platform.getSqlBuilder();
        Database     database   = parseDatabaseFromString(modelXml);
        Map          map        = new HashMap();

        map.put("name", "ddlutils");
        map.put("id", new Integer(0));

        platform.setDelimitedIdentifierModeOn(true);
       
        String sql = sqlBuilder.getUpdateSql(database.getTable(0), map, false);

        assertEquals("UPDATE \"TestTable\" SET \"name\" = 'ddlutils' WHERE \"id\" = '0'",
                     sql);
    }
View Full Code Here
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
            "    <column name='ColPK' type='INTEGER' primaryKey='true' required='true'/>\n" +
            "    <column name='Col' type='INTEGER' default='0'/>\n" +
            "  </table>\n" +
            "</database>";

        Database model1  = parseDatabaseFromString(MODEL1);
        Database model2  = parseDatabaseFromString(MODEL2);
        List     changes = createModelComparator(true).compare(model1, model2);

        assertEquals(1,
                     changes.size());
View Full Code Here
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
            "    <column name='COLPK' type='INTEGER' primaryKey='true' required='true'/>\n" +
            "    <column name='COL' type='INTEGER' required='true'/>\n" +
            "  </table>\n" +
            "</database>";

        Database model1  = parseDatabaseFromString(MODEL1);
        Database model2  = parseDatabaseFromString(MODEL2);
        List     changes = createModelComparator(false).compare(model1, model2);

        assertEquals(1,
                     changes.size());
View Full Code Here
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
            "    <column name='COLPK' type='INTEGER' primaryKey='true' required='true'/>\n" +
            "    <column name='COL' type='INTEGER' autoIncrement='false'/>\n" +
            "  </table>\n" +
            "</database>";

        Database model1  = parseDatabaseFromString(MODEL1);
        Database model2  = parseDatabaseFromString(MODEL2);
        List     changes = createModelComparator(false).compare(model1, model2);

        assertEquals(1,
                     changes.size());
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
75
    /**
     * Test the toColumnValues method.
     */
    public void testToColumnValues()
    {
        Database         database = parseDatabaseFromString(TESTED_MODEL);
        PlatformImplBase platform = new TestPlatform();
        Table            table    = database.getTable(0);
        SqlDynaClass     clz      = SqlDynaClass.newInstance(table);
        DynaBean         db       = new SqlDynaBean(SqlDynaClass.newInstance(table));

        db.set("name", "name");

View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
107
108
    /**
     * Tests the column constraints.
     */
    public void testColumnConstraints() throws Exception
    {
        Database testDb = parseDatabaseFromString(COLUMN_CONSTRAINT_TEST_SCHEMA);

        testDb.findTable("constraints").findColumn("COL_AUTO_INCR").setAutoIncrement(false);
        testDb.findTable("constraints").findColumn("COL_PK_AUTO_INCR").setAutoIncrement(false);

        getPlatform().setSqlCommentsOn(false);
        getPlatform().getSqlBuilder().createTables(testDb, true);

        assertEqualsIgnoringWhitespaces(
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
    /**
     * Tests the usage of creation parameters.
     */
    public void testCreationParameters1() throws Exception
    {
        Database testDb = parseDatabaseFromString(COLUMN_CONSTRAINT_TEST_SCHEMA);

        testDb.findTable("constraints").findColumn("COL_AUTO_INCR").setAutoIncrement(false);
        testDb.findTable("constraints").findColumn("COL_PK_AUTO_INCR").setAutoIncrement(false);

        CreationParameters params = new CreationParameters();

        params.addParameter(testDb.getTable(0),
                            "ROW_FORMAT",
                            "COMPRESSED");
        params.addParameter(null,
                            "ENGINE",
                            "INNODB");
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
96
    /**
     * Tests the column constraints.
     */
    public void testColumnConstraints() throws Exception
    {
        Database           testDb = parseDatabaseFromString(COLUMN_CONSTRAINT_TEST_SCHEMA);
        testDb.findTable("constraints").findColumn("COL_AUTO_INCR").setAutoIncrement(false);
        testDb.findTable("constraints").findColumn("COL_PK_AUTO_INCR").setAutoIncrement(false);

        getPlatform().setSqlCommentsOn(false);
        getPlatform().getSqlBuilder().createTables(testDb, true);

        assertEqualsIgnoringWhitespaces(
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
    /**
     * Tests the usage of creation parameters.
     */
    public void testCreationParameters1() throws Exception
    {
        Database           testDb = parseDatabaseFromString(COLUMN_CONSTRAINT_TEST_SCHEMA);
        testDb.findTable("constraints").findColumn("COL_AUTO_INCR").setAutoIncrement(false);
        testDb.findTable("constraints").findColumn("COL_PK_AUTO_INCR").setAutoIncrement(false);
        CreationParameters params = new CreationParameters();

        params.addParameter(testDb.getTable(0),
                            "ROW_FORMAT",
                            "COMPRESSED");
        params.addParameter(null,
                            "ENGINE",
                            "INNODB");
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
83
            "  <table name='TABLEB'>\n" +
            "    <column name='COLPK' type='INTEGER' primaryKey='true' required='true'/>\n" +
            "  </table>\n" +
            "</database>";

        Database model1  = parseDatabaseFromString(MODEL1);
        Database model2  = parseDatabaseFromString(MODEL2);
        List     changes = createModelComparator(false).compare(model1, model2);

        assertEquals(1,
                     changes.size());
View Full Code Here
TOP

Related Classes of org.apache.ddlutils.model.Database

  • atg.tools.dynunit.adapter.gsa.GSARepositorySchemaGenerator
  • org.apache.commons.lang.builder.EqualsBuilder
  • org.apache.commons.lang.builder.HashCodeBuilder
  • org.apache.ddlutils.alteration.TestAlterationAlgorithm
  • org.apache.ddlutils.alteration.TestModelComparator
  • org.apache.ddlutils.dynabean.DynaClassCache
  • org.apache.ddlutils.io.DatabaseIO
  • org.apache.ddlutils.io.RoundtripTestBase
  • org.apache.ddlutils.io.TestAlteration
  • org.apache.ddlutils.io.TestConstraints
    • 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.