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

Class org.apache.torque.criteria.Criteria

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

org.apache.torque.criteria.Criteria.addAsColumn()
Add an AS clause to the select columns. Usage:
Criteria myCrit = new Criteria(); myCrit.addAsColumn( "alias", "ALIAS("+MyPeer.ID+")"); If the name already exists, it is replaced by the new clause. @param name wanted Name of the column @param clause SQL clause to select from the table @return A modified Criteria object.


    public void testInnerJoinImplicitWithAliasAndAsColumn()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("x", new ColumnImpl("alias.column"));
        criteria.addAlias("alias", "table1");
        criteria.addJoin(new ColumnImpl("x"), new ColumnImpl("table2.column"));
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column AS x FROM table2, table1 alias"

View Full Code Here


    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);
        assertEquals("SELECT TABLE.COLUMN1, count(*) AS count FROM TABLE "

View Full Code Here

0 1

TOP

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.