backend/com.tecknobit.pandoro.services.projects.repositories/ProjectsRepository/editProject

edit Project

@Modifying(clearAutomatically = true )
@Query(value = ""UPDATE " + PROJECTS_KEY + " SET " + NAME_KEY + "=:" + NAME_KEY + "," + PROJECT_DESCRIPTION_KEY + "=:" + PROJECT_DESCRIPTION_KEY + "," + PROJECT_VERSION_KEY + "=:" + PROJECT_VERSION_KEY + "," + PROJECT_REPOSITORY_KEY + "=:" + PROJECT_REPOSITORY_KEY + " WHERE " + AUTHOR_KEY + "=:" + AUTHOR_KEY + " AND " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true )
abstract fun editProject(@Param(value = "author") author: String, @Param(value = "id") projectId: String, @Param(value = "name") name: String, @Param(value = "project_description") description: String, @Param(value = "project_version") version: String, @Param(value = "project_repository") repository: String)

Method to execute the query to edit an existing Project

Parameters

author

The author of the project

projectId

The project identifier

name

The name of the project

description

The description of the project

version

The project_version of the project

repository

The GitHub or Gitlab project_repository url of the project

@Modifying(clearAutomatically = true )
@Query(value = ""UPDATE " + PROJECTS_KEY + " SET " + NAME_KEY + "=:" + NAME_KEY + "," + PROJECT_ICON_KEY + "=:" + PROJECT_ICON_KEY + "," + PROJECT_DESCRIPTION_KEY + "=:" + PROJECT_DESCRIPTION_KEY + "," + PROJECT_VERSION_KEY + "=:" + PROJECT_VERSION_KEY + "," + PROJECT_REPOSITORY_KEY + "=:" + PROJECT_REPOSITORY_KEY + " WHERE " + AUTHOR_KEY + "=:" + AUTHOR_KEY + " AND " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true )
abstract fun editProject(@Param(value = "author") author: String, @Param(value = "id") projectId: String, @Param(value = "name") name: String, @Param(value = "icon") icon: String, @Param(value = "project_description") description: String, @Param(value = "project_version") version: String, @Param(value = "project_repository") repository: String)

Method to execute the query to edit an existing Project

Parameters

author

The author of the project

projectId

The project identifier

name

The name of the project

icon

The icon of the project

description

The description of the project

version

The project_version of the project

repository

The GitHub or Gitlab project_repository url of the project