Add mysql_exec_nodb and mysql_pipe_nodb to pervasive.sh.

[platal.git] / upgrade / inc / pervasive.sh

#!/bin/bash

MYSQL='mysql -u admin '


set -e

if [ "$UID" != 0 ] && [ "$1" != "-u" ] ; then
    echo "has to be run as root"
    exit 1
fi

if [[ -n "${DBPREFIX}" ]]; then
    echo "Using non-default database ${DBPREFIX}x4dat."
fi
if [[ -z "${DATABASE}" ]]; then
  DATABASE="${DBPREFIX}x4dat"
fi

function die() {
    echo $1
    exit 1
}

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 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"
    if [[ -z "${DRY_RUN}" ]]; then
        /etc/init.d/mailman stop &>/dev/null
    fi
    echo .
}

function mailman_templates() {
    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"
    if [[ -z "${DRY_RUN}" ]]; then
        /etc/init.d/mailman start &>/dev/null
    fi
    echo .
}