SqliteDatabaseAdapter

Summary

DatabaseAdapter implementation for synchronous SQLite clients.

Signature

class SqliteDatabaseAdapter {
  constructor(database: SqliteDatabase): SqliteDatabaseAdapter

  // Properties
  capabilities: {
    migrationLock: boolean
    returning: boolean
    savepoints: boolean
    transactionalDdl: boolean
    upsert: boolean
  }
  dialect: string

  // Methods
  beginTransaction(options: TransactionOptions): Promise<TransactionToken>
  commitTransaction(token: TransactionToken): Promise<void>
  compileSql(operation: DataManipulationOperation): SqlStatement[]
  createSavepoint(token: TransactionToken, name: string): Promise<void>
  execute(request: DataManipulationRequest): Promise<DataManipulationResult>
  executeScript(sql: string, transaction: TransactionToken): Promise<void>
  hasColumn(table: TableRef, column: string, transaction: TransactionToken): Promise<boolean>
  hasTable(table: TableRef, transaction: TransactionToken): Promise<boolean>
  releaseSavepoint(token: TransactionToken, name: string): Promise<void>
  rollbackToSavepoint(token: TransactionToken, name: string): Promise<void>
  rollbackTransaction(token: TransactionToken): Promise<void>
}

Properties

capabilities

Feature flags describing the sqlite behaviors supported by this adapter.

dialect

The SQL dialect identifier reported by this adapter.

Methods

beginTransaction(options: TransactionOptions): Promise<TransactionToken>

Starts a sqlite transaction.

Parameters

options

Transaction options.

commitTransaction(token: TransactionToken): Promise<void>

Commits an open sqlite transaction.

Parameters

token

Transaction token to commit.

compileSql(operation: DataManipulationOperation): SqlStatement[]

Compiles a data-manipulation operation to sqlite SQL statements.

Parameters

operation

Operation to compile.

createSavepoint(token: TransactionToken, name: string): Promise<void>

Creates a savepoint in an open sqlite transaction.

Parameters

token

Transaction token to use.

name

Savepoint name.

execute(request: DataManipulationRequest): Promise<DataManipulationResult>

Executes a sqlite data-manipulation request.

Parameters

request

Request to execute.

executeScript(sql: string, transaction: TransactionToken): Promise<void>

Executes a multi-statement sqlite SQL script.

Parameters

sql

SQL script to execute.

transaction

Optional transaction token (asserted when present).

hasColumn(table: TableRef, column: string, transaction: TransactionToken): Promise<boolean>

Checks whether a column exists in sqlite.

Parameters

table

Table reference to inspect.

column

Column name to look up.

transaction

Optional transaction token.

hasTable(table: TableRef, transaction: TransactionToken): Promise<boolean>

Checks whether a table exists in sqlite.

Parameters

table

Table reference to inspect.

transaction

Optional transaction token.

releaseSavepoint(token: TransactionToken, name: string): Promise<void>

Releases a savepoint in an open sqlite transaction.

Parameters

token

Transaction token to use.

name

Savepoint name.

rollbackToSavepoint(token: TransactionToken, name: string): Promise<void>

Rolls back to a savepoint in an open sqlite transaction.

Parameters

token

Transaction token to use.

name

Savepoint name.

rollbackTransaction(token: TransactionToken): Promise<void>

Rolls back an open sqlite transaction.

Parameters

token

Transaction token to roll back.