requirements.txt

# Core testing framework
pytest==8.2.0
pytest-asyncio==0.21.2
pytest-rerunfailures==14.0

# Playwright browser automation
playwright==1.46.0

# Database integration
SQLAlchemy[asyncio]==2.0.32
asyncpg>=0.29.0              # PostgreSQL async driver
aiomysql>=0.2.0              # MySQL async driver (optional)
# pyodbc>=5.0.0              # SQL Server driver (optional - uncomment if needed)
# cx-Oracle>=8.3.0           # Oracle driver (optional - uncomment if needed)

# Redis cache integration
redis==5.0.8

# Configuration and environment
python-dotenv==1.0.1

# Reporting and logging
allure-pytest==2.15.0
allure-python-commons==2.15.0

# Additional utilities
pytest-xdist==3.5.0          # For parallel test execution
pytest-html==4.1.1           # HTML reports
pytest-cov==4.1.0            # Coverage reports