[Squirrel-sql-commits] sql12/test/src/net/sourceforge/squirrel_sql/plugins/dbcopy ColTypeMapperTes
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Rob M. <man...@us...> - 2007-05-11 22:34:56
|
Update of /cvsroot/squirrel-sql/sql12/test/src/net/sourceforge/squirrel_sql/plugins/dbcopy In directory sc8-pr-cvs8.sourceforge.net:/tmp/cvs-serv15628/test/src/net/sourceforge/squirrel_sql/plugins/dbcopy Modified Files: ColTypeMapperTest.java Log Message: Added the ability to set the log level for a given ILogger in test cases. Added more type testing in ColTypeMapper. Index: ColTypeMapperTest.java =================================================================== RCS file: /cvsroot/squirrel-sql/sql12/test/src/net/sourceforge/squirrel_sql/plugins/dbcopy/ColTypeMapperTest.java,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** ColTypeMapperTest.java 6 May 2007 01:46:49 -0000 1.1 --- ColTypeMapperTest.java 11 May 2007 22:34:53 -0000 1.2 *************** *** 19,22 **** --- 19,24 ---- */ import static java.lang.System.out; + import static org.easymock.EasyMock.createNiceMock; + import static org.easymock.EasyMock.expect; import java.sql.ResultSet; *************** *** 27,39 **** import net.sourceforge.squirrel_sql.fw.sql.JDBCTypeMapper; import net.sourceforge.squirrel_sql.fw.sql.TableColumnInfo; import net.sourceforge.squirrel_sql.test.TestUtil; - import static org.easymock.EasyMock.createMock; - import static org.easymock.EasyMock.createNiceMock; - import static org.easymock.EasyMock.expect; - import static org.easymock.EasyMock.replay; - public class ColTypeMapperTest extends BaseSQuirreLTestCase { static String[] dbNames = { "Axion", --- 29,41 ---- import net.sourceforge.squirrel_sql.fw.sql.JDBCTypeMapper; import net.sourceforge.squirrel_sql.fw.sql.TableColumnInfo; + import net.sourceforge.squirrel_sql.fw.util.log.ILogger; + import net.sourceforge.squirrel_sql.fw.util.log.LoggerController; import net.sourceforge.squirrel_sql.test.TestUtil; public class ColTypeMapperTest extends BaseSQuirreLTestCase { + static ILogger s_log = + LoggerController.createLogger(ColTypeMapperTest.class); + static String[] dbNames = { "Axion", *************** *** 61,65 **** --- 63,73 ---- }; + static { + // Don't care to see tons of debug from ColTypeMapper + disableLogging(ColTypeMapper.class); + } + protected void setUp() throws Exception { + } *************** *** 72,85 **** for (String destName : dbNames) { try { ! out.println("processing source = "+sourceName+" dest = "+ ! destName); testBlobColType(sourceName, destName); testClobColType(sourceName, destName); testDateColType(sourceName, destName); testIntegerColType(sourceName, destName); testLongVarcharColType(sourceName, destName); testVarcharColType(sourceName, destName); } catch (Exception e) { ! out.println("Unexpected exception: "+e.getMessage()); } } --- 80,111 ---- for (String destName : dbNames) { try { ! if (s_log.isDebugEnabled()) { ! s_log.debug("processing source = "+sourceName+ ! " dest = "+destName); ! } ! ! testBigintColType(sourceName, destName); ! testBinaryColType(sourceName, destName); ! //testBitColType(sourceName, destName); testBlobColType(sourceName, destName); + //testBooleanColType(sourceName, destName); + //testCharColType(sourceName, destName); testClobColType(sourceName, destName); testDateColType(sourceName, destName); + //testDecimalColType(sourceName, destName); + //testDoubleColType(sourceName, destName); + //testFloatColType(sourceName, destName); testIntegerColType(sourceName, destName); + //testLongVarbinaryColType(sourceName, destName); + //testNumericColType(sourceName, destName); + //testRealColType(sourceName, destName); + //testSmallIntColType(sourceName, destName); + //testTimestampColType(sourceName, destName); + //testTimeColType(sourceName, destName); + //testTinyIntColType(sourceName, destName); testLongVarcharColType(sourceName, destName); testVarcharColType(sourceName, destName); } catch (Exception e) { ! s_log.error("Unexpected exception: "+e.getMessage(), e); } } *************** *** 87,95 **** } private void testBlobColType(String fromDb, String toDb) throws Exception { ISQLDatabaseMetaData md = TestUtil.getEasyMockSQLMetaData(fromDb); TableColumnInfo column = TestUtil.getBlobColumnInfo(md, true); ! // This is for brute force detection of BLOB/CLOB lengths if necessary ResultSet rs = createNiceMock(ResultSet.class); expect(rs.next()).andReturn(true).once(); --- 113,139 ---- } + private void testBigintColType(String fromDb, String toDb) throws Exception + { + ISQLDatabaseMetaData md = TestUtil.getEasyMockSQLMetaData(fromDb); + TableColumnInfo column = TestUtil.getBigintColumnInfo(md, true); + testColType(md, toDb, column); + } + + private void testBinaryColType(String fromDb, String toDb) throws Exception + { + ISQLDatabaseMetaData md = TestUtil.getEasyMockSQLMetaData(fromDb); + TableColumnInfo column = TestUtil.getBinaryColumnInfo(md, true); + // This is for brute force detection of columns whose column size is 0 + ResultSet rs = createNiceMock(ResultSet.class); + expect(rs.next()).andReturn(true).once(); + expect(rs.getInt(1)).andReturn(5000).once(); + testColType(md, toDb, column, rs); + } + private void testBlobColType(String fromDb, String toDb) throws Exception { ISQLDatabaseMetaData md = TestUtil.getEasyMockSQLMetaData(fromDb); TableColumnInfo column = TestUtil.getBlobColumnInfo(md, true); ! //This is for brute force detection of BLOB/CLOB lengths if necessary ResultSet rs = createNiceMock(ResultSet.class); expect(rs.next()).andReturn(true).once(); *************** *** 107,111 **** expect(rs.getInt(1)).andReturn(5000).once(); testColType(md, toDb, column, rs); - testColType(md, toDb, column); } --- 151,154 ---- |