1 files changed, 26 insertions, 0 deletions
diff --git a/lib/api-config/src/schema/get_schema.rs b/lib/api-config/src/schema/get_schema.rs
new file mode 100644
index 0000000..427a02f
--- /dev/null
+++ b/lib/api-config/src/schema/get_schema.rs
@@ -0,0 +1,26 @@
+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)
+}