Class: SqliteAdapter

Defined in: src/adapters/SqliteAdapter.ts:20

Implements

• IDbAdapter

Constructors

Constructor

new SqliteAdapter(config): SqliteAdapter

Defined in: src/adapters/SqliteAdapter.ts:25

Parameters

Parameter	Type
config	string | SqliteAdapterConfig

Returns

SqliteAdapter

Methods

connect()

connect(): Promise<void>

Defined in: src/adapters/SqliteAdapter.ts:27

Returns

Promise<void>

Implementation of

IDbAdapter.connect

---

disconnect()

disconnect(): Promise<void>

Defined in: src/adapters/SqliteAdapter.ts:42

Returns

Promise<void>

Implementation of

IDbAdapter.disconnect

---

ping()

ping(): Promise<boolean>

Defined in: src/adapters/SqliteAdapter.ts:55

Returns

Promise<boolean>

Implementation of

IDbAdapter.ping

---

executeQuery()

executeQuery<T>(sql, params?, _transaction?): Promise<T[]>

Defined in: src/adapters/SqliteAdapter.ts:76

Type Parameters

Type Parameter	Default type
T	unknown

Parameters

Parameter	Type
sql	string
params?	AdapterParam[]
_transaction?	DbTransaction

Returns

Promise<T[]>

Implementation of

IDbAdapter.executeQuery

---

executeNonQuery()

executeNonQuery(sql, params?, _transaction?): Promise<{ rowsAffected: number; insertId?: unknown; }>

Defined in: src/adapters/SqliteAdapter.ts:91

Parameters

Parameter	Type
sql	string
params?	AdapterParam[]
_transaction?	DbTransaction

Returns

Promise<{ rowsAffected: number; insertId?: unknown; }>

Implementation of

IDbAdapter.executeNonQuery

---

executeScalar()

executeScalar<T>(sql, params?, _transaction?): Promise<T>

Defined in: src/adapters/SqliteAdapter.ts:110

Type Parameters

Type Parameter	Default type
T	unknown

Parameters

Parameter	Type
sql	string
params?	AdapterParam[]
_transaction?	DbTransaction

Returns

Promise<T>

Implementation of

IDbAdapter.executeScalar

---

executeProcedure()

executeProcedure<T>(name, params, _timeoutMs?, transaction?): Promise<StoredProcedureResult<T[]>>

Defined in: src/adapters/SqliteAdapter.ts:128

Type Parameters

Type Parameter	Default type
T	unknown

Parameters

Parameter	Type
name	string
params	AdapterParam[]
_timeoutMs?	number
transaction?	DbTransaction

Returns

Promise<StoredProcedureResult<T[]>>

Implementation of

IDbAdapter.executeProcedure

---

executeProcedureMultiple()

executeProcedureMultiple<T>(name, params, timeoutMs?, transaction?): Promise<StoredProcedureResult<T>>

Defined in: src/adapters/SqliteAdapter.ts:149

Type Parameters

Type Parameter	Default type
T extends unknown[]	unknown[]

Parameters

Parameter	Type
name	string
params	AdapterParam[]
timeoutMs?	number
transaction?	DbTransaction

Returns

Promise<StoredProcedureResult<T>>

Implementation of

IDbAdapter.executeProcedureMultiple

---

beginTransaction()

beginTransaction(isolationLevel?): Promise<DbTransaction>

Defined in: src/adapters/SqliteAdapter.ts:164

Parameters

Parameter	Type	Default value
isolationLevel	IsolationLevel	IsolationLevel.ReadCommitted

Returns

Promise<DbTransaction>

Implementation of

IDbAdapter.beginTransaction

---

escapeIdentifier()

escapeIdentifier(name): string

Defined in: src/adapters/SqliteAdapter.ts:188

Parameters

Parameter	Type
name	string

Returns

string

Implementation of

IDbAdapter.escapeIdentifier

---

formatParameterPlaceholder()

formatParameterPlaceholder(_paramName, _index): string

Defined in: src/adapters/SqliteAdapter.ts:192

Parameters

Parameter	Type
_paramName	string
_index	number

Returns

string

Implementation of

IDbAdapter.formatParameterPlaceholder

Properties

provider

readonly provider: DbProvider = 'sqlite'

Defined in: src/adapters/SqliteAdapter.ts:21

Implementation of

IDbAdapter.provider