From 8633c9e784489e23012866086ecc4cff30b45190 Mon Sep 17 00:00:00 2001
From: Mattia Rizzolo <mattia@mapreri.org>
Date: Wed, 18 Feb 2015 02:46:02 +0100
Subject: 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)

---
 bin/reproducible_common.sh | 98 +---------------------------------------------
 1 file changed, 1 insertion(+), 97 deletions(-)

(limited to 'bin/reproducible_common.sh')

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
-- 
cgit v1.2.3-70-g09d2