From 1eb68afd35257ed52d1a00987736996e171f64e4 Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Thu, 12 Jan 2017 13:02:19 +0100 Subject: fixup 93a522cb: reproducible Debian: add a graph with diffoscope crashes and timeouts Signed-off-by: Holger Levsen --- bin/reproducible_db_maintenance.py | 8 ++++---- bin/reproducible_html_breakages.py | 8 ++++---- 2 files changed, 8 insertions(+), 8 deletions(-) diff --git a/bin/reproducible_db_maintenance.py b/bin/reproducible_db_maintenance.py index 649d13dd..7d88befd 100755 --- a/bin/reproducible_db_maintenance.py +++ b/bin/reproducible_db_maintenance.py @@ -593,12 +593,12 @@ schema_updates = { ], 30: [ # Add new table to track diffoscope breake - "CREATE TABLE stats_breakage - (datum TEXT NOT NULL, + '''CREATE TABLE stats_breakages + (datum TEXT, diffoscope_timeouts INTEGER, diffoscope_crashes INTEGER, - PRIMARY KEY (datum))", - "INSERT INTO rb_schema (version, date) VALUES (30, '" + now + "')" + PRIMARY KEY (datum))''', + '''INSERT INTO rb_schema (version, date) VALUES (30, '" + now + "')''' ], } diff --git a/bin/reproducible_html_breakages.py b/bin/reproducible_html_breakages.py index 90ce256b..4023c98d 100755 --- a/bin/reproducible_html_breakages.py +++ b/bin/reproducible_html_breakages.py @@ -311,13 +311,13 @@ def create_breakages_graph(): y_label, '1920', '960']) -def update_stats_breakage(diffoscope_timeouts, diffoscope_crashes): +def update_stats_breakages(diffoscope_timeouts, diffoscope_crashes): # we only do stats up until yesterday YESTERDAY = (datetime.now()-timedelta(days=1)).strftime('%Y-%m-%d') result = query_db(""" SELECT datum, diffoscope_timeouts, diffoscope_crashes - FROM stats_breakage + FROM stats_breakages WHERE datum = '{date}' """.format(date=YESTERDAY)) @@ -326,10 +326,10 @@ def update_stats_breakage(diffoscope_timeouts, diffoscope_crashes): insert = "INSERT INTO stats_breakages VALUES ('{date}', " + \ "'{diffoscope_timeouts}', '{diffoscope_crashes}')" query_db(insert.format(date=YESTERDAY, diffoscope_timeouts=diffoscope_timeouts, diffoscope_crashes=diffoscope_crashes)) - log.info("Updating db table stats_breakage on %s with %s timeouts and %s crashes.", + log.info("Updating db table stats_breakages on %s with %s timeouts and %s crashes.", YESTERDAY, diffoscope_timeouts, diffoscope_crashes) else: - log.debug("Not updating db table stats_breakage as it already has data for %s.", + log.debug("Not updating db table stats_breakages as it already has data for %s.", YESTERDAY) -- cgit v1.2.3-70-g09d2