cvs commit: db-torque/src/test/org/apache/torque/util SqlExpressionTest.java

[mp...@apache.org]

mpoeschl    2003/03/18 22:53:16

  Added:       src/test/org/apache/torque/util SqlExpressionTest.java
  Log:
  some simple tests
  
  Revision  Changes    Path
  1.1                  db-torque/src/test/org/apache/torque/util/SqlExpressionTest.java
  
  Index: SqlExpressionTest.java
  ===================================================================
  package org.apache.torque.util;
  
  /* ====================================================================
   * The Apache Software License, Version 1.1
   *
   * Copyright (c) 2001-2003 The Apache Software Foundation.  All rights
   * reserved.
   *
   * Redistribution and use in source and binary forms, with or without
   * modification, are permitted provided that the following conditions
   * are met:
   *
   * 1. Redistributions of source code must retain the above copyright
   *    notice, this list of conditions and the following disclaimer.
   *
   * 2. Redistributions in binary form must reproduce the above copyright
   *    notice, this list of conditions and the following disclaimer in
   *    the documentation and/or other materials provided with the
   *    distribution.
   *
   * 3. The end-user documentation included with the redistribution,
   *    if any, must include the following acknowledgment:
   *       "This product includes software developed by the
   *        Apache Software Foundation (http://www.apache.org/)."
   *    Alternately, this acknowledgment may appear in the software itself,
   *    if and wherever such third-party acknowledgments normally appear.
   *
   * 4. The names "Apache" and "Apache Software Foundation" and
   *    "Apache Turbine" must not be used to endorse or promote products
   *    derived from this software without prior written permission. For
   *    written permission, please contact apache@apache.org.
   *
   * 5. Products derived from this software may not be called "Apache",
   *    "Apache Turbine", nor may "Apache" appear in their name, without
   *    prior written permission of the Apache Software Foundation.
   *
   * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
   * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
   * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
   * DISCLAIMED.  IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
   * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
   * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
   * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
   * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
   * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
   * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
   * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
   * SUCH DAMAGE.
   * ====================================================================
   *
   * This software consists of voluntary contributions made by many
   * individuals on behalf of the Apache Software Foundation.  For more
   * information on the Apache Software Foundation, please see
   * <http://www.apache.org/>.
   */
  
  import junit.framework.TestCase;
  
  import org.apache.torque.adapter.DB;
  import org.apache.torque.adapter.DBFactory;
  
  /**
   * Tests for SqlExpression
   * 
   * @author <a href="mailto:mpoeschl@marmot.at">Martin Poeschl</a>
   * @version $Id: SqlExpressionTest.java,v 1.1 2003/03/19 06:53:16 mpoeschl 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);
          assertEquals(result, "COL IN ('42','43','44')");
  	}
  }