KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > tonbeller > wcf > param > SqlGeneratorTest


1 package com.tonbeller.wcf.param;
2
3 import java.sql.Time JavaDoc;
4 import java.sql.Timestamp JavaDoc;
5
6 import junit.framework.TestCase;
7
8 public class SqlGeneratorTest extends TestCase {
9
10   public void testColumnNames() {
11     SqlGenerator sg = new SqlGenerator("C1");
12     SqlEqualExpr eq = new SqlEqualExpr();
13
14     // no columnID -> use defaultColumn
15 eq.setSqlValue(new Integer JavaDoc(12));
16     assertEquals("C1 = 12", sg.generate(eq));
17
18     // mapping for defaultColumn
19 sg.getColumnMap().put(SqlGenerator.DEFAULT_COLUMN_ID, "D1");
20     assertEquals("D1 = 12", sg.generate(eq));
21
22     // no mapping, use columnID
23 eq.setColumnId("C2");
24     assertEquals("C2 = 12", sg.generate(eq));
25
26     // use mapping
27 sg.getColumnMap().put("C2", "C3");
28     assertEquals("C3 = 12", sg.generate(eq));
29   }
30
31   public void testTypes() {
32     SqlGenerator sg = new SqlGenerator("C");
33     SqlEqualExpr eq = new SqlEqualExpr();
34
35     eq.setSqlValue(new Integer JavaDoc(12));
36     assertEquals("C = 12", sg.generate(eq));
37     
38     eq.setSqlValue(new Double JavaDoc(12.34));
39     assertEquals("C = 12.34", sg.generate(eq));
40     
41     eq.setSqlValue("abc");
42     assertEquals("C = 'abc'", sg.generate(eq));
43     eq.setSqlValue("ab'c");
44     assertEquals("C = 'ab''c'", sg.generate(eq));
45
46     java.sql.Date JavaDoc sd = java.sql.Date.valueOf("2004-12-01");
47     eq.setSqlValue(sd);
48     assertEquals("C = '2004-12-01'", sg.generate(eq));
49     java.util.Date JavaDoc ud = new java.util.Date JavaDoc(sd.getTime());
50     eq.setSqlValue(ud);
51     assertEquals("C = '2004-12-01'", sg.generate(eq));
52     
53     Time JavaDoc ti = Time.valueOf("14:24:34");
54     eq.setSqlValue(ti);
55     assertEquals("C = '14:24:34'", sg.generate(eq));
56
57     Timestamp JavaDoc ts = Timestamp.valueOf("2004-12-01 14:24:34.123");
58     eq.setSqlValue(ts);
59     assertEquals("C = '2004-12-01 14:24:34.123'", sg.generate(eq));
60   }
61 }
Popular Tags