abstractAbstractSqlDriver <Connection, Platform>

Hierarchy

• DatabaseDriver<Connection>
  • AbstractSqlDriver
    • PostgreSqlDriver
    • MySqlDriver
    • MariaDbDriver
    • SqliteDriver
    • BetterSqliteDriver
    • LibSqlDriver
    • MsSqlDriver

Index

Properties

• [EntityManagerType]
• config

Methods

• aggregate
• close
• connect
• convertException
• count
• countVirtual
• createEntityManager
• execute
• find
• findOne
• findVirtual
• getConnection
• getDependencies
• getMetadata
• getPlatform
• loadFromPivotTable
• lockPessimistic
• mapResult
• nativeDelete
• nativeInsert
• nativeInsertMany
• nativeUpdate
• nativeUpdateMany
• reconnect
• setMetadata
• syncCollections

Properties

[EntityManagerType]

[EntityManagerType]: SqlEntityManager<AbstractSqlDriver<Connection, Platform>>

Overrides DatabaseDriver.[EntityManagerType]

readonlyinheritedconfig

config: Configuration<IDatabaseDriver<Connection>, EntityManager<IDatabaseDriver<Connection>>>

Inherited from DatabaseDriver.config

Methods

inheritedaggregate

• aggregate(entityName: string, pipeline: any[]): Promise<any[]>

• Inherited from DatabaseDriver.aggregate

  Parameters

  • entityName: string

  • pipeline: any[]

  Returns Promise<any[]>

inheritedclose

• close(force?: boolean): Promise<void>

• Inherited from DatabaseDriver.close

  Parameters

  • optionalforce: boolean

  Returns Promise<void>

inheritedconnect

• connect(): Promise<Connection>

• Inherited from DatabaseDriver.connect

  Returns Promise<Connection>

inheritedconvertException

• convertException(exception: Error): DriverException

• Inherited from DatabaseDriver.convertException

  Converts native db errors to standardized driver exceptions

  ---

  Parameters

  • exception: Error

  Returns DriverException

count

• count(entityName: string, where: any, options?: CountOptions<T, never>): Promise<number>

• Overrides DatabaseDriver.count

  Parameters

  • entityName: string

  • where: any

  • options: CountOptions<T, never> = {}

  Returns Promise<number>

countVirtual

• countVirtual(entityName: string, where: FilterQuery<T>, options: CountOptions<T, any>): Promise<number>

• Overrides DatabaseDriver.countVirtual

  Parameters

  • entityName: string

  • where: FilterQuery<T>

  • options: CountOptions<T, any>

  Returns Promise<number>

createEntityManager

• createEntityManager(useContext?: boolean): D[typeof EntityManagerType]

• Overrides DatabaseDriver.createEntityManager

  Parameters

  • optionaluseContext: boolean

  Returns D[typeof EntityManagerType]

execute

• execute(queryOrKnex: string | QueryBuilder<any, any> | Raw<any>, params?: any[], method?: get | all | run, ctx?: any, loggerContext?: LoggingOptions): Promise<T>

• Parameters

  • queryOrKnex: string | QueryBuilder<any, any> | Raw<any>

  • params: any[] = []

  • method: get | all | run = 'all'

  • optionalctx: any

  • optionalloggerContext: LoggingOptions

  Returns Promise<T>

find

• find(entityName: string, where: FilterQuery<T>, options?: FindOptions<T, P, F, E>): Promise<EntityData<T>[]>

• Overrides DatabaseDriver.find

  Finds selection of entities

  ---

  Parameters

  • entityName: string

  • where: FilterQuery<T>

  • options: FindOptions<T, P, F, E> = {}

  Returns Promise<EntityData<T>[]>

findOne

• findOne(entityName: string, where: FilterQuery<T>, options?: FindOneOptions<T, P, F, E>): Promise<null | EntityData<T>>

• Overrides DatabaseDriver.findOne

  Finds single entity (table row, document)

  ---

  Parameters

  • entityName: string

  • where: FilterQuery<T>

  • optionaloptions: FindOneOptions<T, P, F, E>

  Returns Promise<null | EntityData<T>>

findVirtual

• findVirtual(entityName: string, where: FilterQuery<T>, options: FindOptions<T, any, any, any>): Promise<EntityData<T>[]>

• Overrides DatabaseDriver.findVirtual

  Parameters

  • entityName: string

  • where: FilterQuery<T>

  • options: FindOptions<T, any, any, any>

  Returns Promise<EntityData<T>[]>

inheritedgetConnection

• getConnection(type?: ConnectionType): Connection

• Inherited from DatabaseDriver.getConnection

  Parameters

  • type: ConnectionType = 'write'

  Returns Connection

inheritedgetDependencies

• getDependencies(): string[]

• Inherited from DatabaseDriver.getDependencies

  Returns name of the underlying database dependencies (e.g. mongodb or mysql2) for SQL drivers it also returns knex in the array as connectors are not used directly there

  ---

  Returns string[]

inheritedgetMetadata

• getMetadata(): MetadataStorage

• Inherited from DatabaseDriver.getMetadata

  Returns MetadataStorage

getPlatform

• getPlatform(): Platform

• Overrides DatabaseDriver.getPlatform

  Returns Platform

loadFromPivotTable

• loadFromPivotTable(prop: EntityProperty<any, any>, owners: (O extends { [PrimaryKeyProp]?: PK } ? PK extends keyof O<O> ? ReadonlyPrimary<UnwrapPrimary<O<O>[PK<PK>]>> : PK extends keyof O<O>[] ? ReadonlyPrimary<PrimaryPropToType<O<O>, PK<PK>>> : PK : O extends { _id?: PK } ? string | ReadonlyPrimary<PK> : O extends { uuid?: PK } ? ReadonlyPrimary<PK> : O extends { id?: PK } ? ReadonlyPrimary<PK> : O)[][], where?: any, orderBy?: OrderDefinition<T>, ctx?: any, options?: FindOptions<T, any, any, any>, pivotJoin?: boolean): Promise<Dictionary<T[]>>

• Overrides DatabaseDriver.loadFromPivotTable

  When driver uses pivot tables for M:N, this method will load identifiers for given collections from them

  ---

  Parameters

  • prop: EntityProperty<any, any>

  • owners: (O extends { [PrimaryKeyProp]?: PK } ? PK extends keyof O<O> ? ReadonlyPrimary<UnwrapPrimary<O<O>[PK<PK>]>> : PK extends keyof O<O>[] ? ReadonlyPrimary<PrimaryPropToType<O<O>, PK<PK>>> : PK : O extends { _id?: PK } ? string | ReadonlyPrimary<PK> : O extends { uuid?: PK } ? ReadonlyPrimary<PK> : O extends { id?: PK } ? ReadonlyPrimary<PK> : O)[][]

  • where: any = ...

  • optionalorderBy: OrderDefinition<T>

  • optionalctx: any

  • optionaloptions: FindOptions<T, any, any, any>

  • optionalpivotJoin: boolean

  Returns Promise<Dictionary<T[]>>

lockPessimistic

• lockPessimistic(entity: T, options: LockOptions): Promise<void>

• Overrides DatabaseDriver.lockPessimistic

  Parameters

  • entity: T

  • options: LockOptions

  Returns Promise<void>

mapResult

• mapResult(result: EntityData<T>, meta: EntityMetadata<T>, populate?: PopulateOptions<T>[], qb?: QueryBuilder<T, any, any, any>, map?: Dictionary): null | EntityData<T>

• Overrides DatabaseDriver.mapResult

  Parameters

  • result: EntityData<T>

  • meta: EntityMetadata<T>

  • populate: PopulateOptions<T>[] = []

  • optionalqb: QueryBuilder<T, any, any, any>

  • map: Dictionary = {}

  Returns null | EntityData<T>

nativeDelete

• nativeDelete(entityName: string, where: any, options?: DeleteOptions<T>): Promise<QueryResult<T>>

• Overrides DatabaseDriver.nativeDelete

  Parameters

  • entityName: string

  • where: any

  • options: DeleteOptions<T> = {}

  Returns Promise<QueryResult<T>>

nativeInsert

• nativeInsert(entityName: string, data: EntityDictionary<T>, options?: NativeInsertUpdateOptions<T>): Promise<QueryResult<T>>

• Overrides DatabaseDriver.nativeInsert

  Parameters

  • entityName: string

  • data: EntityDictionary<T>

  • options: NativeInsertUpdateOptions<T> = {}

  Returns Promise<QueryResult<T>>

nativeInsertMany

• nativeInsertMany(entityName: string, data: EntityDictionary<T>[], options?: NativeInsertUpdateManyOptions<T>, transform?: (sql: string) => string): Promise<QueryResult<T>>

• Overrides DatabaseDriver.nativeInsertMany

  Parameters

  • entityName: string

  • data: EntityDictionary<T>[]

  • options: NativeInsertUpdateManyOptions<T> = {}

  • optionaltransform: (sql: string) => string

  Returns Promise<QueryResult<T>>

nativeUpdate

• nativeUpdate(entityName: string, where: FilterQuery<T>, data: EntityDictionary<T>, options?: NativeInsertUpdateOptions<T> & UpsertOptions<T, never>): Promise<QueryResult<T>>

• Overrides DatabaseDriver.nativeUpdate

  Parameters

  • entityName: string

  • where: FilterQuery<T>

  • data: EntityDictionary<T>

  • options: NativeInsertUpdateOptions<T> & UpsertOptions<T, never> = {}

  Returns Promise<QueryResult<T>>

nativeUpdateMany

• nativeUpdateMany(entityName: string, where: FilterQuery<T>[], data: EntityDictionary<T>[], options?: NativeInsertUpdateManyOptions<T> & UpsertManyOptions<T, never>): Promise<QueryResult<T>>

• Overrides DatabaseDriver.nativeUpdateMany

  Parameters

  • entityName: string

  • where: FilterQuery<T>[]

  • data: EntityDictionary<T>[]

  • options: NativeInsertUpdateManyOptions<T> & UpsertManyOptions<T, never> = {}

  Returns Promise<QueryResult<T>>

inheritedreconnect

• reconnect(): Promise<Connection>

• Inherited from DatabaseDriver.reconnect

  Returns Promise<Connection>

inheritedsetMetadata

• setMetadata(metadata: MetadataStorage): void

• Inherited from DatabaseDriver.setMetadata

  Parameters

  • metadata: MetadataStorage

  Returns void

syncCollections

• syncCollections(collections: Iterable<Collection<T, O>, any, any>, options?: DriverMethodOptions): Promise<void>

• Overrides DatabaseDriver.syncCollections

  Parameters

  • collections: Iterable<Collection<T, O>, any, any>

  • optionaloptions: DriverMethodOptions

  Returns Promise<void>