Package info.ejava.examples.db.jpa.songs.repo

Interface SongsRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Song,Integer>, org.springframework.data.jpa.repository.JpaRepository<Song,Integer>, org.springframework.data.repository.ListCrudRepository<Song,Integer>, org.springframework.data.repository.ListPagingAndSortingRepository<Song,Integer>, org.springframework.data.repository.PagingAndSortingRepository<Song,Integer>, org.springframework.data.repository.query.QueryByExampleExecutor<Song>, org.springframework.data.repository.Repository<Song,Integer>, SongsRepositoryCustom

public interface SongsRepository
extends org.springframework.data.jpa.repository.JpaRepository<Song,Integer>, SongsRepositoryCustom

Method Summary

Modifier and Type	Method	Description
List<Song>	findByArtistGESize(int length)
List<Song>	findByReleasedAfter(LocalDate date)
org.springframework.data.domain.Page<Song>	findByReleasedAfter(LocalDate date, org.springframework.data.domain.Pageable pageable)
List<Song>	findByReleasedBetween(LocalDate starting, LocalDate ending)
org.springframework.data.domain.Page<Song>	findByReleasedBetween(LocalDate starting, LocalDate ending, org.springframework.data.domain.Pageable pageable)
List<Song>	findByReleasedGreaterThanEqual(LocalDate date)
List<Song>	findByTitle(String title)
List<Song>	findByTitleContaining(String string)
List<Song>	findByTitleGESize(int length)
List<Song>	findByTitleLike(String string)
List<Song>	findByTitleNot(String title)
List<Song>	findByTitleNotContaining(String title)
List<Song>	findByTitleNotLike(String title)
List<Song>	findByTitleNullAndReleasedAfter(LocalDate date)
org.springframework.data.domain.Slice<Song>	findByTitleNullAndReleasedAfter(LocalDate date, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Slice<Song>	findByTitleStartingWith(String string, org.springframework.data.domain.Pageable pageable)
List<Song>	findByTitleStartingWith(String string, org.springframework.data.domain.Sort sort)
org.springframework.data.domain.Page<Song>	findPageByTitleNullAndReleasedAfter(LocalDate date, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<Song>	findPageByTitleStartingWith(String string, org.springframework.data.domain.Pageable pageable)
Optional<Song>	getByTitle(String title)
List<String>	getTitlesGESizeNative(int length)

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

Methods inherited from interface info.ejava.examples.db.jpa.songs.repo.SongsRepositoryCustom

random

Method Details

getByTitle

Optional<Song> getByTitle(String title)

findByTitle

List<Song> findByTitle(String title)

findByTitleNot

List<Song> findByTitleNot(String title)

findByTitleContaining

List<Song> findByTitleContaining(String string)

findByTitleNotContaining

List<Song> findByTitleNotContaining(String title)

findByTitleLike

List<Song> findByTitleLike(String string)

findByTitleNotLike

List<Song> findByTitleNotLike(String title)

findByReleasedAfter

List<Song> findByReleasedAfter(LocalDate date)

findByReleasedGreaterThanEqual

List<Song> findByReleasedGreaterThanEqual(LocalDate date)

findByReleasedBetween

List<Song> findByReleasedBetween(LocalDate starting,
 LocalDate ending)

findByReleasedAfter

org.springframework.data.domain.Page<Song> findByReleasedAfter(LocalDate date,
 org.springframework.data.domain.Pageable pageable)

findByReleasedBetween

@Query("select s from Song s where released between :starting and :ending order by id ASC")
org.springframework.data.domain.Page<Song> findByReleasedBetween(LocalDate starting,
 LocalDate ending,
 org.springframework.data.domain.Pageable pageable)

findByTitleNullAndReleasedAfter

List<Song> findByTitleNullAndReleasedAfter(LocalDate date)

findByTitleNullAndReleasedAfter

org.springframework.data.domain.Slice<Song> findByTitleNullAndReleasedAfter(LocalDate date,
 org.springframework.data.domain.Pageable pageable)

findPageByTitleNullAndReleasedAfter

org.springframework.data.domain.Page<Song> findPageByTitleNullAndReleasedAfter(LocalDate date,
 org.springframework.data.domain.Pageable pageable)

getTitlesGESizeNative

@Query(value="select s.title from REPOSONGS_SONG s where length(s.title) >= :length",
       nativeQuery=true)
List<String> getTitlesGESizeNative(@Param("length")
 int length)

findByTitleGESize

@Query("select s from Song s where length(s.title) >= :length")
List<Song> findByTitleGESize(@Param("length")
 int length)

findByArtistGESize

List<Song> findByArtistGESize(@Param("length")
 int length)

findByTitleStartingWith

List<Song> findByTitleStartingWith(String string,
 org.springframework.data.domain.Sort sort)

findByTitleStartingWith

org.springframework.data.domain.Slice<Song> findByTitleStartingWith(String string,
 org.springframework.data.domain.Pageable pageable)

findPageByTitleStartingWith

org.springframework.data.domain.Page<Song> findPageByTitleStartingWith(String string,
 org.springframework.data.domain.Pageable pageable)