RefyUsersRepository
The RefyUsersRepository
interface is useful to manage the queries for the users operations
Author
N7ghtm4r3 - Tecknobit
See also
JpaRepository
EquinoxUsersRepository
Functions
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = ""DELETE FROM " + USERS_KEY + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true)
Method to execute the query to delete a user from the system
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
@Query(value = ""SELECT " + IDENTIFIER_KEY + "," + PROFILE_PIC_KEY + "," + NAME_KEY + "," + SURNAME_KEY + ","
+ TAG_NAME_KEY + " FROM " + USERS_KEY + " WHERE " + IDENTIFIER_KEY + "!=:" + IDENTIFIER_KEY", nativeQuery = true)
Method to execute the query to get the potential members for a team
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
abstract fun saveUser(p: String, p1: String, p2: String, p3: String, p4: String, p5: String, p6: String, p7: String)
@Modifying(clearAutomatically = true)
@Query(value = "INSERT INTO " + USERS_KEY + "(" +
DISCRIMINATOR_VALUE_KEY + "," +
IDENTIFIER_KEY + "," +
TOKEN_KEY + "," +
TAG_NAME_KEY + "," +
NAME_KEY + "," +
SURNAME_KEY + "," +
EMAIL_KEY + "," +
PASSWORD_KEY + "," +
LANGUAGE_KEY
+ ") VALUES (" +
":" + DISCRIMINATOR_VALUE_KEY + "," +
":" + IDENTIFIER_KEY + "," +
":" + TOKEN_KEY + "," +
":" + TAG_NAME_KEY + "," +
":" + NAME_KEY + "," +
":" + SURNAME_KEY + "," +
":" + EMAIL_KEY + "," +
":" + PASSWORD_KEY + "," +
":" + LANGUAGE_KEY +
")", nativeQuery = true)
Method to execute the query to save a new user in the system