From 521129c88bf432b8755f1fe0a94be73c157d26fe Mon Sep 17 00:00:00 2001
From: "Jakob L. Kreuze" <zerodaysfordays@sdf.org>
Date: Tue, 23 Aug 2022 20:48:38 -0400
Subject: [dynamic] Add `import-images.sh' for image gallery

---
 dynamic/import-images.sh | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 dynamic/import-images.sh

diff --git a/dynamic/import-images.sh b/dynamic/import-images.sh
new file mode 100644
index 0000000..23f6130
--- /dev/null
+++ b/dynamic/import-images.sh
@@ -0,0 +1,16 @@
+#!/usr/bin/env bash
+
+set -euo pipefail
+
+VANITY="$1"
+shift
+
+for item in "$@"; do
+    filename=$(basename -- "$item")
+    extension="${filename##*.}"
+    filename="${filename%.*}"
+    uuid="$(uuidgen)"
+    cp "$item" "/home/jakob/gallery-images/$uuid.$extension"
+    convert "/home/jakob/gallery-images/$uuid.$extension" -thumbnail '100x100>' "/home/jakob/gallery-images/${uuid}_thumb.png"
+    psql jakob_gallery -c "INSERT INTO images (vanity, title, filename, thumb_filename, datetime) VALUES ('$VANITY', '$filename', '$uuid.$extension', '${uuid}_thumb.png', now());"
+done
-- 
cgit v1.3