#!/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