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_org_hsqldb_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.org_postgresql_Driver;
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_org_hsqldb_jdbcDriver extends TestCase {
19: public Test_org_hsqldb_jdbcDriver(String name) {
20: super (name);
21: }
22:
23: public void testGetSqlValue() {
24: SqlConversion dbtypes = null;
25: dbtypes = new org_postgresql_Driver();
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())), "'18:45:40'");
40: assertEquals(dbtypes.getSqlValue(new Timestamp(cal.getTime()
41: .getTime())), "'2002-06-18 18:45:40.132'");
42: assertEquals(dbtypes.getSqlValue(new java.sql.Date(cal
43: .getTime().getTime())), "'2002-06-18'");
44: assertEquals(dbtypes.getSqlValue(new Date(cal.getTime()
45: .getTime())), "'2002-06-18 18:45:40.132'");
46: assertEquals(dbtypes.getSqlValue(cal),
47: "'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: }
|