Package com.datengaertnerei.test.dataservice.person

Interface PostalAddressRepository

All Superinterfaces:

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

public interface PostalAddressRepository
extends org.springframework.data.jpa.repository.JpaRepository<PostalAddress,Long>

JPA Repo for postal address entities

Method Summary

Modifier and Type	Method	Description
List<PostalAddress>	findByAddressLocalityIgnoreCase(String addressLocality)
List<PostalAddress>	findByPostalCodeLike(String likeQuery)
List<PostalAddress>	findByPostalCodeStartsWith(String postalCode)
Long	max()
Long	min()

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

findByAddressLocalityIgnoreCase

List<PostalAddress> findByAddressLocalityIgnoreCase(String addressLocality)

Parameters:

addressLocality - addressLocality

Returns:

list of postalAddress objects

findByPostalCodeStartsWith

List<PostalAddress> findByPostalCodeStartsWith(String postalCode)

Parameters:

postalCode - postalCode

Returns:

list of postalAddress objects

findByPostalCodeLike

@Query("SELECT p FROM PostalAddress p WHERE postalCode LIKE ?1")
List<PostalAddress> findByPostalCodeLike(String likeQuery)

Parameters:

likeQuery - postalCode like query

Returns:

list of postalAddress objects

min

@Query("SELECT min(id) FROM PostalAddress")
Long min()

Returns:

first id

max

@Query("SELECT max(id) FROM PostalAddress")
Long max()

Returns:

last id