Files
mtusi2026lab6/migrations/009_backfill_pipeline.sql
2026-11-18 21:37:25 +03:00

13 lines
642 B
SQL

-- +goose Up
-- Re-process accepted lab4 originals; original keys remain durable staging until ready.
INSERT INTO attachment_jobs(id,attachment_id,state,max_attempts)
SELECT id,id,'queued',5 FROM attachments WHERE status='ready' AND variants='[]'::jsonb;
UPDATE attachments SET staging_key=object_key,
object_key='original/'||id::text||'/v1/original',status='queued',updated_at=clock_timestamp()
WHERE id IN (SELECT attachment_id FROM attachment_jobs);
INSERT INTO attachment_outbox(job_id) SELECT id FROM attachment_jobs;
-- +goose Down
-- Do not erase accepted processing jobs during a downgrade. Schema Down is destructive.
SELECT 1;