use tracing::debug;

use crate::{ConfigurationError, schema::SchemaService};

pub(super) async fn delete_schema(
    state: &SchemaService,
    kind: &str,
    version: &str,
) -> Result<(), ConfigurationError> {
    debug!("deleting transaction schema");
    sqlx::query!(
        "delete from transaction_schema where schema_type = $1 and schema_version = $2",
        kind,
        version,
    )
    .execute(&state.database)
    .await?;
    Ok(())
}