#!/usr/bin/env bash

set -eu -o pipefail

psql $EXASTASH_POSTGRES_URI --tuples-only --quiet --no-psqlrc --echo-errors --no-align --field-separator $'\t' -c "SELECT video_id FROM youtube.captures_view WHERE alive = FALSE ORDER BY folder" | huniq > dead-video-ids.new && mv -f dead-video-ids{.new,}