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

Class org.apache.torque.criteria.Criteria

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

org.apache.torque.criteria.Criteria.addJoin()
Adds a join to the criteria, E.g. to create the condition
AND PROJECT.PROJECT_ID=FOO.PROJECT_ID
use
criteria.addJoin(ProjectPeer.PROJECT_ID, FooPeer.PROJECT_ID) @param left A String with the left side of the join. @param right A String with the right side of the join. @return A modified Criteria object.

        insertTestData();
        Criteria criteria = new Criteria();
        Criterion joinCondition = new Criterion(AuthorPeer.AUTHOR_ID,
                BookPeer.AUTHOR_ID);
        joinCondition.and(new Criterion(BookPeer.TITLE, "Book 1"));
        criteria.addJoin(
                AuthorPeer.TABLE_NAME,
                BookPeer.TABLE_NAME,
                joinCondition,
                null);

View Full Code Here

        insertTestData();
        Criteria criteria = new Criteria();
        Criterion joinCondition = new Criterion(AuthorPeer.AUTHOR_ID,
                BookPeer.AUTHOR_ID);
        joinCondition.and(new Criterion(BookPeer.TITLE, "Book 1"));
        criteria.addJoin(
                AuthorPeer.TABLE_NAME,
                BookPeer.TABLE_NAME,
                joinCondition,
                Criteria.INNER_JOIN);

View Full Code Here

    {
        fillTables();


        Criteria criteria = new Criteria();
        criteria.addAlias("bc", BintBcharTypePeer.TABLE_NAME);
        criteria.addJoin(
                BintBcharTypePeer.ID,
                new ColumnImpl("bc.id"));
        criteria.where(new ColumnImpl("bc.BINT_VALUE"), new Boolean(false))
                .and(new ColumnImpl("bc.BCHAR_VALUE"), new Boolean(false))
                .and(new ColumnImpl("bc.BINT_OBJECT_VALUE"), new Boolean(false))

View Full Code Here

                = ForeignKeySchemaData.getDefaultTestData();
        testData.save();


        // call delete method
        Criteria criteria = new Criteria();
        criteria.addJoin(
                NullableOIntegerFkPeer.FK,
                OIntegerPkPeer.ID,
                Criteria.INNER_JOIN);
        criteria.and(
                OIntegerPkPeer.ID,

View Full Code Here

    public void testInnerJoinImplicit()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column"));
        criteria.addJoin(
                new ColumnImpl("table1.column1"),
                new ColumnImpl("table2.column2"));
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT table1.column FROM table1, table2"

View Full Code Here

    public void testInnerJoinImplicitWithComparison()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column"));
        criteria.addJoin(
                "table1",
                "table2",
                new Criterion(
                    new ColumnImpl("table1.column1"),
                    new ColumnImpl("table2.column2"),

View Full Code Here

    public void testInnerJoinExplicit()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addJoin(
                new ColumnImpl("table1.column1"),
                new ColumnImpl("table2.column2"),
                Criteria.INNER_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(

View Full Code Here

    public void testInnerJoinWithExcplicitExistingRightTable()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addJoin(
                new ColumnImpl("table2.column2"),
                new ColumnImpl("table3.column3"),
                Criteria.INNER_JOIN);
        criteria.addJoin(
                new ColumnImpl("table1.column1"),

View Full Code Here

        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addJoin(
                new ColumnImpl("table2.column2"),
                new ColumnImpl("table3.column3"),
                Criteria.INNER_JOIN);
        criteria.addJoin(
                new ColumnImpl("table1.column1"),
                new ColumnImpl("table2.column2"),
                Criteria.INNER_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        // second join condition must be changed in order to satisfy

View Full Code Here

    public void testInnerJoinWithExcplicitExistingRightTableAndOperator()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addJoin(
                "table2",
                "table3",
                new Criterion(
                    new ColumnImpl("table2.column2"),
                    new ColumnImpl("table3.column3"),

View Full Code Here

0 1 2 3 4

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.