Package org.apache.torque.util

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


        Criteria criteria = new Criteria();
        criteria.add(UserGroupRolePeer.USER_ID,
                ((Persistent) user).getPrimaryKey());
        criteria.add(UserGroupRolePeer.GROUP_ID,
                ((Persistent) group).getPrimaryKey());
        criteria.addJoin(UserGroupRolePeer.ROLE_ID, RolePeer.ROLE_ID);
        return retrieveSet(criteria);
    }

    /**
     * Issues a select based on a criteria.
View Full Code Here


                     user.getName());

        criteria.add(TurbineUserGroupRolePeer.GROUP_ID,
                     ((Persistent) group).getPrimaryKey());

        criteria.addJoin(UserPeerManager.getIdColumn(),
                         TurbineUserGroupRolePeer.USER_ID);

        criteria.addJoin(TurbineUserGroupRolePeer.ROLE_ID, getIdColumn());

        return retrieveSet(criteria);
View Full Code Here

                     ((Persistent) group).getPrimaryKey());

        criteria.addJoin(UserPeerManager.getIdColumn(),
                         TurbineUserGroupRolePeer.USER_ID);

        criteria.addJoin(TurbineUserGroupRolePeer.ROLE_ID, getIdColumn());

        return retrieveSet(criteria);
    }

    /**
 
View Full Code Here

    {
        Criteria criteria = new Criteria();
        criteria.add(TurbineRolePermissionPeer.ROLE_ID,
                     ((Persistent) role).getPrimaryKey());

        criteria.addJoin(TurbineRolePermissionPeer.PERMISSION_ID,
                         getIdColumn());

        return retrieveSet(criteria);
    }
View Full Code Here

            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",
                query.toString());
View Full Code Here

    public void testInnerJoinImplicit()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column");
        criteria.addJoin("table1.column1", "table2.column2");
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT table1.column FROM table1, table2"
                    + " WHERE table1.column1=table2.column2",
                query.toString());
View Full Code Here

    public void testInnerJoinExplicit()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin(
                "table1.column1",
                "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("table1.column1");
        criteria.addJoin("table2.column2", "table3.column3", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table2.column2", Criteria.INNER_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        // second join condition must be changed in order 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.INNER_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        // second join condition must be changed in order to satisfy
        // first join condition
        assertEquals(
                "SELECT table1.column1"
View Full Code Here

    public void testInnerJoinExcplicitWithExistingRightAndLeftTable()
            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);
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.