pg-transactional-tests

import { testTransaction } from 'pg-transactional-tests'; // This setup file should be configured in your test runner, e.g., Jest's `setupFilesAfterEnv`. // It ensures that every test involving the database runs within its own transaction // and that the transaction is rolled back afterwards. // Starts a transaction before any tests begin (useful if using `beforeAll` hooks that perform queries) beforeAll(testTransaction.start); // Starts a new savepoint/transaction before each individual test beforeEach(testTransaction.start); // Rolls back the transaction/savepoint after each test completes, ensuring isolation afterEach(testTransaction.rollback); // Closes all PostgreSQL connections managed by pg-transactional-tests after all tests are done afterAll(testTransaction.close); // Example test structure for context: // describe('User Service', () => { // it('should create a user', async () => { // // Your ORM or pg client code here will run inside a transaction // await someORM.user.create({ name: 'Test User' }); // const user = await someORM.user.findUnique({ where: { name: 'Test User' } }); // expect(user).not.toBeNull(); // }); // it('should not persist user across tests', async () => { // const count = await someORM.user.count(); // expect(count).toBe(0); // Because previous test's transaction was rolled back // }); // });