api-integration-test-generator

Provide the API specification document, router code, and Pydantic schema definitions. The Skill generates conftest.py with database fixtures, test data factories, and test classes covering success cases, 404 errors, 422 validation failures, and pagination for each endpoint.

Each endpoint gets a standard matrix: happy path success tests, 404 not found for GET/PUT/DELETE, 422 validation errors for POST/PUT, 409 conflicts for unique constraints, 401/403 auth checks when required, plus pagination, sorting, and filtering tests for list endpoints.

Yes, the generated conftest.py uses pytest-asyncio with httpx AsyncClient and ASGITransport. It creates an async SQLAlchemy engine with aiosqlite for test databases, overriding the get_db dependency to isolate each test with fresh tables.

Factories provide make_<resource>_data() for valid payloads with sensible defaults from schema definitions, and make_<resource>_invalid_data(scenario) supporting scenarios like missing_required, invalid_type, and exceed_max_length for negative testing.

Service layer tests (test_<module>_service.py) are marked as optional output. The primary focus is router integration tests, but you can request service unit tests as an additional artifact when needed.