innoqueue/com.innopolis.innoqueue.domain.queue.dao/QueueRepository

QueueRepository

@Repository

interface QueueRepository : CrudRepository<Queue, Long> , JpaSpecificationExecutor<Queue>

DAO repository for working with "queue" db table

Functions

abstract fun count(@Nullable spec: Specification<Queue>): Long

abstract fun count(): Long

abstract fun delete(entity: Queue)

abstract fun deleteAll()

abstract fun deleteAll(entities: MutableIterable<Queue>)

abstract fun deleteAllById(ids: MutableIterable<Long>)

abstract fun deleteById(id: Long)

abstract fun exists(spec: Specification<Queue>): Boolean

abstract fun existsById(id: Long): Boolean

abstract fun findAll(@Nullable spec: Specification<Queue>): MutableList<Queue>

abstract fun findAll(@Nullable spec: Specification<Queue>, pageable: Pageable): Page<Queue>

abstract fun findAll(@Nullable spec: Specification<Queue>, sort: Sort): MutableList<Queue>

abstract fun findAll(): MutableIterable<Queue>

abstract fun findAllById(ids: MutableIterable<Long>): MutableIterable<Queue>

abstract fun findById(id: Long): Optional<Queue>

abstract fun findOne(@Nullable spec: Specification<Queue>): Optional<Queue>

@Query(value = " SELECT pin_code FROM queue WHERE pin_code IS NOT NULL; ", nativeQuery = true)

abstract fun findPinCodes(): List<String>

Returns list of existing pin codes

@Query(value = " SELECT qr_code FROM queue WHERE qr_code IS NOT NULL; ", nativeQuery = true)

abstract fun findQrCodes(): List<String>

Returns list of existing QR codes

@Query(value = " SELECT queue.queue_id queueId, queue.name queueName, queue.color queueColor, queue.is_important isImportant, queue.track_expenses trackExpenses FROM queue JOIN user_queue ON queue.queue_id = user_queue.queue_id WHERE queue.current_user_id = user_queue.user_id AND queue.current_user_id = (SELECT user_id FROM "user" WHERE token = :token) AND queue.queue_id in (SELECT queue_id FROM user_queue GROUP BY queue_id HAVING COUNT(*) > 1) ORDER BY queue.name, queue.is_important DESC; ", nativeQuery = true)

abstract fun findToDoTasks(token: String): List<QueueAndUserQueue>

Returns queues for which a particular user is on duty

abstract fun <S : Queue> save(entity: S): S

abstract fun <S : Queue> saveAll(entities: MutableIterable<S>): MutableIterable<S>