Package dev.dokimos.server.repository

Interface ProjectRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Project,UUID>, org.springframework.data.jpa.repository.JpaRepository<Project,UUID>, org.springframework.data.repository.ListCrudRepository<Project,UUID>, org.springframework.data.repository.ListPagingAndSortingRepository<Project,UUID>, org.springframework.data.repository.PagingAndSortingRepository<Project,UUID>, org.springframework.data.repository.query.QueryByExampleExecutor<Project>, org.springframework.data.repository.Repository<Project,UUID>

public interface ProjectRepository
extends org.springframework.data.jpa.repository.JpaRepository<Project,UUID>

Method Summary

Modifier and Type	Method	Description
List<Object[]>	findAllWithExperimentCount()
Optional<Project>	findByName(String name)

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

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

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

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

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

findAll, findAllById, saveAll

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

findAll

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

findAll

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

count, exists, findAll, findBy, findOne

Method Details

findByName

Optional<Project> findByName(String name)

findAllWithExperimentCount

@Query("SELECT p, COUNT(e) as experimentCount\nFROM Project p\nLEFT JOIN p.experiments e\nGROUP BY p\nORDER BY p.createdAt DESC\n")
List<Object[]> findAllWithExperimentCount()