Add requirements-dev.txt for development dependencies

[moshesham]

Problem

No requirements-dev.txt file exists for development dependencies. Developers need to manually discover and install testing/linting tools.

Impact

• Developers need to manually install testing/linting tools
• No standardized development environment
• CI/CD pipeline requirements not documented
• Inconsistent tooling across contributors

Proposed Solution

Create requirements-dev.txt:

# Testing
pytest>=7.4.0,<8.0.0
pytest-cov>=4.1.0,<5.0.0

# Code Quality
flake8>=6.0.0,<7.0.0
black>=23.0.0,<24.0.0
isort>=5.12.0,<6.0.0
pylint>=2.17.0,<3.0.0

# Type Checking
mypy>=1.4.0,<2.0.0

# Documentation
sphinx>=7.0.0,<8.0.0

# Security
bandit>=1.7.0,<2.0.0
safety>=2.3.0,<3.0.0

Tasks

• Create requirements-dev.txt file
• Add testing dependencies (pytest, pytest-cov)
• Add linting dependencies (flake8, black, isort, pylint)
• Add type checking dependencies (mypy)
• Add documentation dependencies (sphinx)
• Add security scanning dependencies (bandit, safety)
• Update README.md with development setup instructions
• Update CONTRIBUTING.md (if exists) with tooling information

Installation Command

After creation, developers can install with:

pip install -r requirements.txt
pip install -r requirements-dev.txt

References

• PROJECT_REVIEW.md Issue feat: Implement difficulty system, enhance database schema, and add comprehensive tests #3