diff options
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 |