addProject

@Modifying(clearAutomatically = true)
@Query(value = "INSERT INTO " + PROJECTS_KEY + " (" + IDENTIFIER_KEY + "," + LOGO_URL_KEY + "," + NAME_KEY + "," + AUTHOR_KEY + " )" + " VALUES (" + ":" + IDENTIFIER_KEY + "," + ":" + LOGO_URL_KEY + "," + ":" + NAME_KEY + "," + ":" + AUTHOR_KEY + ")", nativeQuery = true)
abstract fun addProject(@Param(value = "id") projectId: String, @Param(value = "logo_url") logoUrl: String, @Param(value = "name") name: String, @Param(value = "author") author: String)

Method to execute the query to add a new Project

Parameters

projectId

: the identifier of the project

logoUrl

: the logo of the project formatted as url

name

: the project name

author

: the identifier of the author who create the project