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.criteria.Criteria.addAsColumn()

     * @throws Exception if the test fails
     */
    public void testAsColumn() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("ALIASNAME", AuthorPeer.NAME);
        // we need an additional column to select from,
        // to indicate the table we want use
        criteria.addSelectColumn(AuthorPeer.AUTHOR_ID);
        BasePeer.doSelect(criteria, new DoNothingMapper());
    }

View Full Code Here

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

    }


    public void testOrderByWithAsColumn() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("asColumn", stringColumnMap);
        criteria.addAscendingOrderByColumn(new ColumnImpl("asColumn"));
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN1 AS asColumn "
                    + "FROM TABLE "

View Full Code Here

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

    }


    public void testOrderByWithAsColumnIgnoreCase() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("asColumn", stringColumnMap);
        criteria.addAscendingOrderByColumn(new ColumnImpl("asColumn"), true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN1 AS asColumn, UPPER(asColumn) "
                    + "FROM TABLE "

View Full Code Here

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


    public void testOrderByWithAsColumnAndAliasIgnoreCase() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", stringColumnMap.getTableName());
        criteria.addAsColumn(
                "asColumn",
                new ColumnImpl("alias", stringColumnMap.getColumnName()));
        criteria.addAscendingOrderByColumn(new ColumnImpl("asColumn"), true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(

View Full Code Here

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

    }


    public void testAsColumn() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("columnAlias", stringColumnMap);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN1 AS columnAlias FROM TABLE",
                query.toString());
    }

View Full Code Here

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

    }


    public void testAsColumnWithIgnoreCaseUnknownColumn() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("columnAlias", new ColumnImpl("table.column"));
        criteria.where(new ColumnImpl("columnAlias"), "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT table.column AS columnAlias FROM table"

View Full Code Here

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

    }


    public void testAsColumnWithIgnoreCaseStringColumn() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("columnAlias", stringColumnMap);
        criteria.where(new ColumnImpl("columnAlias"), "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN1 AS columnAlias FROM TABLE"

View Full Code Here

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

    }


    public void testAsColumnWithIgnoreCaseIntegerColumn() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("columnAlias", integerColumnMap);
        criteria.where(new ColumnImpl("columnAlias"), "1");
        criteria.setIgnoreCase(true);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT TABLE.COLUMN4 AS columnAlias FROM TABLE"

View Full Code Here

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


    public void testAsColumnWithIgnoreCaseStringColumnAndDefaultSchema()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("columnAlias", stringColumnMap);
        criteria.addSelectColumn(new ColumnImpl("columnAlias"));
        criteria.where(new ColumnImpl("columnAlias"), "1");
        criteria.setIgnoreCase(true);
        String oldSchema = database.getSchema();
        try

View Full Code Here

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


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

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.