(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/sqlite/sql/write_oauth_provider.sql b/crates/secd/store/sqlite/sql/write_oauth_provider.sql
new file mode 100644
index 0000000..421caf7
--- /dev/null
+++ b/crates/secd/store/sqlite/sql/write_oauth_provider.sql
@@ -0,0 +1,23 @@
+insert into oauth_provider (
+       name
+       , flow
+       , base_url
+       , response_type
+       , default_scope
+       , client_id
+       , client_secret
+       , redirect_url
+       , created_at
+       , deleted_at
+) values (
+       ?1
+       , ?2
+       , ?3
+       , ?4
+       , ?5
+       , ?6
+       , ?7
+       , ?8
+       , ?9
+       , ?10
+) on conflict (name, flow) do nothing;