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

Class org.apache.torque.criteria.Criteria

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

org.apache.torque.criteria.Criteria.addSelectColumn()
Adds a select column to the Criteria. @param column The select column to add. @return A modified Criteria object.

    }


    public void testLimitOffsetMysql() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(stringColumnMap);
        criteria.setLimit(20);
        criteria.setOffset(10);
        criteria.setDbName(databaseMysql.getName());
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT TABLE.COLUMN1 FROM TABLE "

View Full Code Here

    }


    public void testLimitOracle() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(stringColumnMap);
        criteria.setLimit(20);
        criteria.setDbName(databaseOracle.getName());
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT B.* FROM ("
                + " SELECT A.*, rownum AS TORQUE$ROWNUM FROM "

View Full Code Here

    }


    public void testOffsetOracle() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(stringColumnMap);
        criteria.setOffset(10);
        criteria.setDbName(databaseOracle.getName());
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT B.* FROM ("
                + " SELECT A.*, rownum AS TORQUE$ROWNUM FROM "

View Full Code Here

    }


    public void testLimitOffsetOracle() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(stringColumnMap);
        criteria.setLimit(20);
        criteria.setOffset(10);
        criteria.setDbName(databaseOracle.getName());
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT B.* FROM ("

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 "
                + "GROUP BY TABLE.COLUMN1 HAVING count>=10",

View Full Code Here


    public void testSelectColumnWithoutTable()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("*"));
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT * FROM ", query.toString());
    }

View Full Code Here




    public void testCustom() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column"));
        criteria.where("A", "A = functionOf(B)", SqlEnum.CUSTOM);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table WHERE A = functionOf(B)",
                query.toString());
        assertEquals(0, query.getPreparedStatementReplacements().size());

View Full Code Here

    }


    public void testCustomLvalueNull() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column"));
        criteria.where(null, "A = functionOf(B)", SqlEnum.CUSTOM);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table WHERE A = functionOf(B)",
                query.toString());
        assertEquals(0, query.getPreparedStatementReplacements().size());

View Full Code Here

    }


    public void testCriterionCustomSql() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column"));
        Criterion criterion
                = new Criterion("A", null, null, "A = functionOf(B)", null);
        criteria.where(criterion);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table WHERE A = functionOf(B)",

View Full Code Here

    }


    public void testCriterionCustomNoString() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column"));
        Criterion criterion
                = new Criterion("A", 3, SqlEnum.CUSTOM);
        criteria.where(criterion);
        try
        {

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.