Package com.epam.ta.reportportal.dao

Interface ProjectRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Project,java.lang.Long>, FilterableRepository<Project>, org.springframework.data.jpa.repository.JpaRepository<Project,java.lang.Long>, org.springframework.data.repository.PagingAndSortingRepository<Project,java.lang.Long>, ProjectRepositoryCustom, org.springframework.data.repository.query.QueryByExampleExecutor<Project>, ReportPortalRepository<Project,java.lang.Long>, org.springframework.data.repository.Repository<Project,java.lang.Long>

public interface ProjectRepository
extends ReportPortalRepository<Project,java.lang.Long>, ProjectRepositoryCustom

Method Summary

Modifier and Type	Method	Description
boolean	existsByName(java.lang.String name)
java.util.Optional<Project>	findByName(java.lang.String name)
java.util.List<Project>	findUserProjects(java.lang.String login)
java.util.List<Project>	findUserProjects(java.lang.String login, java.lang.String projectType)

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteById, existsById, findById, save

Methods inherited from interface com.epam.ta.reportportal.dao.FilterableRepository

findByFilter, findByFilter

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlush

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface com.epam.ta.reportportal.dao.ProjectRepositoryCustom

deleteByTypeAndLastLaunchRunBefore, findAllIdsAndProjectAttributes, findAllProjectNames, findAllProjectNamesByTerm, findProjectInfoByFilter, findProjectInfoByFilter

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findOne

Methods inherited from interface com.epam.ta.reportportal.dao.ReportPortalRepository

exists, refresh

Method Detail

findByName

java.util.Optional<Project> findByName(java.lang.String name)

existsByName

boolean existsByName(java.lang.String name)

findUserProjects

@Query(value="SELECT * FROM project p JOIN project_user pu on p.id = pu.project_id JOIN users u on pu.user_id = u.id WHERE u.login = :login",
       nativeQuery=true)
java.util.List<Project> findUserProjects(@Param("login")
                                         java.lang.String login)

findUserProjects

@Query(value="SELECT * FROM project p JOIN project_user pu on p.id = pu.project_id JOIN users u on pu.user_id = u.id WHERE u.login = :login AND p.project_type = :projectType",
       nativeQuery=true)
java.util.List<Project> findUserProjects(@Param("login")
                                         java.lang.String login,
                                         @Param("projectType")
                                         java.lang.String projectType)