forked from mtusi2026/mtusi2026lab5
78 lines
1.5 KiB
Bash
78 lines
1.5 KiB
Bash
|
|
#!/usr/bin/env bash
|
|
set -euo pipefail
|
|
|
|
cd "$(dirname "$0")/.."
|
|
|
|
sql() {
|
|
docker compose exec -T db \
|
|
psql -U messenger -d messenger -At -c "$1"
|
|
}
|
|
|
|
echo "Finding completed image job..."
|
|
|
|
JOB_ID=$(sql "
|
|
SELECT j.id
|
|
FROM attachment_jobs j
|
|
JOIN attachment_variants v
|
|
ON v.attachment_id = j.attachment_id
|
|
WHERE j.status = 'ready'
|
|
AND v.variant_name = 'thumbnail'
|
|
ORDER BY j.created_at DESC
|
|
LIMIT 1;
|
|
")
|
|
|
|
if [[ -z "$JOB_ID" ]]; then
|
|
echo "FAIL: no completed image job found"
|
|
exit 1
|
|
fi
|
|
|
|
echo "Job: $JOB_ID"
|
|
|
|
STATE_QUERY="
|
|
SELECT
|
|
j.status || '|' ||
|
|
j.attempts || '|' ||
|
|
v.sha256 || '|' ||
|
|
(
|
|
SELECT COUNT(*)
|
|
FROM attachment_variants
|
|
WHERE attachment_id = j.attachment_id
|
|
)
|
|
FROM attachment_jobs j
|
|
JOIN attachment_variants v
|
|
ON v.attachment_id = j.attachment_id
|
|
WHERE j.id = '$JOB_ID'
|
|
AND v.variant_name = 'thumbnail';
|
|
"
|
|
|
|
BEFORE=$(sql "$STATE_QUERY")
|
|
|
|
echo "Before: $BEFORE"
|
|
echo "Publishing the same job twice..."
|
|
|
|
docker compose run --rm --no-deps api1 \
|
|
python -c '
|
|
import sys
|
|
from src.queue import publish_job
|
|
|
|
job_id = sys.argv[1]
|
|
publish_job(job_id)
|
|
publish_job(job_id)
|
|
print("Two duplicate messages published")
|
|
' "$JOB_ID"
|
|
|
|
sleep 5
|
|
|
|
AFTER=$(sql "$STATE_QUERY")
|
|
|
|
echo "After: $AFTER"
|
|
|
|
if [[ "$BEFORE" != "$AFTER" ]]; then
|
|
echo "FAIL: completed job changed after redelivery"
|
|
exit 1
|
|
fi
|
|
|
|
echo "PASS: duplicate delivery did not change completed job"
|
|
echo "PASS: thumbnail checksum and variant count preserved"
|