11import * as NodeServices from "@effect/platform-node/NodeServices" ;
22import { assert , it } from "@effect/vitest" ;
33import * as Effect from "effect/Effect" ;
4+ import * as FileSystem from "effect/FileSystem" ;
45import * as Layer from "effect/Layer" ;
6+ import * as Option from "effect/Option" ;
7+ import * as Path from "effect/Path" ;
8+ import * as Stream from "effect/Stream" ;
9+ import * as TestClock from "effect/testing/TestClock" ;
510import * as SqlClient from "effect/sql/SqlClient" ;
611
712import * as ServerConfig from "../config.ts" ;
@@ -19,6 +24,23 @@ const freePages = Effect.map(
1924 ( rows ) => rows [ 0 ] ?. freelist_count ?? 0 ,
2025) ;
2126
27+ const storageLayer = < E > (
28+ config : Layer . Layer < ServerConfig . ServerConfig , E , FileSystem . FileSystem | Path . Path > ,
29+ ) =>
30+ DatabaseStorage . layer . pipe (
31+ Layer . provide ( ProjectionMaintenance . layer ) ,
32+ Layer . provide ( Layer . merge ( EventStore . layer , ProjectionStore . layer ) ) ,
33+ Layer . provideMerge ( Sqlite . layerMemory ) ,
34+ Layer . provideMerge ( config ) ,
35+ Layer . provide ( NodeServices . layer ) ,
36+ ) ;
37+
38+ const testConfig = ServerConfig . layerTest ( process . cwd ( ) , { prefix : "database-storage-" } ) ;
39+
40+ const currentStatus = Effect . flatMap ( DatabaseStorage . DatabaseStorage , ( storage ) =>
41+ storage . status . pipe ( Stream . take ( 1 ) , Stream . runHead ) ,
42+ ) ;
43+
2244it . effect ( "a new database returns freed pages online without losing data" , ( ) =>
2345 Effect . gen ( function * ( ) {
2446 const sql = yield * SqlClient . SqlClient ;
@@ -33,14 +55,53 @@ it.effect("a new database returns freed pages online without losing data", () =>
3355 yield * storage . reclaim ;
3456 assert . equal ( yield * freePages , 0 ) ;
3557 assert . deepEqual ( yield * sql `SELECT value FROM retained` , [ { value : "keep" } ] ) ;
58+ } ) . pipe ( Effect . provide ( storageLayer ( testConfig ) ) ) ,
59+ ) ;
60+
61+ it . effect ( "publishes file accounting and the doctor command after each pass" , ( ) =>
62+ Effect . gen ( function * ( ) {
63+ const sql = yield * SqlClient . SqlClient ;
64+ const config = yield * ServerConfig . ServerConfig ;
65+ yield * sql `CREATE TABLE discarded (value BLOB)` ;
66+ yield * sql `INSERT INTO discarded VALUES (zeroblob(1048576))` ;
67+ yield * TestClock . adjust ( "1 minute" ) ;
68+ const before = ( yield * currentStatus ) . pipe ( Option . getOrThrow ) ;
69+ assert . isNotNull ( before ) ;
70+ assert . isAbove ( before ! . databaseBytes , 1048576 ) ;
71+ assert . isTrue ( before ! . incrementalVacuumEnabled ) ;
72+ assert . include ( before ! . compactCommand , "doctor --base-dir" ) ;
73+ assert . include ( before ! . compactCommand , config . baseDir ) ;
74+
75+ // The next reclaim pass frees the dropped table and republishes.
76+ yield * sql `DROP TABLE discarded` ;
77+ yield * TestClock . adjust ( "1 minute" ) ;
78+ const storage = yield * DatabaseStorage . DatabaseStorage ;
79+ const after = yield * storage . status . pipe (
80+ Stream . filter ( ( status ) => status !== null && status . databaseBytes < before ! . databaseBytes ) ,
81+ Stream . runHead ,
82+ Effect . map ( Option . getOrThrow ) ,
83+ ) ;
84+ assert . isAtMost ( after ! . databaseBytes , before ! . databaseBytes - 1048576 ) ;
85+ assert . equal ( after ! . reclaimableBytes , 0 ) ;
86+ } ) . pipe ( Effect . provide ( storageLayer ( testConfig ) ) ) ,
87+ ) ;
88+
89+ it . effect ( "publishes nothing when doctor would repair a different database" , ( ) =>
90+ Effect . gen ( function * ( ) {
91+ yield * TestClock . adjust ( "1 minute" ) ;
92+ assert . deepEqual ( yield * currentStatus , Option . some ( null ) ) ;
3693 } ) . pipe (
3794 Effect . provide (
38- DatabaseStorage . layer . pipe (
39- Layer . provide ( ProjectionMaintenance . layer ) ,
40- Layer . provide ( Layer . merge ( EventStore . layer , ProjectionStore . layer ) ) ,
41- Layer . provideMerge ( Sqlite . layerMemory ) ,
42- Layer . provide ( ServerConfig . layerTest ( process . cwd ( ) , { prefix : "database-storage-" } ) ) ,
43- Layer . provide ( NodeServices . layer ) ,
95+ storageLayer (
96+ // A dev server without an explicit home keeps state in <baseDir>/dev,
97+ // while `doctor --base-dir` targets <baseDir>/userdata.
98+ Layer . effect (
99+ ServerConfig . ServerConfig ,
100+ Effect . gen ( function * ( ) {
101+ const config = yield * ServerConfig . ServerConfig ;
102+ return { ...config , dbPath : `${ config . baseDir } /dev/statev2.sqlite` } ;
103+ } ) ,
104+ ) . pipe ( Layer . provide ( testConfig ) ) ,
44105 ) ,
45106 ) ,
46107 ) ,
0 commit comments