]> git.evergreen-ils.org Git - working/Evergreen.git/commit
LP1893463: Prevent duplicated report outputs
authorJason Boyer <JBoyer@equinoxinitiative.org>
Fri, 28 Aug 2020 21:13:14 +0000 (17:13 -0400)
committerChris Sharp <csharp@georgialibraries.org>
Wed, 7 Oct 2020 18:50:47 +0000 (14:50 -0400)
commit360ad1f138a4ca8e1a70d497873b78055ae6c29d
treee52141e9ef21d3613e55c7a114acbb990db3358c
parent94f44679eb693c1245e6c5cf4d42154fa4620597
LP1893463: Prevent duplicated report outputs

When re-running recurring reports that are interrupted,
it's possible to end up with a duplicate copy of the next
recurrance of that report. This branch adds a unique index
to reporter.schedule and tells clark-kent.pl not to worry
about it.

For the purposes of this change a duplicate report is
one where report.schedule has identical values for report,
(output) folder, runner, run_time, and email.

Signed-off-by: Jason Boyer <JBoyer@equinoxinitiative.org>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Open-ILS/src/reporter/clark-kent.pl
Open-ILS/src/sql/Pg/reporter-schema.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.reporter_schedule_uniqueness.sql [new file with mode: 0644]