X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fcruft_report.py;h=fbbc0446d2156fe5643261ee8eefa438f9ba833d;hb=519c1dbf89c13557afc15a429164616ac563d379;hp=5c6ee8d0c3270c5ca7d846ac8967799b1529cf38;hpb=ac84e3ea94787e97cc8354ac9132dcbf9dc922da;p=dak.git 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)