import importlib.util from contextlib import closing from pathlib import Path import sqlite3 import tempfile import unittest spec = importlib.util.spec_from_file_location("merge_logs", Path(__file__).with_name("merge_logs.py")) merge_logs = importlib.util.module_from_spec(spec) spec.loader.exec_module(merge_logs) class MergeTests(unittest.TestCase): def setUp(self): self.temp = tempfile.TemporaryDirectory() self.addCleanup(self.temp.cleanup) self.root = Path(self.temp.name) self.source, self.target = self.root / "source.db", self.root / "target.db" schema = (Path(__file__).parents[1] / "internal/app/log.go").read_text().split("const logSchema = `", 1)[1].split("`", 1)[0] for path in (self.source, self.target): with closing(sqlite3.connect(path)) as db, db: db.executescript(schema) def seed(self, path, request_id, text="raw response"): with closing(sqlite3.connect(path)) as db, db: db.execute("INSERT INTO completions(created_at,task,model,request_json,response_text,latency_ms,request_id) VALUES(1,'preview_summary','model','{}',?,10,?)", (text, request_id)) db.execute("INSERT INTO requests(created_at,request_id,endpoint,detail,outcome) VALUES(1,?,'search','{}','ok')", (request_id,)) def apply(self, name): return merge_logs.merge(self.source, self.target, "test-origin", self.root / name, True) def test_preserves_colliding_ids_raw_bodies_and_legitimate_duplicates(self): self.seed(self.target, "remote", "remote prose") self.seed(self.source, "local", " exact\nraw prose ") self.seed(self.source, "local", " exact\nraw prose ") report = self.apply("before.db") self.assertEqual(report["tables"]["completions"]["inserted"], 2) with closing(sqlite3.connect(self.target)) as db, db: self.assertEqual(db.execute("SELECT id,response_text FROM completions ORDER BY id").fetchall(), [(1, "remote prose"), (2, " exact\nraw prose "), (3, " exact\nraw prose ")]) again = self.apply("before-retry.db") self.assertEqual(again["tables"]["completions"]["inserted"], 0) self.assertEqual(again["tables"]["completions"]["alreadyImported"], 2) self.seed(self.source, "local-next") incremental = self.apply("before-incremental.db") self.assertEqual(incremental["tables"]["completions"]["inserted"], 1) with closing(sqlite3.connect(self.root / "before.db")) as db, db: self.assertEqual(db.execute("SELECT count(*) FROM completions").fetchone()[0], 1) def test_source_mutation_aborts_without_partial_import(self): self.seed(self.source, "local") self.apply("before.db") with closing(sqlite3.connect(self.source)) as db, db: db.execute("UPDATE completions SET response_text='changed' WHERE id=1") with self.assertRaises(ValueError): self.apply("before-conflict.db") with closing(sqlite3.connect(self.target)) as db, db: self.assertEqual(db.execute("SELECT response_text FROM completions").fetchone()[0], "raw response") def test_episode_collision_rolls_back_and_dry_run_is_read_only(self): self.seed(self.source, "shared") self.seed(self.target, "shared") before = self.target.read_bytes() self.assertTrue(merge_logs.merge(self.source, self.target, "test-origin")["dryRun"]) self.assertEqual(self.target.read_bytes(), before) with self.assertRaises(ValueError): self.apply("before-collision.db") with closing(sqlite3.connect(self.target)) as db, db: self.assertEqual(db.execute("SELECT count(*) FROM completions").fetchone()[0], 1) def test_snapshot_is_self_contained_not_wal_dependent(self): self.seed(self.source, "local") with closing(sqlite3.connect(self.source)) as live, live: live.execute("PRAGMA journal_mode=WAL") destination = self.root / "portable.db" merge_logs.snapshot(self.source, destination) transferred = self.root / "transferred.db" transferred.write_bytes(destination.read_bytes()) with closing(merge_logs.connect_readonly(transferred)) as db: self.assertEqual(db.execute("PRAGMA journal_mode").fetchone()[0], "delete") self.assertEqual(db.execute("SELECT count(*) FROM completions").fetchone()[0], 1) with self.assertRaises(sqlite3.OperationalError): db.execute("DELETE FROM completions") if __name__ == "__main__": unittest.main()