/*
* Copyright 2008 Udai Gupta, Ralf Joachim
*
* 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.
*/
package org.castor.cpa.query;
import junit.framework.TestCase;
import org.castor.cpa.query.object.OrderImpl;
/**
* Junit test for testing query object implimentation.
*
* @author <a href="mailto:mailtoud AT gmail DOT com">Udai Gupta</a>
* @author <a href="mailto:ralf DOT joachim AT syscon DOT eu">Ralf Joachim</a>
* @version $Revision: 7121 $ $Date: 2006-04-25 16:09:10 -0600 (Tue, 25 Apr
* 2006) $
* @since 1.3
*/
public final class TestQOImplimentation extends TestCase {
//--------------------------------------------------------------------------
public static void testSimpleSelect() {
SelectQuery select = QueryFactory.newSelectQuery();
Schema schema = select.newSchema(Foo.class, "o");
select.addSchema(schema);
//System.out.println(select.toString());
String expected = "SELECT FROM org.castor.cpa.query.Foo AS o";
String actual = select.toString();
assertEquals(actual, expected);
}
public static void testDistinctSelect() {
SelectQuery select = QueryFactory.newSelectQuery();
Schema schema = select.newSchema(Foo.class, "o");
select.setDistinct(true);
select.addSchema(schema);
//System.out.println(select.toString());
String expected = "SELECT DISTINCT FROM org.castor.cpa.query.Foo AS o";
String actual = select.toString();
assertEquals(actual, expected);
}
public static void testProjectionSelect() {
SelectQuery select = QueryFactory.newSelectQuery();
Schema schema = select.newSchema(Foo.class, "o");
select.addProjection(schema.field("bar"));
select.addSchema(schema);
//System.out.println(select.toString());
String expected = "SELECT o.bar FROM org.castor.cpa.query.Foo AS o";
String actual = select.toString();
assertEquals(actual, expected);
}
public static void testOrderBySelect() {
SelectQuery select = QueryFactory.newSelectQuery();
Schema schema = select.newSchema(Foo.class, "o");
select.setDistinct(true);
select.addProjection(schema.field("bar"));
select.addSchema(schema);
Order order = new OrderImpl();
order.add(schema.field("kit"), OrderDirection.ASCENDING);
select.setOrder(order);
//System.out.println(select.toString());
String expected = "SELECT DISTINCT o.bar FROM org.castor.cpa.query.Foo AS o"
+ " ORDER BY o.kit ASC";
String actual = select.toString();
assertEquals(actual, expected);
}
//--------------------------------------------------------------------------
}