diff options
Diffstat (limited to 'backend/db/queries/keys')
| -rw-r--r-- | backend/db/queries/keys/add_key.sql | 3 | ||||
| -rw-r--r-- | backend/db/queries/keys/get_key.sql | 3 |
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 |