Scheduled a build of {{ request.form["source"]|e }}
{%- if request.form["architecture"] != "any" %}
for {{ request.form["architecture"]|e -}}
{%- endif %}.
"""
@app.template_filter("sqltimestamp")
def sqltimestamp_filter(s):
strptime = datetime.datetime.strptime
try:
return strptime(s, "%Y-%m-%d %H:%M:%S.%f").replace(microsecond=0)
except ValueError:
return strptime(s, "%Y-%m-%d %H:%M:%S")
def formatts(ts):
assert isinstance(ts, datetime.datetime)
dt = datetime.datetime.utcnow() - ts
if dt < datetime.timedelta(seconds=1):
return "now"
if dt < datetime.timedelta(seconds=100):
return "%d s" % dt.seconds
if dt < datetime.timedelta(minutes=100):
return "%d m" % (dt.seconds // 60)
if dt < datetime.timedelta(days=1):
return "%d h" % (dt.seconds // (60 * 60))
return "%d d" % dt.days
@app.template_filter("formatts")
def formatts_filter(ts):
return jinja2.Markup('' %
(ts, ts, formatts(ts)))
@app.template_filter('arch_format')
@jinja2.contextfilter
def arch_format_filter(context, some_archs):
if context["architectures"] == some_archs:
return "any"
return ", ".join(sorted(some_archs))
def collect_depstate(conn, source):
version = None
depstate = None
query = sqlalchemy.text("""
SELECT version, architecture, satisfiable, reason
FROM depstate WHERE source = :source;""")
for row in conn.execute(query, source=source):
if version is None or version_compare(version, row.version) > 0:
version = row.version
depstate = {}
depstate[row.architecture] = None if row.satisfiable else row.reason
if version is None:
raise werkzeug.exceptions.NotFound()
depresult = {}
for arch, reason in depstate.items():
depresult.setdefault(reason, set()).add(arch)
return version, depresult
@app.route("/")
def show_index():
with db.engine.connect() as conn:
builds = list(conn.execute("""
SELECT source, version, architecture, starttime, filename,
ifnull((SELECT max(patched + 1) FROM bugs
WHERE affects = source),
0) AS buglvl
FROM builds
WHERE success = 0
ORDER BY starttime
DESC LIMIT 10;"""))
return flask.render_template_string(index_template, builds=builds)
@app.route("/src/")
def show_source(source):
context = dict(sourcepackage=source)
with db.engine.connect() as conn:
query = sqlalchemy.text("SELECT architecture FROM depcheck;")
context["architectures"] = set(row[0] for row in conn.execute(query))
context["version"], context["depresult"] = collect_depstate(conn,
source)
query = sqlalchemy.text("""
SELECT version, architecture, success, starttime, filename
FROM builds WHERE source = :source;""")
context["builds"] = list(conn.execute(query, source=source))
query = sqlalchemy.text("""
SELECT bugnum, kind, title, package, patched, affects
FROM bugs WHERE affects = :affects;""")
context["bugs"] = {}
for bug in conn.execute(query, affects=source):
context["bugs"].setdefault(bug.kind, []).append(bug)
context["show_bootstrapdn"] = \
any(reason and not reason.startswith("skew ")
for reason in context["depresult"].keys())
context["show_debcheck"] = \
any(context["depresult"].keys())
return flask.render_template_string(src_template, **context)
@app.route("/build/")
def show_log(filename):
if filename.endswith(".xz"):
return flask.send_from_directory("logs", filename,
mimetype="application/octet-stream")
filename = flask.safe_join("logs", filename + ".xz")
try:
return flask.send_file(lzma.open(filename, "rb"),
mimetype="text/plain")
except FileNotFoundError:
raise werkzeug.exceptions.NotFound()
@app.route("/schedule", methods=["POST"])
def request_schedule():
source = flask.request.form["source"]
architecture = flask.request.form["architecture"]
with db.engine.connect() as conn:
query = sqlalchemy.text("""
SELECT 1 FROM depstate WHERE source = :source;""")
if not conn.execute(query, source=source).first():
raise werkzeug.exceptions.BadRequest()
if architecture == "any":
architecture = None
else:
query = sqlalchemy.text("""
SELECT 1 FROM depcheck WHERE architecture = :architecture;""")
if not conn.execute(query, architecture=architecture).first():
raise werkzeug.exceptions.BadRequest()
query = sqlalchemy.text("""
INSERT INTO buildrequests (source, architecture, requesttime)
VALUES (:source, :architecture, datetime('now'));""")
conn.execute(query, source=source, architecture=architecture)
return flask.render_template_string(schedule_template)