[Squirrel-sql-commits] sql12/test/src/net/sourceforge/squirrel_sql/fw/dialects DialectLiveTestRunn
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Rob M. <man...@us...> - 2008-01-14 01:38:08
|
Update of /cvsroot/squirrel-sql/sql12/test/src/net/sourceforge/squirrel_sql/fw/dialects In directory sc8-pr-cvs8.sourceforge.net:/tmp/cvs-serv14081/test/src/net/sourceforge/squirrel_sql/fw/dialects Modified Files: DialectLiveTestRunner.java dialectLiveTest.properties Log Message: Finished implementing DB2 refactorings. Index: DialectLiveTestRunner.java =================================================================== RCS file: /cvsroot/squirrel-sql/sql12/test/src/net/sourceforge/squirrel_sql/fw/dialects/DialectLiveTestRunner.java,v retrieving revision 1.21 retrieving revision 1.22 diff -C2 -d -r1.21 -r1.22 *** DialectLiveTestRunner.java 12 Jan 2008 22:33:57 -0000 1.21 --- DialectLiveTestRunner.java 14 Jan 2008 01:38:05 -0000 1.22 *************** *** 108,111 **** --- 108,112 ---- private static final String testSequenceName = "testSequence"; private static final String testCreateTable = "testCreateTable"; + private static final String testInsertIntoTable = "testInsertIntoTable"; public DialectLiveTestRunner() throws Exception { *************** *** 333,336 **** --- 334,338 ---- dropTable(session, fixTableName(session, "a")); dropTable(session, fixTableName(session, testCreateTable)); + dropTable(session, fixTableName(session, testInsertIntoTable)); dropView(session, "testView"); *************** *** 338,341 **** --- 340,344 ---- dropSequence(session, testSequenceName); + dropSequence(session, autoIncrementTableName + "_MYID_SEQ"); if (DialectFactory.isOracle(session.getMetaData())) { *************** *** 420,423 **** --- 423,429 ---- + " ( pk_col_1 integer, pk_col_2 integer )" + pageSizeClause); } + + runSQL(session, "create table " + fixTableName(session, testInsertIntoTable) + + " ( myid integer)" + pageSizeClause); } *************** *** 640,644 **** "A varchar comment"); if (dialect.supportsAlterColumnNull()) { ! String notNullSQL = dialect.getColumnNullableAlterSQL(notNullThirdCol, qualifier, prefs); runSQL(session, notNullSQL); } else { --- 646,650 ---- "A varchar comment"); if (dialect.supportsAlterColumnNull()) { ! String[] notNullSQL = dialect.getColumnNullableAlterSQL(notNullThirdCol, qualifier, prefs); runSQL(session, notNullSQL); } else { *************** *** 834,837 **** --- 840,844 ---- } catch (Exception e) { // This is expected + System.err.println(e.getMessage()); } } *************** *** 852,855 **** --- 859,863 ---- } catch (Exception e) { // This is expected + System.err.println(e.getMessage()); } } *************** *** 870,873 **** --- 878,882 ---- } catch (Exception e) { // This is expected + System.err.println(e.getMessage()); } } *************** *** 877,881 **** HibernateDialect dialect = getDialect(session); if (dialect.supportsRenameView()) { ! String sql = dialect.getRenameViewSQL("testView", "newTestView", qualifier, prefs); runSQL(session, sql); --- 886,890 ---- HibernateDialect dialect = getDialect(session); if (dialect.supportsRenameView()) { ! String[] sql = dialect.getRenameViewSQL("testView", "newTestView", qualifier, prefs); runSQL(session, sql); *************** *** 886,889 **** --- 895,899 ---- } catch (Exception e) { // this is expected + System.err.println(e.getMessage()); } } *************** *** 906,909 **** --- 916,920 ---- } catch (Exception e) { // this is expected + System.err.println(e.getMessage()); } } *************** *** 961,964 **** --- 972,976 ---- } catch (Exception e) { // this is expected + System.err.println(e.getMessage()); } } *************** *** 980,983 **** --- 992,996 ---- } catch (Exception e) { // this is expected + System.err.println(e.getMessage()); } } *************** *** 1003,1006 **** --- 1016,1020 ---- } catch (Exception e) { // this is expected + System.err.println(e.getMessage()); } } *************** *** 1032,1035 **** --- 1046,1050 ---- } catch (Exception e) { // this is expected + System.err.println(e.getMessage()); } } *************** *** 1056,1059 **** --- 1071,1075 ---- } catch (Exception e) { // this is expected + System.err.println(e.getMessage()); } } *************** *** 1072,1075 **** --- 1088,1092 ---- } catch (Exception e) { // this is expected + System.err.println(e.getMessage()); } } *************** *** 1101,1104 **** --- 1118,1122 ---- } catch (Exception e) { // this is expected + System.err.println(e.getMessage()); } } *************** *** 1127,1130 **** --- 1145,1149 ---- } catch (Exception e) { // this is expected + System.err.println(e.getMessage()); } } *************** *** 1135,1147 **** if (dialect.supportsAutoIncrement()) { String[] sql = ! dialect.getAddAutoIncrementSQL(autoIncrementColumn, prefs); runSQL(session, sql); } else { try { ! dialect.getAddAutoIncrementSQL(autoIncrementColumn, prefs); throw new IllegalStateException("Expected dialect to fail to provide SQL for add auto increment " + "column"); } catch (Exception e) { // this is expected } } --- 1154,1167 ---- if (dialect.supportsAutoIncrement()) { String[] sql = ! dialect.getAddAutoIncrementSQL(autoIncrementColumn, qualifier, prefs); runSQL(session, sql); } else { try { ! dialect.getAddAutoIncrementSQL(autoIncrementColumn, qualifier, prefs); throw new IllegalStateException("Expected dialect to fail to provide SQL for add auto increment " + "column"); } catch (Exception e) { // this is expected + System.err.println(e.getMessage()); } } *************** *** 1172,1175 **** --- 1192,1196 ---- { // this is expected + System.err.println(e.getMessage()); } } *************** *** 1183,1191 **** { String sql = ! dialect.getInsertIntoSQL(testUniqueConstraintTableName, columns, valuesPart, qualifier, prefs); runSQL(session, sql); valuesPart = " values ( 20 )"; ! sql = dialect.getInsertIntoSQL(testUniqueConstraintTableName, columns, valuesPart, qualifier, prefs); runSQL(session, sql); } --- 1204,1212 ---- { String sql = ! dialect.getInsertIntoSQL(testInsertIntoTable, columns, valuesPart, qualifier, prefs); runSQL(session, sql); valuesPart = " values ( 20 )"; ! sql = dialect.getInsertIntoSQL(testInsertIntoTable, columns, valuesPart, qualifier, prefs); runSQL(session, sql); } *************** *** 1194,1202 **** try { ! dialect.getInsertIntoSQL(testUniqueConstraintTableName, columns, valuesPart, qualifier, prefs); throw new IllegalStateException("Expected dialect to fail to provide SQL for insert into "); } catch (Exception e) { // this is expected } } --- 1215,1224 ---- try { ! dialect.getInsertIntoSQL(testInsertIntoTable, columns, valuesPart, qualifier, prefs); throw new IllegalStateException("Expected dialect to fail to provide SQL for insert into "); } catch (Exception e) { // this is expected + System.err.println(e.getMessage()); } } *************** *** 1221,1224 **** --- 1243,1247 ---- { // this is expected + System.err.println(e.getMessage()); } } *************** *** 1271,1274 **** --- 1294,1298 ---- { // this is expected + System.err.println(e.getMessage()); } } Index: dialectLiveTest.properties =================================================================== RCS file: /cvsroot/squirrel-sql/sql12/test/src/net/sourceforge/squirrel_sql/fw/dialects/dialectLiveTest.properties,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 *** dialectLiveTest.properties 12 Jan 2008 22:33:57 -0000 1.13 --- dialectLiveTest.properties 14 Jan 2008 01:38:05 -0000 1.14 *************** *** 66,70 **** derby_jdbcPass=password derby_jdbcDriver=org.apache.derby.jdbc.ClientDriver ! derby_schema=dbcopydest derby_catalog= --- 66,70 ---- derby_jdbcPass=password derby_jdbcDriver=org.apache.derby.jdbc.ClientDriver ! derby_schema=DBCOPYDEST derby_catalog= |