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

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

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

diff --git a/crates/secd/store/pg/sql/write_oauth_validation.sql b/crates/secd/store/pg/sql/write_oauth_validation.sql
deleted file mode 100644
index 11f2578..0000000
--- a/crates/secd/store/pg/sql/write_oauth_validation.sql
+++ /dev/null
@@ -1,45 +0,0 @@
-insert into secd.oauth_validation (
-       oauth_validation_public_id
-       , oauth_provider_id
-       , access_token
-       , raw_response
-       , created_at
-       , validated_at
-) values (
-       $1
-       , (
-         select oauth_provider_id
-         from secd.oauth_provider
-         where name = $2
-         and flow = $3
-       )
-       , $4
-       , $5
-       , $6
-       , $7
-) on conflict (oauth_validation_public_id) do update
-  set access_token = excluded.access_token
-      , validated_at = excluded.validated_at
-      , raw_response = excluded.raw_response;
---
-insert into secd.identity_oauth_validation (
-       identity_id
-       , oauth_validation_id
-       , revoked_at
-       , deleted_at
-) values (
-       (
-       select identity_id
-       from secd.identity
-       where identity_public_id = $1
-       )
-       , (
-         select oauth_validation_id
-         from secd.oauth_validation
-         where oauth_validation_public_id = $2
-       )
-       , $3
-       , $4
-) on conflict (identity_id, oauth_validation_id) do update
-  set revoked_at = excluded.revoked_at
-      , deleted_at = excluded.deleted_at;
-- 
cgit v1.2.3