summaryrefslogtreecommitdiff
path: root/dynamic/import-images.sh
blob: 23f6130953380671cc3c5479d8cebc59162a935f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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