From 44ba4fd7fe97ac9d138befd94d831e62db340619 Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Fri, 22 May 2015 15:05:21 +0200 Subject: reproducible: display average test duration and oldest build for all suites combined --- bin/reproducible_html_graphs.sh | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/bin/reproducible_html_graphs.sh b/bin/reproducible_html_graphs.sh index effb92d5..c3539e31 100755 --- a/bin/reproducible_html_graphs.sh +++ b/bin/reproducible_html_graphs.sh @@ -563,12 +563,12 @@ create_main_stats_page() { write_page "committers to notes.git in total$(cd ${NOTES_GIT_PATH} ; git log |grep Author|sort -u |wc -l)" write_page "committers to notes.git in the last three months$(cd ${NOTES_GIT_PATH} ; git log --since="3 months ago"|grep Author|sort -u |wc -l)" fi - RESULT=$(sqlite3 -init ${INIT} -csv ${PACKAGES_DB} "SELECT CAST(max(oldest_reproducible, oldest_unreproducible, oldest_FTBFS) AS INTEGER) FROM ${TABLE[2]} WHERE suite='${SUITE}' AND datum='$DATE'") - write_page "oldest build result in $SUITE$RESULT days" - RESULT=$(sqlite3 -init ${INIT} -csv ${PACKAGES_DB} "SELECT CAST(AVG(r.build_duration) AS INTEGER) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='${SUITE}' AND r.build_duration!='' AND r.build_duration!='0'") + RESULT=$(sqlite3 -init ${INIT} -csv ${PACKAGES_DB} "SELECT CAST(max(oldest_reproducible, oldest_unreproducible, oldest_FTBFS) AS INTEGER) FROM ${TABLE[2]} WHERE datum='$DATE'") + write_page "oldest build result in all suites$RESULT days" + RESULT=$(sqlite3 -init ${INIT} -csv ${PACKAGES_DB} "SELECT CAST(AVG(r.build_duration) AS INTEGER) FROM results AS r WHERE r.build_duration!='' AND r.build_duration!='0'") MIN=$(echo $RESULT/60|bc) SEC=$(echo "$RESULT-($MIN*60)"|bc) - write_page "average test duration in $SUITE$MIN minutes, $SEC seconds" + write_page "average test duration in all suites$MIN minutes, $SEC seconds" write_page "" # other graphs write_page "

" -- cgit v1.2.3-70-g09d2