backend/com.tecknobit.refy.helpers.services.links/LinksHelper

LinksHelper

@Service

open class LinksHelper : LinksBaseHelper<T>

The LinksHelper class is useful to manage all the RefyLink database operations

Author

N7ghtm4r3 - Tecknobit

Constructors

LinksHelper

constructor()

Properties

ATTACH_LINK_TO_COLLECTIONS_QUERY

protected val ATTACH_LINK_TO_COLLECTIONS_QUERY: String = "REPLACE INTO collections_links(collection_id,link_id) VALUES "

ATTACH_LINK_TO_COLLECTIONS_QUERY the query used to attach link to collections

ATTACH_LINK_TO_TEAMS_QUERY

private val ATTACH_LINK_TO_TEAMS_QUERY: String = "REPLACE INTO teams_links(team_id,link_id) VALUES "

ATTACH_LINK_TO_TEAMS_QUERY the query used to attach link to teams

COMMA

private val COMMA: String = ","

COMMA comma character

DETACH_LINK_FROM_COLLECTIONS_QUERY

private val DETACH_LINK_FROM_COLLECTIONS_QUERY: String = "DELETE FROM collections_links WHERE link_id='%s' AND collection_id IN ("

DETACH_LINK_FROM_COLLECTIONS_QUERY the query used to detach link from collections

DETACH_LINK_FROM_TEAMS_QUERY

private val DETACH_LINK_FROM_TEAMS_QUERY: String = "DELETE FROM teams_links WHERE link_id='%s' AND team_id IN ("

DETACH_LINK_FROM_TEAMS_QUERY the query used to detach link from teams

entityManager

protected open var entityManager: EntityManager

entityManager entity manager helper

linksRepository

@Autowired

private open var linksRepository: LinksRepository

linksRepository instance for the links repository

RELATIONSHIP_VALUES_SLICE

protected val RELATIONSHIP_VALUES_SLICE: String = "(?, ?)"

RELATIONSHIP_VALUES_SLICE query part to insert in the join table new row

ROUND_BRACKET

private val ROUND_BRACKET: String = ")"

ROUND_BRACKET round bracket character

SINGLE_QUOTE

private val SINGLE_QUOTE: String = "'"

SINGLE_QUOTE single quote character

TUPLE_VALUES_SLICE

protected val TUPLE_VALUES_SLICE: String = "(?, ?, ?)"

TUPLE_VALUES_SLICE query part to insert in the join table new row

Functions

createLink

open fun createLink(userId: String, linkId: String, title: String, description: String, referenceLink: String)

Method to save a new link

deleteLink

open fun deleteLink(linkId: String)

Method to delete a link

editLink

open fun editLink(userId: String, linkId: String, title: String, description: String, referenceLink: String)

Method to edit a new link

executeDeleteBatch

protected open fun <I> executeDeleteBatch(deleteQuery: String, itemToDeleteId: String, values: List<I>)

Method to execute a batch query to delete attachments

executeInsertBatch

protected open fun <I> executeInsertBatch(insertQuery: String, valuesSlice: String, values: Collection<I>, batchQuery: RefyItemsHelper.BatchQuery)

Method to execute a batch query to insert attachments

getAllUserLinks

open fun getAllUserLinks(userId: String): List<RefyLink>

Method to get all the user's links, included the links shared in the teams and in the collections shared in the teams

getItemIfAllowed

open fun getItemIfAllowed(userId: String, linkId: String): RefyLink

Method used to get an item if the user is authorized

getUserLinks

open fun getUserLinks(userId: String): HashSet<String>

Method to get the user's owned links identifiers

getUserOwnedLinks

open fun getUserOwnedLinks(userId: String): List<RefyLink>

Method to get the user's owned links

manageAttachments

protected open fun manageAttachments(workflow: RefyItemsHelper.AttachmentsManagementWorkflow, itemId: String, ids: List<String>)

protected open fun manageAttachments(workflow: RefyItemsHelper.AttachmentsManagementWorkflow, valuesSlice: String, itemId: String, ids: List<String>, batchQuery: RefyItemsHelper.BatchQuery)

Method to manage the attachments of an item to a container

manageLinkCollections

open fun manageLinkCollections(linkId: String, collections: List<String>)

Method to manage the collections where the link is shared

manageLinkTeams

open fun manageLinkTeams(linkId: String, teams: List<String>)

Method to manage the teams where the link is shared

LinksHelper

Author

See also

Constructors

Properties

Functions