aboutsummaryrefslogtreecommitdiff
path: root/crates/secd/store/pg/sql/read_oauth_provider.sql
diff options
context:
space:
mode:
authorbenj <benj@rse8.com>2022-12-12 17:06:57 -0800
committerbenj <benj@rse8.com>2022-12-12 17:06:57 -0800
commit0920c4d4f30a3345870d385d5c6f3e0919228b56 (patch)
treef54668d91db469b7304758893a51b590c8f9b0de /crates/secd/store/pg/sql/read_oauth_provider.sql
parent3a4de13528fc85dcbe6bc9055d97ba5cc87f5712 (diff)
downloadsecdiam-0920c4d4f30a3345870d385d5c6f3e0919228b56.tar
secdiam-0920c4d4f30a3345870d385d5c6f3e0919228b56.tar.gz
secdiam-0920c4d4f30a3345870d385d5c6f3e0919228b56.tar.bz2
secdiam-0920c4d4f30a3345870d385d5c6f3e0919228b56.tar.lz
secdiam-0920c4d4f30a3345870d385d5c6f3e0919228b56.tar.xz
secdiam-0920c4d4f30a3345870d385d5c6f3e0919228b56.tar.zst
secdiam-0920c4d4f30a3345870d385d5c6f3e0919228b56.zip
(oauth2 + email added): a mess that may or may not really work and needs to be refactored...
Diffstat (limited to 'crates/secd/store/pg/sql/read_oauth_provider.sql')
-rw-r--r--crates/secd/store/pg/sql/read_oauth_provider.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/crates/secd/store/pg/sql/read_oauth_provider.sql b/crates/secd/store/pg/sql/read_oauth_provider.sql
new file mode 100644
index 0000000..edaa114
--- /dev/null
+++ b/crates/secd/store/pg/sql/read_oauth_provider.sql
@@ -0,0 +1,12 @@
+select flow
+ , base_url
+ , response_type
+ , default_scope
+ , client_id
+ , client_secret
+ , redirect_url
+ , created_at
+ , deleted_at
+from secd.oauth_provider
+where name = $1
+and flow = $2;