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 testCriterionNullValueAltNotEqual() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column");
        criteria.add("column", (Object) null, Criteria.ALT_NOT_EQUAL);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table "
                + "WHERE column IS NOT NULL",
            query.toString());

View Full Code Here

    }


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

View Full Code Here

    }


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

View Full Code Here

    }


    public void testCriterionCriteria() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");


        Criteria subquery = new Criteria();
        subquery.add("table.column2", "value2");
        subquery.addSelectColumn("table.column3");
        criteria.add("table.column3", subquery);

View Full Code Here

        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");


        Criteria subquery = new Criteria();
        subquery.add("table.column2", "value2");
        subquery.addSelectColumn("table.column3");
        criteria.add("table.column3", subquery);


        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column1 FROM table "
                + "WHERE table.column3=("

View Full Code Here

    }


    public void testCriterionLike() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        criteria.add("table.column2", (Object) "*v%al_e2?", Criteria.LIKE);


        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column1 FROM table "
                + "WHERE table.column2 LIKE ?",

View Full Code Here

     * Test whether LIKE clauses with Escapes are built correctly.
     */
    public void testCriterionLikeWithEscape() throws TorqueException
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        criteria.add(
                "table.column2",
                (Object) "\\*v\\%al\\_e\\\\*2\\?\\",
                Criteria.LIKE);

View Full Code Here

     * Oracle needs to have an ESCAPE clause
     */
    public void testCriterionLikeWithEscapeOracle() throws TorqueException
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        criteria.add(
                "table.column2",
                (Object) "\\*v\\%al\\_e\\\\*2\\?\\",
                Criteria.LIKE);
        criteria.setDbName(databaseOracle.getName());

View Full Code Here

    }


    public void testCriterionLikeIgnoreCase() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        criteria.add("table.column2", (Object) "*v%al_e2?", Criteria.LIKE);
        criteria.setIgnoreCase(true);


        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column1 FROM table "

View Full Code Here

    }


    public void testCriterionLikeIgnoreCaseNoWildcard() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        criteria.add("table.column2", (Object) "value\\\\2", Criteria.LIKE);
        criteria.setIgnoreCase(true);


        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column1 FROM table "

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.