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

for_each_wordpress_site()
{
	wordpress-config-info |
	jq -r '.[] | .site' |
	while read d
	do
		("$@" "$d") || continue
	done
}
if [ $# = 0 ]
then
	for_each_wordpress_site "$0"
	exit
fi

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