From eb41e19bcecc1f0dc6616fe08dcb349e6a442cf8 Mon Sep 17 00:00:00 2001 From: Ansgar Burchardt Date: Fri, 21 Aug 2015 09:47:39 +0200 Subject: [PATCH] Report only obsolete source packages older than one day This should help with avoiding removal of source-only uploads where no binary was built yet. --- dak/cruft_report.py | 1 + 1 file changed, 1 insertion(+) diff --git a/dak/cruft_report.py b/dak/cruft_report.py index 5c6ee8d0..fbbc0446 100755 --- a/dak/cruft_report.py +++ b/dak/cruft_report.py @@ -346,6 +346,7 @@ SELECT ss.src, ss.source, ss.version, LEFT JOIN bin_associations_binaries bab ON ss.src = bab.source AND ss.suite = bab.suite WHERE s.suite_name = :suite_name AND bab.id IS NULL + AND now() - ss.install_date > '1 day'::interval ORDER BY install_date""" args = { 'suite_name': suite_name } return session.execute(query, args) -- 2.39.5