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_mysql_jdbc_Driver.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_mysql_jdbc_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_com_mysql_jdbc_Driver extends TestCase {
19: public Test_com_mysql_jdbc_Driver(String name) {
20: super (name);
21: }
22:
23: public void testGetSqlValue() {
24: SqlConversion dbtypes = null;
25: dbtypes = new com_mysql_jdbc_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: assertEquals(dbtypes.getSqlValue(new Time(cal.getTime()
38: .getTime())), "'18:45:40'");
39: assertEquals(dbtypes.getSqlValue(new Timestamp(cal.getTime()
40: .getTime())), "'2002-06-18 18:45:40.0'");
41: assertEquals(dbtypes.getSqlValue(new java.sql.Date(cal
42: .getTime().getTime())), "'2002-06-18'");
43: assertEquals(dbtypes.getSqlValue(new Date(cal.getTime()
44: .getTime())), "'2002-06-18 18:45:40.0'");
45: assertEquals(dbtypes.getSqlValue(cal),
46: "'2002-06-18 18:45:40.0'");
47: assertEquals(dbtypes.getSqlValue(new String[] { "kjkdf",
48: "fdfdf", "ljkldfd" }), "{'kjkdf','fdfdf','ljkldfd'}");
49: assertEquals(dbtypes.getSqlValue(new Boolean(true)), "1");
50: assertEquals(dbtypes.getSqlValue(SomeEnum.VALUE_TWO),
51: "'VALUE_TWO'");
52: }
53: }
|