[Qa-jenkins-scm] [jenkins.debian.net] 05/06: 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

[Holger Levsen]

This is an automated email from the git hooks/post-receive script.

holger pushed a commit to branch master
in repository jenkins.debian.net.

commit bd4ae04236795fb3d425fe1d80c87c0248a2b9dc
Author: Mattia Rizzolo <mattia at mapreri.org>
Date:   Sun Mar 29 18:19:08 2015 +0200

    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
---
 bin/reproducible_notes.py | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

diff --git a/bin/reproducible_notes.py b/bin/reproducible_notes.py
index e2b44f9..16c39df 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()

-- 
Alioth's /usr/local/bin/git-commit-notice on /srv/git.debian.org/git/qa/jenkins.debian.net.git