11import * as NodeServices from "@effect/platform-node/NodeServices" ;
22import { assert , it } from "@effect/vitest" ;
3+ import * as HostProcess from "@t3tools/shared/HostProcess" ;
34import * as NodeSqliteClient from "@t3tools/shared/nodeSqliteClient" ;
45import * as Clock from "effect/Clock" ;
56import * as Duration from "effect/Duration" ;
@@ -44,6 +45,7 @@ it.layer(DatabaseMaintenance.layer.pipe(Layer.provideMerge(NodeServices.layer)))
4445 yield * Effect . gen ( function * ( ) {
4546 const sql = yield * SqlClient . SqlClient ;
4647 yield * sql `CREATE TABLE retained_data (value TEXT)` ;
48+ yield * sql `INSERT INTO retained_data VALUES ('keep')` ;
4749 } ) . pipe ( Effect . provide ( NodeSqliteClient . layer ( { filename : dbPath } ) ) ) ;
4850 assert . isNull ( ( yield * maintenance . inspect ( dbPath ) ) . legacyDatabaseBytes ) ;
4951
@@ -52,21 +54,52 @@ it.layer(DatabaseMaintenance.layer.pipe(Layer.provideMerge(NodeServices.layer)))
5254 const sql = yield * SqlClient . SqlClient ;
5355 yield * sql `PRAGMA journal_mode = WAL` ;
5456 yield * sql `CREATE TABLE v1_data (value TEXT)` ;
57+ yield * sql `INSERT INTO v1_data VALUES ('rollback')` ;
5558 } ) . pipe ( Effect . provide ( openLegacy ) ) ;
5659 assert . isAbove ( ( yield * maintenance . inspect ( dbPath ) ) . legacyDatabaseBytes ?? 0 , 0 ) ;
5760
5861 const refused = yield * Effect . gen ( function * ( ) {
5962 const sql = yield * SqlClient . SqlClient ;
6063 yield * sql `SELECT value FROM v1_data` ;
61- return yield * Effect . flip ( maintenance . removeLegacyDatabase ( dbPath ) ) ;
64+ const failure = yield * Effect . flip ( maintenance . removeLegacyDatabase ( dbPath ) ) ;
65+ assert . deepEqual ( yield * sql `SELECT value FROM v1_data` , [ { value : "rollback" } ] ) ;
66+ return failure ;
6267 } ) . pipe ( Effect . provide ( openLegacy ) ) ;
6368 assert . equal ( refused . _tag , "DatabaseInUseError" ) ;
6469 assert . isTrue ( yield * fs . exists ( legacy ) ) ;
6570
66- yield * maintenance . removeLegacyDatabase ( dbPath ) ;
71+ yield * Effect . flatMap ( DatabaseMaintenance . DatabaseMaintenance , ( service ) =>
72+ service . removeLegacyDatabase ( dbPath ) ,
73+ ) . pipe (
74+ Effect . provide ( Layer . fresh ( DatabaseMaintenance . layer ) ) ,
75+ Effect . provideService ( HostProcess . Platform , "win32" ) ,
76+ Effect . provideService ( FileSystem . FileSystem , {
77+ ...fs ,
78+ remove : ( target , options ) =>
79+ Effect . gen ( function * ( ) {
80+ if ( target === legacy ) {
81+ yield * Effect . gen ( function * ( ) {
82+ const sql = yield * SqlClient . SqlClient ;
83+ yield * sql `PRAGMA busy_timeout = 0` ;
84+ yield * sql `BEGIN EXCLUSIVE` ;
85+ yield * sql `COMMIT` ;
86+ } ) . pipe ( Effect . provide ( NodeSqliteClient . layer ( { filename : legacy } ) ) ) ;
87+ // Create sidecars after the probe closes so only Doctor can remove them.
88+ yield * fs . writeFileString ( `${ legacy } -wal` , "leftover WAL" ) ;
89+ yield * fs . writeFileString ( `${ legacy } -shm` , "leftover SHM" ) ;
90+ }
91+ yield * fs . remove ( target , options ) ;
92+ } ) ,
93+ } ) ,
94+ ) ;
6795 assert . isFalse ( yield * fs . exists ( legacy ) ) ;
6896 assert . isFalse ( yield * fs . exists ( `${ legacy } -wal` ) ) ;
97+ assert . isFalse ( yield * fs . exists ( `${ legacy } -shm` ) ) ;
6998 assert . isTrue ( yield * fs . exists ( dbPath ) ) ;
99+ yield * Effect . gen ( function * ( ) {
100+ const sql = yield * SqlClient . SqlClient ;
101+ assert . deepEqual ( yield * sql `SELECT value FROM retained_data` , [ { value : "keep" } ] ) ;
102+ } ) . pipe ( Effect . provide ( NodeSqliteClient . layer ( { filename : dbPath , readonly : true } ) ) ) ;
70103 assert . isNull ( ( yield * maintenance . inspect ( dbPath ) ) . legacyDatabaseBytes ) ;
71104 } ) . pipe ( Effect . scoped ) ,
72105 ) ;
0 commit comments