From 9539e58ae7653ffa5ef25cf7b18c67d705813334 Mon Sep 17 00:00:00 2001
From: Cullum Smith <cullum@sacredheartsc.com>
Date: Thu, 27 Mar 2025 22:30:15 -0400
Subject: more mysql stuff

---
 lib/60-mysql    | 25 +++++++++++++++++++++++++
 lib/60-postgres |  1 +
 2 files changed, 26 insertions(+)
 create mode 100644 lib/60-mysql

(limited to 'lib')

diff --git a/lib/60-mysql b/lib/60-mysql
new file mode 100644
index 0000000..1d2f158
--- /dev/null
+++ b/lib/60-mysql
@@ -0,0 +1,25 @@
+#!/bin/sh
+
+mysql_run(){
+  MYSQL_PWD="$boxconf_password" mysql \
+    --batch \
+    --ssl-verify-server-cert \
+    --user="$boxconf_username" \
+    "$@"
+}
+
+mysql_create_user(){
+  # $1 = mysql_host, $2 = username $3 = via
+  cat <<EOF | mysql_run --host="${1}"
+CREATE USER IF NOT EXISTS '${2}' IDENTIFIED VIA ${3};
+EOF
+}
+
+mysql_create_database(){
+  # $1 = mysql_host, $2 = dbname, $3 = owner $4 = options
+  cat <<EOF | mysql_run --host="${1}"
+CREATE DATABASE IF NOT EXISTS ${2} ${4:-};
+GRANT ALL PRIVILEGES ON ${2}.* TO '${3}';
+FLUSH PRIVILEGES;
+EOF
+}
diff --git a/lib/60-postgres b/lib/60-postgres
index 6f418ea..b50d130 100644
--- a/lib/60-postgres
+++ b/lib/60-postgres
@@ -9,6 +9,7 @@ postgres_run(){
     -v ON_ERROR_STOP=1 \
     "$@"
 }
+
 postgres_create_role(){
   # $1 = postgres_host, $2 = username
   cat <<EOF | postgres_run -h "${1}" -d postgres
-- 
cgit v1.2.3