@@ -7,9 +7,14 @@ import {
77 ThreadId ,
88 type OrchestrationV2DomainEvent ,
99} from "@t3tools/contracts" ;
10+ import * as NodeServices from "@effect/platform-node/NodeServices" ;
1011import * as DateTime from "effect/DateTime" ;
12+ import * as Deferred from "effect/Deferred" ;
1113import * as Effect from "effect/Effect" ;
14+ import * as FileSystem from "effect/FileSystem" ;
15+ import * as Fiber from "effect/Fiber" ;
1216import * as Layer from "effect/Layer" ;
17+ import * as Path from "effect/Path" ;
1318import * as SqlClient from "effect/sql/SqlClient" ;
1419
1520import * as SqlitePersistence from "../persistence/Sqlite.ts" ;
@@ -199,3 +204,54 @@ it.layer(layerTest)("ThreadSearch", (it) => {
199204 } ) ,
200205 ) ;
201206} ) ;
207+
208+ it . effect ( "searches on the reader worker while the writer is busy" , ( ) =>
209+ Effect . gen ( function * ( ) {
210+ const fileSystem = yield * FileSystem . FileSystem ;
211+ const path = yield * Path . Path ;
212+ const directory = yield * fileSystem . makeTempDirectoryScoped ( { prefix : "t3-thread-search-" } ) ;
213+ const layerFile = Layer . mergeAll (
214+ ThreadSearch . layer ,
215+ ProjectionStore . layer ,
216+ ProjectStore . layer ,
217+ ) . pipe (
218+ Layer . provideMerge ( SqlitePersistence . layerFromPath ( path . join ( directory , "state.sqlite" ) ) ) ,
219+ Layer . provide ( NodeServices . layer ) ,
220+ ) ;
221+
222+ yield * Effect . gen ( function * ( ) {
223+ const projections = yield * ProjectionStore . ProjectionStoreV2 ;
224+ const search = yield * ThreadSearch . ThreadSearch ;
225+ const sql = yield * SqlClient . SqlClient ;
226+ const project = ProjectId . make ( "project:search-reader" ) ;
227+ const threadId = ThreadId . make ( "thread:reader" ) ;
228+ yield * createProject ( project ) ;
229+ yield * Effect . forEach (
230+ [ thread ( threadId , project ) , message ( threadId , "reader" , "user" , "needle on the reader" ) ] ,
231+ projections . apply ,
232+ { discard : true } ,
233+ ) ;
234+
235+ // A write transaction holds the writer connection. A search on the writer would queue
236+ // behind it and never finish; one on the reader worker does not wait.
237+ const writerHeld = yield * Deferred . make < void > ( ) ;
238+ const releaseWriter = yield * Deferred . make < void > ( ) ;
239+ const writer = yield * Effect . forkChild (
240+ sql . withTransaction (
241+ Deferred . succeed ( writerHeld , undefined ) . pipe (
242+ Effect . andThen ( Deferred . await ( releaseWriter ) ) ,
243+ ) ,
244+ ) ,
245+ ) ;
246+ yield * Deferred . await ( writerHeld ) ;
247+ const result = yield * search . search ( { query : "needle" } ) ;
248+ yield * Deferred . succeed ( releaseWriter , undefined ) ;
249+ yield * Fiber . join ( writer ) ;
250+
251+ assert . deepEqual (
252+ result . matches . map ( ( match ) => match . threadId ) ,
253+ [ threadId ] ,
254+ ) ;
255+ } ) . pipe ( Effect . provide ( layerFile ) ) ;
256+ } ) . pipe ( Effect . scoped , Effect . provide ( NodeServices . layer ) ) ,
257+ ) ;
0 commit comments