backend/com.tecknobit.refy.configuration.indexes/RefyItemFullTextIndexCreator

Refy Item Full Text Index Creator

@Component

open class RefyItemFullTextIndexCreator : IndexesCreator

The RefyItemFullTextIndexCreator is a custom component used to create the fulltext indexes to filter the items query such links, collections and tables using the FullText-Search (FTS) approach

Author

N7ghtm4r3 - Tecknobit

Since

1.0.1

Constructors

RefyItemFullTextIndexCreator

constructor()

Properties

_ADD_FULLTEXT_INDEX_

val _ADD_FULLTEXT_INDEX_: String = " ADD FULLTEXT INDEX %s ("

_IN_BOOLEAN_MODE

val _IN_BOOLEAN_MODE: String = " IN BOOLEAN MODE"

_IN_NATURAL_LANGUAGE_MODE

val _IN_NATURAL_LANGUAGE_MODE: String = " IN NATURAL LANGUAGE MODE"

_KEY_NAME

protected val _KEY_NAME: String = "Key_name='"

ALTER_TABLE_

val ALTER_TABLE_: String = "ALTER TABLE "

entityManager

protected open var entityManager: EntityManager

FULL_TEXT_INDEX_FIELDS

private val FULL_TEXT_INDEX_FIELDS: List<String>

FULL_TEXT_INDEX_FIELDS the fields used to create the fulltext index

SHOW_INDEX_FROM_

val SHOW_INDEX_FROM_: String = "SHOW INDEX FROM "

Functions

assembleCreateIndexQuery

protected open fun assembleCreateIndexQuery(table: String, indexType: String, indexName: String, fields: List<String>): String

createCollectionsTableFullTextIndex

private open fun createCollectionsTableFullTextIndex()

Method used to create the fulltext index in the collections table

createFullTextIndex

protected open fun createFullTextIndex(table: String, indexName: String, fields: List<String>)

createFullTextIndexes

@PostConstruct

open fun createFullTextIndexes()

Method invoked automatically to create the different fulltext indexes required

createIndex

protected open fun createIndex(table: String, indexName: String, indexType: String, fields: List<String>)

createLinksTableFullTextIndex

private open fun createLinksTableFullTextIndex()

Method used to create the fulltext index in the links table

createTeamsTableFullTextIndex

private open fun createTeamsTableFullTextIndex()

Method used to create the fulltext index in the teams table

formatFullTextKeywords

open fun formatFullTextKeywords(keywords: Collection<String>, escapeDoubleQuotes: Boolean): String

open fun formatFullTextKeywords(keywords: Collection<String>, trailingCharacter: String, escapeDoubleQuotes: Boolean): String