DatabaseAdapter

Defined in: packages/core/src/adapters/database.ts:126

Database abstraction over Drizzle tables, agnostic of dialect and driver.

Extends

• Adapter<DatabaseAdapterMetadata>

Properties

lifecycle?

readonly optional lifecycle?: AdapterLifecycle

Defined in: packages/core/src/adapters/metadata.ts:84

Optional lifecycle hooks.

Inherited from

Adapter.lifecycle

---

metadata

readonly metadata: AdapterMetadata & DatabaseAdapterMetadata

Defined in: packages/core/src/adapters/metadata.ts:82

Adapter identity (mandatory).

Inherited from

Adapter.metadata

---

tables

readonly tables: Tables

Defined in: packages/core/src/adapters/database.ts:128

Table handles for this adapter’s dialect, enforced with type safety.

Methods

all()

all<T>(query): Promise<T[]>

Defined in: packages/core/src/adapters/database.ts:146

Run an arbitrary SQL query and return typed rows.

Type Parameters

T

T

Parameters

query

SQL

Returns

Promise<T[]>

---

count()

count(table, where?): Promise<number>

Defined in: packages/core/src/adapters/database.ts:144

Count rows matching an optional where condition.

Parameters

table

Table

where?

SQL<unknown>

Returns

Promise<number>

---

get()

get<T>(table, id): Promise<T["$inferSelect"] | null>

Defined in: packages/core/src/adapters/database.ts:138

Fetch a single row by id, or null if not found.

Type Parameters

T

T extends Table<TableConfig<Column<any, object, object>>>

Parameters

table

T

id

string

Returns

Promise<T["$inferSelect"] | null>

---

insert()

insert<T>(table, values): Promise<T["$inferSelect"]>

Defined in: packages/core/src/adapters/database.ts:130

Insert a row and return the inserted record.

Type Parameters

T

T extends Table<TableConfig<Column<any, object, object>>>

Parameters

table

T

values

T["$inferInsert"]

Returns

Promise<T["$inferSelect"]>

---

list()

list<T>(table, opts?): Promise<T["$inferSelect"][]>

Defined in: packages/core/src/adapters/database.ts:142

List rows matching the given options.

Type Parameters

T

T extends Table<TableConfig<Column<any, object, object>>>

Parameters

table

T

opts?

ListOptions

Returns

Promise<T["$inferSelect"][]>

---

remove()

remove(table, id): Promise<void>

Defined in: packages/core/src/adapters/database.ts:140

Delete a row by id.

Parameters

table

Table

id

string

Returns

Promise<void>

---

setLogger()?

optional setLogger(logger): void

Defined in: packages/core/src/adapters/metadata.ts:90

Bind the host-owned runtime logger. Called by the app/worker when present; factories must never create their own loggers — they only store what they are given (explicit options.logger wins over bound).

Parameters

logger

Logger

Returns

void

Inherited from

Adapter.setLogger

---

transact()?

optional transact<R>(fn): Promise<R>

Defined in: packages/core/src/adapters/database.ts:152

Run fn inside a transaction when the driver supports one. Commits on resolve, rolls back on throw. Drivers without transaction support omit this; callers must use ?. and accept sequential execution.

Type Parameters

R

R

Parameters

fn

(tx) => Promise<R>

Returns

Promise<R>

---

update()

update<T>(table, id, values): Promise<T["$inferSelect"]>

Defined in: packages/core/src/adapters/database.ts:132

Update a row by id and return the updated record.

Type Parameters

T

T extends Table<TableConfig<Column<any, object, object>>>

Parameters

table

T

id

string

values

Partial<T["$inferInsert"]>

Returns

Promise<T["$inferSelect"]>