X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Finc%2Fpervasive.sh;h=063dfd92a318823add8d54ff1835638f1fc63896;hb=4b1d057bb79ea3f9e13a959f79f7d032e1ce4b85;hp=b3467070d1b68d09c5eb2d14a1673da0878c84b6;hpb=34465ab035104f739a54ec62660f04f874448627;p=platal.git

diff --git a/upgrade/inc/pervasive.sh b/upgrade/inc/pervasive.sh
index b346707..063dfd9 100755
--- a/upgrade/inc/pervasive.sh
+++ b/upgrade/inc/pervasive.sh
@@ -1,11 +1,11 @@
 #!/bin/bash
 
-MYSQL='mysql -u admin '
+MYSQL='mysql -u admin --default-character-set=utf8 '
 
 
 set -e
 
-if [ "$UID" != 0 ]; then
+if [ "$UID" != 0 ] && [ "$1" != "-u" ] ; then
     echo "has to be run as root"
     exit 1
 fi
@@ -22,25 +22,104 @@ function die() {
     exit 1
 }
 
-function mysql_run() {
+function confirm() {
+    if [[ -n "${NO_CONFIRM}" ]]; then
+        echo "$1"
+        echo "* press ^C to cancel, waiting 5 seconds..."
+        sleep 5
+    else
+        echo "$1"
+        echo "* press ^D to start import (^C to cancel)"
+        cat
+    fi
+}
+
+function mysql_pipe() {
     sed -e "s/#\([0-9a-z]*\)#/${DBPREFIX}\1/g" | $MYSQL $DATABASE
 }
 
+function mysql_exec() {
+    echo -n " * executing $1 "
+    if [[ -z "${DRY_RUN}" ]]; then
+        (echo "$1" | mysql_pipe) || die "ERROR"
+    fi
+    echo "OK"
+}
+
+function mysql_pipe_nodb() {
+    sed -e "s/#\([0-9a-z]*\)#/${DBPREFIX}\1/g" | $MYSQL
+}
+
+function mysql_exec_nodb() {
+    echo -n " * executing $1 "
+    if [[ -z "${DRY_RUN}" ]]; then
+        (echo "$1" | mysql_pipe_nodb) || die "ERROR"
+    fi
+    echo "OK"
+}
+
+function mysql_run() {
+    echo -n " * running $1 "
+    if [[ -z "${DRY_RUN}" ]]; then
+        (cat "$1" | mysql_pipe) || die "ERROR"
+    fi
+    echo "OK"
+}
+
+function create_db() {
+    echo "* create database "
+    mysql_exec_nodb "CREATE DATABASE IF NOT EXISTS $DATABASE;"
+    mysql_exec_nodb "GRANT ALTER, CREATE, CREATE TEMPORARY TABLES, DELETE, DROP, EXECUTE, INDEX, INSERT, LOCK TABLES, SELECT, UPDATE ON $DATABASE.* TO 'web'@'localhost';"
+    mysql_exec_nodb "FLUSH PRIVILEGES;"
+    echo "OK"
+}
+
+function copy_db() {
+    if [[ -n "$SOURCE_DATABASE" ]]; then
+        confirm "* copying database from $SOURCE_DATABASE to $DATABASE"
+        create_db
+        echo -n "* build database from dump "
+        ( mysqldump --add-drop-table -Q $SOURCE_DATABASE | $MYSQL $DATABASE ) \
+            || die "ERROR"
+        echo "OK"
+    fi
+}
+
+function mysql_run_directory() {
+    for sql in $1/*.sql ; do
+        mysql_run $sql
+    done
+}
+
+function script_run() {
+    echo -n " * running $1 "
+    if [[ -z "${DRY_RUN}" ]]; then
+        $1 || die "ERROR"
+    fi
+    echo "OK"
+}
+
 function mailman_stop() {
-    echo -n "stops mailman"
-    /etc/init.d/mailman stop &>/dev/null
+    echo -n " * stops mailman"
+    if [[ -z "${DRY_RUN}" ]]; then
+        /etc/init.d/mailman stop &>/dev/null
+    fi
     echo .
 }
 
 function mailman_templates() {
-    echo -n "copies new mails templates"
-    mkdir -p /etc/mailman/xorg
-    cp -f ../../modules/lists/mail_templates/*.txt /etc/mailman/xorg
+    echo -n " * copies new mails templates"
+    if [[ -z "${DRY_RUN}" ]]; then
+        mkdir -p /etc/mailman/xorg
+        cp -f ../../modules/lists/mail_templates/*.txt /etc/mailman/xorg
+    fi
     echo .
 }
 
 function mailman_start() {
-    echo -n "starts mailman"
-    /etc/init.d/mailman start &>/dev/null
+    echo -n " * starts mailman"
+    if [[ -z "${DRY_RUN}" ]]; then
+        /etc/init.d/mailman start &>/dev/null
+    fi
     echo .
 }