diff options
author | Holger Levsen <holger@layer-acht.org> | 2014-10-05 02:15:09 +0200 |
---|---|---|
committer | Holger Levsen <holger@layer-acht.org> | 2014-10-05 02:15:09 +0200 |
commit | ff0d8d849527bec10a37bac361cc7b5d3e31ac47 (patch) | |
tree | fb99676c00409463ec37964b374ecf515a1c9675 /bin/reproducible_setup.sh | |
parent | 2d2f11d5f675244a688770e1312045839636b75f (diff) | |
download | jenkins.debian.net-ff0d8d849527bec10a37bac361cc7b5d3e31ac47.tar.xz |
reproducible: move db creation to _setup.sh
Diffstat (limited to 'bin/reproducible_setup.sh')
-rwxr-xr-x | bin/reproducible_setup.sh | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/bin/reproducible_setup.sh b/bin/reproducible_setup.sh index 1a55f28e..1e15d21f 100755 --- a/bin/reproducible_setup.sh +++ b/bin/reproducible_setup.sh @@ -6,6 +6,38 @@ . /srv/jenkins/bin/common-functions.sh common_init "$@" +# create sqlite db +PACKAGES_DB=/var/lib/jenkins/reproducible.db +if [ ! -f ${PACKAGES_DB} ] ; then + sqlite3 ${PACKAGES_DB} ' + CREATE TABLE source_packages + (name TEXT NOT NULL, + version TEXT NOT NULL, + status TEXT NOT NULL + CHECK (status IN ("FTBFS","reproducible","unreproducible","404", "not for us")), + build_date TEXT NOT NULL, + diffp_path TEXT, + PRIMARY KEY (name))' + sqlite3 ${PACKAGES_DB} ' + CREATE TABLE source_stats + (suite TEXT NOT NULL, + amount INTEGER NOT NULL, + PRIMARY KEY (suite))' + sqlite3 ${PACKAGES_DB} ' + CREATE TABLE job_sources + (name TEXT NOT NULL, + job TEXT NOT NULL)' + sqlite3 ${PACKAGES_DB} ' + CREATE TABLE sources + (name TEXT NOT NULL, + version TEXT NOT NULL)' +fi +# 30 seconds timeout when trying to get a lock +INIT=/var/lib/jenkins/reproducible.init +cat >/var/lib/jenkins/reproducible.init <<-EOF +.timeout 30000 +EOF + TMPFILE=$(mktemp) cat > ${TMPFILE} <<- EOF echo "-----BEGIN PGP PUBLIC KEY BLOCK----- |