From 7b5da3c5b65ee5633c42616d3e6ca3f3c7d4785c Mon Sep 17 00:00:00 2001 From: Helmut Grohne Date: Wed, 7 Oct 2020 16:48:12 +0200 Subject: add build architecture to schema of builds table --- webapp.py | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) (limited to 'webapp.py') diff --git a/webapp.py b/webapp.py index cc9de37..3d3af0d 100644 --- a/webapp.py +++ b/webapp.py @@ -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(""" -- cgit v1.2.3