diff options
| author | Mattia Rizzolo <mattia@mapreri.org> | 2015-02-24 09:20:14 +0100 |
|---|---|---|
| committer | Holger Levsen <holger@layer-acht.org> | 2015-02-26 17:13:54 +0100 |
| commit | 574c0147442cc2e880656056aeeacbc89bdef36e (patch) | |
| tree | 710f1b0ab6feb556a24b710e5084c76469b6a9a7 | |
| parent | c81776ed4895b4323fae025dd6df6a5daf2eaec1 (diff) | |
| download | jenkins.debian.net-574c0147442cc2e880656056aeeacbc89bdef36e.tar.xz | |
reproducible: html_dd_list: update to a new database schema supporting multiple suites. Consider only sid to retrive relevant data
| -rwxr-xr-x | bin/reproducible_html_dd_list.sh | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/bin/reproducible_html_dd_list.sh b/bin/reproducible_html_dd_list.sh index 5e37e519..9084d204 100755 --- a/bin/reproducible_html_dd_list.sh +++ b/bin/reproducible_html_dd_list.sh @@ -18,9 +18,9 @@ PAGE=index_${VIEW}.html echo "$(date) - starting to write $PAGE page." write_page_header $VIEW "Overview of ${SPOKENTARGET[$VIEW]}" TMPFILE=$(mktemp) -BAD=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"unreproducible\" ORDER BY build_date DESC" | xargs echo) +BAD=$(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="unreproducible" AND s.suite="sid" ORDER BY r.build_date DESC' | xargs echo) echo "${BAD}" | dd-list -i > $TMPFILE || true -write_page "<p>The following maintainers and uploaders are listed for packages which have built unreproducibly:</p><p><pre>" +write_page "<p>The following maintainers and uploaders are listed for packages within Sid which have built unreproducibly:</p><p><pre>" while IFS= read -r LINE ; do if [ "${LINE:0:3}" = " " ] ; then PACKAGE=$(echo "${LINE:3}" | cut -d " " -f1) |