01: /*
02: * Copyright 2001-2007 Geert Bevin <gbevin[remove] at uwyn dot com>
03: * Distributed under the terms of either:
04: * - the common development and distribution license (CDDL), v1.0; or
05: * - the GNU Lesser General Public License, v2.1 or later
06: * $Id: Test_com_mckoi_JDBCDriver.java 3695 2007-03-16 09:26:50Z gbevin $
07: */
08: package com.uwyn.rife.database.types;
09:
10: import com.uwyn.rife.database.SomeEnum;
11: import com.uwyn.rife.database.types.databasedrivers.com_mckoi_JDBCDriver;
12: import java.sql.Time;
13: import java.sql.Timestamp;
14: import java.util.Calendar;
15: import java.util.Date;
16: import junit.framework.TestCase;
17:
18: public class Test_com_mckoi_JDBCDriver extends TestCase {
19: public Test_com_mckoi_JDBCDriver(String name) {
20: super (name);
21: }
22:
23: public void testGetSqlValue() {
24: SqlConversion dbtypes = null;
25: dbtypes = new com_mckoi_JDBCDriver();
26:
27: assertNotNull(dbtypes);
28: assertEquals(dbtypes.getSqlValue(null), "NULL");
29: assertEquals(dbtypes.getSqlValue("fdjh'kjhsdf'"),
30: "'fdjh''kjhsdf'''");
31: assertEquals(dbtypes.getSqlValue(new StringBuffer(
32: "kkdfkj'jfoodf")), "'kkdfkj''jfoodf'");
33: assertEquals(dbtypes.getSqlValue(new Character('K')), "'K'");
34: assertEquals(dbtypes.getSqlValue(new Character('\'')), "''''");
35: Calendar cal = Calendar.getInstance();
36: cal.set(2002, 05, 18, 18, 45, 40);
37: cal.set(Calendar.MILLISECOND, 132);
38: assertEquals(dbtypes.getSqlValue(new Time(cal.getTime()
39: .getTime())), "TIME '18:45:40'");
40: assertEquals(dbtypes.getSqlValue(new Timestamp(cal.getTime()
41: .getTime())), "TIMESTAMP '2002-06-18 18:45:40.132'");
42: assertEquals(dbtypes.getSqlValue(new java.sql.Date(cal
43: .getTime().getTime())), "DATE '2002-06-18'");
44: assertEquals(dbtypes.getSqlValue(new Date(cal.getTime()
45: .getTime())), "TIMESTAMP '2002-06-18 18:45:40.132'");
46: assertEquals(dbtypes.getSqlValue(cal),
47: "TIMESTAMP '2002-06-18 18:45:40.132'");
48: assertEquals(dbtypes.getSqlValue(new String[] { "kjkdf",
49: "fdfdf", "ljkldfd" }), "{'kjkdf','fdfdf','ljkldfd'}");
50: assertEquals(dbtypes.getSqlValue(new Boolean(true)), "true");
51: assertEquals(dbtypes.getSqlValue(SomeEnum.VALUE_TWO),
52: "'VALUE_TWO'");
53: }
54: }
|