@@ -87,6 +87,12 @@ const createFixtureSource = Effect.fn("createMigrateDevDbFixtureSource")(functio
8787 created_at, updated_at, last_run_status, run_count)
8888 VALUES ('task-1', 'Nightly', 'Run it', 1, '{}', 'project-kept', '{}', '{}',
8989 'full-access', 'default', 'user', 'user', '2026-08-01', '2026-08-01', 'never', 0)` ;
90+ yield * sql `INSERT INTO scheduled_task_webhook_replay_keys
91+ (task_id, replay_key, delivery_id, expires_at)
92+ VALUES ('task-1', 'replay-1', 'delivery-1', 1900000000000)` ;
93+ yield * sql `INSERT INTO scheduled_task_webhook_pending
94+ (delivery_id, task_id, coalesce_key, due_at, task_json, request_json, delivery_ids_json)
95+ VALUES ('delivery-1', 'task-1', 'key-1', 1900000000000, '{}', '{}', '[]')` ;
9096 yield * sql `INSERT INTO auth_sessions (session_id, subject, scopes, method, issued_at, expires_at)
9197 VALUES ('session-1', 'user', '[]', 'pairing', '2026-08-01', '2027-08-01')` ;
9298 } ) ,
@@ -119,10 +125,17 @@ it.layer(NodeServices.layer)("migrate-dev-db", (it) => {
119125 SELECT stream_id FROM orchestration_events ORDER BY stream_id` ;
120126 const sessions = yield * sql < { provider_session_id : string } > `
121127 SELECT provider_session_id FROM orchestration_v2_projection_provider_sessions` ;
122- const [ leftovers ] = yield * sql < { auth : number ; tasks : number ; transfers : number } > `
128+ const [ leftovers ] = yield * sql < {
129+ auth : number ;
130+ tasks : number ;
131+ webhooks : number ;
132+ transfers : number ;
133+ } > `
123134 SELECT
124135 (SELECT COUNT(*) FROM auth_sessions) AS auth,
125136 (SELECT COUNT(*) FROM scheduled_tasks) AS tasks,
137+ (SELECT COUNT(*) FROM scheduled_task_webhook_replay_keys) +
138+ (SELECT COUNT(*) FROM scheduled_task_webhook_pending) AS webhooks,
126139 (SELECT COUNT(*) FROM orchestration_v2_projection_context_transfers) AS transfers` ;
127140 return { threads, events, sessions, leftovers } ;
128141 } ) ,
@@ -139,7 +152,7 @@ it.layer(NodeServices.layer)("migrate-dev-db", (it) => {
139152 kept . sessions . map ( ( row ) => row . provider_session_id ) ,
140153 [ "session-shared" ] ,
141154 ) ;
142- assert . deepStrictEqual ( kept . leftovers , { auth : 0 , tasks : 0 , transfers : 0 } ) ;
155+ assert . deepStrictEqual ( kept . leftovers , { auth : 0 , tasks : 0 , webhooks : 0 , transfers : 0 } ) ;
143156 } ) ,
144157 ) ;
145158
0 commit comments