Async Testing Expert

Testing async FastAPI apps with pytest requires pytest-asyncio to run async test functions and fixtures like event_loop and async_client. This Skill provides production-grade pytest patterns, mock objects (FakeConnection, FakeRecord, FakeTransaction), and layer-specific test strategies for DAO, Service, and Router components, enabling isolated and reliable async testing across your entire application stack.

Mock database interactions using production-ready fake objects that simulate real behavior without hitting a database. This Skill includes FakeConnection, FakeRecord, and FakeTransaction classes designed for async contexts, letting you test data access layers in isolation while maintaining realistic transaction and query patterns.

Yes. pytest-asyncio integrates seamlessly with FastAPI's async context. This Skill combines pytest-asyncio with httpx for async client testing and provides fixtures for event loops and async database mocks, enabling end-to-end testing of FastAPI routes that interact with async database operations.

Use the included generate_test_template.py script to automatically create boilerplate test files for DAO, Service, and Router layers. The generator enforces production-grade testing patterns and reduces setup time, so you can focus on writing meaningful assertions rather than repetitive test structure.

Layer-specific testing patterns isolate concerns: test DAO layers with fake database objects, Service layers with mocked DAOs, and Router layers with async HTTP clients. This Skill provides tailored strategies and fixtures for each layer, ensuring comprehensive coverage without tight coupling between test layers.

This Skill bundles pytest-asyncio for async test execution, httpx for async HTTP client testing, faker for test data generation, and custom mock objects for database simulation. Together these eliminate the complexity of async testing setup, covering fixtures, mocks, and boilerplate generation in one integrated solution.