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 java.lang.reflect.Array;
58
59 import junit.framework.TestCase;
60
61 import org.apache.torque.adapter.DB;
62 import org.apache.torque.adapter.DBFactory;
63
64 /***
65 * Tests for SqlExpression
66 *
67 * @author <a href="mailto:mpoeschl@marmot.at">Martin Poeschl</a>
68 * @version $Id: SqlExpressionTest.java,v 1.2 2003/08/27 22:50:11 mpoeschl Exp $
69 */
70 public class SqlExpressionTest extends TestCase
71 {
72 private DB db = null;
73
74
75 /***
76 * Constructor for SqlExpressionTest.
77 * @param arg0
78 */
79 public SqlExpressionTest(String arg0)
80 {
81 super(arg0);
82 }
83
84 /***
85 * set up environment
86 */
87 public void setUp()
88 {
89 try
90 {
91 db = DBFactory.create("mysql");
92 }
93 catch (Exception ex)
94 {
95 ex.printStackTrace();
96 }
97 }
98
99 /***
100 * Test for String buildInnerJoin(String, String)
101 */
102 public void testBuildInnerJoinStringString()
103 {
104 String result = SqlExpression.buildInnerJoin("TA.COLA", "TB.COLB");
105 assertEquals(result, "TA.COLA=TB.COLB");
106 }
107
108 /***
109 * Test for String buildInnerJoin(String, String, boolean, DB)
110 */
111 public void testBuildInnerJoinStringStringbooleanDB()
112 {
113 String result = SqlExpression.buildInnerJoin("TA.COLA", "TB.COLB",
114 true, db);
115 assertEquals(result, "TA.COLA=TB.COLB");
116 }
117
118 /***
119 * Test for String buildIn(String, Object, SqlEnum, boolean, DB)
120 */
121 public void testBuildInStringObjectSqlEnumbooleanDB()
122 {
123 String[] values = new String[] { "42", "43", "44" };
124 String result = SqlExpression.buildIn("COL", values, SqlEnum.IN,
125 true, db);
126 assertEquals(result, "COL IN ('42','43','44')");
127 }
128
129 public void testLargeBuildInStringObjectSqlEnumbooleanDB()
130 {
131 int size = 10000;
132 String[] values = new String[size];
133 for (int i = 0; i < size; i++)
134 {
135 Array.set(values, i, String.valueOf(i));
136 }
137 long start = System.currentTimeMillis();
138 String result = SqlExpression.buildIn("COL", values, SqlEnum.IN,
139 true, db);
140 long end = System.currentTimeMillis();
141 System.out.println("large buildIn: " + (end - start));
142 }
143
144 }
This page was automatically generated by Maven