aboutsummaryrefslogtreecommitdiff
path: root/sqitch/sqlite
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2021-02-28 18:41:07 +0000
committerChristopher Baines <mail@cbaines.net>2021-02-28 18:41:07 +0000
commit1f79fc38a17ceda30f378efd4e7f80f252c99b4d (patch)
treee5cf6166d69b3f7249d4006846751bf1fb6e5720 /sqitch/sqlite
parentcaf63dce0ea29a07c5205a69ff6f60b7c6b60084 (diff)
downloadbuild-coordinator-1f79fc38a17ceda30f378efd4e7f80f252c99b4d.tar
build-coordinator-1f79fc38a17ceda30f378efd4e7f80f252c99b4d.tar.gz
Add a new dynamic authentication approach
This avoids the need to create agents upfront, which could be useful when creating many childhurd VMs or using scheduling tools to dynamically run agents.
Diffstat (limited to 'sqitch/sqlite')
-rw-r--r--sqitch/sqlite/deploy/add_agent_names.sql7
-rw-r--r--sqitch/sqlite/deploy/add_dynamic_auth_tokens.sql9
-rw-r--r--sqitch/sqlite/revert/add_agent_names.sql7
-rw-r--r--sqitch/sqlite/revert/add_dynamic_auth_tokens.sql7
-rw-r--r--sqitch/sqlite/verify/add_agent_names.sql7
-rw-r--r--sqitch/sqlite/verify/add_dynamic_auth_tokens.sql7
6 files changed, 44 insertions, 0 deletions
diff --git a/sqitch/sqlite/deploy/add_agent_names.sql b/sqitch/sqlite/deploy/add_agent_names.sql
new file mode 100644
index 0000000..bc2ec44
--- /dev/null
+++ b/sqitch/sqlite/deploy/add_agent_names.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-build-coordinator:add_agent_names to sqlite
+
+BEGIN;
+
+ALTER TABLE agents ADD COLUMN name TEXT;
+
+COMMIT;
diff --git a/sqitch/sqlite/deploy/add_dynamic_auth_tokens.sql b/sqitch/sqlite/deploy/add_dynamic_auth_tokens.sql
new file mode 100644
index 0000000..9d50c95
--- /dev/null
+++ b/sqitch/sqlite/deploy/add_dynamic_auth_tokens.sql
@@ -0,0 +1,9 @@
+-- Deploy guix-build-coordinator:add_dynamic_auth_tokens to sqlite
+
+BEGIN;
+
+CREATE TABLE dynamic_auth_tokens (
+ token TEXT NOT NULL
+);
+
+COMMIT;
diff --git a/sqitch/sqlite/revert/add_agent_names.sql b/sqitch/sqlite/revert/add_agent_names.sql
new file mode 100644
index 0000000..5bfd09e
--- /dev/null
+++ b/sqitch/sqlite/revert/add_agent_names.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:add_agent_names from sqlite
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/sqlite/revert/add_dynamic_auth_tokens.sql b/sqitch/sqlite/revert/add_dynamic_auth_tokens.sql
new file mode 100644
index 0000000..8bf4e0a
--- /dev/null
+++ b/sqitch/sqlite/revert/add_dynamic_auth_tokens.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:add_dynamic_auth_tokens from sqlite
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/sqlite/verify/add_agent_names.sql b/sqitch/sqlite/verify/add_agent_names.sql
new file mode 100644
index 0000000..e072871
--- /dev/null
+++ b/sqitch/sqlite/verify/add_agent_names.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:add_agent_names on sqlite
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;
diff --git a/sqitch/sqlite/verify/add_dynamic_auth_tokens.sql b/sqitch/sqlite/verify/add_dynamic_auth_tokens.sql
new file mode 100644
index 0000000..b14eba5
--- /dev/null
+++ b/sqitch/sqlite/verify/add_dynamic_auth_tokens.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:add_dynamic_auth_tokens on sqlite
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;