Class: MysqlAdapter

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

Implements

• IDbAdapter

Constructors

Constructor

new MysqlAdapter(config): MysqlAdapter

Defined in: src/adapters/MysqlAdapter.ts:30

Parameters

Parameter	Type
config	string | MysqlAdapterConfig

Returns

MysqlAdapter

Methods

connect()

connect(): Promise<void>

Defined in: src/adapters/MysqlAdapter.ts:32

Returns

Promise<void>

Implementation of

IDbAdapter.connect

---

disconnect()

disconnect(): Promise<void>

Defined in: src/adapters/MysqlAdapter.ts:49

Returns

Promise<void>

Implementation of

IDbAdapter.disconnect

---

ping()

ping(): Promise<boolean>

Defined in: src/adapters/MysqlAdapter.ts:56

Returns

Promise<boolean>

Implementation of

IDbAdapter.ping

---

executeQuery()

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

Defined in: src/adapters/MysqlAdapter.ts:66

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/MysqlAdapter.ts:83

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/MysqlAdapter.ts:103

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/MysqlAdapter.ts:115

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/MysqlAdapter.ts:189

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/MysqlAdapter.ts:224

Parameters

Parameter	Type	Default value
isolationLevel	IsolationLevel	IsolationLevel.ReadCommitted

Returns

Promise<DbTransaction>

Implementation of

IDbAdapter.beginTransaction

---

escapeIdentifier()

escapeIdentifier(name): string

Defined in: src/adapters/MysqlAdapter.ts:259

Parameters

Parameter	Type
name	string

Returns

string

Implementation of

IDbAdapter.escapeIdentifier

---

formatParameterPlaceholder()

formatParameterPlaceholder(_paramName, _index): string

Defined in: src/adapters/MysqlAdapter.ts:263

Parameters

Parameter	Type
_paramName	string
_index	number

Returns

string

Implementation of

IDbAdapter.formatParameterPlaceholder

Properties

provider

readonly provider: DbProvider = 'mysql'

Defined in: src/adapters/MysqlAdapter.ts:26

Implementation of

IDbAdapter.provider