PostgreSqlDriver

Hierarchy

• AbstractSqlDriver<PostgreSqlConnection>
  • PostgreSqlDriver

Index

Constructors

• constructor

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

Constructors

constructor

• new PostgreSqlDriver(config: Configuration<IDatabaseDriver<Connection>, EntityManager<IDatabaseDriver<Connection>>>): PostgreSqlDriver

• Overrides AbstractSqlDriver<PostgreSqlConnection>.constructor

  Parameters

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

  Returns PostgreSqlDriver

Properties

inherited[EntityManagerType]

[EntityManagerType]: SqlEntityManager<PostgreSqlDriver>

Inherited from AbstractSqlDriver.[EntityManagerType]

readonlyinheritedconfig

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

Inherited from AbstractSqlDriver.config

Methods

inheritedaggregate

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

• Inherited from AbstractSqlDriver.aggregate

  Parameters

  • entityName: string

  • pipeline: any[]

  Returns Promise<any[]>

inheritedclose

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

• Inherited from AbstractSqlDriver.close

  Parameters

  • optionalforce: boolean

  Returns Promise<void>

inheritedconnect

• connect(): Promise<PostgreSqlConnection>

• Inherited from AbstractSqlDriver.connect

  Returns Promise<PostgreSqlConnection>

inheritedconvertException

• convertException(exception: Error): DriverException

• Inherited from AbstractSqlDriver.convertException

  Converts native db errors to standardized driver exceptions

  ---

  Parameters

  • exception: Error

  Returns DriverException

inheritedcount

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

• Inherited from AbstractSqlDriver.count

  Parameters

  • entityName: string

  • where: any

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

  Returns Promise<number>

inheritedcountVirtual

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

• Inherited from AbstractSqlDriver.countVirtual

  Parameters

  • entityName: string

  • where: FilterQuery<T>

  • options: CountOptions<T, any>

  Returns Promise<number>

inheritedcreateEntityManager

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

• Inherited from AbstractSqlDriver.createEntityManager

  Parameters

  • optionaluseContext: boolean

  Returns D[typeof EntityManagerType]

inheritedexecute

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

• Inherited from AbstractSqlDriver.execute

  Parameters

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

  • params: any[] = []

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

  • optionalctx: any

  • optionalloggerContext: LoggingOptions

  Returns Promise<T>

inheritedfind

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

• Inherited from AbstractSqlDriver.find

  Finds selection of entities

  ---

  Parameters

  • entityName: string

  • where: FilterQuery<T>

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

  Returns Promise<EntityData<T>[]>

inheritedfindOne

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

• Inherited from AbstractSqlDriver.findOne

  Finds single entity (table row, document)

  ---

  Parameters

  • entityName: string

  • where: FilterQuery<T>

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

  Returns Promise<null | EntityData<T>>

inheritedfindVirtual

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

• Inherited from AbstractSqlDriver.findVirtual

  Parameters

  • entityName: string

  • where: FilterQuery<T>

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

  Returns Promise<EntityData<T>[]>

inheritedgetConnection

• getConnection(type?: ConnectionType): PostgreSqlConnection

• Inherited from AbstractSqlDriver.getConnection

  Parameters

  • type: ConnectionType = 'write'

  Returns PostgreSqlConnection

inheritedgetDependencies

• getDependencies(): string[]

• Inherited from AbstractSqlDriver.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 AbstractSqlDriver.getMetadata

  Returns MetadataStorage

inheritedgetPlatform

• getPlatform(): AbstractSqlPlatform

• Inherited from AbstractSqlDriver.getPlatform

  Returns AbstractSqlPlatform

inheritedloadFromPivotTable

• 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[]>>

• Inherited from AbstractSqlDriver.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[]>>

inheritedlockPessimistic

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

• Inherited from AbstractSqlDriver.lockPessimistic

  Parameters

  • entity: T

  • options: LockOptions

  Returns Promise<void>

inheritedmapResult

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

• Inherited from AbstractSqlDriver.mapResult

  Parameters

  • result: EntityData<T>

  • meta: EntityMetadata<T>

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

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

  • map: Dictionary = {}

  Returns null | EntityData<T>

inheritednativeDelete

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

• Inherited from AbstractSqlDriver.nativeDelete

  Parameters

  • entityName: string

  • where: any

  • options: DeleteOptions<T> = {}

  Returns Promise<QueryResult<T>>

inheritednativeInsert

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

• Inherited from AbstractSqlDriver.nativeInsert

  Parameters

  • entityName: string

  • data: EntityDictionary<T>

  • options: NativeInsertUpdateOptions<T> = {}

  Returns Promise<QueryResult<T>>

inheritednativeInsertMany

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

• Inherited from AbstractSqlDriver.nativeInsertMany

  Parameters

  • entityName: string

  • data: EntityDictionary<T>[]

  • options: NativeInsertUpdateManyOptions<T> = {}

  • optionaltransform: (sql: string) => string

  Returns Promise<QueryResult<T>>

inheritednativeUpdate

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

• Inherited from AbstractSqlDriver.nativeUpdate

  Parameters

  • entityName: string

  • where: FilterQuery<T>

  • data: EntityDictionary<T>

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

  Returns Promise<QueryResult<T>>

inheritednativeUpdateMany

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

• Inherited from AbstractSqlDriver.nativeUpdateMany

  Parameters

  • entityName: string

  • where: FilterQuery<T>[]

  • data: EntityDictionary<T>[]

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

  Returns Promise<QueryResult<T>>

inheritedreconnect

• reconnect(): Promise<PostgreSqlConnection>

• Inherited from AbstractSqlDriver.reconnect

  Returns Promise<PostgreSqlConnection>

inheritedsetMetadata

• setMetadata(metadata: MetadataStorage): void

• Inherited from AbstractSqlDriver.setMetadata

  Parameters

  • metadata: MetadataStorage

  Returns void

inheritedsyncCollections

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

• Inherited from AbstractSqlDriver.syncCollections

  Parameters

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

  • optionaloptions: DriverMethodOptions

  Returns Promise<void>