#!/bin/bash
set -e
set -o pipefail
PATH=$(dirname "$0"):$PATH

if [ $# = 0 ]
then
	wordpress-config-info |
	while read -r
	do
		"$0" "$REPLY" || continue
	done
	exit
fi

table_prefix=$(\
	NEW_INTERFACE=y \
	wordpress-config-info "$1" |
	jq -r '.assigns | add | .table_prefix'
)
usertable=${table_prefix}users
shortname=${1#/srv/}
shortname=${shortname%%/*}
wordpress-mysql -- "$1" -t <<END
select
	id
,	user_login
	as
		'${shortname} login'
,	user_pass
	as
		'pass'
from
	${usertable}
;
END