@Query(value = " SELECT queueId, queueName, color, isActive, name onDutyUserName, dateJoined FROM (SELECT user_queue.queue_id queueId, queue.name queueName, queue.color, user_queue.is_active isActive, queue.current_user_id currentUserId, user_queue.date_joined dateJoined FROM user_queue JOIN queue ON user_queue.queue_id = queue.queue_id WHERE user_id = (SELECT user_id FROM "user" WHERE token = :token)) queue_details JOIN "user" ON currentUserId = "user".user_id ORDER BY queueName; ", nativeQuery = true)

abstract fun findAllUserQueueByToken(token: String): List<UserQueuesShortForm>

Returns a list of user_queue models for a particular user token

findById

abstract fun findById(id: UserQueueId): Optional<UserQueue>

findQueueParticipants

@Query(value = " SELECT user_queue.user_id userId, "user".name userName, user_queue.expenses, user_queue.is_active isActive FROM user_queue JOIN "user" ON user_queue.user_id = "user".user_id WHERE user_queue.queue_id = :queueId ; ", nativeQuery = true)

abstract fun findQueueParticipants(queueId: Long): List<QueueParticipants>

Returns a list of users participating in a particular queue

findUserQueue

@Query(value = " SELECT user_queue.user_id userId, queue.queue_id queueId, queue.current_user_id currentUserId, queue.track_expenses trackExpenses, user_queue.is_active isActive, user_queue.progress, user_queue.completes, user_queue.skips, user_queue.expenses FROM user_queue JOIN queue ON user_queue.queue_id = queue.queue_id WHERE user_id = (SELECT user_id FROM "user" WHERE token = :token) AND user_queue.queue_id = :queueId ; ", nativeQuery = true)

abstract fun findUserQueue(token: String, queueId: Long): UserQueueAndQueue

Returns user_queue model with custom fields for a particular user token and queueId

findUserQueueByQueueId

@Query(value = " SELECT * FROM user_queue WHERE user_queue.queue_id = :queueId ; ", nativeQuery = true)

abstract fun findUserQueueByQueueId(queueId: Long): List<UserQueue>

Returns a list of user_queue models for a particular queueId

findUserQueueByToken

@Query(value = " SELECT * FROM user_queue WHERE user_id = (SELECT user_id FROM "user" WHERE token = :token) AND queue_id = :queueId ; ", nativeQuery = true)

abstract fun findUserQueueByToken(token: String, queueId: Long): UserQueue?

Returns user_queue model for a particular user token and queueId

save

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

saveAll

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