Struct SqliteConnection 

pub struct SqliteConnection { /* private fields */ }

A wrapper around a SQLite connection.

Implementations

impl SqliteConnection

pub fn new(conn: Connection, permit: OwnedSemaphorePermit) -> Self

Create a new connection wrapper (non-pooled).

pub async fn query(&self, sql: &str) -> SqliteResult<Vec<Value>>

Execute a query and return all rows as JSON values.

pub async fn query_params( &self, sql: &str, params: Vec<Value>, ) -> SqliteResult<Vec<Value>>

Execute a query with parameters and return all rows.

pub async fn query_one(&self, sql: &str) -> SqliteResult<Value>

Execute a query and return a single row.

pub async fn query_optional(&self, sql: &str) -> SqliteResult<Option<Value>>

Execute a query and return an optional row.

pub async fn execute(&self, sql: &str) -> SqliteResult<usize>

Execute a statement and return the number of affected rows.

pub async fn execute_params( &self, sql: &str, params: Vec<Value>, ) -> SqliteResult<usize>

Execute a statement with parameters and return the number of affected rows.

pub async fn execute_insert(&self, sql: &str) -> SqliteResult<i64>

Execute a statement and return the last insert rowid.

pub async fn execute_insert_params( &self, sql: &str, params: Vec<Value>, ) -> SqliteResult<i64>

Execute a statement with parameters and return the last insert rowid.

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

Execute multiple statements in a batch.

pub fn inner(&self) -> &Connection

Get the inner connection.

Trait Implementations

impl Drop for SqliteConnection

fn drop(&mut self)

Executes the destructor for this type.