Package eu.dnetlib.openaire.community.repository

Interface DbProjectRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<DbProject,DbProjectPK>, org.springframework.data.jpa.repository.JpaRepository<DbProject,DbProjectPK>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<DbProject>, org.springframework.data.repository.PagingAndSortingRepository<DbProject,DbProjectPK>, org.springframework.data.repository.query.QueryByExampleExecutor<DbProject>, org.springframework.data.repository.Repository<DbProject,DbProjectPK>

@ConditionalOnProperty(value="openaire.exporter.enable.community",
                       havingValue="true")
public interface DbProjectRepository
extends org.springframework.data.jpa.repository.JpaRepository<DbProject,DbProjectPK>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<DbProject>

Method Summary

Modifier and Type	Method	Description
void	deleteByCommunity(String id)
org.springframework.data.domain.Page<DbProject>	findByCommunity(String community, org.springframework.data.domain.Pageable page)
List<String>	findFundersByCommunity(String id)

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, findAll, findAll, findAllById, flush, getById, getOne, saveAll, saveAllAndFlush, saveAndFlush

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

count, findAll, findAll, findAll, findOne

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

findAll

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

count, exists, findAll, findOne

Method Details

findByCommunity

org.springframework.data.domain.Page<DbProject> findByCommunity(String community,
 org.springframework.data.domain.Pageable page)

deleteByCommunity

void deleteByCommunity(String id)

findFundersByCommunity

@Query(value="select distinct project_funder from community_projects where community = ?1 order by project_funder",
       nativeQuery=true)
List<String> findFundersByCommunity(String id)