From 4ccf3132b6f7e7946fc148228d4ff1ca93ab422c Mon Sep 17 00:00:00 2001
From: Christopher Baines <mail@cbaines.net>
Date: Sun, 2 Jun 2019 16:20:51 +0100
Subject: 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.
---
 sqitch/verify/dates_to_load_new_guix_revision_jobs.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 sqitch/verify/dates_to_load_new_guix_revision_jobs.sql

(limited to 'sqitch/verify/dates_to_load_new_guix_revision_jobs.sql')

diff --git a/sqitch/verify/dates_to_load_new_guix_revision_jobs.sql b/sqitch/verify/dates_to_load_new_guix_revision_jobs.sql
new file mode 100644
index 0000000..71afed2
--- /dev/null
+++ b/sqitch/verify/dates_to_load_new_guix_revision_jobs.sql
@@ -0,0 +1,8 @@
+-- Verify guix-data-service:dates_to_load_new_guix_revision_jobs on pg
+
+BEGIN;
+
+SELECT created_at FROM load_new_guix_revision_jobs WHERE FALSE;
+SELECT succeeded_at FROM load_new_guix_revision_jobs WHERE FALSE;
+
+ROLLBACK;
-- 
cgit v1.2.3

