sqlload 0.46.0

SQL data loading tooling.
//! Run SQL statements in order.

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;

/// Run each statement in order on the target's session, stopping at the first failure; an open transaction is rolled back, so a failed write leaves the table as it was.
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(())
}