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

org.apache.torque.util.Criteria.addSelectColumn()
Add select column. @param name A String with the name of the select column. @return A modified Criteria object.

    }


    public void testOffsetMysql() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(stringColumnMap);
        criteria.setOffset(10);
        criteria.setDbName(databaseMysql.getName());
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT TABLE.COLUMN1 FROM TABLE "
                + "LIMIT 18446744073709551615 OFFSET 10",

View Full Code Here

    }


    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 testHaving() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addGroupByColumn(stringColumnMap);
        criteria.addAsColumn("count", "count(*)");
        criteria.addSelectColumn(stringColumnMap);
        criteria.addHaving(
                criteria.getNewCriterion("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("*");
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT * FROM ", query.toString());
    }

View Full Code Here




    public void testCriterionCustom() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column");
        criteria.add("A", (Object) "A = functionOf(B)", Criteria.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 testCriterionCurrentDate() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column");
        criteria.add("column", Criteria.CURRENT_DATE);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table "
                + "WHERE column=CURRENT_DATE",
            query.toString());

View Full Code Here

    }


    public void testCriterionCurrentTime() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column");
        criteria.add("column", Criteria.CURRENT_TIME);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table "
                + "WHERE column=CURRENT_TIME",
            query.toString());

View Full Code Here

    }


    public void testCriterionObjectKey() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column");
        criteria.add("column", new NumberKey(11));
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table "
                + "WHERE column=?",
            query.toString());

View Full Code Here

    }


    public void testCriterionNullValue() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column");
        criteria.add("column", null);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table "
                + "WHERE column IS NULL",
            query.toString());

View Full Code Here

    }


    public void testCriterionNullValueNotEqual() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column");
        criteria.add("column", (Object) null, Criteria.NOT_EQUAL);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table "
                + "WHERE column IS NOT NULL",
            query.toString());

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.