localserver: Add updatedb script

1 files changed, 24 insertions, 0 deletions

diff --git a/localserver/updatedb.sh b/localserver/updatedb.sh
new file mode 100755
index 0000000..1d641c2
--- /dev/null
+++ b/localserver/updatedb.sh
@@ -0,0 +1,24 @@
+#!/bin/bash
+
+export VER=$(cat versions/sqlver 2>/dev/null)
+export SQLDIR="../../server-data/sql-files/"
+export CMD="mysql -u evol -pevol evol"
+
+function run {
+    echo "Running $1"
+#    $CMD <$1
+}
+
+if [[ -z "${VER}" ]]; then
+    export VER="1"
+fi
+
+if [ "${VER}" -lt "2" ]; then
+    run "2015-07-02--18-14.sql"
+    run "2015-07-08--13-08.sql"
+    run "2015-08-27--20-42.sql"
+fi
+
+if [ "${VER}" -lt "2" ]; then
+    echo "2" >versions/sqlver
+fi