From 7b8a1d4b706ee25c53da720cb85152f3d20cadbf Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Mon, 16 Feb 2015 06:13:46 +0100 Subject: reproducible: commmon: do not fail here if the database is new. Jobs will fail anyway later --- bin/reproducible_common.py | 26 ++++++++++++++++++++------ 1 file changed, 20 insertions(+), 6 deletions(-) diff --git a/bin/reproducible_common.py b/bin/reproducible_common.py index b25bc39f..b75d440d 100755 --- a/bin/reproducible_common.py +++ b/bin/reproducible_common.py @@ -420,12 +420,26 @@ conn_db = start_db_connection() # the local sqlite3 reproducible db conn_udd = start_udd_connection() # do the db querying -amount = int(query_db('SELECT count(name) FROM sources')[0][0]) -count_total = int(query_db('SELECT COUNT(name) FROM source_packages')[0][0]) -count_good = int(query_db( - 'SELECT COUNT(name) FROM source_packages WHERE status="reproducible"')[0][0]) -percent_total = round(((count_total/amount)*100), 1) -percent_good = round(((count_good/count_total)*100), 1) +try: + amount = int(query_db('SELECT count(name) FROM sources')[0][0]) + count_total = int(query_db('SELECT COUNT(name) FROM source_packages')[0][0]) + count_good = int(query_db('SELECT COUNT(name) FROM source_packages ' + \ + 'WHERE status="reproducible"')[0][0]) +except sqlite3.OperationalError: + log.critical('Error performing basic queries. You have to setup the ' + \ + 'database to successfully continue after this point.') + log.critical('Continuing anyway, hoping for the best!') + amount = 0 + count_total = 0 + count_good = 0 +try: + percent_total = round(((count_total/amount)*100), 1) + percent_good = round(((count_good/count_total)*100), 1) +except ZeroDivisionError: + log.error('Looks like there are either no tested package or no packages' + \ + ' available at all. Maybe it\'s a new database?') + percent_total = 0.0 + percent_good = 0.0 log.info('Total packages in Sid:\t\t' + str(amount)) log.info('Total tested packages:\t\t' + str(count_total)) log.info('Total reproducible packages:\t' + str(count_good)) -- cgit v1.2.3-70-g09d2