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

Class org.apache.torque.criteria.Criteria

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

org.apache.torque.criteria.Criteria.addFrom()
Adds a table to the from clause, not using a joinType or joinCondition. @return the modified Criteria object.


        Criteria subquery = new Criteria();
        subquery.addSelectColumn(new ColumnImpl("count(*)"));
        subquery.where(BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID);
        subquery.and(BookPeer.TITLE, book3.getTitle());
        subquery.addFrom(BookPeer.TABLE_NAME);
        Criteria criteria = new Criteria();
        criteria.where(subquery, 1);


        List<?> result = AuthorPeer.doSelect(criteria);
        assertEquals("Expected result of size 1 but got " + result.size(),

View Full Code Here


    public void testFromElementsSetExplicitly() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addFrom(new FromElement("table3"));
        criteria.where(new ColumnImpl("table2.column2"), 1);


        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table1.column1 FROM table3 "
                + "WHERE table2.column2=?",

View Full Code Here


    public void testFromElementsSetExplicitlyAsString() throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(new ColumnImpl("table1.column1"));
        criteria.addFrom("table3");
        criteria.where(new ColumnImpl("table2.column2"), 1);


        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals("SELECT table1.column1 FROM table3 "
                + "WHERE table2.column2=?",

View Full Code Here

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.