1 files changed, 31 insertions, 0 deletions
diff --git a/tools/dev_update_schema.sh b/tools/dev_update_schema.sh
new file mode 100755
index 0000000..e1d08d6
--- /dev/null
+++ b/tools/dev_update_schema.sh
@@ -0,0 +1,31 @@
+#!/bin/bash
+
+set -e
+set -o pipefail
+
+cd "$(dirname "$0")"
+
+BASEDIR=".."
+
+test "$1" = '-f' || (
+	echo "Run  '$0' -f  to DROP ALL ICINGADB TABLES and re-create them using the current schema"
+	false
+)
+
+set -x
+
+(
+	mysql -uroot -e 'SHOW TABLES\G' icingadb </dev/null |\
+	( grep -Ee '^Tables_in_icingadb: ' || true ) |\
+	cut -d ' ' -f 2 |\
+	perl -pe 's/^(.*?)$/DROP TABLE $1;/'
+
+	mysql -uroot -e 'SHOW PROCEDURE STATUS\G' icingadb </dev/null |\
+	( grep -Ee '^ *Name: ' || true ) |\
+	cut -d ':' -f 2 |\
+	perl -pe 's/^ *(.*?)$/DROP PROCEDURE IF EXISTS $1;/'
+
+	cat $BASEDIR/etc/schema/mysql/{,helper/}*.sql
+
+	echo "GRANT ALL ON icingadb.* TO 'icingadb'@'127.0.0.1' IDENTIFIED BY 'icingadb';"
+) |mysql -uroot icingadb