From bc4e624732bd51c0dd1e9529cf228e8c23127732 Mon Sep 17 00:00:00 2001
From: Daniel Baumann <daniel.baumann@progress-linux.org>
Date: Sat, 13 Apr 2024 13:40:59 +0200
Subject: Adding upstream version 1.1.1.

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 tools/dev_update_schema.sh | 31 +++++++++++++++++++++++++++++++
 1 file changed, 31 insertions(+)
 create mode 100755 tools/dev_update_schema.sh

(limited to 'tools/dev_update_schema.sh')

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