equinox-backend/com.tecknobit.equinoxbackend.environment.services.builtin.service/EquinoxItemsHelper

Equinox Items Helper

abstract class EquinoxItemsHelper<T : EquinoxItem?>

The EquinoxItemsHelper class is useful to manage all the EquinoxItem database operations

Author

N7ghtm4r3 - Tecknobit

Inheritors

EquinoxUsersHelper

Constructors

EquinoxItemsHelper

constructor()

Types

BatchQuery

interface BatchQuery

The BatchQuery interface is useful to manage the batch queries to insert or delete values in batch

InsertCommand

enum InsertCommand

InsertCommand list of supported commands to insert records in the batch queries

SyncBatchContainer

interface SyncBatchContainer

The SyncBatchContainer interface is useful to execute the syncBatch method to synchronize the data.

Properties

_IN_CLAUSE_

private val _IN_CLAUSE_: String = " IN "

IN_CLAUSE in clause query part

_VALUES_

val _VALUES_: String = " VALUES "

VALUES values query part

_WHERE_

val _WHERE_: String = " WHERE "

WHERE where query part

CLOSED_ROUND_BRACKET

val CLOSED_ROUND_BRACKET: String = ")"

CLOSED_ROUND_BRACKET closed round bracket character

COMMA

val COMMA: String = ","

COMMA comma character

DELETE_FROM_

val DELETE_FROM_: String = "DELETE FROM "

DELETE_FROM_ delete from query command

entityManager

protected open var entityManager: EntityManager

entityManager entity manager helper

OPENED_ROUND_BRACKET

val OPENED_ROUND_BRACKET: String = "("

OPENED_ROUND_BRACKET opened round bracket character

QUESTION_MARK

val QUESTION_MARK: String = "?"

QUESTION_MARK question mark character

SINGLE_QUOTE

val SINGLE_QUOTE: String = "'"

SINGLE_QUOTE single quote character

Functions

batchDelete

protected open fun batchDelete(table: String, values: List<List<out Any>>, columns: Array<String>)

Method to execute a batch delete of a list of data simultaneously

batchInsert

protected open fun batchInsert(command: EquinoxItemsHelper.InsertCommand, table: String, values: List<out Any>, batchQuery: EquinoxItemsHelper.BatchQuery, columns: Array<String>)

Method to execute a batch insert of a list of data simultaneously

findMaxSize

private open fun findMaxSize(inValues: List<List<out Any>>): Int

Method to find the max size of a list

formatColumns

private open fun formatColumns(columns: Array<String>): String

Method to format the columns value for the query

formatInClause

private open fun formatInClause(columns: Int, inValues: List<out Any>): String

Method to format the in clause for the query

formatPlaceholder

private open fun formatPlaceholder(columns: Array<String>): String

Method to format the placeholder value for the query

formatValuesForQuery

private open fun formatValuesForQuery(start: String, values: List<out Any>, formatter: String, isToClose: Boolean): String

Method to format a list of values for the query

mergeAlternativelyInColumnsValues

private open fun mergeAlternativelyInColumnsValues(inValues: List<List<out Any>>): List<out Any>

Method to merge alternatively different lists

syncBatch

protected open fun <V> syncBatch(container: EquinoxItemsHelper.SyncBatchContainer, table: String, targetId: String, updatedData: List<V>, batchQuery: EquinoxItemsHelper.BatchQuery)

Method to execute a batch synchronization of a list of data simultaneously