use std::borrow::BorrowMut;
use widestring::U16Str;
use crate::{
handles::{Statement, StatementImpl},
CursorImpl, Error, ParameterCollection,
};
pub fn execute_with_parameters<'o, S>(
lazy_statement: impl FnOnce() -> Result<S, Error>,
query: Option<&U16Str>,
params: impl ParameterCollection,
) -> Result<Option<CursorImpl<'o, S>>, Error>
where
S: BorrowMut<StatementImpl<'o>>,
{
let parameter_set_size = params.parameter_set_size();
if parameter_set_size == 0 {
Ok(None)
} else {
let mut statement = lazy_statement()?;
let stmt = statement.borrow_mut();
stmt.reset_parameters()?;
unsafe {
stmt.set_paramset_size(parameter_set_size)?;
params.bind_parameters_to(stmt)?;
if let Some(sql) = query {
stmt.exec_direct(sql)?;
} else {
stmt.execute()?;
}
};
if stmt.num_result_cols()? == 0 {
Ok(None)
} else {
Ok(Some(CursorImpl::new(statement)))
}
}
}
pub fn columns<'o, S>(
mut statement: S,
catalog_name: &U16Str,
schema_name: &U16Str,
table_name: &U16Str,
column_name: &U16Str,
) -> Result<Option<CursorImpl<'o, S>>, Error>
where
S: BorrowMut<StatementImpl<'o>>,
{
let stmt = statement.borrow_mut();
stmt.columns(catalog_name, schema_name, table_name, column_name)?;
if stmt.num_result_cols()? == 0 {
Ok(None)
} else {
Ok(Some(CursorImpl::new(statement)))
}
}