DatabaseConnection
Exposes the Database Connection and the associated Encryption APIs.
Properties
Configuration of the connection.
File control object that allows direct call to the xFileControl.
Whether the connection is in autocommit mode.
Whether an interrupt is currently in effect.
Rowid of the most recent successful INSERT into a rowid table or virtual table on this connection.
Total number of rows inserted, modified or deleted by all INSERT, UPDATE or DELETE statements completed since the database connection was opened, including those executed as part of trigger programs.
Write-Ahead Log operating on this connection.
Functions
Creates or replaces a collation.
Creates or updates an aggregate function.
Creates or updates a scalar function.
Creates or updates a window function.
Creates or replaces a virtual table module.
Deletes the collation created using the same parameters.
Deletes the function that was created with the same arguments. If the function is a window function, then isWindowFunction should be set to true.
Deletes the module for name.
Deletes all the modules excepts those that get their name listed in keep.
Disconnects from database and then reopens database as an in-memory database based on the serialization contained in serializedDatabase. The serializedDatabase is databaseSize bytes in size. bufferSize is the size of the buffer serializedDatabase, which might be larger than databaseSize. If bufferSize is larger than databaseSize, and the SqliteDeserializeFlag.READONLY bit is not set in flags, then SQLite is permitted to add content to the in-memory database as long as the total size does not exceed bufferSize bytes.
Writes any dirty pages in the pager-cache that are not currently in use. The operation only take places if there is a write-transaction open at the time this function is called.
Returns the absolute pathname of the database database of this connection.
Returns the current value of the given limit category.
Returns the status for the given options.
Returns the current transaction state of database.
Returns true if the database database is read-only, or false If it is read/write.
Creates and returns a PreparedStatement.
Attempts to scan the WAL file associated with database of this connection and make all valid snapshots available to openSnapshot.
Attempts to free as much heap memory as possible from this connection.
Sets the callback that get invoked whenever an SQL statements is being compiled by prepare.
Sets the callback that is invoked prior to each autovacuum of the database file.
Sets the callback that might be invoked whenever an attempt is made to access a database table associated with this connection when another thread or process has the table locked.
Sets a BusyHandler that sleeps for a specified amount of time when a table is locked. Any BusyHandler previously passed to setBusyHandler is replaced.
Sets a BusyHandler that sleeps for a specified amount of time when a table is locked. Any BusyHandler previously passed to DatabaseConnection.setBusyHandler is replaced.
Sets the callback that get invoked whenever an undefined collation sequence is required.
Sets the callback that get invoked whenever an undefined collation sequence is required.
Enables or disables the extended result codes.
Sets the value of the given limit category.
Sets the callback that is invoked prior to each INSERT, UPDATE, and DELETE operation.
Sets the callback that is invoked periodically during long-running calls.
Sets the callback that get invoked whenever a transaction is rolled back.
Sets the callback that get invoked whenever any of the events identified by eventCodes occur.
Sets the callback that is invoked whenever a row is updated, inserted or deleted in a rowid table.