#!/bin/bash
set -e
set -o pipefail
PATH=./wordpress:$PATH

json_to_shell()
{
	jq -r '{ db_user, db_password, db_host, db_name } |
		to_entries |
		.[] |
		@sh "declare \(.key)=\(.value);" '
}
case $# in
	0 )
		wordpress-config-info |
		while read cfg
		do
			"$SHELL" "$0" "$cfg" || break
		done
		exit
		;;
	1 )
		[ "$1" ]
		eval "$(wordpress-config-info "$1" | json_to_shell)"
		;;
	* )
		exit 3
		;;
esac

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

if [ "$db_host" != localhost ]
then
	mariadb_tls_args=(--protocol=tcp --ssl-verify-server-cert)
else
	mariadb_tls_args=()
fi

mariadb \
	"${mariadb_tls_args[@]}" \
	--user="$db_user" \
	--password="$db_password" \
	--host="$db_host" \
	-- "$db_name" <<.
select
	@@hostname
,	user()
	as
		login
\G
show
	grants
;
.