edu.pitt.dbmi.ccd.db.repository.GroupRepository.java Source code

Introduction

Here is the source code for edu.pitt.dbmi.ccd.db.repository.GroupRepository.java

Source

/*
 * Copyright (C) 2015 University of Pittsburgh.
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
 * MA 02110-1301  USA
 */
package edu.pitt.dbmi.ccd.db.repository;

import edu.pitt.dbmi.ccd.db.entity.Group;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.domain.Specification;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.rest.core.annotation.RepositoryRestResource;
import org.springframework.stereotype.Repository;

/**
 * @author Mark Silvis (marksilvis@pitt.edu)
 */
@Repository
@RepositoryRestResource(exported = false)
public interface GroupRepository extends JpaRepository<Group, Long>, JpaSpecificationExecutor<Group> {

    /**
     * Find group by id
     *
     * @param id group id
     * @return group
     */
    public Group findById(Long id);

    /**
     * Find group by name
     *
     * @param name group name
     * @return group
     */
    public Group findByName(String name);

    @Query(value = "SELECT g FROM Group AS g " + "LEFT JOIN g.members AS m " + "WHERE m.username = ?1")
    public Page<Group> findByMember(String username, Pageable pageable);

    @Query(value = "SELECT g FROM Group AS g " + "LEFT JOIN g.moderators AS m " + "WHERE m.username = ?1")
    public Page<Group> findByModerator(String username, Pageable pageable);

    @Query(value = "SELECT g FROM Group AS g " + "LEFT JOIN g.requesters AS r " + "WHERE r.username = ?1")
    public Page<Group> findByRequester(String username, Pageable pageable);

    /**
     * Find all groups by spec
     *
     * @param spec group specification
     * @param pageable page request
     * @return page of groups matching parameters
     */
    public Page<Group> findAll(Specification<Group> spec, Pageable pageable);

    /**
     * Find all groups
     *
     * @param pageable page request
     * @return page of groups
     */
    public Page<Group> findAll(Pageable pageable);
}