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)

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