Examples of org.apache.torque.criteria.Criterion

org.apache.torque.criteria.Criterion
Describes one or more where clause parts in the Criteria. Either the parts list is not null and represents this criterion or the column, value, comparison and ignoreStringCase columns are not null and represent this criterion.

            .where("BooleanCheck.bint_value", true)
            .and("BooleanCheck.bchar_value", true);


        BintBcharTypePeer.correctBooleans(criteria);


        Criterion criterionBool1
                = criteria.getTopLevelCriterion().getParts().get(0);
        Object boolValue1 = criterionBool1.getRValue();


        assertTrue("The boolean value should be an instance of Boolean",
               boolValue1 instanceof Boolean);


        Criterion criterionBool2
                = criteria.getTopLevelCriterion().getParts().get(1);
        Object boolValue2 = criterionBool2.getRValue();


        assertTrue("The boolean value should be an instance of Boolean",
               boolValue2 instanceof Boolean);
    }

View Full Code Here


                queryWhereClause.add(joinConditionStringBuilder.toString());
            }
            else
            {
                Criterion joinCondition = join.getJoinCondition();


                // get the table names
                // (and the alias names for them if necessary))
                PreparedStatementPart leftExpression;
                if (join.getLeftTable() != null)
                {
                    leftExpression = join.getLeftTable();
                }
                else
                {
                    if (joinCondition.isComposite())
                    {
                        throw new TorqueException(
                                "join condition is composite "
                                + "and there is no leftTable defined "
                                + "in the join. "
                                + "Please define a leftTable in the join");
                    }
                    Object lValue = joinCondition.getLValue();
                    leftExpression = SqlBuilder.getExpressionForFromClause(
                            lValue,
                            criteria);
                }
                PreparedStatementPart rightExpression;
                if (join.getRightTable() != null)
                {
                    rightExpression = join.getRightTable();
                }
                else
                {
                    if (joinCondition.isComposite())
                    {
                        throw new TorqueException(
                                "join condition is composite "
                                + "and there is no rightTable defined "
                                + "in the join. "
                                + "Please define a rightTable in the join");
                    }
                    Object rValue = joinCondition.getRValue();
                    rightExpression = SqlBuilder.getExpressionForFromClause(
                            rValue,
                            criteria);


                }

View Full Code Here

        final Column column1 = new ColumnImpl("myTable", "myColumn1");
        final Column column2 = new ColumnImpl("myTable", "myColumn2");
        final String value1a = "1a";
        final String value1b = "1b";
        final String value2a = "2a";
        Criterion criterion1 = new Criterion(column1, value1a);
        Criterion criterion2 = new Criterion(column1, value1b);
        Criterion criterion3 = new Criterion(column2, value2a);
        criterion1.and(criterion2).and(criterion3);
        Criteria c = new Criteria().where(criterion1);


        Query query = SqlBuilder.buildQuery(c);

View Full Code Here

        final Column column1 = new ColumnImpl("myTable", "myColumn1");
        final Column column2 = new ColumnImpl("myTable", "myColumn2");
        final String value1a = "1a";
        final String value1b = "1b";
        final String value2a = "2a";
        Criterion criterion1 = new Criterion(column1, value1a);
        Criterion criterion2 = new Criterion(column1, value1b);
        Criterion criterion3 = new Criterion(column2, value2a);
        criterion1.or(criterion2).or(criterion3);
        Criteria c = new Criteria().where(criterion1);


        Query query = SqlBuilder.buildQuery(c);

View Full Code Here

        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column"));
        criteria.addJoin(
                "table1",
                "table2",
                new Criterion(
                    new ColumnImpl("table1.column1"),
                    new ColumnImpl("table2.column2"),
                    SqlEnum.NOT_EQUAL),
                null);
        Query query = SqlBuilder.buildQuery(criteria);

View Full Code Here

        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addJoin(
                "table2",
                "table3",
                new Criterion(
                    new ColumnImpl("table2.column2"),
                    new ColumnImpl("table3.column3"),
                    Criteria.LESS_THAN),
                Criteria.INNER_JOIN);
        criteria.addJoin(
                "table1",
                "table2",
                new Criterion(
                    new ColumnImpl("table1.column1"),
                    new ColumnImpl("table2.column2"),
                    Criteria.GREATER_THAN),
                Criteria.INNER_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);

View Full Code Here

    }


    public void testInnerJoinExplicitWithComplicatedCondition()
            throws Exception
    {
        Criterion join1 = new Criterion(new ColumnImpl("table1.column2"), "x");
        Criterion join2 = new Criterion(
                "y",
                new ColumnImpl("table2.column2"),
                SqlEnum.NOT_EQUAL);
        join2.setIgnoreCase(true);
        Criterion join3 = new Criterion(
                new ColumnImpl("table1.column2"),
                new ColumnImpl("table2.column2"));
        Criterion join = new Criterion(join1).and(join2).and(join3);


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

View Full Code Here

    }


    public void testInnerJoinImplicitWithComplicatedCondition()
            throws Exception
    {
        Criterion join1 = new Criterion(new ColumnImpl("table1.column2"), "x");
        Criterion join2 = new Criterion(
                "y",
                new ColumnImpl("table2.column2"),
                SqlEnum.NOT_EQUAL);
        join2.setIgnoreCase(true);
        Criterion join3 = new Criterion(
                new ColumnImpl("table1.column2"),
                new ColumnImpl("table2.column2"));
        Criterion join = new Criterion(join1).and(join2).and(join3);


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

View Full Code Here

        Criteria criteria = new Criteria();
        criteria.addGroupByColumn(stringColumnMap);
        criteria.addAsColumn("count", new ColumnImpl("count(*)"));
        criteria.addSelectColumn(stringColumnMap);
        criteria.addHaving(
                new Criterion("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",
            query.toString());
    }

View Full Code Here


    public void testCriterionCustomSql() throws Exception
    {
        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

0 1 2

TOP

Related Classes of org.apache.torque.criteria.Criterion

org.apache.commons.lang.builder.EqualsBuilder

org.apache.commons.lang.builder.HashCodeBuilder

org.apache.torque.DataTest

org.apache.torque.datatypes.BooleanIntCharTest

org.apache.torque.generated.peer.JoinTest

org.apache.torque.sql.JoinBuilder

org.apache.torque.sql.SqlBuilder

org.apache.torque.sql.SqlBuilderTest

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.