CustomLinksRepository
The CustomLinksRepository
interface is useful to manage the queries of the CustomRefyLink
Author
N7ghtm4r3 - Tecknobit
See also
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
@Modifying(clearAutomatically = true)
@Query(value = ""DELETE FROM " + LINKS_KEY + " WHERE " + LINK_IDENTIFIER_KEY + "=:" + LINK_IDENTIFIER_KEY", nativeQuery = true)
Method to execute the query to delete a link
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = ""DELETE FROM " + COLLECTIONS_LINKS_TABLE
+ " WHERE " + COLLECTION_IDENTIFIER_KEY + "=:" + COLLECTION_IDENTIFIER_KEY", nativeQuery = true)
Method to execute the query to detach a collection from links
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = ""DELETE FROM " + COLLECTIONS_TEAMS_TABLE
+ " WHERE " + COLLECTION_IDENTIFIER_KEY + "=:" + COLLECTION_IDENTIFIER_KEY", nativeQuery = true)
Method to execute the query to detach a collection from teams
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = ""DELETE FROM " + COLLECTIONS_LINKS_TABLE + " WHERE " + LINK_IDENTIFIER_KEY + "=:" + LINK_IDENTIFIER_KEY", nativeQuery = true)
Method to execute the query to detach a link from collections
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = ""DELETE FROM " + TEAMS_LINKS_TABLE + " WHERE " + LINK_IDENTIFIER_KEY + "=:" + LINK_IDENTIFIER_KEY", nativeQuery = true)
Method to execute the query to detach a link from teams
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = ""DELETE FROM " + COLLECTIONS_TEAMS_TABLE + " WHERE " + TEAM_IDENTIFIER_KEY + "=:" + TEAM_IDENTIFIER_KEY", nativeQuery = true)
Method to execute the query to detach a team from collections
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = ""DELETE FROM " + TEAMS_LINKS_TABLE + " WHERE " + TEAM_IDENTIFIER_KEY + "=:" + TEAM_IDENTIFIER_KEY", nativeQuery = true)
Method to execute the query to detach a team from links
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
@Query(value = ""SELECT l.* FROM " + LINKS_KEY + " AS l WHERE l." + OWNER_KEY + "=:" + USER_IDENTIFIER_KEY
+ " AND " + LINK_IDENTIFIER_KEY + "=:" + LINK_IDENTIFIER_KEY", nativeQuery = true)
Method to execute the query to get a custom link if the owner is authorized
Link copied to clipboard
Link copied to clipboard
@Query(value = ""SELECT l.* FROM " + LINKS_KEY + " AS l WHERE l." + OWNER_KEY + "=:" + USER_IDENTIFIER_KEY
+ " AND dtype='" + CUSTOM_LINK_KEY + "' ORDER BY " + CREATION_DATE_KEY", nativeQuery = true)
Method to execute the query to get all the user's custom links
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = "INSERT INTO " + LINKS_KEY + "(" +
DISCRIMINATOR_VALUE_KEY + "," +
LINK_IDENTIFIER_KEY + "," +
TITLE_KEY + "," +
DESCRIPTION_KEY + "," +
REFERENCE_LINK_KEY + "," +
CREATION_DATE_KEY + "," +
EXPIRED_TIME_KEY + "," +
UNIQUE_ACCESS_KEY + "," +
PREVIEW_TOKEN_KEY + "," +
OWNER_KEY
+ ") VALUES (" +
":" + DISCRIMINATOR_VALUE_KEY + "," +
":" + LINK_IDENTIFIER_KEY + "," +
":" + TITLE_KEY + "," +
":" + DESCRIPTION_KEY + "," +
":" + REFERENCE_LINK_KEY + "," +
":" + CREATION_DATE_KEY + "," +
":#{#" + EXPIRED_TIME_KEY + ".name()}," +
":" + UNIQUE_ACCESS_KEY + "," +
":" + PREVIEW_TOKEN_KEY + "," +
":" + OWNER_KEY +
")", nativeQuery = true)
Method to execute the query to save a link
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = ""UPDATE " + LINKS_KEY + " SET " +
TITLE_KEY + "=:" + TITLE_KEY + "," +
DESCRIPTION_KEY + "=:" + DESCRIPTION_KEY + "," +
EXPIRED_TIME_KEY + "=" + ":#{#" + EXPIRED_TIME_KEY + ".name()}," +
UNIQUE_ACCESS_KEY + "=:" + UNIQUE_ACCESS_KEY +
" WHERE " + LINK_IDENTIFIER_KEY + "=:" + LINK_IDENTIFIER_KEY + " AND " + OWNER_KEY + "=:" + OWNER_KEY", nativeQuery = true)
Method to execute the query to save a link