From bd4ae04236795fb3d425fe1d80c87c0248a2b9dc Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Sun, 29 Mar 2015 18:19:08 +0200 Subject: 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 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() -- cgit v1.2.3-70-g09d2