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

insert Project

@Modifying(clearAutomatically = true )

@Query(value = "INSERT INTO " + PROJECTS_KEY + "( " + AUTHOR_KEY + "," + IDENTIFIER_KEY + "," + NAME_KEY + "," + PROJECT_ICON_KEY + "," + CREATION_DATE_KEY + "," + PROJECT_DESCRIPTION_KEY + "," + PROJECT_VERSION_KEY + "," + PROJECT_REPOSITORY_KEY + ") VALUES " + "( " + ":" + AUTHOR_KEY + "," + ":" + IDENTIFIER_KEY + "," + ":" + NAME_KEY + "," + ":" + PROJECT_ICON_KEY + "," + ":" + CREATION_DATE_KEY + "," + ":" + PROJECT_DESCRIPTION_KEY + "," + ":" + PROJECT_VERSION_KEY + "," + ":" + PROJECT_REPOSITORY_KEY + ")", nativeQuery = true )

abstract fun insertProject(@Param(value = "author") author: String, @Param(value = "id") projectId: String, @Param(value = "name") name: String, @Param(value = "icon") icon: String, @Param(value = "creation_date") creationDate: Long, @Param(value = "project_description") description: String, @Param(value = "project_version") version: String, @Param(value = "project_repository") repository: String)

Method to execute the query to add a new Project

Parameters

author

The author of the project

projectId

The project identifier

name

The name of the project

icon

The icon of the project

creationDate

The date when the project has been created

description

The description of the project

version

The project_version of the project

repository

The GitHub or Gitlab project_repository url of the project