feat(warden): save clearance

2 files changed, 43 insertions, 0 deletions

diff --git a/.sqlx/query-37a548705f84beb612bb984fcaecb39d2b5560eb7cbd0cc9d496c819b88d8c52.json b/.sqlx/query-37a548705f84beb612bb984fcaecb39d2b5560eb7cbd0cc9d496c819b88d8c52.json
new file mode 100644
index 0000000..6301b0f
--- /dev/null
+++ b/.sqlx/query-37a548705f84beb612bb984fcaecb39d2b5560eb7cbd0cc9d496c819b88d8c52.json
@@ -0,0 +1,15 @@
+{
+  "db_name": "PostgreSQL",
+  "query": "insert into pacs002 (id, document) values ($1, $2)",
+  "describe": {
+    "columns": [],
+    "parameters": {
+      "Left": [
+        "Uuid",
+        "Jsonb"
+      ]
+    },
+    "nullable": []
+  },
+  "hash": "37a548705f84beb612bb984fcaecb39d2b5560eb7cbd0cc9d496c819b88d8c52"
+}
diff --git a/.sqlx/query-dee04f022231e4b4b5b4a9941acf891583af2d241615045d788c7a54093f6091.json b/.sqlx/query-dee04f022231e4b4b5b4a9941acf891583af2d241615045d788c7a54093f6091.json
new file mode 100644
index 0000000..29d2a8c
--- /dev/null
+++ b/.sqlx/query-dee04f022231e4b4b5b4a9941acf891583af2d241615045d788c7a54093f6091.json
@@ -0,0 +1,28 @@
+{
+  "db_name": "PostgreSQL",
+  "query": "select id, document as \"document: sqlx::types::Json<serde_json::Value>\" from pacs008 where exists (\n            select 1\n            from jsonb_array_elements(document->'f_i_to_f_i_cstmr_cdt_trf'->'cdt_trf_tx_inf') as elem\n            where elem->'pmt_id'->>'end_to_end_id' = $1\n        ) limit 1",
+  "describe": {
+    "columns": [
+      {
+        "ordinal": 0,
+        "name": "id",
+        "type_info": "Uuid"
+      },
+      {
+        "ordinal": 1,
+        "name": "document: sqlx::types::Json<serde_json::Value>",
+        "type_info": "Jsonb"
+      }
+    ],
+    "parameters": {
+      "Left": [
+        "Text"
+      ]
+    },
+    "nullable": [
+      false,
+      false
+    ]
+  },
+  "hash": "dee04f022231e4b4b5b4a9941acf891583af2d241615045d788c7a54093f6091"
+}