| package org.apache.ddlutils.io; | |
| /* | |
| * Licensed to the Apache Software Foundation (ASF) under one | |
| * or more contributor license agreements. See the NOTICE file | |
| * distributed with this work for additional information | |
| * regarding copyright ownership. The ASF licenses this file | |
| * to you under the Apache License, Version 2.0 (the | |
| * "License"); you may not use this file except in compliance | |
| * with the License. You may obtain a copy of the License at | |
| * | |
| * http://www.apache.org/licenses/LICENSE-2.0 | |
| * | |
| * Unless required by applicable law or agreed to in writing, | |
| * software distributed under the License is distributed on an | |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY | |
| * KIND, either express or implied. See the License for the | |
| * specific language governing permissions and limitations | |
| * under the License. | |
| */ | |
| import java.util.List; | |
| import junit.framework.Test; | |
| import org.apache.commons.beanutils.DynaBean; | |
| import org.apache.commons.lang.StringUtils; | |
| import org.apache.ddlutils.DdlUtilsException; | |
| import org.apache.ddlutils.TestAgainstLiveDatabaseBase; | |
| import org.apache.ddlutils.model.CascadeActionEnum; | |
| import org.apache.ddlutils.model.Database; | |
| import org.apache.ddlutils.platform.sybase.SybasePlatform; | |
| /** | |
| * Performs the constraint tests. | |
| * | |
| * @version $Revision: 289996 $ | |
| */ | |
| public class TestConstraints extends TestAgainstLiveDatabaseBase | |
| { | |
| /** | |
| * Parameterized test case pattern. | |
| * | |
| * @return The tests | |
| */ | |
| public static Test suite() throws Exception | |
| { | |
| return getTests(TestConstraints.class); | |
| } | |
| /** | |
| * Tests a nullable column. Basically we're creating the test database | |
| * and then read it back and compare the original with the read one. | |
| * In addition we can also check that DdlUtils does not try to alter the new | |
| * database when using the <code>alterTables</code>/<code>getAlterTablesSql</code> | |
| * methods of the {@link org.apache.ddlutils.Platform} with the read-back model. | |
| * | |
| * @param modelXml The model to be tested in XML form | |
| * @param checkAlteration Whether to also check the alter tables sql | |
| */ | |
| protected void performConstraintsTest(String modelXml, boolean checkAlteration) | |
| { | |
| createDatabase(modelXml); | |
| Database modelFromDb = readModelFromDatabase("roundtriptest"); | |
| assertEquals(getAdjustedModel(), | |
| modelFromDb); | |
| if (checkAlteration) | |
| { | |
| String alterTablesSql = getAlterTablesSql(modelFromDb).trim(); | |
| assertTrue(alterTablesSql.length() == 0); | |
| } | |
| } | |
| /** | |
| * Tests a table name that is longer than the maximum allowed. | |
| */ | |
| public void testLongTableName() | |
| { | |
| if (getSqlBuilder().getMaxTableNameLength() == -1) | |
| { | |
| return; | |
| } | |
| String tableName = StringUtils.repeat("Test", (getSqlBuilder().getMaxTableNameLength() / 4) + 3); | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='" + tableName + "'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='INTEGER' required='false'/>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| } | |
| /** | |
| * Tests a column name that is longer than the maximum allowed. | |
| */ | |
| public void testLongColumnName() | |
| { | |
| if (getPlatformInfo().getMaxColumnNameLength() == -1) | |
| { | |
| return; | |
| } | |
| String columnName = StringUtils.repeat("Test", (getSqlBuilder().getMaxColumnNameLength() / 4) + 3); | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='lengthtest'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='" + columnName + "' type='INTEGER' required='false'/>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| } | |
| /** | |
| * Tests a constraint name that is longer than the maximum allowed. | |
| */ | |
| public void testLongConstraintName() | |
| { | |
| if (getSqlBuilder().getMaxConstraintNameLength() == -1) | |
| { | |
| return; | |
| } | |
| String constraintName = StringUtils.repeat("Test", (getSqlBuilder().getMaxConstraintNameLength() / 4) + 3); | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='DOUBLE'/>\n"+ | |
| " <index name='" + constraintName + "'>\n"+ | |
| " <index-column name='avalue'/>\n"+ | |
| " </index>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| } | |
| /** | |
| * Tests a foreign key name that is longer than the maximum allowed. | |
| */ | |
| public void testLongForeignKeyName() | |
| { | |
| if (getSqlBuilder().getMaxForeignKeyNameLength() == -1) | |
| { | |
| return; | |
| } | |
| String fkName = StringUtils.repeat("Test", (getSqlBuilder().getMaxForeignKeyNameLength() / 4) + 3); | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip_1'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " </table>\n"+ | |
| " <table name='roundtrip_2'>\n"+ | |
| " <column name='pk' type='VARCHAR' size='32' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='INTEGER' required='true'/>\n"+ | |
| " <foreign-key name='" + fkName + "' foreignTable='roundtrip_1'>\n"+ | |
| " <reference local='avalue' foreign='pk'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| } | |
| /** | |
| * Tests a nullable column. | |
| */ | |
| public void testNullableColumn() | |
| { | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='INTEGER' required='false'/>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| } | |
| /** | |
| * Tests a not-nullable column. | |
| */ | |
| public void testNotNullableColumn() | |
| { | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='VARCHAR' required='true'/>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| } | |
| /** | |
| * Tests an auto-increment INTEGER column. | |
| */ | |
| public void testAutoIncrementIntegerColumn() | |
| { | |
| // only test this if the platform supports it | |
| if (!getPlatformInfo().isNonPrimaryKeyIdentityColumnsSupported()) | |
| { | |
| return; | |
| } | |
| // we need special catering for Sybase which does not support identity for INTEGER columns | |
| final String modelXml; | |
| if (SybasePlatform.DATABASENAME.equals(getPlatform().getName())) | |
| { | |
| modelXml = "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='NUMERIC' size='12,0' required='true' autoIncrement='true'/>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| } | |
| else | |
| { | |
| modelXml = "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='INTEGER' required='true' autoIncrement='true'/>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| } | |
| performConstraintsTest(modelXml, | |
| getPlatformInfo().getIdentityStatusReadingSupported()); | |
| } | |
| /** | |
| * Tests an auto-increment primary key column. | |
| */ | |
| public void testPrimaryKeyAutoIncrementColumn() | |
| { | |
| // we need special catering for Sybase which does not support identity for INTEGER columns | |
| final String modelXml; | |
| if (SybasePlatform.DATABASENAME.equals(getPlatform().getName())) | |
| { | |
| modelXml = "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip'>\n"+ | |
| " <column name='pk' type='NUMERIC' size='12,0' primaryKey='true' required='true' autoIncrement='true'/>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| } | |
| else | |
| { | |
| modelXml = "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true' autoIncrement='true'/>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| } | |
| performConstraintsTest(modelXml, | |
| getPlatformInfo().getIdentityStatusReadingSupported()); | |
| } | |
| /** | |
| * Test for DDLUTILS-199. | |
| */ | |
| public void testAutoIncrementPrimaryKeyWithUnderscoreInName() | |
| { | |
| // we need special catering for Sybase which does not support identity for INTEGER columns | |
| final String modelXml; | |
| if (SybasePlatform.DATABASENAME.equals(getPlatform().getName())) | |
| { | |
| modelXml = "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip'>\n"+ | |
| " <column name='PK_Column' type='NUMERIC' size='12,0' primaryKey='true' required='true' autoIncrement='true'/>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| } | |
| else | |
| { | |
| modelXml = "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip'>\n"+ | |
| " <column name='PK_Column' type='INTEGER' primaryKey='true' required='true' autoIncrement='true'/>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| } | |
| performConstraintsTest(modelXml, | |
| getPlatformInfo().getIdentityStatusReadingSupported()); | |
| } | |
| /** | |
| * Tests a simple index. | |
| */ | |
| public void testIndex() | |
| { | |
| if (!getPlatformInfo().isIndicesSupported()) | |
| { | |
| return; | |
| } | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='DOUBLE'/>\n"+ | |
| " <index name='TEST_INDEX'>\n"+ | |
| " <index-column name='avalue'/>\n"+ | |
| " </index>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| } | |
| /** | |
| * Tests an unique index for two columns. | |
| */ | |
| public void testUniqueIndex() | |
| { | |
| if (!getPlatformInfo().isIndicesSupported()) | |
| { | |
| return; | |
| } | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='value_1' type='DOUBLE'/>\n"+ | |
| " <column name='value_2' type='VARCHAR' size='32'/>\n"+ | |
| " <unique name='test_index'>\n"+ | |
| " <unique-column name='value_2'/>\n"+ | |
| " <unique-column name='value_1'/>\n"+ | |
| " </unique>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| } | |
| /** | |
| * Tests an index for two columns, one of which a pk column. | |
| */ | |
| public void testPrimaryKeyIndex() | |
| { | |
| if (!getPlatformInfo().isIndicesSupported()) | |
| { | |
| return; | |
| } | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip'>\n"+ | |
| " <column name='pk_1' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='pk_2' type='VARCHAR' size='32' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='DOUBLE'/>\n"+ | |
| " <index name='test_index'>\n"+ | |
| " <index-column name='avalue'/>\n"+ | |
| " <index-column name='pk_1'/>\n"+ | |
| " </index>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| } | |
| /** | |
| * Tests two tables with a simple foreign key relationship between them. | |
| */ | |
| public void testSimpleForeignKey() | |
| { | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip_1'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " </table>\n"+ | |
| " <table name='roundtrip_2'>\n"+ | |
| " <column name='pk' type='VARCHAR' size='32' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='INTEGER' required='true'/>\n"+ | |
| " <foreign-key foreignTable='roundtrip_1'>\n"+ | |
| " <reference local='avalue' foreign='pk'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| } | |
| /** | |
| * Tests two tables with overlapping foreign key relationships between them. | |
| */ | |
| public void testOverlappingForeignKeys() | |
| { | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip_1'>\n"+ | |
| " <column name='pk_1' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='pk_2' type='VARCHAR' size='32' primaryKey='true' required='true'/>\n"+ | |
| " </table>\n"+ | |
| " <table name='roundtrip_2'>\n"+ | |
| " <column name='pk' type='VARCHAR' size='32' primaryKey='true' required='true'/>\n"+ | |
| " <column name='value_1' type='INTEGER' required='true'/>\n"+ | |
| " <column name='value_2' type='INTEGER'/>\n"+ | |
| " <column name='value_3' type='VARCHAR' size='32'/>\n"+ | |
| " <foreign-key name='fk_1' foreignTable='roundtrip_1'>\n"+ | |
| " <reference local='value_1' foreign='pk_1'/>\n"+ | |
| " <reference local='value_3' foreign='pk_2'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " <foreign-key foreignTable='roundtrip_1'>\n"+ | |
| " <reference local='value_2' foreign='pk_1'/>\n"+ | |
| " <reference local='value_3' foreign='pk_2'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| } | |
| /** | |
| * Tests two tables with circular foreign key relationships between them. | |
| */ | |
| public void testCircularForeignKeys() | |
| { | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip_1'>\n"+ | |
| " <column name='pk_1' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='pk_2' type='VARCHAR' size='32' primaryKey='true' required='true'/>\n"+ | |
| " <column name='value_1' type='INTEGER'/>\n"+ | |
| " <column name='value_2' type='VARCHAR' size='32'/>\n"+ | |
| " <foreign-key foreignTable='roundtrip_2'>\n"+ | |
| " <reference local='value_1' foreign='pk_1'/>\n"+ | |
| " <reference local='value_2' foreign='pk_2'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " </table>\n"+ | |
| " <table name='roundtrip_2'>\n"+ | |
| " <column name='pk_1' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='pk_2' type='VARCHAR' size='32' primaryKey='true' required='true'/>\n"+ | |
| " <column name='value_1' type='VARCHAR' size='32' required='true'/>\n"+ | |
| " <column name='value_2' type='INTEGER' required='true'/>\n"+ | |
| " <foreign-key foreignTable='roundtrip_1'>\n"+ | |
| " <reference local='value_2' foreign='pk_1'/>\n"+ | |
| " <reference local='value_1' foreign='pk_2'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| } | |
| /** | |
| * Tests two tables with a foreign key with a restrict onDelete action. | |
| */ | |
| public void testForeignKeyWithOnDeleteRestrict() | |
| { | |
| if (!getPlatformInfo().isActionSupportedForOnDelete(CascadeActionEnum.RESTRICT)) | |
| { | |
| return; | |
| } | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip_1'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " </table>\n"+ | |
| " <table name='roundtrip_2'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='INTEGER' required='true'/>\n"+ | |
| " <foreign-key foreignTable='roundtrip_1' onDelete='restrict'>\n"+ | |
| " <reference local='avalue' foreign='pk'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| insertRow("roundtrip_1", new Object[] { new Integer(1) }); | |
| insertRow("roundtrip_2", new Object[] { new Integer(5), new Integer(1) }); | |
| List beansTable1 = getRows("roundtrip_1"); | |
| List beansTable2 = getRows("roundtrip_2"); | |
| assertEquals(1, beansTable1.size()); | |
| assertEquals(1, beansTable2.size()); | |
| assertEquals(new Integer(1), beansTable1.get(0), "pk"); | |
| assertEquals(new Integer(5), beansTable2.get(0), "pk"); | |
| assertEquals(new Integer(1), beansTable2.get(0), "avalue"); | |
| try | |
| { | |
| deleteRow("roundtrip_1", new Object[] { new Integer(1) }); | |
| fail(); | |
| } | |
| catch (DdlUtilsException ex) | |
| {} | |
| } | |
| /** | |
| * Tests two tables with a foreign key with a cascade onDelete action. | |
| */ | |
| public void testForeignKeyWithOnDeleteCascade() | |
| { | |
| if (!getPlatformInfo().isActionSupportedForOnDelete(CascadeActionEnum.CASCADE)) | |
| { | |
| return; | |
| } | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip_1'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " </table>\n"+ | |
| " <table name='roundtrip_2'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='INTEGER' required='true'/>\n"+ | |
| " <foreign-key foreignTable='roundtrip_1' onDelete='cascade'>\n"+ | |
| " <reference local='avalue' foreign='pk'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| insertRow("roundtrip_1", new Object[] { new Integer(1) }); | |
| insertRow("roundtrip_2", new Object[] { new Integer(5), new Integer(1) }); | |
| List beansTable1 = getRows("roundtrip_1"); | |
| List beansTable2 = getRows("roundtrip_2"); | |
| assertEquals(1, beansTable1.size()); | |
| assertEquals(1, beansTable2.size()); | |
| assertEquals(new Integer(1), beansTable1.get(0), "pk"); | |
| assertEquals(new Integer(5), beansTable2.get(0), "pk"); | |
| assertEquals(new Integer(1), beansTable2.get(0), "avalue"); | |
| deleteRow("roundtrip_1", new Object[] { new Integer(1) }); | |
| beansTable1 = getRows("roundtrip_1"); | |
| beansTable2 = getRows("roundtrip_2"); | |
| assertEquals(0, beansTable1.size()); | |
| assertEquals(0, beansTable2.size()); | |
| } | |
| /** | |
| * Tests two tables with a foreign key with a set-null onDelete action. | |
| */ | |
| public void testForeignKeyWithOnDeleteSetNull() | |
| { | |
| if (!getPlatformInfo().isActionSupportedForOnDelete(CascadeActionEnum.SET_NULL)) | |
| { | |
| return; | |
| } | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip_1'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " </table>\n"+ | |
| " <table name='roundtrip_2'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='INTEGER' required='false'/>\n"+ | |
| " <foreign-key foreignTable='roundtrip_1' onDelete='setnull'>\n"+ | |
| " <reference local='avalue' foreign='pk'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| insertRow("roundtrip_1", new Object[] { new Integer(1) }); | |
| insertRow("roundtrip_2", new Object[] { new Integer(5), new Integer(1) }); | |
| List beansTable1 = getRows("roundtrip_1"); | |
| List beansTable2 = getRows("roundtrip_2"); | |
| assertEquals(1, beansTable1.size()); | |
| assertEquals(1, beansTable2.size()); | |
| assertEquals(new Integer(1), beansTable1.get(0), "pk"); | |
| assertEquals(new Integer(5), beansTable2.get(0), "pk"); | |
| assertEquals(new Integer(1), beansTable2.get(0), "avalue"); | |
| deleteRow("roundtrip_1", new Object[] { new Integer(1) }); | |
| beansTable1 = getRows("roundtrip_1"); | |
| beansTable2 = getRows("roundtrip_2"); | |
| assertEquals(0, beansTable1.size()); | |
| assertEquals(1, beansTable2.size()); | |
| assertEquals(new Integer(5), beansTable2.get(0), "pk"); | |
| assertEquals((Object)null, beansTable2.get(0), "avalue"); | |
| } | |
| /** | |
| * Tests two tables with a foreign key with a set-default onDelete action. | |
| */ | |
| public void testForeignKeyWithOnDeleteSetDefault() | |
| { | |
| if (!getPlatformInfo().isActionSupportedForOnDelete(CascadeActionEnum.SET_DEFAULT)) | |
| { | |
| return; | |
| } | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip_1'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " </table>\n"+ | |
| " <table name='roundtrip_2'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='INTEGER' required='false' default='2'/>\n"+ | |
| " <foreign-key foreignTable='roundtrip_1' onDelete='setdefault'>\n"+ | |
| " <reference local='avalue' foreign='pk'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| insertRow("roundtrip_1", new Object[] { new Integer(1) }); | |
| insertRow("roundtrip_1", new Object[] { new Integer(2) }); | |
| insertRow("roundtrip_2", new Object[] { new Integer(5), new Integer(1) }); | |
| List beansTable1 = getRows("roundtrip_1"); | |
| List beansTable2 = getRows("roundtrip_2"); | |
| assertEquals(2, beansTable1.size()); | |
| assertEquals(1, beansTable2.size()); | |
| assertEquals(new Integer(1), beansTable1.get(0), "pk"); | |
| assertEquals(new Integer(2), beansTable1.get(1), "pk"); | |
| assertEquals(new Integer(5), beansTable2.get(0), "pk"); | |
| assertEquals(new Integer(1), beansTable2.get(0), "avalue"); | |
| deleteRow("roundtrip_1", new Object[] { new Integer(1) }); | |
| beansTable1 = getRows("roundtrip_1"); | |
| beansTable2 = getRows("roundtrip_2"); | |
| assertEquals(1, beansTable1.size()); | |
| assertEquals(1, beansTable2.size()); | |
| assertEquals(new Integer(2), beansTable1.get(0), "pk"); | |
| assertEquals(new Integer(5), beansTable2.get(0), "pk"); | |
| assertEquals(new Integer(2), beansTable2.get(0), "avalue"); | |
| } | |
| /** | |
| * Tests two tables with a foreign key with a restrict onUpdate action. | |
| */ | |
| public void testForeignKeyWithOnUpdateRestrict() | |
| { | |
| if (!getPlatformInfo().isActionSupportedForOnUpdate(CascadeActionEnum.RESTRICT)) | |
| { | |
| return; | |
| } | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip_1'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " </table>\n"+ | |
| " <table name='roundtrip_2'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='INTEGER' required='true'/>\n"+ | |
| " <foreign-key foreignTable='roundtrip_1' onUpdate='restrict'>\n"+ | |
| " <reference local='avalue' foreign='pk'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| insertRow("roundtrip_1", new Object[] { new Integer(1) }); | |
| insertRow("roundtrip_2", new Object[] { new Integer(5), new Integer(1) }); | |
| List beansTable1 = getRows("roundtrip_1"); | |
| List beansTable2 = getRows("roundtrip_2"); | |
| assertEquals(1, beansTable1.size()); | |
| assertEquals(1, beansTable2.size()); | |
| assertEquals(new Integer(1), beansTable1.get(0), "pk"); | |
| assertEquals(new Integer(5), beansTable2.get(0), "pk"); | |
| assertEquals(new Integer(1), beansTable2.get(0), "avalue"); | |
| try | |
| { | |
| updateRow("roundtrip_1", (DynaBean)beansTable1.get(0), new Object[] { new Integer(5) }); | |
| fail(); | |
| } | |
| catch (DdlUtilsException ex) | |
| {} | |
| } | |
| /** | |
| * Tests two tables with a foreign key with a cascade onUpdate action. | |
| */ | |
| public void testForeignKeyWithOnUpdateCascade() | |
| { | |
| if (!getPlatformInfo().isActionSupportedForOnUpdate(CascadeActionEnum.CASCADE)) | |
| { | |
| return; | |
| } | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip_1'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " </table>\n"+ | |
| " <table name='roundtrip_2'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='INTEGER' required='true'/>\n"+ | |
| " <foreign-key foreignTable='roundtrip_1' onUpdate='cascade'>\n"+ | |
| " <reference local='avalue' foreign='pk'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| insertRow("roundtrip_1", new Object[] { new Integer(1) }); | |
| insertRow("roundtrip_2", new Object[] { new Integer(5), new Integer(1) }); | |
| List beansTable1 = getRows("roundtrip_1"); | |
| List beansTable2 = getRows("roundtrip_2"); | |
| assertEquals(1, beansTable1.size()); | |
| assertEquals(1, beansTable2.size()); | |
| assertEquals(new Integer(1), beansTable1.get(0), "pk"); | |
| assertEquals(new Integer(5), beansTable2.get(0), "pk"); | |
| assertEquals(new Integer(1), beansTable2.get(0), "avalue"); | |
| updateRow("roundtrip_1", (DynaBean)beansTable1.get(0), new Object[] { new Integer(2) }); | |
| beansTable1 = getRows("roundtrip_1"); | |
| beansTable2 = getRows("roundtrip_2"); | |
| assertEquals(1, beansTable1.size()); | |
| assertEquals(1, beansTable2.size()); | |
| assertEquals(new Integer(2), beansTable1.get(0), "pk"); | |
| assertEquals(new Integer(5), beansTable2.get(0), "pk"); | |
| assertEquals(new Integer(2), beansTable2.get(0), "avalue"); | |
| } | |
| /** | |
| * Tests two tables with a foreign key with a set-null onUpdate action. | |
| */ | |
| public void testForeignKeyWithOnUpdateSetNull() | |
| { | |
| if (!getPlatformInfo().isActionSupportedForOnUpdate(CascadeActionEnum.SET_NULL)) | |
| { | |
| return; | |
| } | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip_1'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " </table>\n"+ | |
| " <table name='roundtrip_2'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='INTEGER' required='false'/>\n"+ | |
| " <foreign-key foreignTable='roundtrip_1' onUpdate='setnull'>\n"+ | |
| " <reference local='avalue' foreign='pk'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| insertRow("roundtrip_1", new Object[] { new Integer(1) }); | |
| insertRow("roundtrip_2", new Object[] { new Integer(5), new Integer(1) }); | |
| List beansTable1 = getRows("roundtrip_1"); | |
| List beansTable2 = getRows("roundtrip_2"); | |
| assertEquals(1, beansTable1.size()); | |
| assertEquals(1, beansTable2.size()); | |
| assertEquals(new Integer(1), beansTable1.get(0), "pk"); | |
| assertEquals(new Integer(5), beansTable2.get(0), "pk"); | |
| assertEquals(new Integer(1), beansTable2.get(0), "avalue"); | |
| updateRow("roundtrip_1", (DynaBean)beansTable1.get(0), new Object[] { new Integer(2) }); | |
| beansTable1 = getRows("roundtrip_1"); | |
| beansTable2 = getRows("roundtrip_2"); | |
| assertEquals(1, beansTable1.size()); | |
| assertEquals(1, beansTable2.size()); | |
| assertEquals(new Integer(2), beansTable1.get(0), "pk"); | |
| assertEquals(new Integer(5), beansTable2.get(0), "pk"); | |
| assertEquals((Object)null, beansTable2.get(0), "avalue"); | |
| } | |
| /** | |
| * Tests two tables with a foreign key with a det-default onUpdate action. | |
| */ | |
| public void testForeignKeyWithOnUpdateSetDefault() | |
| { | |
| if (!getPlatformInfo().isActionSupportedForOnUpdate(CascadeActionEnum.SET_DEFAULT)) | |
| { | |
| return; | |
| } | |
| final String modelXml = | |
| "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+ | |
| "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+ | |
| " <table name='roundtrip_1'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " </table>\n"+ | |
| " <table name='roundtrip_2'>\n"+ | |
| " <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+ | |
| " <column name='avalue' type='INTEGER' required='false' default='1'/>\n"+ | |
| " <foreign-key foreignTable='roundtrip_1' onUpdate='setdefault'>\n"+ | |
| " <reference local='avalue' foreign='pk'/>\n"+ | |
| " </foreign-key>\n"+ | |
| " </table>\n"+ | |
| "</database>"; | |
| performConstraintsTest(modelXml, true); | |
| insertRow("roundtrip_1", new Object[] { new Integer(1) }); | |
| insertRow("roundtrip_1", new Object[] { new Integer(2) }); | |
| insertRow("roundtrip_2", new Object[] { new Integer(5), new Integer(2) }); | |
| List beansTable1 = getRows("roundtrip_1"); | |
| List beansTable2 = getRows("roundtrip_2"); | |
| assertEquals(2, beansTable1.size()); | |
| assertEquals(1, beansTable2.size()); | |
| assertEquals(new Integer(1), beansTable1.get(0), "pk"); | |
| assertEquals(new Integer(2), beansTable1.get(1), "pk"); | |
| assertEquals(new Integer(5), beansTable2.get(0), "pk"); | |
| assertEquals(new Integer(2), beansTable2.get(0), "avalue"); | |
| updateRow("roundtrip_1", (DynaBean)beansTable1.get(1), new Object[] { new Integer(0) }); | |
| beansTable1 = getRows("roundtrip_1", "pk"); | |
| beansTable2 = getRows("roundtrip_2", "pk"); | |
| assertEquals(2, beansTable1.size()); | |
| assertEquals(1, beansTable2.size()); | |
| assertEquals(new Integer(0), beansTable1.get(0), "pk"); | |
| assertEquals(new Integer(1), beansTable1.get(1), "pk"); | |
| assertEquals(new Integer(5), beansTable2.get(0), "pk"); | |
| assertEquals(new Integer(1), beansTable2.get(0), "avalue"); | |
| } | |
| } |