Class Sqlite3Handle

SQLite3 database connection handle

Index

Constructors

Methods

busyTimeout changes close exec interrupt inTransaction lastInsertRowid loadExtension prepare

Constructors

constructor

new Sqlite3Handle(): Sqlite3Handle
Returns Sqlite3Handle

Methods

busyTimeout

busyTimeout(ms: number): void
Set SQLite busy timeout in milliseconds.
Parameters
- ms: number
Returns void

changes

changes(): number
Number of rows changed by the most recent INSERT, UPDATE, or DELETE.

Returns number

close

close(): void
Close the database connection

Returns void

exec

exec(sql: string): void
Execute a SQL statement
Parameters
- sql: string
  The SQL statement to execute
Returns void

interrupt

interrupt(): void
Interrupt a pending SQLite operation on this connection.

Returns void

inTransaction

inTransaction(): boolean
Check if a transaction is active

Returns boolean
True if a transaction is active

lastInsertRowid

lastInsertRowid(): number
Rowid of the most recent successful INSERT.

Returns number

loadExtension

loadExtension(file: string, proc?: string): void
Load an extension into the database connection
Parameters
- file: string
  Path to the extension file
- Optionalproc: string
  Optional entry point name
Returns void

prepare

prepare(sql: string): Sqlite3Stmt
Prepare a SQL statement
Parameters
- sql: string
  The SQL statement to prepare
Returns Sqlite3Stmt
A prepared statement object