summaryrefslogtreecommitdiff
path: root/database-test.bash
blob: 1488b88cd4070f8c8166beef5db9be5b77ad62d6 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
#!/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
;
.