sqlexpressiontest.java

另外一种持久性o/m软件

package org.apache.torque.util;

/*
 * Copyright 2001-2004 The Apache Software Foundation.
 *
 * Licensed under the Apache License, Version 2.0 (the "License")
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

import java.lang.reflect.Array;

import junit.framework.TestCase;

import org.apache.torque.adapter.DB;
import org.apache.torque.adapter.DBFactory;

/**
 * Tests for SqlExpression
 * 
 * @author <a href="mailto:[e-mail]">Martin Poeschl</a>
 * @author <a href="mailto:[e-mail]">Scott Eade</a>
 * @version $Id: SqlExpressionTest.java,v 1.6 2005/03/19 06:39:31 tfischer Exp $
 */
public class SqlExpressionTest extends TestCase
{
    private DB db = null;
    

        /**
         * Constructor for SqlExpressionTest.
         * @param arg0
         */
        public SqlExpressionTest(String arg0)
        {
                super(arg0);
        }

    /**
     * set up environment
     */
    public void setUp()
    {
        try
        {
            db = DBFactory.create("mysql");
        }
        catch (Exception ex)
        {
            ex.printStackTrace();
        }
    }

        /**
         * Test for String buildInnerJoin(String, String)
         */
        public void testBuildInnerJoinStringString()
        {
        String result = SqlExpression.buildInnerJoin("TA.COLA", "TB.COLB");
        assertEquals(result, "TA.COLA=TB.COLB");
        }

        /**
         * Test for String buildInnerJoin(String, String, boolean, DB)
         */
        public void testBuildInnerJoinStringStringbooleanDB()
        {
        String result = SqlExpression.buildInnerJoin("TA.COLA", "TB.COLB", 
                true, db);
        assertEquals(result, "TA.COLA=TB.COLB");
        }

        /**
         * Test for String buildIn(String, Object, SqlEnum, boolean, DB)
         */
        public void testBuildInStringObjectSqlEnumbooleanDB()
        {
        String[] values = new String[] { "42", "43", "44" };
        String result = SqlExpression.buildIn("COL", values, SqlEnum.IN, 
                true, db);
        // It seems the order of the values is different for jdk1.3 vs 1.4
        // In any case, the order is not significant.
        if (result.equals("COL IN ('42','43','44')"))
        {
            // jdk 1.4
            assertEquals(result, "COL IN ('42','43','44')");
        }
        else
        {
            // jdk 1.3
            assertEquals(result, "COL IN ('43','44','42')");
        }
        }
    
    public void testLargeBuildInStringObjectSqlEnumbooleanDB()
    {
        int size = 10000;
        String[] values = new String[size];
        for (int i = 0; i < size; i++)
        {
            Array.set(values, i, String.valueOf(i));
        }
        long start = System.currentTimeMillis();
        String result = SqlExpression.buildIn("COL", values, SqlEnum.IN, 
                true, db);
        long end =  System.currentTimeMillis();
        System.out.println("large buildIn took " + (end - start) + " milliseconds");
    }
    
}