remove
User
Constraints
@Modifying(clearAutomatically = true
)
@Query(value = ""UPDATE " + UPDATES_KEY + " SET "
+ AUTHOR_KEY + "=NULL,"
+ UPDATE_STARTED_BY_KEY + "=NULL,"
+ UPDATE_PUBLISHED_BY_KEY + "=NULL"
+ " WHERE " + AUTHOR_KEY + "=:" + IDENTIFIER_KEY
+ " OR " + UPDATE_STARTED_BY_KEY + "=:" + IDENTIFIER_KEY
+ " OR " + UPDATE_PUBLISHED_BY_KEY + "=:" + IDENTIFIER_KEY",
nativeQuery = true
)
Method to execute the query to remove the constraints between PandoroUser deleted and ProjectUpdate
Parameters
userId
: the user identifier