Package org.apache.torque.util

Examples of org.apache.torque.util.Criteria.addSelectColumn()

1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
        for (int i = 0; i < size; i++)
        {
            Array.set(values, i, String.valueOf(i));
        }
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        criteria.add(
                "table.column2",
                values,
                Criteria.IN);
        long start = System.currentTimeMillis();
View Full Code Here
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
    }

    public void testCriterionInString() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        criteria.add(
                "table.column2",
                (Object) "illegal in value",
                Criteria.IN);
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
     * is set.
     */
    public void testignoreCaseUnknownColumnType() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("unknownTable.column1");
        criteria.add("column1", "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT unknownTable.column1 FROM unknownTable "
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
    }

    public void testIgnoreCaseStringColumnType() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(stringColumnMap);
        criteria.add(stringColumnMap, "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN1 FROM TABLE "
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
    }

    public void testIgnoreCaseIntegerColumnType() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(integerColumnMap);
        criteria.add(integerColumnMap, "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN4 FROM TABLE "
View Full Code Here
260
261
262
263
264
265
266
267
268
269
270
    public void testAlias() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", "table");
        criteria.addSelectColumn("alias.column1");
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column1 FROM table alias",
                query.toString());
    }
View Full Code Here
271
272
273
274
275
276
277
278
279
280
281
    public void testAliasWithDefaultSchema() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", "table");
        criteria.addSelectColumn("alias.column1");
        String oldSchema = database.getSchema();
        try
        {
            database.setSchema("schema1");
            criteria.setDbName(database.getName());
View Full Code Here
292
293
294
295
296
297
298
299
300
301
302
    public void testAliasWithIgnoreCaseUnknownColumnType() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", "table");
        criteria.addSelectColumn("alias.column1");
        criteria.add("alias.column1", "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column1 FROM table alias "
View Full Code Here
306
307
308
309
310
311
312
313
314
315
316
    public void testAliasWithIgnoreCaseStringColumnType() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", tableMap.getName());
        criteria.addSelectColumn("alias.COLUMN1");
        criteria.add("alias.COLUMN1", "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.COLUMN1 FROM TABLE alias "
View Full Code Here
320
321
322
323
324
325
326
327
328
329
330
    public void testAliasWithIgnoreCaseIntegerColumnType() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", tableMap.getName());
        criteria.addSelectColumn("alias.COLUMN4");
        criteria.add("alias.COLUMN4", "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.COLUMN4 FROM TABLE alias "
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.