use tracing::debug;

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

pub(super) async fn get_schema(
    state: &SchemaService,
    kind: &str,
    version: &str,
) -> Result<Option<TransactionSchema>, ConfigurationError> {
    debug!("getting transaction schema");
    let result = sqlx::query_as!(
        TransactionSchema,
        "select 
            *
            from transaction_schema where schema_type = $1 and schema_version = $2",
        kind,
        version,
    )
    .fetch_optional(&state.database)
    .await?;

    Ok(result)
}