Interface SQLTagStoreInstance

Readonlycapacity

Readonlydb

Readonlysize

all

• all(strings: TemplateStringsArray, ...values: unknown[]): unknown[]

  Execute a query and return all rows as an array.

  Parameters

  • strings: TemplateStringsArray

    Template literal strings array.

  • ...values: unknown[]

    Values to bind to the placeholders.

  Returns unknown[]

clear

• clear(): void

  Clears all cached statements.

  Returns void

get

• get(strings: TemplateStringsArray, ...values: unknown[]): unknown

  Execute a query and return the first row, or undefined if no rows.

  Parameters

  • strings: TemplateStringsArray

    Template literal strings array.

  • ...values: unknown[]

    Values to bind to the placeholders.

  Returns unknown

iterate

• iterate(
      strings: TemplateStringsArray,
      ...values: unknown[],
  ): IterableIterator<unknown>

  Execute a query and return an iterator over the rows.

  Parameters

  • strings: TemplateStringsArray

    Template literal strings array.

  • ...values: unknown[]

    Values to bind to the placeholders.

  Returns IterableIterator<unknown>

run

• run(
      strings: TemplateStringsArray,
      ...values: unknown[],
  ): { changes: number; lastInsertRowid: number | bigint }

  Execute an INSERT, UPDATE, DELETE or other statement that doesn't return rows.

  Parameters

  • strings: TemplateStringsArray

    Template literal strings array.

  • ...values: unknown[]

    Values to bind to the placeholders.

  Returns { changes: number; lastInsertRowid: number | bigint }

  An object with changes and lastInsertRowid.