11import { assert , it } from "@effect/vitest" ;
2- import { EventId , ThreadId } from "@t3tools/contracts" ;
2+ import {
3+ ComposerContextId ,
4+ EventId ,
5+ type OrchestrationMessageContext ,
6+ ThreadId ,
7+ } from "@t3tools/contracts" ;
38import * as DateTime from "effect/DateTime" ;
49import * as Effect from "effect/Effect" ;
10+ import * as Exit from "effect/Exit" ;
511import * as Layer from "effect/Layer" ;
612import * as Tracer from "effect/Tracer" ;
713import * as SqlClient from "effect/sql/SqlClient" ;
14+ import * as Statement from "effect/sql/Statement" ;
815
916import * as SqlitePersistence from "../../persistence/Sqlite.ts" ;
1017import { listLinkedPullRequestThreads } from "../../pullRequest/linkedThreads.ts" ;
@@ -36,6 +43,113 @@ const layerTest = Layer.mergeAll(
3643 layerProjectionMaintenanceProvided ,
3744) ;
3845
46+ const seedPendingTranscripts = Effect . gen ( function * ( ) {
47+ const sql = yield * SqlClient . SqlClient ;
48+ const importer = yield * LegacyV1ThreadImporter . LegacyV1ThreadImporter ;
49+ const threadIds = [ ThreadId . make ( "thread:first" ) , ThreadId . make ( "thread:later" ) ] ;
50+ yield * sql `
51+ INSERT INTO projection_projects (
52+ project_id, title, workspace_root, scripts_json, created_at, updated_at
53+ ) VALUES (
54+ 'project:background', 'Legacy project', '/tmp/legacy-background', '[]',
55+ '2026-01-01T00:00:00.000Z', '2026-01-01T00:00:00.000Z'
56+ )
57+ ` ;
58+ for ( const threadId of threadIds ) {
59+ yield * sql `
60+ INSERT INTO projection_threads (
61+ thread_id, project_id, title, model_selection_json, runtime_mode,
62+ interaction_mode, created_at, updated_at
63+ ) VALUES (
64+ ${ threadId } , 'project:background', 'Legacy thread',
65+ '{"instanceId":"codex","model":"gpt-5.4"}', 'full-access', 'default',
66+ '2026-01-01T00:00:00.000Z', '2026-01-01T00:00:00.000Z'
67+ )
68+ ` ;
69+ yield * sql `
70+ INSERT INTO projection_thread_messages (
71+ message_id, thread_id, role, text, is_streaming, created_at, updated_at
72+ ) VALUES
73+ (${ `${ threadId } :old` } , ${ threadId } , 'user', 'Old question', 0,
74+ '2026-01-01T01:00:00.000Z', '2026-01-01T01:00:00.000Z'),
75+ (${ `${ threadId } :latest` } , ${ threadId } , 'user', 'Latest question', 0,
76+ '2026-01-02T01:00:00.000Z', '2026-01-02T01:00:00.000Z')
77+ ` ;
78+ }
79+ yield * importer . reconcileShells ;
80+ } ) ;
81+
82+ it . effect (
83+ "keeps hydrating later transcripts after a defect and leaves the failed thread pending" ,
84+ ( ) =>
85+ Effect . gen ( function * ( ) {
86+ const sql = yield * SqlClient . SqlClient ;
87+ const importer = yield * LegacyV1ThreadImporter . LegacyV1ThreadImporter ;
88+ const projections = yield * ProjectionStore . ProjectionStoreV2 ;
89+ yield * seedPendingTranscripts ;
90+ yield * sql `
91+ UPDATE projection_thread_messages SET created_at = '0000-not-a-date'
92+ WHERE message_id = 'thread:first:old'
93+ ` ;
94+
95+ yield * importer . importPendingTranscripts ;
96+
97+ const later = yield * projections . getThreadProjection ( ThreadId . make ( "thread:later" ) ) ;
98+ assert . deepStrictEqual (
99+ later . messages . map ( ( message ) => message . text ) ,
100+ [ "Old question" , "Latest question" ] ,
101+ ) ;
102+ assert . deepStrictEqual (
103+ yield * sql `
104+ SELECT thread_id, transcript_imported_at, last_error FROM orchestration_v2_legacy_imports
105+ WHERE transcript_imported_at IS NULL OR last_error IS NOT NULL
106+ ` ,
107+ [
108+ {
109+ thread_id : "thread:first" ,
110+ transcript_imported_at : null ,
111+ last_error : "Transcript hydration failed; retry on next open." ,
112+ } ,
113+ ] ,
114+ ) ;
115+ } ) . pipe ( Effect . provide ( layerTest ) ) ,
116+ ) ;
117+
118+ it . effect ( "propagates interruption from transcript reads and retry-marker writes" , ( ) =>
119+ Effect . gen ( function * ( ) {
120+ const sql = yield * SqlClient . SqlClient ;
121+ const importer = yield * LegacyV1ThreadImporter . LegacyV1ThreadImporter ;
122+ yield * seedPendingTranscripts ;
123+ const interrupted = [ ] ;
124+ for ( const phase of [ "transcript" , "retry-marker" ] ) {
125+ const exit = yield * importer . importPendingTranscripts . pipe (
126+ Effect . provideService ( Statement . CurrentTransformer , ( statement ) => {
127+ const [ query ] = statement . compile ( ) ;
128+ const readingTranscript = query . includes ( "FROM projection_thread_messages" ) ;
129+ const writingRetryMarker = query . includes ( "SET last_error =" ) ;
130+ if ( phase === "retry-marker" && readingTranscript ) {
131+ return Effect . die ( "transcript read failed" ) ;
132+ }
133+ if ( phase === "transcript" ? readingTranscript : writingRetryMarker ) {
134+ return Effect . interrupt ;
135+ }
136+ return Effect . succeed ( statement ) ;
137+ } ) ,
138+ Effect . exit ,
139+ ) ;
140+ interrupted . push ( Exit . hasInterrupts ( exit ) ) ;
141+ }
142+ assert . deepStrictEqual ( interrupted , [ true , true ] ) ;
143+ assert . deepStrictEqual (
144+ yield * sql `
145+ SELECT thread_id FROM orchestration_v2_legacy_imports
146+ WHERE transcript_imported_at IS NOT NULL OR last_error IS NOT NULL
147+ ` ,
148+ [ ] ,
149+ ) ;
150+ } ) . pipe ( Effect . provide ( layerTest ) ) ,
151+ ) ;
152+
39153it . layer ( layerTest ) ( "LegacyV1ThreadImporter" , ( it ) => {
40154 it . effect ( "uses the created-thread index for startup migration checks" , ( ) =>
41155 Effect . gen ( function * ( ) {
@@ -214,6 +328,31 @@ it.layer(layerTest)("LegacyV1ThreadImporter", (it) => {
214328 )
215329 ` ;
216330
331+ const validContext = {
332+ version : 1 ,
333+ records : [
334+ {
335+ version : 1 ,
336+ contextId : ComposerContextId . make ( "ctx_1" ) ,
337+ kind : "skill" ,
338+ label : "$test" ,
339+ name : "test" ,
340+ } ,
341+ ] ,
342+ } satisfies OrchestrationMessageContext ;
343+ yield * sql `
344+ UPDATE projection_thread_messages
345+ SET context_json = CASE message_id
346+ WHEN 'message:legacy:2' THEN '{broken-json'
347+ WHEN 'message:legacy:3' THEN '{"version":2,"records":[]}'
348+ ELSE ${ JSON . stringify ( validContext ) }
349+ END
350+ WHERE thread_id = ${ threadId }
351+ ` ;
352+ const sourceMessages = yield * sql `
353+ SELECT * FROM projection_thread_messages WHERE thread_id = ${ threadId } ORDER BY message_id
354+ ` ;
355+
217356 yield * sql `
218357 INSERT INTO projection_thread_pull_requests (
219358 thread_id, host, repository, number, url, source, linked_at, snapshot_json
@@ -284,6 +423,13 @@ it.layer(layerTest)("LegacyV1ThreadImporter", (it) => {
284423 shellProjection . messages . map ( ( message ) => message . id ) ,
285424 [ "message:legacy:3" , "message:legacy:4" ] ,
286425 ) ;
426+ assert . deepStrictEqual (
427+ shellProjection . messages . map ( ( message ) => [ message . text , message . context ] ) ,
428+ [
429+ [ "Follow-up question" , undefined ] ,
430+ [ "Partial answer" , validContext ] ,
431+ ] ,
432+ ) ;
287433
288434 const renamedAt = DateTime . makeUnsafe ( "2026-01-05T00:00:00.000Z" ) ;
289435 yield * eventSink . write ( {
@@ -308,7 +454,7 @@ it.layer(layerTest)("LegacyV1ThreadImporter", (it) => {
308454 ] ,
309455 } ) ;
310456
311- const transcriptImport = yield * importer . ensureTranscript ( threadId ) ;
457+ const transcriptImport = yield * importer . importPendingTranscripts ;
312458 assert . equal ( yield * importer . pendingThreadCount , 0 ) ;
313459 assert . deepStrictEqual ( transcriptImport , {
314460 importedThreadCount : 1 ,
@@ -326,6 +472,22 @@ it.layer(layerTest)("LegacyV1ThreadImporter", (it) => {
326472 projection . messages . map ( ( message ) => message . id ) ,
327473 [ "message:legacy:1" , "message:legacy:2" , "message:legacy:3" , "message:legacy:4" ] ,
328474 ) ;
475+ const expectedMessages = [
476+ [ "First question" , validContext ] ,
477+ [ "First answer" , undefined ] ,
478+ [ "Follow-up question" , undefined ] ,
479+ [ "Partial answer" , validContext ] ,
480+ ] ;
481+ assert . deepStrictEqual (
482+ projection . messages . map ( ( message ) => [ message . text , message . context ] ) ,
483+ expectedMessages ,
484+ ) ;
485+ assert . deepStrictEqual (
486+ yield * sql `
487+ SELECT * FROM projection_thread_messages WHERE thread_id = ${ threadId } ORDER BY message_id
488+ ` ,
489+ sourceMessages ,
490+ ) ;
329491 assert . deepStrictEqual (
330492 projection . turnItems
331493 . filter (
0 commit comments