diff options
| author |  Anshul Gupta <ansg191@anshulg.com>
| 2024-08-05 18:55:10 -0700 |
|---|---|---|
| committer | Anshul Gupta <ansg191@anshulg.com>
| 2024-08-05 18:55:19 -0700 |
| commit | b96fcd1a54a46a95f98467b49a051564bc21c23c (patch) | |
| tree | 93caeeb05f8d6310e241095608ea2428c749b18c /backend/db/queries/users | |
| download | ibd-trader-b96fcd1a54a46a95f98467b49a051564bc21c23c.tar.gz ibd-trader-b96fcd1a54a46a95f98467b49a051564bc21c23c.tar.zst ibd-trader-b96fcd1a54a46a95f98467b49a051564bc21c23c.zip | |
Initial Commit
Diffstat (limited to 'backend/db/queries/users')
| -rw-r--r-- | backend/db/queries/users/add_ibd_creds.sql | 5 | ||||
| -rw-r--r-- | backend/db/queries/users/add_user.sql | 3 | ||||
| -rw-r--r-- | backend/db/queries/users/get_ibd_creds.sql | 4 | ||||
| -rw-r--r-- | backend/db/queries/users/get_user.sql | 3 | ||||
| -rw-r--r-- | backend/db/queries/users/list_users.sql | 2 |
5 files changed, 17 insertions, 0 deletions
diff --git a/backend/db/queries/users/add_ibd_creds.sql b/backend/db/queries/users/add_ibd_creds.sql new file mode 100644 index 0000000..054f328 --- /dev/null +++ b/backend/db/queries/users/add_ibd_creds.sql @@ -0,0 +1,5 @@ +UPDATE users +SET ibd_username = $2, + ibd_password = $3, + encryption_key = $4 +WHERE subject = $1;
\ No newline at end of file diff --git a/backend/db/queries/users/add_user.sql b/backend/db/queries/users/add_user.sql new file mode 100644 index 0000000..bf97ad5 --- /dev/null +++ b/backend/db/queries/users/add_user.sql @@ -0,0 +1,3 @@ +INSERT INTO users (subject) +VALUES ($1) +ON CONFLICT DO NOTHING;
\ No newline at end of file diff --git a/backend/db/queries/users/get_ibd_creds.sql b/backend/db/queries/users/get_ibd_creds.sql new file mode 100644 index 0000000..271abcc --- /dev/null +++ b/backend/db/queries/users/get_ibd_creds.sql @@ -0,0 +1,4 @@ +SELECT ibd_username, ibd_password, encrypted_key, kms_key_name +FROM users +INNER JOIN public.keys k on k.id = users.encryption_key +WHERE subject = $1;
\ No newline at end of file diff --git a/backend/db/queries/users/get_user.sql b/backend/db/queries/users/get_user.sql new file mode 100644 index 0000000..567f988 --- /dev/null +++ b/backend/db/queries/users/get_user.sql @@ -0,0 +1,3 @@ +SELECT subject, ibd_username, ibd_password, encryption_key +FROM users +WHERE subject = $1;
\ No newline at end of file diff --git a/backend/db/queries/users/list_users.sql b/backend/db/queries/users/list_users.sql new file mode 100644 index 0000000..ceafeb2 --- /dev/null +++ b/backend/db/queries/users/list_users.sql @@ -0,0 +1,2 @@ +SELECT subject, ibd_username, ibd_password, encryption_key +FROM users;
\ No newline at end of file |