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

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

Parameters

joiningQRCodeId

: the identifier of the qrcode

creationDate

: the creation date when the qrcode has been created

joinCode

: the textual join code

projectId

: the project identifier where join with the qrcode