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.

        book.setAuthor(author);
        book.setIsbn("unknown");
        book.save();


        Criteria criteria = new Criteria();
        criteria.addJoin(BookPeer.TITLE, AuthorPeer.NAME);
        BookPeer.addSelectColumns(criteria);
        AuthorPeer.addSelectColumns(criteria);
        // basically a BaseBookPeer.setDbName(criteria);
        // and BasePeer.doSelect(criteria);
        List villageRecords = BookPeer.doSelectVillageRecords(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

        String groupName = uri.toString().substring(uri.toString().lastIndexOf('/') + 1);
                GroupManagement groupService = (GroupManagement)TurbineServices.getInstance()
                                  .getService("GroupManagement");


        Criteria criteria = new Criteria();
        criteria.addJoin(
          TurbineGroupPeer.GROUP_ID,
          TurbineUserGroupRolePeer.GROUP_ID);
        criteria.addJoin(
          TurbineUserGroupRolePeer.USER_ID,
          TurbineUserPeer.USER_ID);

View Full Code Here


        Criteria criteria = new Criteria();
        criteria.addJoin(
          TurbineGroupPeer.GROUP_ID,
          TurbineUserGroupRolePeer.GROUP_ID);
        criteria.addJoin(
          TurbineUserGroupRolePeer.USER_ID,
          TurbineUserPeer.USER_ID);
        criteria.add(TurbineGroupPeer.GROUP_NAME, groupName);
        criteria.setDistinct();
        List users = TurbineUserPeer.doSelectUsers(criteria);

View Full Code Here

        String groupName = uri.toString().substring(uri.toString().lastIndexOf('/') + 1);
                GroupManagement groupService = (GroupManagement)TurbineServices.getInstance()
                                  .getService("GroupManagement");


        Criteria criteria = new Criteria();
        criteria.addJoin(
          TurbineGroupPeer.GROUP_ID,
          TurbineUserGroupRolePeer.GROUP_ID);
        criteria.addJoin(
          TurbineUserGroupRolePeer.USER_ID,
          TurbineUserPeer.USER_ID);

View Full Code Here


        Criteria criteria = new Criteria();
        criteria.addJoin(
          TurbineGroupPeer.GROUP_ID,
          TurbineUserGroupRolePeer.GROUP_ID);
        criteria.addJoin(
          TurbineUserGroupRolePeer.USER_ID,
          TurbineUserPeer.USER_ID);
        criteria.add(TurbineGroupPeer.GROUP_NAME, groupName);
        criteria.setDistinct();
        List users = TurbineUserPeer.doSelectUsers(criteria);

View Full Code Here

            book.save();
        }


        // test left join
        Criteria criteria = new Criteria();
        criteria.addJoin(AuthorPeer.AUTHOR_ID, BookPeer.AUTHOR_ID,
                Criteria.LEFT_JOIN);
        List authorList = AuthorPeer.doSelect(criteria);
        // Here we get 5 authors:
        // the author with one book, the author without books,
        // and three times the author with three books

View Full Code Here

                     + ", should be 5");
        }
      
        // test inner join
        criteria = new Criteria();
        criteria.addJoin(
                AuthorPeer.AUTHOR_ID, BookPeer.AUTHOR_ID,
                Criteria.INNER_JOIN);
        authorList = AuthorPeer.doSelect(criteria);
        // Here we get 4 authors:
        // the author with one book,

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.