From 2a32c1c2affcddbb3b3bb65248d806775fb40363 Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Tue, 3 Mar 2015 01:21:23 +0100 Subject: reproducible: start to populate the stats_builds table, to gather stats about all the builds --- bin/reproducible_build.sh | 3 +++ 1 file changed, 3 insertions(+) diff --git a/bin/reproducible_build.sh b/bin/reproducible_build.sh index 7dfe1258..b99c7ec6 100755 --- a/bin/reproducible_build.sh +++ b/bin/reproducible_build.sh @@ -92,6 +92,7 @@ call_debbindiff() { echo "${SRCPACKAGE} built successfully and reproducibly." | tee -a ${RBUILDLOG} calculate_build_duration sqlite3 -init $INIT ${PACKAGES_DB} "REPLACE INTO results (package_id, version, status, build_date, build_duration) VALUES ('${SRCPKGID}', '${VERSION}', 'reproducible', '$DATE', '$DURATION')" + sqlite3 -init $INIT ${PACKAGES_DB} "INSERT INTO stats_builds (name, version, suite, architecture, status, build_date, build_duration) VALUES ('${SRCPACKAGE}', '${VERSION}', '${SUITE}', '${ARCH}', 'reproducible', '${DATE}', '${DURATION}')" update_db_and_html else echo | tee -a ${RBUILDLOG} @@ -116,6 +117,7 @@ call_debbindiff() { fi calculate_build_duration sqlite3 -init $INIT ${PACKAGES_DB} "REPLACE INTO results (package_id, version, status, build_date, build_duration) VALUES ('${SRCPKGID}', '${VERSION}', 'unreproducible', '$DATE', '$DURATION')" + sqlite3 -init $INIT ${PACKAGES_DB} "INSERT INTO stats_builds (name, version, suite, architecture, status, build_date, build_duration) VALUES ('${SRCPACKAGE}', '${VERSION}', '${SUITE}', '${ARCH}', 'unreproducible', '${DATE}', '${DURATION}')" update_db_and_html fi } @@ -264,6 +266,7 @@ else echo "${SRCPACKAGE} failed to build from source." calculate_build_duration sqlite3 -init $INIT ${PACKAGES_DB} "REPLACE INTO results (package_id, version, status, build_date, build_duration) VALUES ('${SRCPKGID}', '${VERSION}', 'FTBFS', '$DATE', '$DURATION')" + sqlite3 -init $INIT ${PACKAGES_DB} "INSERT INTO stats_builds (name, version, suite, architecture, status, build_date, build_duration) VALUES ('${SRCPACKAGE}', '${VERSION}', '${SUITE}', '${ARCH}', 'FTBFS', '${DATE}', '${DURATION}')" update_db_and_html fi fi -- cgit v1.2.3-70-g09d2