add build architecture to schema of buildrequests table

1 files changed, 8 insertions, 4 deletions

diff --git a/webapp.py b/webapp.py
index 3d3af0d..ee7cce6 100644
--- a/webapp.py
+++ b/webapp.py
@@ -424,7 +424,9 @@ def show_log(filename):
 def request_schedule():
     source = flask.request.form["source"]
     buildarch, hostarch = flask.request.form["archpair"].split("_")
-    if buildarch not in ("any", "amd64"):
+    if buildarch == "any":
+        buildarch = None
+    elif buildarch != "amd64":
         raise werkzeug.exceptions.BadRequest()
     with db.engine.connect() as conn:
         query = sqlalchemy.text("""
@@ -439,7 +441,9 @@ def request_schedule():
             if not conn.execute(query, hostarch=hostarch).first():
                 raise werkzeug.exceptions.BadRequest()
         query = sqlalchemy.text("""
-            INSERT INTO buildrequests (source, architecture, requesttime)
-                VALUES (:source, :hostarch, datetime('now'));""")
-        conn.execute(query, source=source, hostarch=hostarch)
+            INSERT INTO buildrequests (source, buildarch, hostarch,
+                                       requesttime)
+                VALUES (:source, :buildarch, :hostarch, datetime('now'));""")
+        conn.execute(query, source=source, buildarch=buildarch,
+                     hostarch=hostarch)
     return flask.render_template_string(schedule_template)