Package org.apache.torque.criteria

Examples of org.apache.torque.criteria.Criteria.addGroupByColumn()

1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
    public void testGroupBy()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addGroupByColumn(stringColumnMap);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN1 FROM TABLE GROUP BY TABLE.COLUMN1",
                query.toString());
    }
View Full Code Here
1524
1525
1526
1527
1528
1529
1530
1531
1532
1533
1534
    }

    public void testHaving() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addGroupByColumn(stringColumnMap);
        criteria.addAsColumn("count", new ColumnImpl("count(*)"));
        criteria.addSelectColumn(stringColumnMap);
        criteria.addHaving(
                new Criterion("count", 10, Criteria.GREATER_EQUAL));
        Query query = SqlBuilder.buildQuery(criteria);
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.