From 623f060957af62e176f5a66aa66d8f0d519c7372 Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Tue, 3 Mar 2015 11:05:10 +0100 Subject: Revert "Revert "reproducible: start to populate the stats_builds table, to gather stats about all the builds"", let's actually fix this This reverts commit 5e5b7d8e65a2c71e6b925b53cc179cd3e8ba2478. --- 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