@zturnlibs/ztron-api

---

sql#

Classes#

Database#

Defined in: sql.ts:7

Properties#

id#

readonly id: number

Defined in: sql.ts:8

Methods#

close()#

close(): Promise<void>

Defined in: sql.ts:33

Returns#

Promise<void>

execute()#

execute(query, params?): Promise<void>

Defined in: sql.ts:21

Runs an INSERT/UPDATE/DELETE (or any non-SELECT) statement.

Parameters#

query#

string

params?#

unknown[] = []

Returns#

Promise<void>

select()#

select<T>(query, params?): Promise<T[]>

Defined in: sql.ts:26

Runs a SELECT and returns the rows.

Type Parameters#

T#

T = Record<string, unknown>

Parameters#

query#

string

params?#

unknown[] = []

Returns#

Promise<T[]>

load()#

static load(path): Promise<Database>

Defined in: sql.ts:15

Opens (or creates) a database file; returns a pooled connection.

Parameters#

path#

string

Returns#

Promise<Database>

Variables#

sql#

const sql: object

Defined in: sql.ts:38

Type Declaration#

Database#

Database: typeof Database