use tracing::debug;

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

pub(super) async fn update_schema(
    state: &SchemaService,
    kind: &str,
    version: &str,
    schema: &serde_json::Value,
) -> Result<Option<TransactionSchema>, ConfigurationError> {
    debug!("updating transaction schema");
    sqlx::query_as!(
        TransactionSchema,
        "
            update
                transaction_schema
            set 
                schema = $3
            where 
                schema_type = $1 
                and schema_version = $2
            returning *
        ",
        kind,
        version,
        sqlx::types::Json(&schema) as _
    )
    .fetch_optional(&state.database)
    .await
    .map_err(|e| e.into())
}