reproducible: notes: query the db and lists packages which FTBFS but no due to timestamps from cpp macros. Bad house for this code, but let's dump it here for now

1 files changed, 21 insertions, 0 deletions

diff --git a/bin/reproducible_notes.py b/bin/reproducible_notes.py
index e2b44f96..16c39df6 100755
--- a/bin/reproducible_notes.py
+++ b/bin/reproducible_notes.py
@@ -130,9 +130,30 @@ def store_notes():
     log.info('Saved ' + str(len(to_add)) + ' notes in the database')
 
 
+def really_ftbfs_packages():
+    query = 'SELECT s.id, s.name, s.suite, s.architecture ' + \
+            'FROM notes AS n JOIN sources AS s ON n.package_id=s.id ' + \
+            'JOIN results AS r ON r.package_id=s.id ' + \
+            'WHERE n.issues NOT LIKE "%timestamps_from_cpp_macros%" ' + \
+            'AND r.status="FTBFS"'
+    result = sorted(query_db(query), key=lambda x: x[1])
+    log.info('')
+    log.info('')
+    log.info('Following there are a list of package which FTBFS in our ' +
+             'current setup, but does not have the tag ' +
+             'timestamps_from cpp_macros, i.e. they are real FTBFS.')
+    log.info('')
+    for pkg in result:
+        log.info(pkg[1] + '\t' + REPRODUCIBLE_URL + '/' + pkg[2] + '/' +
+                 pkg[3] + '/' + pkg[1])
+    log.info('')
+    log.info('For a total of ' + str(len(result)) + ' packages')
+
+
 if __name__ == '__main__':
     notes = load_notes()
     issues = load_issues()
     store_issues()
     drop_old_issues()
     store_notes()
+    really_ftbfs_packages()