.env.example

# Django System Config
DJANGO_SECRET_KEY=django-insecure-change-this-in-production
DEBUG=True
ALLOWED_HOSTS=localhost,127.0.0.1

# Management Database — stores users, questions, assessments, results
# Leave DB_NAME unset to fall back to SQLite (no other vars needed).
DB_NAME=QueryBench
DB_HOST=localhost\SQLEXPRESS
DB_PORT=1433

# SQL Server Authentication (username + password)
# If DB_USER is set, SQL auth is used. If omitted, Windows auth is used instead.
DB_USER=sa
DB_PASSWORD=yourpassword

# Evaluation Target Database — the DB participants run queries against
ASSESSMENT_DB_PRIMARY_CONN=Driver={ODBC Driver 17 for SQL Server};Server=localhost;Database=AssessmentDB;UID=sa;PWD=yourpassword;
QUERY_TIMEOUT_SECONDS=5
MAX_RESULT_ROWS=5000

# Cache backend — leave blank to use in-process LocMemCache (dev/single-worker).
# Set to a Redis URL for multi-worker production deployments.
# Rate limiting and async job state are shared across workers only when Redis is configured.
REDIS_URL=

# Fernet key for encrypting DB passwords at rest.
# Generate with: python -c "from cryptography.fernet import Fernet; print(Fernet.generate_key().decode())"
DB_FIELD_ENCRYPTION_KEY=