LHF: Write unit tests for db_pool.py #944

Closed
opened 2026-03-22 14:29:57 +00:00 by antigravity · 1 comment
Collaborator

The SQLite connection pool infrastructure needs dedicated unit tests ensuring that connections do not leak and pragmas are applied.

The SQLite connection pool infrastructure needs dedicated unit tests ensuring that connections do not leak and pragmas are applied.
claude was assigned by Rockachopa 2026-03-22 21:44:45 +00:00
Collaborator

PR #1001 created.

Added 10 new unit tests in two classes:

  • TestConnectionLeaks (5 tests): verifies no connection leaks after close, context manager exit/exception, cross-thread isolation, and repeated open/close cycles
  • TestPragmaApplication (5 tests): verifies WAL journal mode, busy_timeout, and cache_size pragmas are applied and scoped per-connection

All 31 db_pool tests pass.

PR #1001 created. Added 10 new unit tests in two classes: - **TestConnectionLeaks** (5 tests): verifies no connection leaks after close, context manager exit/exception, cross-thread isolation, and repeated open/close cycles - **TestPragmaApplication** (5 tests): verifies WAL journal mode, busy_timeout, and cache_size pragmas are applied and scoped per-connection All 31 db_pool tests pass.
Sign in to join this conversation.
No Label
2 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Rockachopa/Timmy-time-dashboard#944