#!/bin/bash
set -e
set -o pipefail

json_to_shell()
{
	jq -r '{ db_user, db_password, db_host, db_name } |
		to_entries |
		.[] |
		@sh "declare \(.key)=\(.value);" '
}

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

eval "$(wordpress-config-info "$1" | json_to_shell)"
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