From 5799f1861ff3696e8420caa6f0914a2f0bf651b8 Mon Sep 17 00:00:00 2001
From: root <root@vps-18a7a2b7.vps.ovh.ca>
Date: Sat, 10 Feb 2024 00:18:38 -0500
Subject: database-test.bash

---
 database-test.bash | 35 +++++++++++++++++++++++++++++++++++
 1 file changed, 35 insertions(+)
 create mode 100644 database-test.bash

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;
+.
-- 
cgit v1.2.3