Frontend advisory A2 fixed (inserted deep-link slide deduplicated when the feed refetches), regression test fails without it; A1 not reproducible on React Query 5, kept as a guard test
—
Land: full gates
mvn verify exit 0 (coverage gate ≥ 0.90 passed); npm run test 78 files / 680 tests; npm run lint clean
—
Gate 2 (owner)
Push 1 approved after the owner's prod pg_dump backup; push 2 approved after push 1 was verified live
—
CI + smoke
Push 1: Funny App Build and Deploy 4/4 jobs success (Trivy skipped as usual); mock-test.sh 22/22; prod feed 59 videos, GET /video-stream/{id} 200, health 200, so the migration applied and the app booted. Push 2: Deploy Frontend (see tracking)
Schema (api/src/main/resources/db/changelog/sql/202610300001-video-visibility.sql): the first Liquibase formatted-SQL file in the repo. It adds video_sources.visibility (backfilled from is_hide), recreates idx_video_sources_feed on visibility = 'FEED', drops is_hide, adds video_import_jobs.visibility and a drive_file_id index, and carries --rollback lines.
Feed lists FEED only (StreamVideoServiceImplfindAllByVisibilityAndStatus…). Collections, watch history, GET /video-stream/{id}, views, reactions and HLS accept anything but HIDDEN. VisibilityQueryPredicatesTest guards the native SQL predicates, because the repo has no DB test harness.
AdminPATCH /admin/videos/{id}/visibility takes {visibility} and still accepts the legacy {hidden}. Bad bodies get 400. AdminVideoDto has visibility plus a derived hidden.
Import:visibility is FEED (default) or COLLECTION_ONLY; HIDDEN or an unknown value gets 400/4104 INVALID_VISIBILITY. saveInfo and upsertInfo copy the latest job's value for the Drive file; an existing row keeps its own.
Admin UI: a Feed / Collection only / Hidden select (the tooltip says collection-only is not private), a badge, an Add to collection row action, an Import "Collection only" checkbox and a badge in the import table.
Deep link (webapp/src/components/video/VideoFeed.jsx): a video that is not in the feed is fetched by id and inserted as slide 0. Search keeps the feed list and maps by id (VideoSwiper.jsx). The link now resolves once in every outcome; before, a missing id was never resolved.
Stage path: every review and build ran as a worker-* fallback (the agent read the skill's SKILL.md), so that worker transcripts stay out of the orchestrator context.
[A] webapp/src/components/video/VideoSwiper.jsx:216: the slide counter shows N+1 while an inserted deep-link slide exists. This is a known limitation in the plan.
[A] api/src/main/java/com/canhlabs/funnyapp/service/impl/VideoStorageServiceImpl.java:6: two new imports are out of alphabetical order.
[A] The migration and rollback are checked only as file text. The owner skipped CO-1 AC 9, the local Postgres run (2026-10-30).
Before push 1: take a pg_dump of prod. It is the only way back if the --rollback statements fail.
Between push 1 and push 2: make no visibility edits on the Admin page. The old page sends {hidden:false}, which resets a COLLECTION_ONLY row to FEED (EC-1).
After push 2, prod smoke (CO-7 AC 4):
A video set to Collection only leaves the feed within 30 s, and still plays in a collection and through ?v=.
An import with Collection only never shows in the feed.