kotlin-node/node.sqlite/DatabaseSync

DatabaseSync

external class DatabaseSync(source)

This class represents a single connection to a SQLite database. All APIs exposed by this class execute synchronously.

Since

v22.5.0

Constructors

DatabaseSync

constructor(location: String, options: DatabaseSyncOptions = definedExternally)

Constructs a new DatabaseSync instance.

Functions

applyChangeset

fun applyChangeset( changeset: <Error class: unknown class><out <Error class: unknown class>>, options: ApplyChangesetOptions = definedExternally): Boolean

An exception is thrown if the database is not open. This method is a wrapper around sqlite3changeset_apply().

fun close()

Closes the database connection. An exception is thrown if the database is not open. This method is a wrapper around sqlite3_close_v2().

createSession

fun createSession(options: CreateSessionOptions = definedExternally): Session

Creates and attaches a session to the database. This method is a wrapper around sqlite3session_create() and sqlite3session_attach().

enableLoadExtension

fun enableLoadExtension(allow: Boolean)

Enables or disables the loadExtension SQL function, and the loadExtension() method. When allowExtension is false when constructing, you cannot enable loading extensions for security reasons.

exec

fun exec(sql: String)

This method allows one or more SQL statements to be executed without returning any results. This method is useful when executing SQL statements read from a file. This method is a wrapper around sqlite3_exec().

function

fun function(name: String, func: Function<SupportedValueType>)

fun function(name: String, options: FunctionOptions, func: Function<SupportedValueType>)

This method is used to create SQLite user-defined functions. This method is a wrapper around sqlite3_create_function_v2().

loadExtension

fun loadExtension(path: String)

Loads a shared library into the database connection. This method is a wrapper around sqlite3_load_extension(). It is required to enable the allowExtension option when constructing the DatabaseSync instance.

open

fun open()

Opens the database specified in the location argument of the DatabaseSyncconstructor. This method should only be used when the database is not opened via the constructor. An exception is thrown if the database is already open.

prepare

fun prepare(sql: String): StatementSync

Compiles a SQL statement into a prepared statement. This method is a wrapper around sqlite3_prepare_v2().