aboutsummaryrefslogtreecommitdiff
path: root/backend/db/queries/keys
diff options
context:
space:
mode:
authorGravatar Anshul Gupta <ansg191@anshulg.com> 2024-08-05 18:55:10 -0700
committerGravatar Anshul Gupta <ansg191@anshulg.com> 2024-08-05 18:55:19 -0700
commitb96fcd1a54a46a95f98467b49a051564bc21c23c (patch)
tree93caeeb05f8d6310e241095608ea2428c749b18c /backend/db/queries/keys
downloadibd-trader-b96fcd1a54a46a95f98467b49a051564bc21c23c.tar.gz
ibd-trader-b96fcd1a54a46a95f98467b49a051564bc21c23c.tar.zst
ibd-trader-b96fcd1a54a46a95f98467b49a051564bc21c23c.zip
Initial Commit
Diffstat (limited to 'backend/db/queries/keys')
-rw-r--r--backend/db/queries/keys/add_key.sql3
-rw-r--r--backend/db/queries/keys/get_key.sql3
2 files changed, 6 insertions, 0 deletions
diff --git a/backend/db/queries/keys/add_key.sql b/backend/db/queries/keys/add_key.sql
new file mode 100644
index 0000000..bb416c5
--- /dev/null
+++ b/backend/db/queries/keys/add_key.sql
@@ -0,0 +1,3 @@
+INSERT INTO keys (kms_key_name, encrypted_key)
+VALUES ($1, $2)
+RETURNING id; \ No newline at end of file
diff --git a/backend/db/queries/keys/get_key.sql b/backend/db/queries/keys/get_key.sql
new file mode 100644
index 0000000..97d8367
--- /dev/null
+++ b/backend/db/queries/keys/get_key.sql
@@ -0,0 +1,3 @@
+SELECT id, kms_key_name, encrypted_key, created_at
+FROM keys
+WHERE id = $1; \ No newline at end of file