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

org.apache.torque.util.Criteria.addAlias()
Allows one to specify an alias for a table that can be used in various parts of the SQL. @param alias a String value @param table a String value

                     + ", should be 5");
        }


        // 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,

View Full Code Here

                     + ", should be 11");
        }


        // 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,

View Full Code Here

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


        // 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(

View Full Code Here

                     + ((Book) bookList.get(2)).getTitle()
                     + ", 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);

View Full Code Here

                     + ", should be 5");
        }
        
        // 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,

View Full Code Here

                     + ", should be 11");
        }
        
        // 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,

View Full Code Here

                     + ", should be \"Book 4\"");
        }
        
        // 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(

View Full Code Here

                     + ((Book) bookList.get(2)).getTitle()
                     + ", 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);

View Full Code Here

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

View Full Code Here

    }


    public void testAlias() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addAlias("alias", "table");
        criteria.addSelectColumn("alias.column1");
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column1 FROM table alias",
                query.toString());

View Full Code Here

0 1

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.