@@ -30,6 +30,7 @@ import * as Layer from "effect/Layer";
3030import * as Schema from "effect/Schema" ;
3131import * as Tracer from "effect/Tracer" ;
3232import * as SqlClient from "effect/sql/SqlClient" ;
33+ import * as Statement from "effect/sql/Statement" ;
3334import { projectThreadAwarenessV2 } from "@t3tools/shared/agentAwareness" ;
3435
3536import * as SqlitePersistence from "../persistence/Sqlite.ts" ;
@@ -936,6 +937,53 @@ it.layer(layerTest)("ProjectionStoreV2", (it) => {
936937 assert . deepEqual ( yield * store . getTurnStartHistory ( threadId , [ RunId . make ( "run:other" ) ] ) , [ ] ) ;
937938 } ) ,
938939 ) ;
940+ it . effect ( "answers empty record filters without reading the filtered tables" , ( ) =>
941+ Effect . gen ( function * ( ) {
942+ const store = yield * ProjectionStore . ProjectionStoreV2 ;
943+ const threadId = yield * addRolledBackRecoveryCandidate ( "empty-record-filters" ) ;
944+ const runId = ( yield * store . getThreadProjection ( threadId ) ) . runs [ 0 ] ! . id ;
945+ const queries : Array < string > = [ ] ;
946+ const recordQueries : Statement . Transformer = ( statement ) => {
947+ queries . push ( statement . compile ( ) [ 0 ] ) ;
948+ return Effect . succeed ( statement ) ;
949+ } ;
950+ const read = ( filter : ProjectionStore . ProjectionRecordFilter ) =>
951+ store
952+ . getThreadRecords ( threadId , [ "runs" , "messages" , "turnItems" ] , filter )
953+ . pipe ( Effect . provideService ( Statement . CurrentTransformer , recordQueries ) ) ;
954+
955+ const emptyFilters = [
956+ [ { turnItemTypes : [ ] } , "turnItems" , "turn_items" ] ,
957+ [ { turnItemStatuses : [ ] } , "turnItems" , "turn_items" ] ,
958+ [ { turnItemRunIds : [ ] } , "turnItems" , "turn_items" ] ,
959+ [ { runIds : [ ] } , "runs" , "runs" ] ,
960+ [ { messageIds : [ ] } , "messages" , "messages" ] ,
961+ [ { messageRoles : [ ] } , "messages" , "messages" ] ,
962+ [ { messageRunIds : [ ] } , "messages" , "messages" ] ,
963+ ] as const ;
964+ for ( const [ filter , field , table ] of emptyFilters ) {
965+ queries . length = 0 ;
966+ assert . isEmpty ( ( yield * read ( filter ) ) [ field ] ) ;
967+ assert . isFalse (
968+ queries . some ( ( query ) =>
969+ new RegExp ( `FROM orchestration_v2_projection_${ table } \\b` ) . test ( query ) ,
970+ ) ,
971+ `${ JSON . stringify ( filter ) } read ${ table } ` ,
972+ ) ;
973+ }
974+
975+ const selected = yield * read ( { turnItemTypes : [ "command_execution" ] , runIds : [ runId ] } ) ;
976+ assert . deepEqual (
977+ selected . turnItems . map ( ( item ) => item . type ) ,
978+ [ "command_execution" ] ,
979+ ) ;
980+ assert . deepEqual (
981+ selected . runs . map ( ( run ) => run . id ) ,
982+ [ runId ] ,
983+ ) ;
984+ assert . isEmpty ( ( yield * read ( { turnItemTypes : [ "user_message" ] } ) ) . turnItems ) ;
985+ } ) ,
986+ ) ;
939987 it . effect ( "preserves stored provider usage when a terminal update omits it" , ( ) =>
940988 Effect . gen ( function * ( ) {
941989 const projectionStore = yield * ProjectionStore . ProjectionStoreV2 ;
0 commit comments