#!/bin/bash
set -e

read_config()
{
        eval "$(jq -r '. | to_entries | .[] | .key + "=" + (.value | @sh) + "\n"')"
}

our_mysqladmin()
{
	ssh -- "$db_host" mysqladmin "$@"
}

our_mysql()
{
	ssh -- "$db_host" mysql "$@"
}

have_database()
{
	our_mysql -ss <<END | (read match && [ "$match" ])
show databases where \`database\` = '${db_name//\'/\'\'}'
END
}

create_new_mysql_database()
{
	[ "$db_host" ]
	our_mysqladmin create "$db_name"
	our_mysql "$db_name" <<END
grant all privileges on \`$db_name\`.* to "$db_user" identified by "$db_password";
END
}

while [ $# -gt 0 ]
do
	case "$1" in
		--create)
			shift
			CREATE_NEW=y
			;;
		--)	shift
			break
			;;
		-*)	exit 1
			;;
		*)
			break
			;;
	esac
done

read_config < <(wordpress-config-info "$1")
shift

[ "$db_name" ]
[ "$db_host" ]
[ "$db_user" ]
[ "$db_password" ]

if [ "$CREATE_NEW" ]
then
	if ! have_database
	then
		set -x
		create_new_mysql_database
	else
		echo "$0: Warning: create_new_mysql_database: skipped" >&2
	fi
	exit
else
	our_mysql --user="$db_user" --password="$db_password" "$@" "$db_name"
fi