Examples of addJoin()


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

                     + ", should be 5");
        }

        // test inner join
        criteria = new Criteria();
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID, BookPeer.AUTHOR_ID,
                Criteria.INNER_JOIN);
        authorList = AuthorPeer.doSelect(criteria);
        // Here we get 4 authors:
        // the author with one book,
View Full Code Here

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

            return;
        }

        // test right join
        criteria = new Criteria();
        criteria.addJoin(
                BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID,
                Criteria.RIGHT_JOIN);
        authorList = AuthorPeer.doSelect(criteria);
        // Here we get 4 authors:
        // the author with one book, the author without books,
View Full Code Here

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

        }

        // test double join with aliases
        criteria = new Criteria();
        criteria.addAlias("b", BookPeer.TABLE_NAME);
        criteria.addJoin(
                BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID,
                Criteria.RIGHT_JOIN);
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                "b." + getRawColumnName(BookPeer.AUTHOR_ID),
View Full Code Here

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

        criteria = new Criteria();
        criteria.addAlias("b", BookPeer.TABLE_NAME);
        criteria.addJoin(
                BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID,
                Criteria.RIGHT_JOIN);
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                "b." + getRawColumnName(BookPeer.AUTHOR_ID),
                Criteria.LEFT_JOIN);
        authorList = AuthorPeer.doSelect(criteria);
        // Here we get 11 authors:
View Full Code Here

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

        }

        // test double join with aliases and "reversed" second join
        criteria = new Criteria();
        criteria.addAlias("b", BookPeer.TABLE_NAME);
        criteria.addJoin(BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID,
                Criteria.RIGHT_JOIN);
        criteria.addJoin(
                "b." + getRawColumnName(BookPeer.AUTHOR_ID),
                AuthorPeer.AUTHOR_ID,
                Criteria.RIGHT_JOIN);
View Full Code Here

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

        // test double join with aliases and "reversed" second join
        criteria = new Criteria();
        criteria.addAlias("b", BookPeer.TABLE_NAME);
        criteria.addJoin(BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID,
                Criteria.RIGHT_JOIN);
        criteria.addJoin(
                "b." + getRawColumnName(BookPeer.AUTHOR_ID),
                AuthorPeer.AUTHOR_ID,
                Criteria.RIGHT_JOIN);
        authorList = AuthorPeer.doSelect(criteria);
        // Here we get 11 authors:
View Full Code Here

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

        }

        // test ordering by Aliases and in joins
        criteria = new Criteria();
        criteria.addAlias("b", BookPeer.TABLE_NAME);
        criteria.addJoin(BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID);
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                "b." + getRawColumnName(BookPeer.AUTHOR_ID));
        criteria.addAscendingOrderByColumn(
                "b." + getRawColumnName(BookPeer.TITLE));
View Full Code Here

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

        // test ordering by Aliases and in joins
        criteria = new Criteria();
        criteria.addAlias("b", BookPeer.TABLE_NAME);
        criteria.addJoin(BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID);
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                "b." + getRawColumnName(BookPeer.AUTHOR_ID));
        criteria.addAscendingOrderByColumn(
                "b." + getRawColumnName(BookPeer.TITLE));
        criteria.addDescendingOrderByColumn(BookPeer.TITLE);
View Full Code Here

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

                     + ", should be \"Book 3\"");
        }

        criteria = new Criteria();
        criteria.addAlias("b", BookPeer.TABLE_NAME);
        criteria.addJoin(BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID);
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                "b." + getRawColumnName(BookPeer.AUTHOR_ID));
        criteria.addAscendingOrderByColumn(BookPeer.TITLE);
        criteria.addDescendingOrderByColumn(
View Full Code Here

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

        }

        criteria = new Criteria();
        criteria.addAlias("b", BookPeer.TABLE_NAME);
        criteria.addJoin(BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID);
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID,
                "b." + getRawColumnName(BookPeer.AUTHOR_ID));
        criteria.addAscendingOrderByColumn(BookPeer.TITLE);
        criteria.addDescendingOrderByColumn(
                "b." + getRawColumnName(BookPeer.TITLE));
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.