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

org.apache.torque.util.Criteria.addJoin()
This is the way that you should add a join of two tables. For example:
AND PROJECT.PROJECT_ID=FOO.PROJECT_ID
left = PROJECT.PROJECT_ID right = FOO.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.

            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table2.column2", "table3.column3", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table4.column4", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table2.column2", Criteria.INNER_JOIN);
        try
        {
            SqlBuilder.buildQuery(criteria);
            fail("Exception expected");

View Full Code Here

    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table2.column2", "table3.column3", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table4.column4", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table2.column2", Criteria.INNER_JOIN);
        try
        {
            SqlBuilder.buildQuery(criteria);
            fail("Exception expected");
        }

View Full Code Here

    public void testLeftJoin()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table1.column", "table2.column", Criteria.LEFT_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT table1.column1"
                    + " FROM table1 LEFT JOIN table2"
                    + " ON table1.column=table2.column",

View Full Code Here

    public void testLeftJoinWithExistingRightTable()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table2.column2", "table3.column3", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table2.column2", Criteria.LEFT_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        // left join must be converted to right join to satisfy
        // first join condition
        assertEquals(

View Full Code Here

            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table2.column2", "table3.column3", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table2.column2", Criteria.LEFT_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        // left join must be converted to right join to satisfy
        // first join condition
        assertEquals(
                "SELECT table1.column1"

View Full Code Here

    public void testRightJoin()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table1.column", "table2.column", Criteria.RIGHT_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT table1.column1"
                    + " FROM table1 RIGHT JOIN table2"
                    + " ON table1.column=table2.column",

View Full Code Here

    public void testRightJoinWithExistingRightTable()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table2.column2", "table3.column3", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table2.column2", Criteria.RIGHT_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        // right join must be converted to left join to satisfy
        // first join condition
        assertEquals(

View Full Code Here

            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table2.column2", "table3.column3", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table2.column2", Criteria.RIGHT_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        // right join must be converted to left join to satisfy
        // first join condition
        assertEquals(
                "SELECT table1.column1"

View Full Code Here

            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("alias.column1");
        criteria.addAlias("alias", "table1");
        criteria.addJoin("alias.column", "table2.column");
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column1 FROM table1 alias, table2"
                    + " WHERE alias.column=table2.column",
                query.toString());

View Full Code Here

            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAsColumn("x", "alias.column");
        criteria.addAlias("alias", "table1");
        criteria.addJoin("x", "table2.column");
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column AS x FROM table2, table1 alias"
                    + " WHERE x=table2.column",
                query.toString());

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.