From d0f4f64a6f946d56a5a7304eb07edda66e725b4b Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Thu, 8 Oct 2020 22:28:09 +0200
Subject: Database dump pull script (S3 -> MySQL)

---
 dumps/load-dumps.sh | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100755 dumps/load-dumps.sh

(limited to 'dumps/load-dumps.sh')

diff --git a/dumps/load-dumps.sh b/dumps/load-dumps.sh
new file mode 100755
index 0000000..7695a40
--- /dev/null
+++ b/dumps/load-dumps.sh
@@ -0,0 +1,17 @@
+#!/bin/bash
+pushd $(dirname $0) >> /dev/null
+cat .mapping | while read DB DUMP
+do
+    grep -v 'CREATE DATABASE' $DUMP | grep -vi '^Use ' | mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DB
+    if [ "$DB" != "dmp202021_e" ]
+    then
+        <logoh.sql mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DB
+    else
+        <logoh.en.sql mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DB
+    fi
+    cat .queries | while read -r QUERY
+    do
+        mysql ${LIGA_MYSQL_CONNECTION_OPTS} -N -e "$QUERY" $DB
+    done
+done
+popd >> /dev/null
-- 
cgit v1.2.3