Skip to content

TableRunner class

Home > @direct-sqlite/core > TableRunner

Core table execution driver managing distinct query builder pipelines.

Signature:

export declare class TableRunner<TRow>

The constructor for this class is marked as internal. Third-party code should not call the constructor directly or create subclasses that extend the TableRunner class.

Constructor

Modifiers

Description

(constructor)(db, client, tableName)

Constructs a new instance of the TableRunner class

Method

Modifiers

Description

delete()

Spawns a query builder to wipe matching elements from storage.

insert(data)

Runs an atomic single-record write payload tracking metadata state alterations.

insertMany(records)

Packages arrays of similar records into a single multi-row insertion statement to minimize execution context switches.

prepare(action, column, operator)

Pre-compiles execution statement structures bypassing standard lookup evaluations during fast loops.

select(columns)

Generates a targeted selection pipeline targeting specified key components. Defaults to SELECT *.

update(data)

Spawns a query builder to update properties inside matching row footprints.

upsert(data, conflictTarget, updateFields)

Executes write assertions, running cell overrides if targeted index boundaries trigger collision states.

where(column, operator, value)

Shorthand helper to quickly initialize a full row read operation matching a specific filter criteria.