editProject

@Modifying(clearAutomatically = true)
@Query(value = ""UPDATE " + PROJECTS_KEY + " SET " + NAME_KEY + "=:" + NAME_KEY + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true)
abstract fun editProject(@Param(value = "id") projectId: String, @Param(value = "name") name: String)

Method to execute the query to edit an existing Project

Parameters

projectId

: the identifier of the project

name

: the project name


@Modifying(clearAutomatically = true)
@Query(value = ""UPDATE " + PROJECTS_KEY + " SET " + NAME_KEY + "=:" + NAME_KEY + "," + LOGO_URL_KEY + "=:" + LOGO_URL_KEY + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true)
abstract fun editProject(@Param(value = "id") projectId: String, @Param(value = "logo_url") logoUrl: String, @Param(value = "name") name: String)

Method to execute the query to add an existing Project

Parameters

projectId

: the identifier of the project

logoUrl

: the logo of the project formatted as url

name

: the project name