List of addAsColumn() Examples

Examples of 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.
org.apache.torque.util.Criteria.addAsColumn()
Add an AS clause to the select columns. Usage:
Criteria myCrit = new Criteria(); myCrit.addAsColumn("alias", "ALIAS("+MyPeer.ID+")"); @param name wanted Name of the column @param clause SQL clause to select from the tableIf the name already exists, it is replaced by the new clause. @return A modified Criteria object.

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


    public void testAsColumnWithIgnoreCaseIntegerColumnAndDefaultSchema()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("columnAlias", integerColumnMap);
        criteria.addSelectColumn("columnAlias");
        criteria.add("columnAlias", "1");
        criteria.setIgnoreCase(true);
        String oldSchema = database.getSchema();
        try

View Full Code Here

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


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

View Full Code Here

0 1 2

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.