app/config.py

from pydantic import BaseModel
import os

def _default_sqlite_url() -> str:
    """
    /data があれば最優先（HF Spacesの永続領域）
    次に /tmp（Cloud Run等の書込可領域）
    最後にカレント（ローカル）
    """
    candidates = ["/data/app.db", "/tmp/app.db", "./app.db"]
    for path in candidates:
        try:
            dirpath = os.path.dirname(path) or "."
            os.makedirs(dirpath, exist_ok=True)
            # 書き込み可能か簡易チェック（touch → 削除）
            probe = path + ".touch"
            with open(probe, "w") as f:
                f.write("ok")
            os.remove(probe)
            return f"sqlite+pysqlite:///{path}"
        except Exception:
            continue
    # 最後の砦
    return "sqlite+pysqlite:///./app.db"

class Settings(BaseModel):
    APP_ENV: str = os.getenv("APP_ENV", "dev")
    SECRET_KEY: str = os.getenv("SECRET_KEY", "change_me")
    ALLOWED_ORIGINS: str = os.getenv("ALLOWED_ORIGINS", "*")
    BASE_URL: str = os.getenv("BASE_URL", "http://localhost:7860")

    # 未設定なら書込み可能な場所を自動検出
    DATABASE_URL: str = os.getenv("DATABASE_URL", _default_sqlite_url())

    CELERY_BROKER_URL: str = os.getenv("CELERY_BROKER_URL", "")
    CELERY_RESULT_BACKEND: str = os.getenv("CELERY_RESULT_BACKEND", "")

    OPENAI_API_KEY: str = os.getenv("OPENAI_API_KEY", "")
    OPENAI_MODEL: str = os.getenv("OPENAI_MODEL", "gpt-4o-mini")
    OPENAI_TEMPERATURE: float = float(os.getenv("OPENAI_TEMPERATURE", "0.2"))

    SMTP_HOST: str = os.getenv("SMTP_HOST", "")
    SMTP_PORT: int = int(os.getenv("SMTP_PORT", "587"))
    SMTP_USERNAME: str = os.getenv("SMTP_USERNAME", "")
    SMTP_PASSWORD: str = os.getenv("SMTP_PASSWORD", "")
    EMAIL_FROM: str = os.getenv("EMAIL_FROM", "no-reply@example.com")

    X_API_KEY: str = os.getenv("X_API_KEY", "")
    X_API_SECRET: str = os.getenv("X_API_SECRET", "")
    X_ACCESS_TOKEN: str = os.getenv("X_ACCESS_TOKEN", "")
    X_ACCESS_TOKEN_SECRET: str = os.getenv("X_ACCESS_TOKEN_SECRET", "")

    NOTE_WEBHOOK_URL: str = os.getenv("NOTE_WEBHOOK_URL", "")

settings = Settings()