testing-database-code

Use predefined fixtures from tests/conftest.py to structure your pgdbm tests. The Skill provides a fixture selection decision tree covering test_db, test_db_with_tables, and related fixtures that handle database isolation, cleanup, and common scenarios like migrations and transactions automatically.

Organize tests by leveraging fixture composition patterns shown in this guide. Structure unit and integration tests using appropriate fixtures based on your needs—fixtures manage AsyncTestDatabase setup, teardown, and data isolation so you focus on test logic.

No. This Skill enforces using fixtures instead of manual AsyncTestDatabase usage. Predefined fixtures handle all database management, cleanup, and lifecycle concerns, eliminating guesswork and ensuring reliable test isolation.

The Skill demonstrates patterns for composing tests with fixtures that support migration and transaction scenarios. Examples show best practices for reusable test patterns that safely validate migrations, transaction behavior, and data setup without manual database handling.

Use fixture selection to match your test scope—lighter fixtures speed up runs for unit tests, while comprehensive fixtures ensure proper data state for integration tests. The Skill's decision tree guides you to choose fixtures that isolate tests and guarantee cleanup.

Yes. The Skill covers fixture patterns for both unit and integration testing scenarios. Fixture composition lets you scale from minimal setup for isolated unit tests to full database state for integration tests, all with consistent cleanup.