Interface IntervalRepository

All Superinterfaces:

CrudRepository<IntervalEntity, Integer>, GenericRepository<IntervalEntity, Integer>, PageableRepository<IntervalEntity, Integer>

public interface IntervalRepository
extends PageableRepository<IntervalEntity, Integer>

Method Summary

Modifier and Type	Method	Description
List<IntervalEntity>	findCustom(Duration duration, Period period)
void	saveCustom(Duration duration, Period period)
void	updateCustom(Integer id, Duration duration, Period period)

Methods inherited from interface CrudRepository

count, delete, deleteAll, deleteAll, deleteById, existsById, findAll, findById, save, saveAll, update, updateAll

Methods inherited from interface PageableRepository

findAll, findAll

Method Details

saveCustom

@Query("INSERT INTO interval_entity(duration, period) VALUES (:dur, :per)")
void saveCustom(@Parameter("dur")
 Duration duration,
 @Parameter("per")
 Period period)

findCustom

@Query("SELECT * FROM interval_entity WHERE duration = :dur AND period = :per ORDER BY id ASC")
List<IntervalEntity> findCustom(@Parameter("dur")
 Duration duration,
 @Parameter("per")
 Period period)

updateCustom

@Query("UPDATE interval_entity SET duration = :dur, period = :per WHERE id = :id")
void updateCustom(Integer id,
 @Parameter("dur")
 Duration duration,
 @Parameter("per")
 Period period)