Backend Testing Skill

Unit tests validate service layer logic in isolation using pytest fixtures to create deterministic database state. Define test functions in a tests/ directory, use in-memory SQLite fixtures for setup, and run pytest tests/ to execute all tests with repeatable results.

Yes. This Skill covers integration tests for database operations, API endpoint tests with authentication, and unit tests in a single structured test layout. Run pytest tests/ to execute all test types across service, database, and API layers simultaneously.

Use in-memory SQLite fixtures to ensure isolated, deterministic test environments. Follow structured naming conventions and layout patterns that enforce test independence. Fixtures reset state between tests, eliminating side effects and flakiness across unit, integration, and API tests.

API tests verify endpoint responses with proper authentication and error handling using pytest fixtures. Define test cases that exercise success and failure paths, use fixtures to mock authenticated users, and validate response codes and payloads.

No. Integration tests use in-memory SQLite databases via fixtures, eliminating the need for live databases. This approach ensures isolated test environments, faster execution, and repeatable results without external dependencies.