(oauth2 + email added): a mess that may or may not really work and needs to be refactored...

1 files changed, 23 insertions, 0 deletions

diff --git a/crates/secd/store/pg/sql/read_oauth_validation.sql b/crates/secd/store/pg/sql/read_oauth_validation.sql
new file mode 100644
index 0000000..d8361ea
--- /dev/null
+++ b/crates/secd/store/pg/sql/read_oauth_validation.sql
@@ -0,0 +1,23 @@
+select oauth_validation_public_id
+       , i.identity_public_id
+       , ov.access_token
+       , ov.raw_response
+       , ov.created_at
+       , ov.validated_at
+       , iov.revoked_at
+       , iov.deleted_at
+       , op.name          as oauth_provider_name
+       , op.flow          as oauth_provider_flow
+       , op.base_url      as oauth_provider_base_url
+       , op.response_type as oauth_provider_response_type
+       , op.default_scope as oauth_provider_default_scope
+       , op.client_id     as oauth_provider_client_id
+       , op.client_secret as oauth_provider_client_secret
+       , op.redirect_url  as oauth_provider_redirect_url
+       , op.created_at    as oauth_provider_created_at
+       , op.deleted_at    as oauth_provider_deleted_at
+from secd.oauth_validation               ov
+join secd.oauth_provider                 op  using(oauth_provider_id)
+left join secd.identity_oauth_validation iov using(oauth_validation_id)
+left join secd.identity                  i   using(identity_id)
+where oauth_validation_public_id = $1;