TxStore
Defined in: packages/core/src/adapters/database.ts:95
Transactional CRUD subset available inside DatabaseAdapter.transact.
Mirrors the adapter surface minus metadata, lifecycle, and raw all
(opaque to transactions on some drivers).
Methods
Section titled “Methods”count()
Section titled “count()”count(
table,where?):Promise<number>
Defined in: packages/core/src/adapters/database.ts:111
Count rows matching an optional where condition.
Parameters
Section titled “Parameters”Table
where?
Section titled “where?”SQL<unknown>
Returns
Section titled “Returns”Promise<number>
get<
T>(table,id):Promise<T["$inferSelect"] |null>
Defined in: packages/core/src/adapters/database.ts:105
Fetch a single row by id, or null if not found.
Type Parameters
Section titled “Type Parameters”T extends Table<TableConfig<Column<any, object, object>>>
Parameters
Section titled “Parameters”T
string
Returns
Section titled “Returns”Promise<T["$inferSelect"] | null>
insert()
Section titled “insert()”insert<
T>(table,values):Promise<T["$inferSelect"]>
Defined in: packages/core/src/adapters/database.ts:97
Insert a row and return the inserted record.
Type Parameters
Section titled “Type Parameters”T extends Table<TableConfig<Column<any, object, object>>>
Parameters
Section titled “Parameters”T
values
Section titled “values”T["$inferInsert"]
Returns
Section titled “Returns”Promise<T["$inferSelect"]>
list()
Section titled “list()”list<
T>(table,opts?):Promise<T["$inferSelect"][]>
Defined in: packages/core/src/adapters/database.ts:109
List rows matching the given options.
Type Parameters
Section titled “Type Parameters”T extends Table<TableConfig<Column<any, object, object>>>
Parameters
Section titled “Parameters”T
Returns
Section titled “Returns”Promise<T["$inferSelect"][]>
remove()
Section titled “remove()”remove(
table,id):Promise<void>
Defined in: packages/core/src/adapters/database.ts:107
Delete a row by id.
Parameters
Section titled “Parameters”Table
string
Returns
Section titled “Returns”Promise<void>
update()
Section titled “update()”update<
T>(table,id,values):Promise<T["$inferSelect"]>
Defined in: packages/core/src/adapters/database.ts:99
Update a row by id and return the updated record.
Type Parameters
Section titled “Type Parameters”T extends Table<TableConfig<Column<any, object, object>>>
Parameters
Section titled “Parameters”T
string
values
Section titled “values”Partial<T["$inferInsert"]>
Returns
Section titled “Returns”Promise<T["$inferSelect"]>