Struct SqlitePreparedSelect 

pub struct SqlitePreparedSelect<'stmt, 'conn, 'params> { /* private fields */ }

Builder for executing a prepared SQLite SELECT.

Implementations

impl<'stmt, 'conn, 'params> SqlitePreparedSelect<'stmt, 'conn, 'params>

pub fn params<'next>( self, params: &'next [RowValues], ) -> SqlitePreparedSelect<'stmt, 'conn, 'next>

Use middleware RowValues parameters.

pub fn params_buf<'next>( self, params: &'next SqliteParamsBuf, ) -> SqlitePreparedSelect<'stmt, 'conn, 'next>

Use a reusable SQLite parameter buffer.

pub async fn all(self) -> Result<ResultSet, SqlMiddlewareDbError>

Execute and return all rows as a ResultSet.

Errors

Returns SqlMiddlewareDbError if execution fails or result conversion encounters an issue.

pub async fn optional(self) -> Result<Option<CustomDbRow>, SqlMiddlewareDbError>

Execute and return the first row, if present.

Errors

Returns SqlMiddlewareDbError if execution or row conversion fails.

pub async fn one(self) -> Result<CustomDbRow, SqlMiddlewareDbError>

Execute and return exactly one row.

Errors

Returns SqlMiddlewareDbError if execution fails, row conversion fails, or no row is returned.

pub async fn map_one<T, F>(self, mapper: F) -> Result<T, SqlMiddlewareDbError>

where T: Send + 'static, F: FnOnce(&Row<'_>) -> Result<T, SqlMiddlewareDbError> + Send + 'static,

Execute and map exactly one native SQLite row.

Errors

Returns SqlMiddlewareDbError if execution fails, the mapper fails, or no row is returned.

pub async fn map_optional<T, F>( self, mapper: F, ) -> Result<Option<T>, SqlMiddlewareDbError>

where T: Send + 'static, F: FnOnce(&Row<'_>) -> Result<T, SqlMiddlewareDbError> + Send + 'static,

Execute and map the first native SQLite row, if present.

Errors

Returns SqlMiddlewareDbError if execution or the mapper fails.