diff options
| author | Holger Levsen <holger@layer-acht.org> | 2014-10-05 03:32:18 +0200 |
|---|---|---|
| committer | Holger Levsen <holger@layer-acht.org> | 2014-10-05 05:06:12 +0200 |
| commit | 31e2a7f9b689f8e726e9076651129c21e315d2d8 (patch) | |
| tree | 0166855cff409efda4f70a0188f76eb383e677bd /bin | |
| parent | 2aec168d4a1c0234df1bbefeb57176171d2800ea (diff) | |
| download | jenkins.debian.net-31e2a7f9b689f8e726e9076651129c21e315d2d8.tar.xz | |
reproducible: drop job_sources table and code
Diffstat (limited to 'bin')
| -rwxr-xr-x | bin/reproducible_build.sh | 15 | ||||
| -rwxr-xr-x | bin/reproducible_setup.sh | 4 |
2 files changed, 1 insertions, 18 deletions
diff --git a/bin/reproducible_build.sh b/bin/reproducible_build.sh index 21ddaf1c..691e43ea 100755 --- a/bin/reproducible_build.sh +++ b/bin/reproducible_build.sh @@ -44,12 +44,6 @@ if [[ $1 =~ ^-?[0-9]+$ ]] ; then fi done AMOUNT=$REAL_AMOUNT - for PKG in $PACKAGES ; do - RESULT=$(sqlite3 ${PACKAGES_DB} "SELECT name FROM job_sources WHERE ( name = '${PKG}' AND job = 'random' )") - if [ "$RESULT" = "" ] ; then - sqlite3 -init $INIT ${PACKAGES_DB} "REPLACE INTO job_sources VALUES ('$PKG','random')" - fi - done else # this is kind of a hack: if $1 is 0, then schedule 33 failed packages which were randomly picked and where a new version is available CSVFILE=$(mktemp) @@ -58,7 +52,7 @@ if [[ $1 =~ ^-?[0-9]+$ ]] ; then echo ".import $CSVFILE sources" | sqlite3 -csv -init $INIT ${PACKAGES_DB} rm $CSVFILE AMOUNT=33 - PACKAGES=$(sqlite3 -init $INIT ${PACKAGES_DB} "SELECT DISTINCT source_packages.name FROM source_packages,sources,job_sources WHERE sources.version IN (SELECT version FROM sources WHERE name=source_packages.name ORDER by sources.version DESC LIMIT 1) AND (( source_packages.status = 'unreproducible' OR source_packages.status = 'FTBFS') AND source_packages.name = job_sources.name AND source_packages.name = sources.name AND job_sources.job = 'random' AND source_packages.version < sources.version) ORDER BY source_packages.build_date LIMIT $AMOUNT" | xargs -r echo) + PACKAGES=$(sqlite3 -init $INIT ${PACKAGES_DB} "SELECT DISTINCT source_packages.name FROM source_packages,sources WHERE sources.version IN (SELECT version FROM sources WHERE name=source_packages.name ORDER by sources.version DESC LIMIT 1) AND (( source_packages.status = 'unreproducible' OR source_packages.status = 'FTBFS') AND source_packages.name = sources.name AND source_packages.version < sources.version) ORDER BY source_packages.build_date LIMIT $AMOUNT" | xargs -r echo) echo "Info: Only unreproducible and FTBFS packages with a new version available are selected from this job." AMOUNT=0 for PKG in $PACKAGES ; do @@ -72,13 +66,6 @@ if [[ $1 =~ ^-?[0-9]+$ ]] ; then else PACKAGES="$@" AMOUNT="${#@}" - JOB=$(echo $JOB_NAME|cut -d "_" -f3-) - for PKG in $PACKAGES ; do - RESULT=$(sqlite3 ${PACKAGES_DB} "SELECT name FROM job_sources WHERE ( name = '${PKG}' AND job = '$JOB' )") - if [ "$RESULT" = "" ] ; then - sqlite3 -init $INIT ${PACKAGES_DB} "REPLACE INTO job_sources VALUES ('$PKG','$JOB')" - fi - done fi echo "=============================================================================" echo "The following source packages will be build: ${PACKAGES}" diff --git a/bin/reproducible_setup.sh b/bin/reproducible_setup.sh index 0be8089b..70c02fe7 100755 --- a/bin/reproducible_setup.sh +++ b/bin/reproducible_setup.sh @@ -23,10 +23,6 @@ if [ ! -f ${PACKAGES_DB} ] ; then 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)' |