Class BasePostgresEntityDatabaseAdapter<TFields, TIDField>`Abstract`

Type Parameters

TFields extends Record<string, any>
TIDField extends keyof TFields

Hierarchy (View Summary)

EntityDatabaseAdapter<TFields, TIDField>
- BasePostgresEntityDatabaseAdapter
  - PostgresEntityDatabaseAdapter

Constructors

constructor

new BasePostgresEntityDatabaseAdapter<
    TFields extends Record<string, any>,
    TIDField extends string | number | symbol,
>(
    entityConfiguration: EntityConfiguration<TFields, TIDField>,
): BasePostgresEntityDatabaseAdapter<TFields, TIDField>
Type Parameters
- TFields extends Record<string, any>
- TIDField extends string | number | symbol
Parameters
- entityConfiguration: EntityConfiguration<TFields, TIDField>
Returns BasePostgresEntityDatabaseAdapter<TFields, TIDField>
Inherited from EntityDatabaseAdapter<TFields, TIDField>.constructor
- Defined in entity/build/src/EntityDatabaseAdapter.d.ts:14

Properties

`Protected` `Readonly`entityConfiguration

entityConfiguration: EntityConfiguration<TFields, TIDField>

`Protected` `Readonly`fieldTransformerMap

fieldTransformerMap: FieldTransformerMap

Accessors

paginationMaxPageSize

get paginationMaxPageSize(): number | undefined
Get the maximum page size for pagination.

Returns number | undefined
maximum page size if configured, undefined otherwise
- Defined in entity-database-adapter-knex/src/BasePostgresEntityDatabaseAdapter.ts:156

Methods

deleteAsync

deleteAsync<K extends string | number | symbol>(
    queryContext: EntityQueryContext,
    idField: K,
    id: any,
): Promise<void>
Delete an object by ID.
Type Parameters
- K extends string | number | symbol
Parameters
- queryContext: EntityQueryContext
  query context with which to perform the deletion
- idField: K
  the field in the object that is the ID
- id: any
  the value of the ID field in the object
Returns Promise<void>
Inherited from EntityDatabaseAdapter.deleteAsync
- Defined in entity/build/src/EntityDatabaseAdapter.d.ts:70

`Protected` `Abstract`deleteInternalAsync

deleteInternalAsync(
    queryInterface: any,
    tableName: string,
    tableIdField: string,
    id: any,
): Promise<number>
Parameters
- queryInterface: any
- tableName: string
- tableIdField: string
- id: any
Returns Promise<number>
Inherited from EntityDatabaseAdapter.deleteInternalAsync
- Defined in entity/build/src/EntityDatabaseAdapter.d.ts:71

fetchManyByFieldEqualityConjunctionAsync

fetchManyByFieldEqualityConjunctionAsync<N extends string | number | symbol>(
    queryContext: EntityQueryContext,
    fieldEqualityOperands: FieldEqualityCondition<TFields, N>[],
    querySelectionModifiers: PostgresQuerySelectionModifiers<TFields>,
): Promise<readonly Readonly<TFields>[]>
Fetch many objects matching the conjunction of where clauses constructed from specified field equality operands.
Type Parameters
- N extends string | number | symbol
Parameters
- queryContext: EntityQueryContext
  query context with which to perform the fetch
- fieldEqualityOperands: FieldEqualityCondition<TFields, N>[]
  list of field equality where clause operand specifications
- querySelectionModifiers: PostgresQuerySelectionModifiers<TFields>
  limit, offset, orderBy, and orderByRaw for the query
Returns Promise<readonly Readonly<TFields>[]>
array of objects matching the query
- Defined in entity-database-adapter-knex/src/BasePostgresEntityDatabaseAdapter.ts:168

`Protected` `Abstract`fetchManyByFieldEqualityConjunctionInternalAsync

fetchManyByFieldEqualityConjunctionInternalAsync(
    queryInterface: Knex,
    tableName: string,
    tableFieldSingleValueEqualityOperands: TableFieldSingleValueEqualityCondition[],
    tableFieldMultiValueEqualityOperands: TableFieldMultiValueEqualityCondition[],
    querySelectionModifiers: TableQuerySelectionModifiers,
): Promise<object[]>
Parameters
- queryInterface: Knex
- tableName: string
- tableFieldSingleValueEqualityOperands: TableFieldSingleValueEqualityCondition[]
- tableFieldMultiValueEqualityOperands: TableFieldMultiValueEqualityCondition[]
- querySelectionModifiers: TableQuerySelectionModifiers
Returns Promise<object[]>
- Defined in entity-database-adapter-knex/src/BasePostgresEntityDatabaseAdapter.ts:202

fetchManyByRawWhereClauseAsync

fetchManyByRawWhereClauseAsync(
    queryContext: EntityQueryContext,
    rawWhereClause: string,
    bindings: object | any[],
    querySelectionModifiers: PostgresQuerySelectionModifiersWithOrderByRaw<
        TFields,
    >,
): Promise<readonly Readonly<TFields>[]>
Fetch many objects matching the raw WHERE clause.
Parameters
- queryContext: EntityQueryContext
  query context with which to perform the fetch
- rawWhereClause: string
  parameterized SQL WHERE clause with positional binding placeholders or named binding placeholders
- bindings: object | any[]
  array of positional bindings or object of named bindings
- querySelectionModifiers: PostgresQuerySelectionModifiersWithOrderByRaw<TFields>
  limit, offset, and orderBy for the query
Returns Promise<readonly Readonly<TFields>[]>
array of objects matching the query
- Defined in entity-database-adapter-knex/src/BasePostgresEntityDatabaseAdapter.ts:219

`Protected` `Abstract`fetchManyByRawWhereClauseInternalAsync

fetchManyByRawWhereClauseInternalAsync(
    queryInterface: Knex,
    tableName: string,
    rawWhereClause: string,
    bindings: object | any[],
    querySelectionModifiers: TableQuerySelectionModifiersWithOrderByRaw,
): Promise<object[]>
Parameters
- queryInterface: Knex
- tableName: string
- rawWhereClause: string
- bindings: object | any[]
- querySelectionModifiers: TableQuerySelectionModifiersWithOrderByRaw
Returns Promise<object[]>
- Defined in entity-database-adapter-knex/src/BasePostgresEntityDatabaseAdapter.ts:238

fetchManyBySQLFragmentAsync

fetchManyBySQLFragmentAsync(
    queryContext: EntityQueryContext,
    sqlFragment: SQLFragment,
    querySelectionModifiers: PostgresQuerySelectionModifiersWithOrderByFragment<
        TFields,
    >,
): Promise<readonly Readonly<TFields>[]>
Fetch many objects matching the SQL fragment.
Parameters
- queryContext: EntityQueryContext
  query context with which to perform the fetch
- sqlFragment: SQLFragment
  SQLFragment for the WHERE clause of the query
- querySelectionModifiers: PostgresQuerySelectionModifiersWithOrderByFragment<TFields>
  limit, offset, and orderByFragment for the query
Returns Promise<readonly Readonly<TFields>[]>
array of objects matching the query
- Defined in entity-database-adapter-knex/src/BasePostgresEntityDatabaseAdapter.ts:254

`Protected` `Abstract`fetchManyBySQLFragmentInternalAsync

fetchManyBySQLFragmentInternalAsync(
    queryInterface: Knex,
    tableName: string,
    sqlFragment: SQLFragment,
    querySelectionModifiers: TableQuerySelectionModifiersWithOrderByFragment,
): Promise<object[]>
Parameters
- queryInterface: Knex
- tableName: string
- sqlFragment: SQLFragment
- querySelectionModifiers: TableQuerySelectionModifiersWithOrderByFragment
Returns Promise<object[]>
- Defined in entity-database-adapter-knex/src/BasePostgresEntityDatabaseAdapter.ts:271

fetchManyWhereAsync

fetchManyWhereAsync<
    TLoadKey extends
        IEntityLoadKey<TFields, TIDField, TSerializedLoadValue, TLoadValue>,
    TSerializedLoadValue,
    TLoadValue extends IEntityLoadValue<TSerializedLoadValue>,
>(
    queryContext: EntityQueryContext,
    key: TLoadKey,
    values: readonly TLoadValue[],
): Promise<ReadonlyMap<TLoadValue, readonly Readonly<TFields>[]>>
Fetch many objects where key is one of values.
Type Parameters
- TLoadKey extends IEntityLoadKey<TFields, TIDField, TSerializedLoadValue, TLoadValue>
- TSerializedLoadValue
- TLoadValue extends IEntityLoadValue<TSerializedLoadValue>
Parameters
- queryContext: EntityQueryContext
  query context with which to perform the fetch
- key: TLoadKey
  load key being queried
- values: readonly TLoadValue[]
  load values being queried
Returns Promise<ReadonlyMap<TLoadValue, readonly Readonly<TFields>[]>>
map from value to objects that match the query for that value
Inherited from EntityDatabaseAdapter.fetchManyWhereAsync
- Defined in entity/build/src/EntityDatabaseAdapter.d.ts:29

`Protected` `Abstract`fetchManyWhereInternalAsync

fetchManyWhereInternalAsync(
    queryInterface: any,
    tableName: string,
    tableColumns: readonly string[],
    tableTuples: (readonly any[])[],
): Promise<object[]>
Parameters
- queryInterface: any
- tableName: string
- tableColumns: readonly string[]
- tableTuples: (readonly any[])[]
Returns Promise<object[]>
Inherited from EntityDatabaseAdapter.fetchManyWhereInternalAsync
- Defined in entity/build/src/EntityDatabaseAdapter.d.ts:30

fetchOneWhereAsync

fetchOneWhereAsync<
    TLoadKey extends
        IEntityLoadKey<TFields, TIDField, TSerializedLoadValue, TLoadValue>,
    TSerializedLoadValue,
    TLoadValue extends IEntityLoadValue<TSerializedLoadValue>,
>(
    queryContext: EntityQueryContext,
    key: TLoadKey,
    value: TLoadValue,
): Promise<Readonly<TFields> | null>
Fetch one objects where key is equal to value, null if no matching object exists. Returned object is not guaranteed to be deterministic. Most concrete implementations will implement this with a "first" or "limit 1" query.
Type Parameters
- TLoadKey extends IEntityLoadKey<TFields, TIDField, TSerializedLoadValue, TLoadValue>
- TSerializedLoadValue
- TLoadValue extends IEntityLoadValue<TSerializedLoadValue>
Parameters
- queryContext: EntityQueryContext
  query context with which to perform the fetch
- key: TLoadKey
  load key being queried
- value: TLoadValue
Returns Promise<Readonly<TFields> | null>
object that matches the query for the value
Inherited from EntityDatabaseAdapter.fetchOneWhereAsync
- Defined in entity/build/src/EntityDatabaseAdapter.d.ts:41

`Protected` `Abstract`fetchOneWhereInternalAsync

fetchOneWhereInternalAsync(
    queryInterface: any,
    tableName: string,
    tableColumns: readonly string[],
    tableTuple: readonly any[],
): Promise<object | null>
Parameters
- queryInterface: any
- tableName: string
- tableColumns: readonly string[]
- tableTuple: readonly any[]
Returns Promise<object | null>
Inherited from EntityDatabaseAdapter.fetchOneWhereInternalAsync
- Defined in entity/build/src/EntityDatabaseAdapter.d.ts:42

`Protected` `Abstract`getFieldTransformerMap

getFieldTransformerMap(): FieldTransformerMap
Transformer definitions for field types. Used to modify values as they are read from or written to the database. Override in concrete subclasses to change transformation behavior. If a field type is not present in the map, then fields of that type will not be transformed.

Returns FieldTransformerMap
Inherited from EntityDatabaseAdapter.getFieldTransformerMap
- Defined in entity/build/src/EntityDatabaseAdapter.d.ts:20

insertAsync

insertAsync(
queryContext: EntityQueryContext,
object: Readonly<Partial<TFields>>,
): Promise<Readonly<TFields>>
Insert an object.
Parameters
- queryContext: EntityQueryContext
  query context with which to perform the insert
- object: Readonly<Partial<TFields>>
  the object to insert
Returns Promise<Readonly<TFields>>
the inserted object
Inherited from EntityDatabaseAdapter.insertAsync
- Defined in entity/build/src/EntityDatabaseAdapter.d.ts:50

`Protected` `Abstract`insertInternalAsync

insertInternalAsync(
    queryInterface: any,
    tableName: string,
    object: object,
): Promise<object[]>
Parameters
- queryInterface: any
- tableName: string
- object: object
Returns Promise<object[]>
Inherited from EntityDatabaseAdapter.insertInternalAsync
- Defined in entity/build/src/EntityDatabaseAdapter.d.ts:51

updateAsync

updateAsync<K extends string | number | symbol>(
    queryContext: EntityQueryContext,
    idField: K,
    id: any,
    object: Readonly<Partial<TFields>>,
): Promise<Readonly<TFields>>
Update an object.
Type Parameters
- K extends string | number | symbol
Parameters
- queryContext: EntityQueryContext
  query context with which to perform the update
- idField: K
  the field in the object that is the ID
- id: any
  the value of the ID field in the object
- object: Readonly<Partial<TFields>>
  the object to update
Returns Promise<Readonly<TFields>>
the updated object
Inherited from EntityDatabaseAdapter.updateAsync
- Defined in entity/build/src/EntityDatabaseAdapter.d.ts:61

`Protected` `Abstract`updateInternalAsync

updateInternalAsync(
    queryInterface: any,
    tableName: string,
    tableIdField: string,
    id: any,
    object: object,
): Promise<object[]>
Parameters
- queryInterface: any
- tableName: string
- tableIdField: string
- id: any
- object: object
Returns Promise<object[]>
Inherited from EntityDatabaseAdapter.updateInternalAsync
- Defined in entity/build/src/EntityDatabaseAdapter.d.ts:62

Class BasePostgresEntityDatabaseAdapter<TFields, TIDField>Abstract

Type Parameters

Hierarchy (View Summary)

Index

Constructors

Properties

Accessors

Methods

Constructors

constructor

Type Parameters

Parameters

Returns BasePostgresEntityDatabaseAdapter<TFields, TIDField>

Properties

Protected ReadonlyentityConfiguration

Protected ReadonlyfieldTransformerMap

Accessors

paginationMaxPageSize

Returns number | undefined

Methods

deleteAsync

Type Parameters

Parameters

Returns Promise<void>

Protected AbstractdeleteInternalAsync

Parameters

Returns Promise<number>

fetchManyByFieldEqualityConjunctionAsync

Type Parameters

Parameters

Returns Promise<readonly Readonly<TFields>[]>

Protected AbstractfetchManyByFieldEqualityConjunctionInternalAsync

Parameters

Returns Promise<object[]>

fetchManyByRawWhereClauseAsync

Parameters

Returns Promise<readonly Readonly<TFields>[]>

Protected AbstractfetchManyByRawWhereClauseInternalAsync

Parameters

Returns Promise<object[]>

fetchManyBySQLFragmentAsync

Parameters

Returns Promise<readonly Readonly<TFields>[]>

Protected AbstractfetchManyBySQLFragmentInternalAsync

Parameters

Returns Promise<object[]>

fetchManyWhereAsync

Type Parameters

Parameters

Returns Promise<ReadonlyMap<TLoadValue, readonly Readonly<TFields>[]>>

Protected AbstractfetchManyWhereInternalAsync

Parameters

Returns Promise<object[]>

fetchOneWhereAsync

Type Parameters

Parameters

Returns Promise<Readonly<TFields> | null>

Protected AbstractfetchOneWhereInternalAsync

Parameters

Returns Promise<object | null>

Protected AbstractgetFieldTransformerMap

Returns FieldTransformerMap

insertAsync

Parameters

Returns Promise<Readonly<TFields>>

Protected AbstractinsertInternalAsync

Parameters

Returns Promise<object[]>

updateAsync

Type Parameters

Parameters

Returns Promise<Readonly<TFields>>

Protected AbstractupdateInternalAsync

Parameters

Returns Promise<object[]>

Settings

On This Page

Class BasePostgresEntityDatabaseAdapter<TFields, TIDField>`Abstract`

`Protected` `Readonly`entityConfiguration

`Protected` `Readonly`fieldTransformerMap

`Protected` `Abstract`deleteInternalAsync

`Protected` `Abstract`fetchManyByFieldEqualityConjunctionInternalAsync

`Protected` `Abstract`fetchManyByRawWhereClauseInternalAsync

`Protected` `Abstract`fetchManyBySQLFragmentInternalAsync

`Protected` `Abstract`fetchManyWhereInternalAsync

`Protected` `Abstract`fetchOneWhereInternalAsync

`Protected` `Abstract`getFieldTransformerMap

`Protected` `Abstract`insertInternalAsync

`Protected` `Abstract`updateInternalAsync