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

delete Projects

@Modifying(clearAutomatically = true )

@Query(value = ""DELETE pg FROM " + PROJECTS_GROUPS_TABLE + " pg LEFT JOIN " + PROJECTS_KEY + " ON " + PROJECTS_KEY + "." + IDENTIFIER_KEY + "=" + "pg." + PROJECT_IDENTIFIER_KEY + " WHERE " + PROJECTS_KEY + "." + AUTHOR_KEY + "=:" + AUTHOR_KEY", nativeQuery = true )

abstract fun deleteProjects(@Param(value = "author") userId: String)

Method to execute the query to delete the current list of projects of an user

Parameters

userId

The user identifier