diff options
| author | Holger Levsen <holger@layer-acht.org> | 2015-07-19 09:24:13 +0200 |
|---|---|---|
| committer | Holger Levsen <holger@layer-acht.org> | 2015-07-19 09:24:13 +0200 |
| commit | b9bcb8e6899213c47da8be8ffc7add6316d34bd2 (patch) | |
| tree | ea6ef463192d5a1b78d20fa02674960ec28b5601 | |
| parent | 12e6503b04232b32e7a4aed869b54bfde628eb58 (diff) | |
| download | jenkins.debian.net-b9bcb8e6899213c47da8be8ffc7add6316d34bd2.tar.xz | |
know your tables
| -rwxr-xr-x | bin/reproducible_common.sh | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/bin/reproducible_common.sh b/bin/reproducible_common.sh index b37ff514..0f468e3f 100755 --- a/bin/reproducible_common.sh +++ b/bin/reproducible_common.sh @@ -222,7 +222,7 @@ write_page_header() { write_page "<li><a href=\"https://wiki.debian.org/ReproducibleBuilds\" target=\"_blank\">wiki</a></li>" write_page "</ul>" if [ "$1" = "$MAINVIEW" ] ; then - LATEST=$(sqlite3 -init $INIT ${PACKAGES_DB} "SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id = s.id WHERE r.status IN ('unreproducible', 'FTBFS') AND r.suite = 'unstable' AND s.id NOT IN (SELECT package_id FROM notes) ORDER BY build_date DESC LIMIT 1") + LATEST=$(sqlite3 -init $INIT ${PACKAGES_DB} "SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id = s.id WHERE r.status IN ('unreproducible', 'FTBFS') AND s.suite = 'unstable' AND s.id NOT IN (SELECT package_id FROM notes) ORDER BY build_date DESC LIMIT 1") write_page "<form onsubmit=\"location.href='https://reproducible.debian.net/' + document.getElementById('SrcPkg').value; return false;\">" write_page "https://reproducible.debian.net/<input type=\"text\" id=\"SrcPkg\" value=\"$LATEST\"/>" write_page "<input type=\"submit\" value=\"submit source package name\" />" |