Examples of org.apache.turbine.util.db.Criteria

org.apache.turbine.util.db.Criteria
This is a utility class that is used for retrieving different types of values from a hashtable based on a simple name string. This class is meant to minimize the amount of casting that needs to be done when working with Hashtables. NOTE: other methods will be added as needed and as time permits. @author Frank Y. Kim @author John D. McNally @author Brett McLaughlin @author Eric Dobbs @author Henning P. Schmiedehausen @version $Id: Criteria.java,v 1.35 2001/05/30 22:27:49 jmcnally Exp $

     * @exception Exception, a generic exception.
     */
    public static Vector selectAllConfirmedUsers()
        throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.add ( User.CONFIRM_VALUE, User.CONFIRM_DATA );
        criteria.addAscendingOrderByColumn(TurbineUserPeer.LAST_NAME);
        criteria.addAscendingOrderByColumn(TurbineUserPeer.FIRST_NAME);
        criteria.setIgnoreCase(true);
        return TurbineUserPeer.doSelect(criteria);
    }

View Full Code Here

     * @exception Exception, a generic exception.
     */
    public static void deleteRole(int role_id)
        throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.add(ROLE_ID, role_id);
        doDelete(criteria);
    }

View Full Code Here

     * @exception Exception, a generic exception.
     */
    public static void deletePermission(int permission_id)
        throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.add(PERMISSION_ID, permission_id);
        doDelete(criteria);
    }

View Full Code Here

     * @exception Exception, a generic exception.
     */
    public static PermissionSet retrieveSet( Role role )
        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

    /**
     * Builds a criteria object based upon an Permission object
     */
    public static Criteria buildCriteria( Permission permission )
    {
        Criteria criteria = new Criteria();
        if ( !((BaseObject)permission).isNew() )
        {
            criteria.add(PERMISSION_ID, 
                         ((BaseObject)permission).getPrimaryKey());
        }
        criteria.add(NAME, ((SecurityObject)permission).getName());
        
        /*
         * This is causing the the removal and updating of
         * a permission to crap out. This addition to the
         * criteria produces something like:

View Full Code Here

     * @exception Exception, a generic exception.
     */
    public static void doUpdate(Criteria criteria)
        throws Exception
    {
        Criteria selectCriteria = new Criteria(2);
        selectCriteria.put( PERMISSION_ID,
                            criteria.remove(PERMISSION_ID) );
        BasePeer.doUpdate( selectCriteria, criteria );
    }

View Full Code Here

     * @throws Exception, a generic exception.
     */
    public static boolean checkExists( Permission permission )
        throws DataBackendException, Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(PERMISSION_ID);
        criteria.add(NAME, ((SecurityObject)permission).getName());
        Vector results = BasePeer.doSelect(criteria);
        if(results.size() > 1)
        {
            throw new DataBackendException("Multiple permissions named '" + 
                ((SecurityObject)permission).getName() + "' exist!");

View Full Code Here

     * @exception Exception, a generic exception.
     */
    public static RoleSet retrieveSet( User user, Group group )
        throws Exception
    {
        Criteria criteria = new Criteria();
        
        /*
         * Peer specific methods should absolutely NOT be part
         * of any of the generic interfaces in the security system.
         * this is not good.
         *
         * UserPeer up = TurbineSecurity.getUserPeerInstance();
         */
        
        UserPeer up = ((DBSecurityService)TurbineSecurity.getService())
            .getUserPeerInstance();
        
        criteria.add(up.getFullColumnName(UserPeer.USERNAME), user.getUserName());
        criteria.add(GroupPeer.NAME, group.getName());
        criteria.addJoin(up.getFullColumnName(UserPeer.USER_ID), UserGroupRolePeer.USER_ID);


        criteria.addJoin(GroupPeer.GROUP_ID, UserGroupRolePeer.GROUP_ID);
        criteria.addJoin(UserGroupRolePeer.ROLE_ID, RolePeer.ROLE_ID);
        return retrieveSet(criteria);
    }

View Full Code Here

    /**
     * Builds a criteria object based upon an Role object
     */
    public static Criteria buildCriteria( Role role )
    {
        Criteria criteria = new Criteria();
        if ( !((BaseObject)role).isNew() )
        {
            criteria.add(ROLE_ID, ((BaseObject)role).getPrimaryKey());
        }
        criteria.add(NAME, role.getName());
        // causing the removal and updating of roles to
        // crap out because of the generated SQL.
        //criteria.add(OBJECTDATA, role.getAttributes());
        return criteria;
    }

View Full Code Here

     * @exception Exception, a generic exception.
     */
    public static void doUpdate(Criteria criteria)
        throws Exception
    {
        Criteria selectCriteria = new Criteria(2);
        selectCriteria.put( ROLE_ID, criteria.remove(ROLE_ID) );
        BasePeer.doUpdate( selectCriteria, criteria );
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.turbine.util.db.Criteria

org.apache.turbine.om.peer.BasePeer

org.apache.turbine.om.security.peer.GroupPeer

org.apache.turbine.om.security.peer.PermissionPeer

org.apache.turbine.om.security.peer.RolePeer

org.apache.turbine.om.security.peer.RolePermissionPeer

org.apache.turbine.om.security.peer.TurbineUserPeer

org.apache.turbine.services.schedule.JobEntry

org.apache.turbine.services.schedule.JobEntryPeer

org.apache.turbine.services.schedule.TurbineSchedulerService

org.apache.turbine.services.security.BaseSecurityService

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.