updateCollection

@Modifying(clearAutomatically = true)
@Query(value = ""UPDATE " + COLLECTIONS_KEY + " SET " + COLLECTION_COLOR_KEY + "=:" + COLLECTION_COLOR_KEY + "," + TITLE_KEY + "=:" + TITLE_KEY + "," + DESCRIPTION_KEY + "=:" + DESCRIPTION_KEY + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY + " AND " + OWNER_KEY + "=:" + OWNER_KEY", nativeQuery = true)
abstract fun updateCollection(@Param(value = "id") collectionId: String, @Param(value = "collection_color") color: String, @Param(value = "title") title: String, @Param(value = "description") description: String, @Param(value = "owner") owner: String)

Method to execute the query to edit a collection

Parameters

collectionId

: the identifier of the collection

color

: the color of the collection

title

: the title of the collection

description

: the description of the collection

owner

: the owner of the collection