Struct Connection 

pub struct Connection { /* private fields */ }

A SQLite database connection.

Closed when dropped. Not Sync – all access must happen from a single thread (matches the WASM single-thread constraint and the native Mutex-guarded usage in CredentialStoreInner).

Implementations

impl Connection

pub fn open(path: &Path, read_only: bool) -> DbResult<Self>

Opens (or creates) a database at path.

Errors

Returns Error if SQLite cannot open the file.

pub fn execute_batch(&self, sql: &str) -> DbResult<()>

Executes one or more SQL statements separated by semicolons.

No result rows are returned. Suitable for DDL, PRAGMAs, and multi-statement scripts.

Errors

Returns Error if any statement fails.

pub fn execute_batch_zeroized(&self, sql: &str) -> DbResult<()>

Like execute_batch but zeroizes the internal C string buffer after execution. Use for SQL containing sensitive material (e.g. PRAGMA key).

Errors

Returns Error if the statement fails.

pub fn prepare(&self, sql: &str) -> DbResult<Statement<'_>>

Prepares a single SQL statement.

Errors

Returns Error if the SQL is invalid.

pub fn execute(&self, sql: &str, params: &[Value]) -> DbResult<usize>

Prepares and executes a single SQL statement with the given parameters.

Returns the number of rows changed.

Errors

Returns Error if preparation or execution fails.

pub fn query_row<T>( &self, sql: &str, params: &[Value], mapper: impl FnOnce(&Row<'_, '_>) -> DbResult<T>, ) -> DbResult<T>

Prepares and executes a statement, mapping exactly one result row.

Returns an error if no row is returned.

Errors

Returns Error if preparation, execution, or the mapper fails, or if the query returns no rows.

pub fn query_row_optional<T>( &self, sql: &str, params: &[Value], mapper: impl FnOnce(&Row<'_, '_>) -> DbResult<T>, ) -> DbResult<Option<T>>

Like query_row but returns Ok(None) when no row is returned.

Errors

Returns Error if preparation, execution, or the mapper fails.

pub fn transaction(&self) -> DbResult<Transaction<'_>>

Begins a deferred transaction.

Errors

Returns Error if BEGIN DEFERRED fails.

pub fn transaction_immediate(&self) -> DbResult<Transaction<'_>>

Begins an immediate transaction (acquires a RESERVED lock right away).

Errors

Returns Error if BEGIN IMMEDIATE fails.

pub fn last_insert_rowid(&self) -> i64

Returns the rowid of the most recent successful INSERT.

pub fn changes(&self) -> usize

Returns the number of rows changed by the most recent statement.

Trait Implementations

impl Debug for Connection

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.