change Profile Pic

@Modifying(clearAutomatically = true )
@Query(value = ""UPDATE " + GROUP_MEMBERS_TABLE + " SET " + PROFILE_PIC_KEY + "=:" + PROFILE_PIC_KEY + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true )
abstract fun changeProfilePic(@Param(value = "id") userId: String, @Param(value = "profile_pic") profilePic: String)

Method to execute the query to change the user's profile pic

Parameters

userId

: the user identifier

profilePic

: the profile pic chosen by the user to set as the new profile pic