Struct PooledSqliteConnection 

pub struct PooledSqliteConnection<'a> { /* private fields */ }

A pooled read-only connection for SQLite

This wraps a SQLite read-only connection with automatic permit release when the connection is returned to the pool.

Implementations

impl<'a> PooledSqliteConnection<'a>

pub fn query_row<T, P, F>(&self, sql: &str, params: P, f: F) -> Result<T>

where P: Params, F: FnOnce(&Row<'_>) -> Result<T>,

Execute a read-only query

Example

let conn = pool.acquire().await?;
let count: i64 = conn.query_row("SELECT COUNT(*) FROM users", [], |row| row.get(0))?;

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

Prepare a statement for execution

pub fn connection(&self) -> &Connection

Get direct access to the underlying connection

Use this for complex queries that need the full rusqlite API.