#!/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 [[ $(mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DB -N -e "SELECT language FROM params;") == *"english.language"* ]]
    then
        <logoh.en.sql mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DB
    else
        <logoh.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