From 574c0147442cc2e880656056aeeacbc89bdef36e Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Tue, 24 Feb 2015 09:20:14 +0100 Subject: reproducible: html_dd_list: update to a new database schema supporting multiple suites. Consider only sid to retrive relevant data --- bin/reproducible_html_dd_list.sh | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'bin/reproducible_html_dd_list.sh') 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 "

The following maintainers and uploaders are listed for packages which have built unreproducibly:

"
+write_page "
The following maintainers and uploaders are listed for packages within Sid which have built unreproducibly:
"
 while IFS= read -r LINE ; do
 	if [ "${LINE:0:3}" = "   " ] ; then
 		PACKAGE=$(echo "${LINE:3}" | cut -d " " -f1)
-- 
cgit v1.2.3-54-g00ecf