1 files changed, 16 insertions, 0 deletions
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