use crate::adapters::contract::constants::{BEGIN_STATEMENT, COMMIT_STATEMENT};
use crate::adapters::postgres::_helpers::session::{query_error, session};
use crate::adapters::postgres::models::PostgresDestination;
use crate::loader::errors::LoaderError;
pub(in crate::adapters) async fn run_statements(
destination: &PostgresDestination,
statements: &[String],
) -> Result<(), LoaderError> {
if statements.is_empty() {
return Ok(());
}
let held = session(destination).await?;
let Some((client, _)) = held.as_ref() else {
return Ok(());
};
let mut in_transaction = false;
for statement in statements {
tracing::debug!(%statement, "running on Postgres");
in_transaction = match statement.as_str() {
BEGIN_STATEMENT => true,
COMMIT_STATEMENT => false,
_ => in_transaction,
};
if let Err(error) = client.batch_execute(statement).await {
if in_transaction
&& !client.is_closed()
&& let Err(rollback) = client.batch_execute("ROLLBACK").await
{
tracing::warn!(error = %rollback, "cannot roll back after a failed statement");
}
return Err(query_error(error));
}
}
Ok(())
}