_{Official ZPE/YASS documentation}zpe.lib.sqlite

The SQLite plugin provides access to SQLite databases using JDBC. It supports parameterised queries, transactions, and basic error reporting.

Objects

ZPESQLite

open (string path) ⇒ boolean

Opens (or creates) an SQLite database at the given file path. Returns true on success, otherwise false.

close () ⇒ boolean

Closes the current database connection. Returns true on success.

is_open () ⇒ boolean

Returns true if the database connection is currently open.

execute (string sql, list params) ⇒ number

Executes a parameterised SQL statement such as INSERT, UPDATE, or DELETE.

params is an optional list of values bound to ? placeholders.

Returns the number of rows affected.

query (string sql, list params) ⇒ list

Executes a parameterised SELECT query.

Returns a list of rows. Each row is represented as a map where keys are column names and values are the corresponding cell values.

If the query fails, an empty list is returned.

begin () ⇒ boolean

Begins a transaction. Returns true on success.

commit () ⇒ boolean

Commits the current transaction. Returns true on success.

rollback () ⇒ boolean

Rolls back the current transaction. Returns true on success.

last_insert_rowid () ⇒ number

Returns the row ID of the most recent successful INSERT. If unavailable, returns -1.

get_last_error () ⇒ string

Returns the message from the most recent database error. If no error has occurred, an empty string is returned.