Bash – tworzenie miniaturek wraz z generowaniem sql.

#!/bin/bash
GEOMETRY=$1
if [ "$GEOMETRY" -lt 1 ]
then
#128px width thumbnails default
GEOMETRY=128
fi

for filename in *jpg

do
convert -quality 85 -geometry x$GEOMETRY $filename ~/thumbs/$filename
echo “INSERT INTO photos (photo_url) VALUES(’$filename’)” >> ./database.sql
done