refactor everything with more abstraction and a nicer interface

1 files changed, 0 insertions, 23 deletions

diff --git a/crates/secd/store/pg/sql/read_oauth_validation.sql b/crates/secd/store/pg/sql/read_oauth_validation.sql
deleted file mode 100644
index d8361ea..0000000
--- a/crates/secd/store/pg/sql/read_oauth_validation.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-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;