diff options
| author | Holger Levsen <holger@layer-acht.org> | 2015-07-23 13:27:26 +0200 |
|---|---|---|
| committer | Holger Levsen <holger@layer-acht.org> | 2015-07-23 13:27:26 +0200 |
| commit | 91676c9e5d18c4b0cbf75c73e359297e99c22fee (patch) | |
| tree | bffa65c60fe7d45c77acd0d9b8171f426f129498 /bin | |
| parent | 514631f29901aa8bb6e3f12d4bfa746c9b1d360b (diff) | |
| download | jenkins.debian.net-91676c9e5d18c4b0cbf75c73e359297e99c22fee.tar.xz | |
reproducible: fixup 514631f2, also count packages with notes without (categorized) issues
Diffstat (limited to 'bin')
| -rwxr-xr-x | bin/reproducible_html_dashboards.sh | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/bin/reproducible_html_dashboards.sh b/bin/reproducible_html_dashboards.sh index 1677616e..5dc79ab5 100755 --- a/bin/reproducible_html_dashboards.sh +++ b/bin/reproducible_html_dashboards.sh @@ -117,12 +117,14 @@ update_suite_stats() { # update notes stats # update_notes_stats() { - NOTES=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT COUNT(package_id) FROM notes AS n JOIN sources AS s ON n.package_id=s.id WHERE s.suite=\"unstable\" AND n.issues != \"[]\"") + NOTES=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT COUNT(package_id) FROM notes AS n JOIN sources AS s ON n.package_id=s.id WHERE s.suite=\"unstable\"") ISSUES=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT COUNT(name) FROM issues") # the following is a hack to workaround the bad sql db design which is the issue_s_ column in the notes table... # it assumes we don't have packages with more than 7 issues. (we have one with 6...) COUNT_ISSUES=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT \ - (SELECT COUNT(issues) FROM notes AS n JOIN sources AS s ON n.package_id=s.id WHERE s.suite=\"unstable\" AND n.issues != \"[]\") \ + (SELECT COUNT(issues) FROM notes AS n JOIN sources AS s ON n.package_id=s.id WHERE s.suite=\"unstable\" AND n.issues = \"[]\") \ + + \ + (SELECT COUNT(issues) FROM notes AS n JOIN sources AS s ON n.package_id=s.id WHERE s.suite=\"unstable\" AND n.issues != \"[]\" AND n.issues NOT LIKE \"%,%\") \ + \ (SELECT COUNT(issues) FROM notes AS n JOIN sources AS s ON n.package_id=s.id WHERE s.suite=\"unstable\" AND n.issues LIKE \"%,%\") \ + \ |