Struct PreparedSelect 

pub struct PreparedSelect<'tx, 'prepared, 'params, 'conn> { /* private fields */ }

Builder for executing a prepared SQLite SELECT inside a transaction.

Implementations

impl<'tx, 'prepared, 'params, 'conn> PreparedSelect<'tx, 'prepared, 'params, 'conn>

pub fn params<'next>( self, params: &'next [RowValues], ) -> PreparedSelect<'tx, 'prepared, 'next, 'conn>

Use middleware RowValues parameters.

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

Execute and return all rows as a ResultSet.

Errors

Returns SqlMiddlewareDbError if parameter conversion or execution fails.

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

Execute and return the first row, if present.

Errors

Returns SqlMiddlewareDbError if parameter conversion or execution fails.

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

Execute and return exactly one row.

Errors

Returns SqlMiddlewareDbError if execution fails or no row is returned.