database-test.bash

1 files changed, 35 insertions, 0 deletions

diff --git a/database-test.bash b/database-test.bash
new file mode 100644
index 0000000..4a20e68
--- /dev/null
+++ b/database-test.bash
@@ -0,0 +1,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;
+.