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

Class org.apache.torque.criteria.Criteria

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

org.apache.torque.criteria.Criteria.where()
"AND"s Criterion object with the conditions in this Criteria. Equivalent to #and(Criterion) but better to read if this is the first condition to be added to the Criteria. @param criterion A Criterion object. @return A modified Criteria object.

            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("columnAlias", integerColumnMap);
        criteria.addSelectColumn(new ColumnImpl("columnAlias"));
        criteria.where(new ColumnImpl("columnAlias"), "1");
        criteria.setIgnoreCase(true);
        String oldSchema = database.getSchema();
        try
        {
            database.setSchema("schema1");

View Full Code Here


        Criteria criteria = new Criteria();
        criteria.setDbName(databasePostgresql.getName());
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addJoin("table1", "table2", join, null);
        criteria.where(new ColumnImpl("table1.column3"), null, Criteria.ISNULL);


        Query query = SqlBuilder.buildQuery(criteria);


        assertEquals(
                "SELECT table1.column1 FROM table1, table2 "

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

    {
        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)",
                query.toString());
        assertEquals(0, query.getPreparedStatementReplacements().size());
    }

View Full Code Here

    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column"));
        Criterion criterion
                = new Criterion("A", 3, SqlEnum.CUSTOM);
        criteria.where(criterion);
        try
        {
            SqlBuilder.buildQuery(criteria);
            fail("Exception expected");
        }

View Full Code Here

    }
    public void testLvalueIsObject() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column"));
        criteria.where(1, 2);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table WHERE ?=?",
                query.toString());
        assertEquals(2, query.getPreparedStatementReplacements().size());
        assertEquals(1, query.getPreparedStatementReplacements().get(0));

View Full Code Here


    public void testCurrentDate() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column"));
        criteria.where(new ColumnImpl("column"), Criteria.CURRENT_DATE);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table "
                + "WHERE column=CURRENT_DATE",
            query.toString());
        assertEquals(0, query.getPreparedStatementReplacements().size());

View Full Code Here


    public void testCurrentTime() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column"));
        criteria.where(new ColumnImpl("column"), Criteria.CURRENT_TIME);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table "
                + "WHERE column=CURRENT_TIME",
            query.toString());
        assertEquals(0, query.getPreparedStatementReplacements().size());

View Full Code Here


    public void testCurrentTimestamp() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table.column"));
        criteria.where(new ColumnImpl("column"), Criteria.CURRENT_TIMESTAMP);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table.column FROM table "
                + "WHERE column=CURRENT_TIMESTAMP",
            query.toString());
        assertEquals(0, query.getPreparedStatementReplacements().size());

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.