summaryrefslogtreecommitdiff
path: root/database-test.bash
blob: 4a20e68317545f479551e32a258c2c59fabcd0fa (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
#!/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);" '
}
[ "$1" ]
eval "$(wordpress-config-info "$1" | json_to_shell)"

[ "$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 @@have_ssl, user()\G
show grants;
.