# QR Code Management System - Python Dependencies
# Production-ready Flask application with MySQL support
# Versions pinned as of March 2026 — run `pip install -r requirements.txt` on fresh deploy

# Core Flask Framework
Flask==3.1.0
Flask-SQLAlchemy==3.1.1

# Database Support - MySQL
PyMySQL==1.1.1                  # Pure Python MySQL client
mysql-connector-python==9.2.0   # Official MySQL connector (alternative)
SQLAlchemy==2.0.36

# Security and Authentication
Werkzeug==3.1.3                 # Security utilities and password hashing

# QR Code Generation
qrcode==8.0                     # QR code generation library
Pillow==11.1.0                  # Image processing for QR codes

# User Agent Detection
user-agents==2.2.0              # Device and browser detection from user agent strings

# URL and Regex Processing
regex==2024.11.6                # Enhanced regex support for URL generation

# Environment and Configuration
python-dotenv==1.0.1            # Environment variable management

# Date and Time Processing
python-dateutil==2.9.0.post0    # Extended date/time processing

# Development and Testing (optional)
pytest==8.3.4                   # Testing framework
pytest-flask==1.3.0             # Flask testing utilities
Flask-Testing==0.8.1            # Additional Flask testing tools

# Production Server (optional)
gunicorn==23.0.0                # WSGI HTTP Server for production
gevent==24.11.1                 # Async worker support

# Utilities
click==8.1.8                    # Command line interface creation
itsdangerous==2.2.0             # Secure data serialization
Jinja2==3.1.5                   # Template engine
MarkupSafe==3.0.2               # Safe string handling

# Data Export and Processing
openpyxl==3.1.5                 # Excel file generation for attendance reports
pandas==2.2.3                   # Data manipulation for reports (optional)

# HTTP Requests (for potential integrations)
requests==2.32.3                # HTTP library for external API calls

# Google Maps Integration
googlemaps==4.10.0              # Google Maps API client

# Caching (optional for performance)
Flask-Caching==2.3.0            # Caching support for Flask

# Logging and Monitoring (optional)
python-json-logger==3.2.1       # Structured logging support

# Cryptography dependencies (required for some MySQL features)
cryptography==44.0.0            # Required for MySQL SSL connections

# Employee Synchronization Dependencies
schedule==1.2.2                 # For automated scheduling

jwt