1 /*
2 * Created on 2003-6-19 14:39:59 by joel guo
3 *
4 * vTradEx Information Technology Inc.
5 */
6 package com.cyclops.dbdigger.sql;
7 import com.cyclops.dbdigger.DBDigger;
8 import com.cyclops.dbdigger.DBDiggerTestCase;
9 import com.cyclops.dbdigger.schema.Database;
10 import com.cyclops.dbdigger.sqlcastor.DefaultSQLCastor;
11 /*** Add description <font color="red">HERE</font>!
12 *
13 * @author <a href="mailto:joeblack.guo@vtradex.com">joel guo</a>
14 * @since 2003-6-19 14:39:59
15 */
16 public class SelectTest extends DBDiggerTestCase {
17 /*** Method testNothing()
18 *
19 */
20 public void testExpression() {
21 Database db = DBDigger.getSchema().getDefaultDatabase();
22 Equal e1 =
23 new Equal(
24 db.getTable("c_foo_object2s").getColumn("object_name"),
25 new Integer(4));
26 Equal e2 =
27 new Equal(
28 db.getTable("c_foo_object2s").getColumn("object_name"),
29 new Integer(6));
30 Select sel = new Select();
31 sel.setWhere(new Or(new Equal[] { e1, e2 }));
32 sel.addSelectedColumns(db.getTable("c_foo_object2s").getColumns());
33 DefaultSQLCastor sql = new DefaultSQLCastor();
34 assertEquals(
35 "SELECT c_foo_object2s.id, "
36 + "c_foo_object2s.object_name, "
37 + "c_foo_object2s.sequence, "
38 + "c_foo_object2s.object_data, "
39 + "c_foo_object2s.description FROM c_foo_object2s "
40 + "WHERE (c_foo_object2s.object_name = '4') "
41 + "OR (c_foo_object2s.object_name = '6')",
42 sql.cast(sel));
43 }
44 }
This page was automatically generated by Maven