Class: D1Adapter

Defined in: src/adapters/D1Adapter.ts:34

Cloudflare D1 serverless SQLite adapter. Runs directly on Cloudflare Workers / Pages using the environment D1 binding.

Implements

• IDbAdapter

Constructors

Constructor

new D1Adapter(config): D1Adapter

Defined in: src/adapters/D1Adapter.ts:38

Parameters

Parameter	Type
config	D1DatabaseLike | D1AdapterConfig

Returns

D1Adapter

Methods

connect()

connect(): Promise<void>

Defined in: src/adapters/D1Adapter.ts:48

Returns

Promise<void>

Implementation of

IDbAdapter.connect

---

disconnect()

disconnect(): Promise<void>

Defined in: src/adapters/D1Adapter.ts:52

Returns

Promise<void>

Implementation of

IDbAdapter.disconnect

---

ping()

ping(): Promise<boolean>

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

Returns

Promise<boolean>

Implementation of

IDbAdapter.ping

---

executeQuery()

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

Defined in: src/adapters/D1Adapter.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/D1Adapter.ts:81

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/D1Adapter.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/D1Adapter.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/D1Adapter.ts:138

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/D1Adapter.ts:153

Parameters

Parameter	Type	Default value
isolationLevel	IsolationLevel	IsolationLevel.ReadCommitted

Returns

Promise<DbTransaction>

Implementation of

IDbAdapter.beginTransaction

---

escapeIdentifier()

escapeIdentifier(name): string

Defined in: src/adapters/D1Adapter.ts:173

Parameters

Parameter	Type
name	string

Returns

string

Implementation of

IDbAdapter.escapeIdentifier

---

formatParameterPlaceholder()

formatParameterPlaceholder(_paramName, _index): string

Defined in: src/adapters/D1Adapter.ts:177

Parameters

Parameter	Type
_paramName	string
_index	number

Returns

string

Implementation of

IDbAdapter.formatParameterPlaceholder

Properties

provider

readonly provider: DbProvider = 'd1'

Defined in: src/adapters/D1Adapter.ts:35

Implementation of

IDbAdapter.provider