## Web Framework & API
fastapi==0.104.1
uvicorn==0.23.2
python-multipart==0.0.6
httpx==0.25.0
pydantic==1.10.13  # Ältere Version ohne Rust-Abhängigkeit
email-validator==2.0.0  # Required by Pydantic for email validation
slowapi==0.1.8     # For rate limiting

## Authentication & Security
python-jose[cryptography]==3.3.0  # For JWT tokens
passlib==1.7.4
argon2-cffi>=21.3.0 # Für Passwort-Hashing in gateway_interface.py
google-auth-oauthlib==1.2.0  # Für Google OAuth
google-auth==2.27.0         # Für Google Authentication
google-api-python-client==2.170.0  # For Google API integration
bcrypt==4.0.1              # For password hashing

## Database
mysql-connector-python==8.1.0

## PDF & Document Processing
reportlab==4.0.4
PyMuPDF>=1.23.7     # Statt dem ungenauen 'fitz'
PyPDF2==3.0.1
python-docx>=0.8.11 # Für Word-Dokumente
openpyxl>=3.1.2     # Für Excel-Dateien
python-pptx>=0.6.21 # Für PowerPoint-Dateien

## Data Processing & Analysis
numpy==1.26.3       # Version die mit pandas und matplotlib kompatibel ist
pandas==2.2.3       # Aktuelle Version beibehalten

## Data Visualization
matplotlib==3.8.0   # Aktuelle Version beibehalten
seaborn==0.13.0
markdown

## Web Scraping & HTTP
beautifulsoup4==4.12.2  # Required for HTML/XML parsing
requests==2.31.0
chardet>=5.0.0      # Für Zeichensatzerkennung bei Webinhalten
aiohttp>=3.8.0      # Required for SharePoint operations (async HTTP)
selenium>=4.15.0    # Required for web automation and JavaScript-heavy pages
tavily-python==0.7.11  # Tavily SDK
Office365-REST-Python-Client==2.6.2  # Easy Sharepoint integration

## Image Processing
Pillow>=10.0.0      # Für Bildverarbeitung (als PIL importiert)

## Utilities & Timezone Support
python-dateutil==2.8.2
python-dotenv==1.0.0
pytz>=2023.3        # For timezone handling and UTC operations

## Dependencies for trio (used by httpx)
sortedcontainers>=2.4.0     # Required by trio

## MSFT Integration
msal==1.24.1

# Enhanced Office document processing
python-docx>=0.8.11
openpyxl>=3.0.9
python-pptx>=0.6.21
xlrd>=2.0.1  # For legacy .xls files
Pillow>=9.0.0  # For image processing
PyPDF2>=3.0.0
PyMuPDF>=1.20.0
beautifulsoup4>=4.11.0
chardet>=4.0.0  # For encoding detection

## Testing Dependencies
pytest>=8.0.0
pytest-asyncio>=0.21.0

## For Scheduling / Repeated Tasks
APScheduler==3.11.0

## Missing Dependencies for IPython and other tools
decorator>=5.0.0
jedi>=0.16
matplotlib-inline>=0.1.0
stack-data>=0.1.0
traitlets>=5.0.0
docutils>=0.13.1
markdown-it-py>=2.2.0
keyring>=15.1
pkginfo>=1.8.1

## Missing Dependencies for Panel 1.3.8
bleach>=4.0.0
bokeh>=3.2.0,<3.4.0
linkify-it-py>=1.0.0
mdit-py-plugins>=0.3.0
pyviz-comms>=2.0.0
xyzservices>=2021.09.1

# PostgreSQL connector dependencies
psycopg2-binary==2.9.9
