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 testCriterionLikeInteger() throws TorqueException
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        criteria.add(
                "table.column2",
                1,
                Criteria.LIKE);

View Full Code Here

    }


    public void testCriterionNotLike() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        criteria.add("table.column2", (Object) "*val_e2?", Criteria.NOT_LIKE);


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

View Full Code Here

    }


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


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

View Full Code Here

    }


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


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

View Full Code Here

    }


    public void testCriterionIlike() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        criteria.add("table.column2", (Object) "*val_e2?", Criteria.ILIKE);


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

View Full Code Here

    }


    public void testCriterionNotIlike() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        criteria.add("table.column2", (Object) "*val_e2?", Criteria.NOT_ILIKE);


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

View Full Code Here

    }


    public void testCriterionInArray() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        criteria.add(
                "table.column2",
                new String[] {"a", "b", null, null},
                Criteria.IN);

View Full Code Here

    }


    public void testCriterionInArrayIgnoreCase() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        criteria.add(
                "table.column2",
                new String[] {"a", "b", null, null},
                Criteria.IN);
        criteria.setIgnoreCase(true);

View Full Code Here

    }


    public void testCriterionInList() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        List<Integer> inList = new ArrayList<Integer>();
        inList.add(1);
        inList.add(2);
        inList.add(null);
        inList.add(null);

View Full Code Here

    }


    public void testCriterionInListIgnoreCase() throws Exception
        {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table.column1");
        List<String> inList = new ArrayList<String>();
        inList.add("a");
        inList.add(null);
        inList.add("b");
        inList.add(null);

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.