Class MSSQLDataAdapter

A data adapter which is written for Microsoft SQL databases.

Hierarchy

DataAdapterBase
- MSSQLDataAdapter

Index

Constructors

constructor

new MSSQLDataAdapter(optionsOrClient?): MSSQLDataAdapter
Initializes a new instance of that class.
Parameters
- Optional optionsOrClient: Nilable<MSSQLDataAdapterOptionsValue>
  
  The options or the client/pool.
Returns MSSQLDataAdapter
Overrides DataAdapterBase.constructor
- Defined in src/classes/MSSQLDataAdapter.ts:141

Properties

`Private` `Readonly` clientGetter

clientGetter: Getter<ConnectionPool>

`Private` `Readonly` debug

debug: DebugActionWithoutSource

Accessors

context

get context(): IDataContext
Gets the underlying context.

Returns IDataContext
The context.
Inherited from DataAdapterBase.context
- Defined in node_modules/@egomobile/orm/lib/classes/DataAdapterBase.d.ts:33

`Private` defaultValueTransformer

get defaultValueTransformer(): SyncValueTransformer
Returns SyncValueTransformer
- Defined in src/classes/MSSQLDataAdapter.ts:273

Methods

`Private` buildFindQuery

buildFindQuery<T>(type, findOptions): {
params: any[];
query: string;
}
Type Parameters
- T extends unknown = any
Parameters
- type: Constructor<T>
- findOptions: undefined | null | IBuildFindQueryOptions
Returns {
params: any[];
query: string;
}
- params: any[]
- query: string
- Defined in src/classes/MSSQLDataAdapter.ts:166

count

count<T>(type, options?): Promise<number>
Type Parameters
- T extends unknown = any
Parameters
- type: Constructor<T>
- Optional options: Nilable<IFindOptions>
Returns Promise<number>

Inherit Doc
Overrides DataAdapterBase.count
- Defined in src/classes/MSSQLDataAdapter.ts:253

find

find<T>(type, options?): Promise<T[]>
Type Parameters
- T extends unknown = any
Parameters
- type: Constructor<T>
- Optional options: Nilable<IFindOptions>
Returns Promise<T[]>

Inherit Doc
Overrides DataAdapterBase.find
- Defined in src/classes/MSSQLDataAdapter.ts:284

findOne

findOne<T>(type, options?): Promise<null | T>
Type Parameters
- T extends unknown = any
Parameters
- type: Constructor<T>
- Optional options: Nilable<IFindOneOptions>
Returns Promise<null | T>

Inherit Doc
Overrides DataAdapterBase.findOne
- Defined in src/classes/MSSQLDataAdapter.ts:296

getClient

getClient(): Promise<ConnectionPool>
Gets the underlying client / pool.

Returns Promise<ConnectionPool>
The promise with the client.
- Defined in src/classes/MSSQLDataAdapter.ts:310

getEntityByType

getEntityByType(type): null | IEntityInfo
Returns an entity by its type.
Parameters
- type: Constructor<any>
  
  The type of the entity.
Returns null | IEntityInfo
The object or (null), if not found.
Inherited from DataAdapterBase.getEntityByType
- Defined in node_modules/@egomobile/orm/lib/classes/DataAdapterBase.d.ts:53

getEntityByTypeOrThrow

getEntityByTypeOrThrow(type): IEntityInfo
Returns an entity by its type or throws an exception if not found.
Parameters
- type: Constructor<any>
  
  The type of the entity.
Returns IEntityInfo
The object.
Inherited from DataAdapterBase.getEntityByTypeOrThrow
- Defined in node_modules/@egomobile/orm/lib/classes/DataAdapterBase.d.ts:61

getEntityIdsByType

getEntityIdsByType(type): string[]
Returns the list of entity/table fields, which represent the IDs of a row.
Parameters
- type: Constructor<any>
  
  The type.
Returns string[]
The list of field names.
Inherited from DataAdapterBase.getEntityIdsByType
- Defined in node_modules/@egomobile/orm/lib/classes/DataAdapterBase.d.ts:70

getEntityIdsByTypeOrThrow

getEntityIdsByTypeOrThrow(type): string[]
Returns the list of entity fields columns, which represent the IDs of a row, or throws an exception if not defined.
Parameters
- type: Constructor<any>
  
  The type.
Returns string[]
The list of ID fields.
Inherited from DataAdapterBase.getEntityIdsByTypeOrThrow
- Defined in node_modules/@egomobile/orm/lib/classes/DataAdapterBase.d.ts:79

getEntityNameByTypeOrThrow

getEntityNameByTypeOrThrow(type): string
Returns the name of the underlying entity/table by type or throws an exception, if not configured.
Parameters
- type: Constructor<any>
  
  The type.
Returns string
The name of the underlying entity/table name.
Inherited from DataAdapterBase.getEntityNameByTypeOrThrow
- Defined in node_modules/@egomobile/orm/lib/classes/DataAdapterBase.d.ts:87

`Private` hasColumnValue

hasColumnValue(entity, columnName): boolean
Parameters
- entity: any
- columnName: PropertyKey
Returns boolean
- Defined in src/classes/MSSQLDataAdapter.ts:314

insert

insert<T>(entityOrEntities): Promise<T | T[]>
Type Parameters
- T extends unknown = any
Parameters
- entityOrEntities: T | List<T>
Returns Promise<T | T[]>

Inherit Doc
Overrides DataAdapterBase.insert
- Defined in src/classes/MSSQLDataAdapter.ts:325

`Private` mapEntityWithRow

mapEntityWithRow(entity, row): Promise<void>
Parameters
- entity: any
- row: Record<string, any>
Returns Promise<void>
- Defined in src/classes/MSSQLDataAdapter.ts:406

query

query(sql, ...values?): Promise<IResult<any>>
Invokes a raw SQL query.
Parameters
- sql: string
  
  The SQL query,
- Optional Rest ...values: any[]
  
  One or more values for the placeholders in the SQL query.
Returns Promise<IResult<any>>
The promise with the result.
Overrides DataAdapterBase.query
- Defined in src/classes/MSSQLDataAdapter.ts:435

queryAndMap

queryAndMap<T>(type, sql, ...values): Promise<any[]>
Type Parameters
- T extends unknown = any
Parameters
- type: Constructor<any>
- sql: string
- Rest ...values: any[]
Returns Promise<any[]>

Inherit Doc
Overrides DataAdapterBase.queryAndMap
- Defined in src/classes/MSSQLDataAdapter.ts:455

remove

remove<T>(entityOrEntities): Promise<T | T[]>
Type Parameters
- T extends unknown = any
Parameters
- entityOrEntities: T | List<T>
Returns Promise<T | T[]>

Inherit Doc
Overrides DataAdapterBase.remove
- Defined in src/classes/MSSQLDataAdapter.ts:485

setContext

setContext(context): MSSQLDataAdapter
Parameters
- context: IDataContext
Returns MSSQLDataAdapter

Inherit Doc
Inherited from DataAdapterBase.setContext
- Defined in node_modules/@egomobile/orm/lib/classes/DataAdapterBase.d.ts:107

`Private` transformValue

transformValue(options): Promise<any>
Parameters
- options: ITransformValueOptions
Returns Promise<any>
- Defined in src/classes/MSSQLDataAdapter.ts:537

update

update<T>(entityOrEntities): Promise<T | T[]>
Type Parameters
- T extends unknown = any
Parameters
- entityOrEntities: T | List<T>
Returns Promise<T | T[]>

Inherit Doc
Overrides DataAdapterBase.update
- Defined in src/classes/MSSQLDataAdapter.ts:555

Generated using TypeDoc