Examples of addJoin()


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

    {
        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

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

                     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

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

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

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

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

        return retrieveSet(criteria);
    }

    /**
 
View Full Code Here

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

            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

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

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

        // inner joins
        List bookAuthors = null;
        try
        {
            Criteria criteria = new Criteria();
            criteria.addJoin(
                    AuthorPeer.AUTHOR_ID,
                    BookPeer.AUTHOR_ID,
                    Criteria.INNER_JOIN);

            bookAuthors = AuthorPeer.doSelect(criteria);
View Full Code Here

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

        // test left outer join
        bookAuthors = null;
        try
        {
              Criteria criteria = new Criteria();
              criteria.addJoin(
                      AuthorPeer.AUTHOR_ID,
                      BookPeer.AUTHOR_ID,
                      Criteria.LEFT_JOIN);
              bookAuthors = AuthorPeer.doSelect(criteria);
        }
View Full Code Here

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

    {
        List bookAuthors = null;
        try
        {
            Criteria criteria = new Criteria();
            criteria.addJoin(
                    AuthorPeer.AUTHOR_ID,
                    BookPeer.AUTHOR_ID,
                    Criteria.INNER_JOIN);
            criteria.setDistinct();
View Full Code Here

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

    {
        List bookAuthors = null;
        try
        {
            Criteria criteria = new Criteria();
            criteria.addJoin(
                    AuthorPeer.AUTHOR_ID,
                    BookPeer.AUTHOR_ID,
                    Criteria.INNER_JOIN);
            criteria.setDistinct();
            criteria.addAscendingOrderByColumn(AuthorPeer.NAME);
View Full Code Here

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

            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
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.