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.

    public void testInnerJoinImplicitWithDefaultSchema()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("*");
        criteria.addJoin("table1.column", "table2.column");
        String oldSchema = database.getSchema();
        try
        {
            database.setSchema("schema1");
            criteria.setDbName(database.getName());

View Full Code Here

            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("alias.column1");
        criteria.addAlias("alias", "table1");
        criteria.addJoin("alias.column", "table2.column");
        String oldSchema = database.getSchema();
        try
        {
            database.setSchema("schema1");
            criteria.setDbName(database.getName());

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.add(RolePermissionPeer.ROLE_ID,
                ((TurbineRole) role).getPrimaryKey());
        criteria.addJoin(RolePermissionPeer.PERMISSION_ID,
                PermissionPeer.PERMISSION_ID);
        return retrieveSet(criteria);
    }


    /**

View Full Code Here

        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

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.