diff options
| author | Mattia Rizzolo <mattia@debian.org> | 2015-12-09 23:10:52 +0000 |
|---|---|---|
| committer | Holger Levsen <holger@layer-acht.org> | 2015-12-10 00:18:37 +0100 |
| commit | 35ad1767a81d20422c2e8c52f0fa144a71f03981 (patch) | |
| tree | b00d8f2ba37c5745e11c79dfb840798fe3aed431 /bin | |
| parent | e83a85b678693a3950107c192105620b2fac7bf4 (diff) | |
| download | jenkins.debian.net-35ad1767a81d20422c2e8c52f0fa144a71f03981.tar.xz | |
reproducible: build/live_status: check whether sch.date_build_started is NULL instead of ''
Diffstat (limited to 'bin')
| -rwxr-xr-x | bin/reproducible_build.sh | 2 | ||||
| -rwxr-xr-x | bin/reproducible_html_live_status.py | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/bin/reproducible_build.sh b/bin/reproducible_build.sh index 83326c35..0c51a6e8 100755 --- a/bin/reproducible_build.sh +++ b/bin/reproducible_build.sh @@ -403,7 +403,7 @@ choose_package() { local RESULT=$(sqlite3 -init $INIT ${PACKAGES_DB} " SELECT s.suite, s.id, s.name, sch.date_scheduled, sch.save_artifacts, sch.notify, s.notify_maintainer, sch.message FROM schedule AS sch JOIN sources AS s ON sch.package_id=s.id - WHERE sch.date_build_started='' + WHERE sch.date_build_started is NULL AND s.architecture='$ARCH' ORDER BY date_scheduled LIMIT 5"|sort -R|head -1) if [ -z "$RESULT" ] ; then diff --git a/bin/reproducible_html_live_status.py b/bin/reproducible_html_live_status.py index 00eb8e26..b9ac6819 100755 --- a/bin/reproducible_html_live_status.py +++ b/bin/reproducible_html_live_status.py @@ -53,7 +53,7 @@ def generate_live_status_table(arch): '(SELECT coalesce(AVG(h.build_duration), 0) FROM stats_build AS h WHERE h.status IN ("reproducible", "unreproducible") AND h.name=s.name AND h.suite=s.suite AND h.architecture=s.architecture) ' + \ ', p.job ' + \ 'FROM sources AS s JOIN schedule AS p ON p.package_id=s.id LEFT JOIN results AS r ON s.id=r.package_id ' + \ - 'WHERE p.date_build_started != "" AND s.architecture="{arch}" ' + \ + 'WHERE p.date_build_started IS NOT NULL AND s.architecture="{arch}" ' + \ 'ORDER BY p.date_build_started DESC' html = '' rows = query_db(query.format(arch=arch)) |