diff options
author | Mattia Rizzolo <mattia@mapreri.org> | 2015-02-18 02:46:02 +0100 |
---|---|---|
committer | Holger Levsen <holger@layer-acht.org> | 2015-02-26 17:13:54 +0100 |
commit | 8633c9e784489e23012866086ecc4cff30b45190 (patch) | |
tree | ffc8d6e3c6180cc7e6030e1e15898749a5325746 /bin/reproducible_common.sh | |
parent | e9564865df793bd6ad33eee82009472edf59fb22 (diff) | |
download | jenkins.debian.net-8633c9e784489e23012866086ecc4cff30b45190.tar.xz |
reproducible: and finally commit the updated schema. + a new simple script to manage the db schema and handle+track updates (so remove the schema from _common.sh and call this instead)
Diffstat (limited to 'bin/reproducible_common.sh')
-rwxr-xr-x | bin/reproducible_common.sh | 98 |
1 files changed, 1 insertions, 97 deletions
diff --git a/bin/reproducible_common.sh b/bin/reproducible_common.sh index 173c863e..f467cba3 100755 --- a/bin/reproducible_common.sh +++ b/bin/reproducible_common.sh @@ -25,103 +25,7 @@ if [ -f $PACKAGES_DB ] && [ -f $INIT ] ; then fi elif [ ! -f ${PACKAGES_DB} ] ; then echo "Warning: $PACKAGES_DB doesn't exist, creating it now." - echo - # create sqlite db if needed - sqlite3 ${PACKAGES_DB} ' - CREATE TABLE source_packages - (name TEXT NOT NULL, - version TEXT NOT NULL, - status TEXT NOT NULL - CHECK (status IN ("blacklisted", "FTBFS","reproducible","unreproducible","404", "not for us")), - build_date TEXT NOT NULL, - PRIMARY KEY (name))' - sqlite3 ${PACKAGES_DB} ' - CREATE TABLE sources_scheduled - (name TEXT NOT NULL, - date_scheduled TEXT NOT NULL, - date_build_started TEXT NOT NULL, - PRIMARY KEY (name))' - sqlite3 ${PACKAGES_DB} ' - CREATE TABLE sources - (name TEXT NOT NULL, - version TEXT NOT NULL)' - sqlite3 ${PACKAGES_DB} ' - CREATE TABLE stats_pkg_state - (datum TEXT NOT NULL, - suite TEXT NOT NULL, - untested INTEGER, - reproducible INTEGER, - unreproducible INTEGER, - FTBFS INTEGER, - other INTEGER, - PRIMARY KEY (datum))' - sqlite3 ${PACKAGES_DB} ' - CREATE TABLE stats_builds_per_day - (datum TEXT NOT NULL, - suite TEXT NOT NULL, - reproducible INTEGER, - unreproducible INTEGER, - FTBFS INTEGER, - other INTEGER, - PRIMARY KEY (datum))' - sqlite3 ${PACKAGES_DB} ' - CREATE TABLE stats_builds_age - (datum TEXT NOT NULL, - suite TEXT NOT NULL, - oldest_reproducible REAL, - oldest_unreproducible REAL, - oldest_FTBFS REAL, - PRIMARY KEY (datum))' - sqlite3 ${PACKAGES_DB} ' - CREATE TABLE stats_bugs - (datum TEXT NOT NULL, - open_toolchain INTEGER, - done_toolchain INTEGER, - open_infrastructure INTEGER, - done_infrastructure INTEGER, - open_timestamps INTEGER, - done_timestamps INTEGER, - open_fileordering INTEGER, - done_fileordering INTEGER, - open_buildpath INTEGER, - done_buildpath INTEGER, - open_username INTEGER, - done_username INTEGER, - open_hostname INTEGER, - done_hostname INTEGER, - open_uname INTEGER, - done_uname INTEGER, - open_randomness INTEGER, - done_randomness INTEGER, - open_buildinfo INTEGER, - done_buildinfo INTEGER, - open_cpu INTEGER, - done_cpu INTEGER, - open_signatures INTEGER, - done_signatures INTEGER, - open_environment INTEGER, - done_environment INTEGER, - PRIMARY KEY (datum))' - sqlite3 ${PACKAGES_DB} ' - CREATE TABLE stats_notes - (datum TEXT NOT NULL, - packages_with_notes INTEGER, - PRIMARY KEY (datum))' - sqlite3 ${PACKAGES_DB} ' - CREATE TABLE stats_issues - (datum TEXT NOT NULL, - known_issues INTEGER, - PRIMARY KEY (datum))' - sqlite3 ${PACKAGES_DB} ' - CREATE TABLE stats_meta_pkg_state - (datum TEXT NOT NULL, - suite TEXT NOT NULL, - meta_pkg TEXT NOT NULL, - reproducible INTEGER, - unreproducible INTEGER, - FTBFS INTEGER, - other INTEGER, - PRIMARY KEY (datum, suite, meta_pkg))' + /srv/jenkins/bin/reproducible_db_maintenance.py # 60 seconds timeout when trying to get a lock cat > $INIT <<-EOF .timeout 60000 |