MySQL Transactional tests

If you’re working with MySQL and want reliable, clean database tests without worrying about cleanup, **mysql-transactional-tests is a great solution, especially for Node.js apps using mysql or mysql2 drivers.

🔑 Key Features

• Automatic Transaction Wrapping: Every test runs inside its own SQL transaction, which is rolled back at the end—ensuring complete data isolation without manual cleanup.
• Driver-Agnostic Support: Works seamlessly with both mysql and mysql2—just import the right driver wrapper before establishing your DB connection.
• Nested Transaction Safety: Uses SAVEPOINT and custom handling of COMMIT/ROLLBACK so that even nested transactions behave correctly and resources remain clean.
• Parallel Test Compatibility: Works well in parallel test runners like Jest—each test uses its own transaction and single connection, avoiding cross-test interference.
• Lightweight & Zero Overhead: No need to reset or truncate tables between tests—it’s fast, simple, and designed solely for transactional test support.

mysql-transactional-tests brings clean, reliable, and fast database testing to your MySQL-powered Node.js apps. It’s a must-have for testers and QA professionals who want robust integration tests without the hassle of manual resets.