1 package org.apache.torque.util;
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22 import junit.framework.TestCase;
23
24 /***
25 * Tests for Query
26 *
27 * @author <a href="mailto:mpoeschl@marmot.at">Martin Poeschl</a>
28 * @author <a href="mailto:fischer@seitenbau.de">Thomas Fischer</a>
29 * @version $Id: QueryTest.java 473821 2006-11-11 22:37:25Z tv $
30 */
31 public class QueryTest extends TestCase
32 {
33
34 /***
35 * Constructor for QueryTest.
36 * @param arg0
37 */
38 public QueryTest(String arg0)
39 {
40 super(arg0);
41 }
42
43 /***
44 * Test for String toString()
45 */
46 public void testColumns()
47 {
48 String expected
49 = "SELECT tableA.column1, tableA.column2, tableB.column1 FROM ";
50 Query query = new Query();
51
52 UniqueList columns = new UniqueList();
53 columns.add("tableA.column1");
54 columns.add("tableA.column2");
55 columns.add("tableB.column1");
56 query.setSelectClause(columns);
57
58 assertEquals(expected, query.toString());
59 }
60
61 /***
62 * Test for String toString()
63 */
64 public void testToString()
65 {
66 String expected = "SELECT tableA.column1, tableA.column2, "
67 + "tableB.column1 FROM tableA, tableB WHERE tableA.A = tableB.A"
68 + " AND tableA.B = 1234";
69 Query query = new Query();
70
71 UniqueList columns = new UniqueList();
72 columns.add("tableA.column1");
73 columns.add("tableA.column2");
74 columns.add("tableB.column1");
75 query.setSelectClause(columns);
76
77 UniqueList tables = new UniqueList();
78 tables.add(new Query.FromElement("tableA", null, null));
79 tables.add(new Query.FromElement("tableB", null, null));
80 query.setFromClause(tables);
81
82 UniqueList where = new UniqueList();
83 where.add("tableA.A = tableB.A");
84 where.add("tableA.B = 1234");
85 query.setWhereClause(where);
86
87 assertEquals(expected, query.toString());
88 }
89 }