diff options
| author | Holger Levsen <holger@layer-acht.org> | 2014-09-28 02:03:09 +0200 |
|---|---|---|
| committer | Holger Levsen <holger@layer-acht.org> | 2014-09-28 02:03:09 +0200 |
| commit | 2c4c1b8a04b2e18cbde1af33431afef04cc27664 (patch) | |
| tree | 32e57569be1a877917b256b4cbadfa8b95bfe5fb | |
| parent | c667209b14dec78f2dcf59052bed6cab39d84e57 (diff) | |
| download | jenkins.debian.net-2c4c1b8a04b2e18cbde1af33431afef04cc27664.tar.xz | |
reproducible: extend db schema, add date and diffp_path
| -rwxr-xr-x | bin/reproducible_build.sh | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/bin/reproducible_build.sh b/bin/reproducible_build.sh index 32e68a75..c54afed6 100755 --- a/bin/reproducible_build.sh +++ b/bin/reproducible_build.sh @@ -24,6 +24,8 @@ if [ ! -f $PACKAGES_DB ] ; then version TEXT NOT NULL, status TEXT NOT NULL CHECK (status IN ("FTBFS","reproducible","unreproducible","404")), + date TEXT NOT NULL, + diffp_path TEXT, PRIMARY KEY (name))' fi @@ -61,12 +63,13 @@ for SRCPACKAGE in $PACKAGES ; do let "COUNT_TOTAL=COUNT_TOTAL+1" rm b1 b2 -rf set +e + DATE=(date +'%Y-%m-%d %H:%M') apt-get source --download-only ${SRCPACKAGE} RESULT=$? if [ $RESULT != 0 ] ; then SOURCELESS="${SOURCELESS} ${SRCPACKAGE}" echo "Warning: ${SRCPACKAGE} is not a source package, or was removed or renamed. Please investigate." - sqlite3 $PACKAGES_DB "REPLACE INTO source_packages VALUES (\"${SRCPACKAGE}\", \"none available\", \"404\")" + sqlite3 $PACKAGES_DB "REPLACE INTO source_packages VALUES (\"${SRCPACKAGE}\", \"none available\", \"404\", \'$DATE\', \'\')" else VERSION=$(grep ^Version ${SRCPACKAGE}_*.dsc | cut -d " " -f2 | head -1) STATUS=$(sqlite3 $PACKAGES_DB "SELECT status FROM source_packages WHERE name = \"${SRCPACKAGE}\" AND version = \"${VERSION}\"") @@ -97,20 +100,20 @@ for SRCPACKAGE in $PACKAGES ; do figlet ${SRCPACKAGE} echo echo "${SRCPACKAGE} built successfully and reproducibly." - sqlite3 $PACKAGES_DB "REPLACE INTO source_packages VALUES (\"${SRCPACKAGE}\", \"${VERSION}\", \"reproducible\")" + sqlite3 $PACKAGES_DB "REPLACE INTO source_packages VALUES (\"${SRCPACKAGE}\", \"${VERSION}\", \"reproducible\", \'$DATE\', \'\')" let "COUNT_GOOD=COUNT_GOOD+1" GOOD="${SRCPACKAGE} ${GOOD}" touch results/___.dummy.log # not having any bad logs is not a reason for failure else echo "Warning: ${SRCPACKAGE} failed to build reproducibly." - sqlite3 $PACKAGES_DB "REPLACE INTO source_packages VALUES (\"${SRCPACKAGE}\", \"${VERSION}\", \"unreproducible\")" + sqlite3 $PACKAGES_DB "REPLACE INTO source_packages VALUES (\"${SRCPACKAGE}\", \"${VERSION}\", \"unreproducible\", \'$DATE\', \'\')" let "COUNT_BAD=COUNT_BAD+1" BAD="${SRCPACKAGE} ${BAD}" rm -f results/dummy.log 2>/dev/null # just cleanup fi rm b1 b2 -rf else - sqlite3 $PACKAGES_DB "REPLACE INTO source_packages VALUES (\"${SRCPACKAGE}\", \"${VERSION}\", \"FTBFS\")" + sqlite3 $PACKAGES_DB "REPLACE INTO source_packages VALUES (\"${SRCPACKAGE}\", \"${VERSION}\", \"FTBFS\", \'$DATE\', \'\')" fi dcmd rm ${SRCPACKAGE}_*.dsc |