# some library functions for phpbb3 maintainer scripts
# copyright 2010 J.M. Roth <jmroth@iip.lu>

run_sql () {
    if [ -f /etc/dbconfig-common/phpbb3.conf ] ; then
        . /etc/dbconfig-common/phpbb3.conf
    else
        echo "$0 $@: run_sql: cannot load db metadata" 1>&2
        return 1
    fi

    local sql="$1"

    ERR=
    case $dbc_dbtype in
        mysql )
            l_dbc_dbserver=${dbc_dbserver:- localhost}
            echo $sql | mysql -h ${l_dbc_dbserver} ${dbc_dbport:+--port $dbc_dbport} -u $dbc_dbuser -p$dbc_dbpass $dbc_dbname -s || run_sql_fail $dbc_dbtype
            ;;
        pgsql )
            if [ -z "${dbc_dbserver}" ]; then
                echo $sql | su - postgres -c "psql ${dbc_dbport:+-p $dbc_dbport} -d \"dbname=$dbc_dbname ${dbc_ssl:+sslmode=require}\" -q" || run_sql_fail $dbc_dbtype
            else
                echo $sql | psql -h $dbc_dbserver ${dbc_dbport:+-p $dbc_dbport} -d \"dbname=$dbc_dbname ${dbc_ssl:+sslmode=require}\" -q || run_sql_fail $dbc_dbtype
            fi
            ;;
        sqlite )
            echo $sql | sqlite $dbc_basepath/$dbc_dbname || run_sql_fail $dbc_dbtype
            ;;
        * )
            echo "run_sql: $dbc_dbtype not supported" >&2
            ;;
    esac

    return 0
}

run_sql_fail () {
    echo "run_sql $@ fail" >&2
    ERR=fail
}

postgres_update_seqs () {
# repair pgsql sequences, this has always been a source of trouble
# on prepopulated DBs
    if db_get phpbb3/dbconfig-install && [ "$RET" = "true" ] ; then
        db_get phpbb3/database-type
        if [ "$RET" = "pgsql" ]; then
            db_get phpbb3/db/dbname
            local dbname="$RET"
            db_get phpbb3/remote/host
            local dbhost="$RET"
            db_get phpbb3/remote/port
            local dbport="$RET"
            if [ -z "${dbc_dbserver}" ]; then
                /usr/share/phpbb3/postgres_update_seqs.sh /usr/share/dbconfig-common/data/phpbb3/install/pgsql | su - postgres -c "psql ${dbhost:+-h $dbhost} ${dbport:+-p $dbport} -d $dbname -q >/dev/null"
            else
                /usr/share/phpbb3/postgres_update_seqs.sh /usr/share/dbconfig-common/data/phpbb3/install/pgsql | psql ${dbhost:+-h $dbhost} ${dbport:+-p $dbport} -d $dbname -q >/dev/null
            fi
        fi
    fi
}

_md5 () {
    echo -n $1 | md5sum | cut -c-32
}

dc_true () {
    db_get $1
    [ "$RET" = "true" ]
    return $?
}

dc_forget () {
    db_reset $1
    db_fset $1 seen false
}

dc_get () {
    db_get $1
    echo -n $RET
}

dc_copy () {
    db_set $2 "$(dc_get $1)"
}

dc_out () {
    db_get $1
    echo $1: $RET # -- "$(debconf-show phpbb3 | grep $1)"
}

dc_dbg () {
    [ "$PB3DEBUG" != "maint" ] && return
    set +e
    echo $0:$LINENO $@
    for d in install upgrade reinstall remove; do
        db_get phpbb3/dbconfig-$d && echo [dbc] phpbb3/dbconfig-$d "$RET"
    done
    set -e
}