Updating a character image in the WaifuBot DB with `usql`, `jq` and `curl`

update-char-img.sh

#! /bin/bash

query=$(curl 'https://graphql.anilist.co/' \
    -s \
    -H 'content-type: application/json' \
    -d "{\"query\":\"query(\$id: Int) {Character(id:\$id){image{large}}}\",\"variables\":{\"id\":$1}}")

URL=$(echo $query | jq -r '.data.Character.image.large')

if [ $URL != "null" ]; then
    echo updating $1 to $URL
    usql $DB_URL -c "UPDATE characters SET image = '$URL' WHERE id = $1" -q
else
    echo no image for $1
fi