summaryrefslogtreecommitdiffstats
path: root/bin/reproducible_blacklist.sh
diff options
context:
space:
mode:
Diffstat (limited to 'bin/reproducible_blacklist.sh')
-rwxr-xr-xbin/reproducible_blacklist.sh7
1 files changed, 6 insertions, 1 deletions
diff --git a/bin/reproducible_blacklist.sh b/bin/reproducible_blacklist.sh
index bbd9b7fc..5e94e962 100755
--- a/bin/reproducible_blacklist.sh
+++ b/bin/reproducible_blacklist.sh
@@ -17,7 +17,12 @@ blacklist_packages() {
VERSION=$(query_db "SELECT version FROM sources WHERE name='$PKG' AND suite='$SUITE' AND architecture='$ARCH';")
PKGID=$(query_db "SELECT id FROM sources WHERE name='$PKG' AND suite='$SUITE' AND architecture='$ARCH';")
cleanup_pkg_files
- query_db "REPLACE INTO results (package_id, version, status, build_date, job) VALUES ('$PKGID', '$VERSION', 'blacklisted', '$DATE', '');"
+ RESULTID=$(query_db "SELECT id FROM results WHERE package_id=$PKGID")
+ if [ ! -z "$RESULTID" ] ; then
+ query_db "UPDATE results set package_id='$PKGID', version='$VERSION', status='blacklisted', build_date='$DATE', job='' WHERE id=$RESULTID;"
+ else
+ query_db "INSERT into results (package_id, version, status, build_date, job) VALUES ('$PKGID', '$VERSION', 'blacklisted', '$DATE', '');"
+ fi
query_db "DELETE FROM schedule WHERE package_id='$PKGID'"
done
}