Package com.eeit87t3.tickiteasy.event.repository

Interface EventsRepo

All Superinterfaces:

org.springframework.data.repository.CrudRepository<EventsEntity,Integer>, JpaRepository<EventsEntity,Integer>, JpaSpecificationExecutor<EventsEntity>, org.springframework.data.repository.ListCrudRepository<EventsEntity,Integer>, org.springframework.data.repository.ListPagingAndSortingRepository<EventsEntity,Integer>, org.springframework.data.repository.PagingAndSortingRepository<EventsEntity,Integer>, org.springframework.data.repository.query.QueryByExampleExecutor<EventsEntity>, org.springframework.data.repository.Repository<EventsEntity,Integer>

public interface EventsRepo
extends JpaRepository<EventsEntity,Integer>, JpaSpecificationExecutor<EventsEntity>

Author:

Chuan (chuan13)

Method Summary

Modifier and Type	Method	Description
List<EventsEntity>	findByDynamic(String eventName, List<Short> statuses, String categoryString, LocalDateTime searchingStartTime, LocalDateTime searchingEndTime)
List<EventsEntity>	findByEventCategory(CategoryEntity eventCategory)
EventsEntity	findByEventName(String eventName)
List<EventsEntity>	findByEventTag(TagEntity eventTag)
List<EventsEntity>	findByStatusIn(List<Integer> statuses)

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.jpa.repository.JpaSpecificationExecutor

count, delete, exists, findAll, findAll, findAll, findBy, findOne

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

findByEventCategory

List<EventsEntity> findByEventCategory(CategoryEntity eventCategory)

findByEventTag

List<EventsEntity> findByEventTag(TagEntity eventTag)

findByEventName

EventsEntity findByEventName(String eventName)

findByStatusIn

List<EventsEntity> findByStatusIn(List<Integer> statuses)

findByDynamic

@Query("SELECT e FROM EventsEntity AS e WHERE 1 = 1\n\tAND (:eventName IS NULL OR e.eventName LIKE %:eventName%)\n\tAND (:statuses IS NULL OR e.status IN :statuses)\n\tAND (:categoryString IS NULL OR e.eventCategory.categoryString = :categoryString)\n\tAND ((:searchingStartTime IS NULL OR :searchingStartTime BETWEEN e.eventStartTime AND e.eventEndTime)\n\t\tOR (:searchingEndTime IS NULL OR :searchingEndTime BETWEEN e.eventStartTime AND e.eventEndTime)\n\t\tOR ((:searchingStartTime IS NULL OR :searchingStartTime < e.eventStartTime)\n\t\t\tAND (:searchingEndTime IS NULL OR :searchingEndTime > e.eventEndTime)))\n")
List<EventsEntity> findByDynamic(@Param("eventName")
 String eventName,
 @Param("statuses")
 List<Short> statuses,
 @Param("categoryString")
 String categoryString,
 @Param("searchingStartTime")
 LocalDateTime searchingStartTime,
 @Param("searchingEndTime")
 LocalDateTime searchingEndTime)