1 package org.apache.torque.util;
2
3 /* ====================================================================
4 * The Apache Software License, Version 1.1
5 *
6 * Copyright (c) 2001-2003 The Apache Software Foundation. All rights
7 * reserved.
8 *
9 * Redistribution and use in source and binary forms, with or without
10 * modification, are permitted provided that the following conditions
11 * are met:
12 *
13 * 1. Redistributions of source code must retain the above copyright
14 * notice, this list of conditions and the following disclaimer.
15 *
16 * 2. Redistributions in binary form must reproduce the above copyright
17 * notice, this list of conditions and the following disclaimer in
18 * the documentation and/or other materials provided with the
19 * distribution.
20 *
21 * 3. The end-user documentation included with the redistribution,
22 * if any, must include the following acknowledgment:
23 * "This product includes software developed by the
24 * Apache Software Foundation (http://www.apache.org/)."
25 * Alternately, this acknowledgment may appear in the software itself,
26 * if and wherever such third-party acknowledgments normally appear.
27 *
28 * 4. The names "Apache" and "Apache Software Foundation" and
29 * "Apache Turbine" must not be used to endorse or promote products
30 * derived from this software without prior written permission. For
31 * written permission, please contact apache@apache.org.
32 *
33 * 5. Products derived from this software may not be called "Apache",
34 * "Apache Turbine", nor may "Apache" appear in their name, without
35 * prior written permission of the Apache Software Foundation.
36 *
37 * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
38 * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
39 * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
40 * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
41 * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
42 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
43 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
44 * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
45 * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
46 * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
47 * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
48 * SUCH DAMAGE.
49 * ====================================================================
50 *
51 * This software consists of voluntary contributions made by many
52 * individuals on behalf of the Apache Software Foundation. For more
53 * information on the Apache Software Foundation, please see
54 * <http://www.apache.org/>.
55 */
56
57 import junit.framework.TestCase;
58
59 /***
60 * Tests for Query
61 *
62 * @author <a href="mailto:mpoeschl@marmot.at">Martin Poeschl</a>
63 * @version $Id: QueryTest.java,v 1.4 2003/06/19 04:05:54 dlr Exp $
64 */
65 public class QueryTest extends TestCase
66 {
67
68 /***
69 * Constructor for QueryTest.
70 * @param arg0
71 */
72 public QueryTest(String arg0)
73 {
74 super(arg0);
75 }
76
77 /***
78 * Test for String toString()
79 */
80 public void testColumns()
81 {
82 String expected
83 = "SELECT tableA.column1, tableA.column2, tableB.column1 FROM ";
84 Query query = new Query();
85
86 UniqueList columns = new UniqueList();
87 columns.add("tableA.column1");
88 columns.add("tableA.column2");
89 columns.add("tableB.column1");
90 query.setSelectClause(columns);
91
92 assertEquals(expected, query.toString());
93 }
94
95 /***
96 * Test for String toString()
97 */
98 public void testToString()
99 {
100 String expected = "SELECT tableA.column1, tableA.column2, "
101 + "tableB.column1 FROM tableA, tableB WHERE tableA.A = tableB.A"
102 + " AND tableA.B = 1234";
103 Query query = new Query();
104
105 UniqueList columns = new UniqueList();
106 columns.add("tableA.column1");
107 columns.add("tableA.column2");
108 columns.add("tableB.column1");
109 query.setSelectClause(columns);
110
111 UniqueList tables = new UniqueList();
112 tables.add("tableA");
113 tables.add("tableB");
114 query.setFromClause(tables);
115
116 UniqueList where = new UniqueList();
117 where.add("tableA.A = tableB.A");
118 where.add("tableA.B = 1234");
119 query.setWhereClause(where);
120
121 assertEquals(expected, query.toString());
122 }
123 }
This page was automatically generated by Maven