From c2268c285648ef02ece04de0d9df0813c6d70ff8 Mon Sep 17 00:00:00 2001
From: benj <benj@rse8.com>
Date: Sat, 24 Dec 2022 00:43:38 -0800
Subject: refactor everything with more abstraction and a nicer interface

---
 crates/secd/store/pg/sql/read_oauth_validation.sql | 23 ----------------------
 1 file changed, 23 deletions(-)
 delete mode 100644 crates/secd/store/pg/sql/read_oauth_validation.sql

(limited to 'crates/secd/store/pg/sql/read_oauth_validation.sql')

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;
-- 
cgit v1.2.3

