use rusqlite::Connection;
use crate::db::types::{SqlRow, SqlValue, bind, column_names, read_row};
pub(crate) fn call(
conn: &Connection,
sql: &str,
params: &[SqlValue],
max_rows: usize,
) -> Result<Vec<SqlRow>, rusqlite::Error> {
let mut stmt = conn.prepare_cached(sql)?;
let bound = bind(&stmt, params);
let columns = column_names(&stmt)?;
let mut rows = stmt.query(bound)?;
let mut out = vec![];
while let Some(row) = rows.next()? {
if out.len() >= max_rows {
return Err(rusqlite::Error::SqliteFailure(
rusqlite::ffi::Error::new(rusqlite::ffi::SQLITE_TOOBIG),
Some(format!(
"the query returned more than {max_rows} rows ([database] max_rows); add \
a LIMIT or raise the setting"
)),
));
}
out.push(read_row(&columns, row)?);
}
Ok(out)
}