summaryrefslogtreecommitdiffstats
path: root/bin
diff options
context:
space:
mode:
authorMattia Rizzolo <mattia@mapreri.org>2015-03-29 18:19:08 +0200
committerMattia Rizzolo <mattia@mapreri.org>2015-03-29 18:19:08 +0200
commitbd4ae04236795fb3d425fe1d80c87c0248a2b9dc (patch)
treed507e0339f3d055a24877ab4991ffa3300f3fc78 /bin
parent68eefd759bd6a128ac9844582405cf2aa2f76c97 (diff)
downloadjenkins.debian.net-bd4ae04236795fb3d425fe1d80c87c0248a2b9dc.tar.xz
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
Diffstat (limited to 'bin')
-rwxr-xr-xbin/reproducible_notes.py21
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()