Package org.apache.torque.criteria

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

1920
1921
1922
1923
1924
1925
1926
1927
1928
1929
1930
    }

    public void testNotLikeIgnoreCaseNoWildcard() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column1"));
        criteria.where(
                new ColumnImpl("table.column2"),
                "value\\\\2",
                Criteria.NOT_LIKE);
        criteria.setIgnoreCase(true);
View Full Code Here
1940
1941
1942
1943
1944
1945
1946
1947
1948
1949
1950
    }

    public void testIlike() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column1"));
        criteria.where(
                new ColumnImpl("table.column2"),
                "*val_e2?",
                Criteria.ILIKE);

View Full Code Here
1959
1960
1961
1962
1963
1964
1965
1966
1967
1968
1969
    }

    public void testNotIlike() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column1"));
        criteria.where(
                new ColumnImpl("table.column2"),
                "*val_e2?",
                Criteria.NOT_ILIKE);

View Full Code Here
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
1988
    }

    public void testLvalueString() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column"));
        criteria.where("X", "Y");
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table WHERE ?=?",
                query.toString());
        assertEquals(2, query.getPreparedStatementReplacements().size());
View Full Code Here
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
    }

    public void testLvalueNull() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column"));
        try
        {
          criteria.where(null, new ColumnImpl("table.column"));
          fail("Exception expected");
        }
View Full Code Here
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
    }

    public void testLvalueCriteria() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column"));
        Criteria subselect = new Criteria();
        subselect.addSelectColumn(new ColumnImpl("table2.column2"));
        criteria.where(subselect, new ColumnImpl("table.column"));
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table WHERE "
View Full Code Here
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
    public void testLvalueCriteria() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column"));
        Criteria subselect = new Criteria();
        subselect.addSelectColumn(new ColumnImpl("table2.column2"));
        criteria.where(subselect, new ColumnImpl("table.column"));
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table WHERE "
                + "(SELECT table2.column2 FROM table2)=table.column",
                query.toString());
View Full Code Here
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
    }

    public void testInArray() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column1"));
        String[] inValue = new String[] {"a", "b", null, null};
        criteria.whereIn(new ColumnImpl("table.column2"), inValue.clone());

        Query query = SqlBuilder.buildQuery(criteria);
View Full Code Here
2044
2045
2046
2047
2048
2049
2050
2051
2052
2053
2054
    }

    public void testInArrayIgnoreCase() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column1"));
        String[] inValue = new String[] {"a", "b", null, null};
        criteria.whereIn(new ColumnImpl("table.column2"), inValue.clone());
        criteria.setIgnoreCase(true);

        Query query = SqlBuilder.buildQuery(criteria);
View Full Code Here
2064
2065
2066
2067
2068
2069
2070
2071
2072
2073
2074
    }

    public void testInList() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column1"));
        List<Integer> inList = new ArrayList<Integer>();
        inList.add(1);
        inList.add(null);
        inList.add(2);
        inList.add(null);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.