diff options
author | Christopher Baines <mail@cbaines.net> | 2020-05-08 15:17:05 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2020-05-08 15:17:05 +0100 |
commit | 628b7b78f6fd92d006c4db9d971dcad58df051b9 (patch) | |
tree | 0f3a48dbba5dd4703ca7c9c0b062f7e288e8c6a2 /sqitch | |
parent | bda7d58853ed4fba976cac92a70c4dc68db263aa (diff) | |
download | build-coordinator-628b7b78f6fd92d006c4db9d971dcad58df051b9.tar build-coordinator-628b7b78f6fd92d006c4db9d971dcad58df051b9.tar.gz |
Add sqlite datastore support for storing unprocessed hook events
Diffstat (limited to 'sqitch')
-rw-r--r-- | sqitch/pg/deploy/unprocessed_hook_events.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/revert/unprocessed_hook_events.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/verify/unprocessed_hook_events.sql | 7 | ||||
-rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
-rw-r--r-- | sqitch/sqlite/deploy/unprocessed_hook_events.sql | 11 | ||||
-rw-r--r-- | sqitch/sqlite/revert/unprocessed_hook_events.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/verify/unprocessed_hook_events.sql | 7 |
7 files changed, 47 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/unprocessed_hook_events.sql b/sqitch/pg/deploy/unprocessed_hook_events.sql new file mode 100644 index 0000000..8961683 --- /dev/null +++ b/sqitch/pg/deploy/unprocessed_hook_events.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:unprocessed_hook_events to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/unprocessed_hook_events.sql b/sqitch/pg/revert/unprocessed_hook_events.sql new file mode 100644 index 0000000..863cf81 --- /dev/null +++ b/sqitch/pg/revert/unprocessed_hook_events.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:unprocessed_hook_events from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/unprocessed_hook_events.sql b/sqitch/pg/verify/unprocessed_hook_events.sql new file mode 100644 index 0000000..5b65407 --- /dev/null +++ b/sqitch/pg/verify/unprocessed_hook_events.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:unprocessed_hook_events on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 565d142..a062e08 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -11,3 +11,4 @@ setup_failures 2020-04-13T13:05:29Z Christopher Baines <mail@cbaines.net> # Crea output_metadata 2020-04-23T14:26:15Z Christopher Baines <mail@cbaines.net> # Create table for storing output metadata derivation_outputs_output_index 2020-04-28T17:49:19Z Christopher Baines <mail@cbaines.net> # Add an index on derivation_outputs.output allocator_related_indexes 2020-04-29T16:59:14Z Christopher Baines <mail@cbaines.net> # Add a few indexes that should speed up build allocation +unprocessed_hook_events 2020-05-08T12:55:28Z Christopher Baines <mail@cbaines.net> # Add a new table unprocessed_hook_events diff --git a/sqitch/sqlite/deploy/unprocessed_hook_events.sql b/sqitch/sqlite/deploy/unprocessed_hook_events.sql new file mode 100644 index 0000000..33fa86b --- /dev/null +++ b/sqitch/sqlite/deploy/unprocessed_hook_events.sql @@ -0,0 +1,11 @@ +-- Deploy guix-build-coordinator:unprocessed_hook_events to sqlite + +BEGIN; + +CREATE TABLE unprocessed_hook_events ( + id INTEGER PRIMARY KEY ASC, + event TEXT NOT NULL, + arguments TEXT NOT NULL +); + +COMMIT; diff --git a/sqitch/sqlite/revert/unprocessed_hook_events.sql b/sqitch/sqlite/revert/unprocessed_hook_events.sql new file mode 100644 index 0000000..4a3137d --- /dev/null +++ b/sqitch/sqlite/revert/unprocessed_hook_events.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:unprocessed_hook_events from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/unprocessed_hook_events.sql b/sqitch/sqlite/verify/unprocessed_hook_events.sql new file mode 100644 index 0000000..0a5fb28 --- /dev/null +++ b/sqitch/sqlite/verify/unprocessed_hook_events.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:unprocessed_hook_events on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |