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.

13 files changed, 88 insertions, 0 deletions

diff --git a/sqitch/pg/deploy/add_agent_names.sql b/sqitch/pg/deploy/add_agent_names.sql
new file mode 100644
index 0000000..e53c2f1
--- /dev/null
+++ b/sqitch/pg/deploy/add_agent_names.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-build-coordinator:add_agent_names to pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/deploy/add_dynamic_auth_tokens.sql b/sqitch/pg/deploy/add_dynamic_auth_tokens.sql
new file mode 100644
index 0000000..5a4022d
--- /dev/null
+++ b/sqitch/pg/deploy/add_dynamic_auth_tokens.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-build-coordinator:add_dynamic_auth_tokens to pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/revert/add_agent_names.sql b/sqitch/pg/revert/add_agent_names.sql
new file mode 100644
index 0000000..9446feb
--- /dev/null
+++ b/sqitch/pg/revert/add_agent_names.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:add_agent_names from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/revert/add_dynamic_auth_tokens.sql b/sqitch/pg/revert/add_dynamic_auth_tokens.sql
new file mode 100644
index 0000000..b061032
--- /dev/null
+++ b/sqitch/pg/revert/add_dynamic_auth_tokens.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:add_dynamic_auth_tokens from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/verify/add_agent_names.sql b/sqitch/pg/verify/add_agent_names.sql
new file mode 100644
index 0000000..9f69522
--- /dev/null
+++ b/sqitch/pg/verify/add_agent_names.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:add_agent_names on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;
diff --git a/sqitch/pg/verify/add_dynamic_auth_tokens.sql b/sqitch/pg/verify/add_dynamic_auth_tokens.sql
new file mode 100644
index 0000000..b0b62a0
--- /dev/null
+++ b/sqitch/pg/verify/add_dynamic_auth_tokens.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:add_dynamic_auth_tokens on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;
diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan
index 513609c..19e2b11 100644
--- a/sqitch/sqitch.plan
+++ b/sqitch/sqitch.plan
@@ -26,3 +26,5 @@ support_build_cancelation 2020-12-11T18:25:42Z Christopher Baines <mail@cbaines.
 add_build_tags_build_id_idx 2020-12-21T13:20:54Z Christopher Baines <mail@cbaines.net> # Add an index on build_tags.build_id
 add_builds_deferred_until 2020-12-26T19:26:32Z Christopher Baines <mail@cbaines.net> # Add builds.deferred_until
 add_agent_tags 2021-01-17T11:13:23Z Christopher Baines <mail@cbaines.net> # Add tags for agents
+add_agent_names 2021-02-28T14:04:24Z Christopher Baines <mail@cbaines.net> # Add agent.names
+add_dynamic_auth_tokens 2021-02-28T15:21:24Z Christopher Baines <mail@cbaines.net> # Add dynamic_auth_tokens
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;