backend/com.tecknobit.refy.helpers.services/LinksCollectionsHelper

LinksCollectionsHelper

@Service

open class LinksCollectionsHelper : RefyItemsHelper<T>

The LinksCollectionsHelper class is useful to manage all the LinksCollection database operations

Author

N7ghtm4r3 - Tecknobit

Constructors

LinksCollectionsHelper

constructor()

Properties

ATTACH_COLLECTION_TO_LINKS_QUERY

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

ATTACH_COLLECTION_TO_LINKS_QUERY the query used to attach links to a collection

ATTACH_COLLECTION_TO_TEAM_QUERY

private val ATTACH_COLLECTION_TO_TEAM_QUERY: String = "REPLACE INTO collections_teams(team_id,collection_id) VALUES "

ATTACH_COLLECTION_TO_TEAM_QUERY the query used to share a collection with teams

collectionsRepository

@Autowired

private open var collectionsRepository: CollectionsRepository

collectionsRepository instance for the collections repository

COMMA

private val COMMA: String = ","

COMMA comma character

DETACH_COLLECTION_FROM_LINKS_QUERY

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

DETACH_COLLECTION_FROM_LINKS_QUERY the query used to detach links from a collection

DETACH_COLLECTION_FROM_TEAMS_QUERY

private val DETACH_COLLECTION_FROM_TEAMS_QUERY: String = "DELETE FROM collections_teams WHERE collection_id='%s' AND team_id IN ("

DETACH_COLLECTION_FROM_TEAMS_QUERY the query used to remove a collection from teams

entityManager

protected open var entityManager: EntityManager

entityManager entity manager helper

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

createCollection

open fun createCollection(userId: String, collectionId: String, color: String, title: String, description: String, links: List<String>)

Method to create a collection

deleteCollection

open fun deleteCollection(collectionId: String)

Method to delete a collection

editCollection

open fun editCollection(userId: String, collectionId: String, color: String, title: String, description: String, links: List<String>)

Method to edit a collection

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

getAllUserCollections

open fun getAllUserCollections(userId: String): List<LinksCollection>

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

getItemIfAllowed

open fun getItemIfAllowed(userId: String, collectionId: String): LinksCollection

Method used to get an item if the user is authorized

getUserCollections

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

Method to get the user's owned collections identifiers

getUserOwnedCollections

open fun getUserOwnedCollections(userId: String): List<LinksCollection>

Method to get the user's owned collections

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

manageCollectionLinks

private open fun manageCollectionLinks(collection: LinksCollection, links: List<String>)

open fun manageCollectionLinks(collectionId: String, links: List<String>)

Method to manage the links attached to the collection

manageCollectionTeams

open fun manageCollectionTeams(collectionId: String, teams: List<String>)

Method to manage the teams where the collection is shared

LinksCollectionsHelper

Author

See also

Constructors

Properties

Functions