GetPrivateGroupIdsCoordinatedByPerson.java

/*
 * Copyright (c) 2009 Lockheed Martin Corporation
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.eurekastreams.server.persistence.mappers;

import java.util.List;

import javax.persistence.Query;

/**
 * Get a list of the private group ids that a person is a direct coordinator of.
 */
public class GetPrivateGroupIdsCoordinatedByPerson extends
        BaseArgDomainMapper<Long, List<Long>>
{
    /**
     * Get a list of the group ids that the person with the input id is a direct
     * coordinator of.
     * 
     * @param inPersonId
     *            the person id to check for groups coordinated
     * @return a list of all group ids that the person with the input id is a
     *         direct coordinator of
     */
    @SuppressWarnings("unchecked")
    @Override
    public List<Long> execute(final Long inPersonId)
    {
        Query query = getEntityManager()
                .createQuery(
                        "SELECT g.id FROM DomainGroup g, Person p "
                                + "WHERE g.publicGroup=false AND p.id=:personId AND "
                                + "(p member of g.coordinators)");
        query.setParameter("personId", inPersonId);
        return (List<Long>) query.getResultList();
    }
}