diff options
Diffstat (limited to 'webapp.py')
-rw-r--r-- | webapp.py | 6 |
1 files changed, 2 insertions, 4 deletions
@@ -370,8 +370,7 @@ def collect_depstate(conn, source): def show_index(): with db.engine.connect() as conn: builds = list(conn.execute(""" - SELECT source, version, 'amd64' AS buildarch, - architecture AS hostarch, starttime, filename, + SELECT source, version, buildarch, hostarch, starttime, filename, ifnull((SELECT max(patched + 1) FROM bugs WHERE affects = source), 0) AS buglvl @@ -392,8 +391,7 @@ def show_source(source): context["version"], context["depresult"] = collect_depstate(conn, source) query = sqlalchemy.text(""" - SELECT version, 'amd64' AS buildarch, architecture AS hostarch, - success, starttime, filename + SELECT version, buildarch, hostarch, success, starttime, filename FROM builds WHERE source = :source;""") context["builds"] = list(conn.execute(query, source=source)) query = sqlalchemy.text(""" |