backend/com.tecknobit.nova.helpers.services.repositories.projectsutils/JoiningQRCodeRepository

JoiningQRCodeRepository

@Service

@Repository

interface JoiningQRCodeRepository : JpaRepository<T, ID>

The JoiningQRCodeRepository interface is useful to manage the queries for the joining qrcodes

Author

N7ghtm4r3 - Tecknobit

See also

JpaRepository

Functions

abstract fun <S : T?> count(example: Example<S>): Long

abstract fun delete(entity: T)

abstract fun deleteAll(entities: Iterable<out T>)

abstract fun deleteAllById(ids: Iterable<out ID>)

deleteAllByIdInBatch

abstract fun deleteAllByIdInBatch(ids: Iterable<ID>)

deleteAllInBatch

abstract fun deleteAllInBatch(entities: Iterable<T>)

abstract fun deleteById(id: ID)

open fun deleteInBatch(entities: Iterable<T>)

deleteJoiningQRCode

@Modifying(clearAutomatically = true)

@Query(value = ""DELETE FROM " + JOINING_QRCODES_TABLE + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true)

abstract fun deleteJoiningQRCode(@Param(value = "id") joiningQRCodeId: String)

Method to execute the query to delete an existing JoiningQRCode after that all the member joined in the project or when the qrcode is expired

abstract fun <S : T?> exists(example: Example<S>): Boolean

abstract fun existsById(id: ID): Boolean

abstract fun <S : T?> findAll(example: Example<S>): List<S>

abstract fun findAll(): Iterable<T>

abstract fun findAll(): List<T>

abstract fun findAll(pageable: Pageable): Page<T>

abstract fun <S : T?> findAll(example: Example<S>): Iterable<S>

abstract fun <S : T?> findAll(example: Example<S>, pageable: Pageable): Page<S>

abstract fun findAllById(ids: Iterable<ID>): Iterable<T>

abstract fun findAllById(ids: Iterable<ID>): List<T>

abstract fun <S : T?, R> findBy(example: Example<S>, queryFunction: (FluentQuery.FetchableFluentQuery<S>) -> R): R

abstract fun findById(id: ID): Optional<T>

abstract fun <S : T?> findOne(example: Example<S>): Optional<S>

abstract fun flush()

abstract fun getById(id: ID): T

getJoiningQRCode

@Query(value = ""SELECT * FROM " + JOINING_QRCODES_TABLE + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true)

abstract fun getJoiningQRCode(@Param(value = "id") joiningQRCodeId: String): JoiningQRCode

Method to execute the query to select a JoiningQRCode by its identifier

getJoiningQRCodeByJoinCode

@Query(value = ""SELECT * FROM " + JOINING_QRCODES_TABLE + " WHERE " + JOIN_CODE_KEY + "=:" + JOIN_CODE_KEY", nativeQuery = true)

abstract fun getJoiningQRCodeByJoinCode(@Param(value = "join_code") joinCode: String): JoiningQRCode

Method to execute the query to select a JoiningQRCode by its textual join code

abstract fun getOne(id: ID): T

getReferenceById

abstract fun getReferenceById(id: ID): T

insertJoiningQRCode

@Modifying(clearAutomatically = true)

@Query(value = "INSERT INTO " + JOINING_QRCODES_TABLE + " (" + IDENTIFIER_KEY + "," + CREATION_DATE_KEY + "," + JOIN_CODE_KEY + "," + PROJECT_IDENTIFIER_KEY + ")" + " VALUES (" + ":" + IDENTIFIER_KEY + "," + ":" + CREATION_DATE_KEY + "," + ":" + JOIN_CODE_KEY + "," + ":" + PROJECT_IDENTIFIER_KEY + ")", nativeQuery = true)

abstract fun insertJoiningQRCode(@Param(value = "id") joiningQRCodeId: String, @Param(value = "creation_date") creationDate: Long, @Param(value = "join_code") joinCode: String, @Param(value = "project_id") projectId: String)

Method to execute the query to add a new JoiningQRCode

removeMemberFromMailingList

@Modifying(clearAutomatically = true)

@Query(value = ""DELETE FROM " + JOINING_QRCODES_MEMBERS_KEY + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY + " AND " + EMAIL_KEY + "=:" + EMAIL_KEY", nativeQuery = true)

abstract fun removeMemberFromMailingList(@Param(value = "id") joiningQRCodeId: String, @Param(value = "email") email: String)

Method to execute the query to delete from an existing JoiningQRCode an email of a member invited with that joining qrcode

abstract fun <S : T?> save(entity: S): S

abstract fun <S : T?> saveAll(entities: Iterable<S>): Iterable<S>

abstract fun <S : T?> saveAll(entities: Iterable<S>): List<S>

saveAllAndFlush

abstract fun <S : T?> saveAllAndFlush(entities: Iterable<S>): List<S>

abstract fun <S : T?> saveAndFlush(entity: S): S

updateJoiningQRCode

@Modifying(clearAutomatically = true)

@Query(value = ""UPDATE " + JOINING_QRCODES_TABLE + " SET " + PROJECT_MEMBERS_TABLE + "=:" + PROJECT_MEMBERS_TABLE + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true)

abstract fun updateJoiningQRCode(@Param(value = "id") joiningQRCodeId: String, @Param(value = "project_members") projectMembers: String)

Method to execute the query to update an existing JoiningQRCode after a user join in a project and the allowed mailing list must remove the joined member