pgxmock

Simulates pgx behavior entirely in-memory, allowing fast unit tests without setting up PostgreSQL, as shown in the examples where tests run without real connections.

Supports regex, exact, or custom matchers via QueryMatcher interface, enabling precise validation of SQL queries, including complex patterns like time.Time arguments.

Accurately mocks BEGIN, COMMIT, and ROLLBACK, facilitating reliable testing of transactional code, as demonstrated in the rollback test example.

Implements the pgx interface without modifying production code, making it easy to drop into existing Go projects for test-driven development workflows.