aboutsummaryrefslogtreecommitdiff
path: root/sqitch/revert
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2019-06-02 16:20:51 +0100
committerChristopher Baines <mail@cbaines.net>2019-06-02 21:48:02 +0100
commit4ccf3132b6f7e7946fc148228d4ff1ca93ab422c (patch)
treeca2f0847ba7736fa9287bd3332447d53d5cf3e85 /sqitch/revert
parentf03a750705980035f7efdfb4cc6498e4e0ce8054 (diff)
downloaddata-service-4ccf3132b6f7e7946fc148228d4ff1ca93ab422c.tar
data-service-4ccf3132b6f7e7946fc148228d4ff1ca93ab422c.tar.gz
Record job success without deleting the job record
Previously, the records for jobs would be deleted. It's useful to know when jobs were inserted in to the database, as well as when they succeeded (if they have). This change also makes it possible to keep track of jobs that have failed, as they won't be deleted.
Diffstat (limited to 'sqitch/revert')
-rw-r--r--sqitch/revert/dates_to_load_new_guix_revision_jobs.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sqitch/revert/dates_to_load_new_guix_revision_jobs.sql b/sqitch/revert/dates_to_load_new_guix_revision_jobs.sql
new file mode 100644
index 0000000..614b37f
--- /dev/null
+++ b/sqitch/revert/dates_to_load_new_guix_revision_jobs.sql
@@ -0,0 +1,8 @@
+-- Revert guix-data-service:dates_to_load_new_guix_revision_jobs from pg
+
+BEGIN;
+
+ALTER TABLE load_new_guix_revision_jobs DROP COLUMN created_at;
+ALTER TABLE load_new_guix_revision_jobs DROP COLUMN succeeded_at;
+
+COMMIT;