Package gov.niem.tools.api.db.steward

Interface StewardRepository

All Superinterfaces:

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

public interface StewardRepository
extends org.springframework.data.jpa.repository.JpaRepository<Steward,Long>

Repository interface for finding and managing stewards in the database.

Method Summary

Modifier and Type	Method	Description
List<Steward>	findByCategoryOrderByShortName(String category)
List<Steward>	findByCountryOrderByShortName(String category)
List<Steward>	findByFullNameContainingOrderByFullName(String keyword)
Optional<Steward>	findOneById(Long id)
Optional<Steward>	findOneByShortName(String shortName)
Optional<Steward>	findOneByStewardKey(String key)
String	slugify(String value)

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

findOneById

Optional<Steward> findOneById(Long id)

findOneByStewardKey

Optional<Steward> findOneByStewardKey(String key)

findOneByShortName

Optional<Steward> findOneByShortName(String shortName)

findByCategoryOrderByShortName

List<Steward> findByCategoryOrderByShortName(String category)

findByCountryOrderByShortName

List<Steward> findByCountryOrderByShortName(String category)

findByFullNameContainingOrderByFullName

List<Steward> findByFullNameContainingOrderByFullName(String keyword)

slugify

@Query(nativeQuery=true,
       value="select slugify(:value);")
String slugify(@Param("value")
 String value)