innoqueue/com.innopolis.innoqueue.domain.notification.dao/NotificationRepository

NotificationRepository

@Repository

interface NotificationRepository : CrudRepository<Notification, Long>

DAO repository for working with "notification" db table

Functions

@Query(value = " SELECT EXISTS( SELECT * FROM notification WHERE user_id = (SELECT user_id FROM "user" WHERE token = :token) AND is_read = false ); ", nativeQuery = true)

abstract fun anyUnreadNotification(token: String): Boolean

Returns boolean whether there is any unread notification for a particular user token

count

abstract fun count(): Long

delete

abstract fun delete(entity: Notification)

deleteAll

abstract fun deleteAll()

abstract fun deleteAll(entities: MutableIterable<Notification>)

deleteAllById

abstract fun deleteAllById(ids: MutableIterable<Long>)

deleteById

abstract fun deleteById(id: Long)

existsById

abstract fun existsById(id: Long): Boolean

findAll

abstract fun findAll(): MutableIterable<Notification>

findAllById

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

findAllByToken

@Query(value = " SELECT * FROM notification WHERE user_id = (SELECT user_id FROM "user" WHERE token = :token) order by "date" DESC; ", nativeQuery = true)

abstract fun findAllByToken(token: String): List<Notification>

Returns all notification for a particular user token

@Query(value = " SELECT * FROM notification WHERE user_id = (SELECT user_id FROM "user" WHERE token = :token) ", countQuery = " SELECT count(*) FROM notification WHERE user_id = (SELECT user_id FROM "user" WHERE token = :token); ", nativeQuery = true)

abstract fun findAllByToken(token: String, pageable: Pageable): Page<Notification>

Returns all notification for a particular user token with pagination

findAllExpiredNotifications

@Query(value = " SELECT * FROM notification WHERE "date" < current_timestamp + INTERVAL '- 2 WEEK'; ", nativeQuery = true)

abstract fun findAllExpiredNotifications(): List<Notification>

Returns notifications which are older than 2 weeks

findById

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

save

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

saveAll

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