config/config.py

import os
from datetime import timedelta


class Config:
    SECRET_KEY = os.environ.get("SECRET_KEY") or "dev-secret-key-change-in-production"
    CRON_SECRET = os.environ.get("CRON_SECRET", "mettez-un-token-tres-complique-ici-12345")
    # PostgreSQL Configuration
    raw_db_url = os.environ.get(
        "DATABASE_URL",
        "postgresql://neondb_owner:npg_2ew9miZStgCn@ep-falling-union-ahdrk8h5-pooler.c-3.us-east-1.aws.neon.tech/neondb"
    )
    
    # Supprimer tous les paramètres SSL de l'URL
    if "?" in raw_db_url:
        raw_db_url = raw_db_url.split("?")[0]
    
    # Utiliser sslmode=prefer au lieu de require pour éviter la validation des certificats
    SQLALCHEMY_DATABASE_URI = f"{raw_db_url}?sslmode=prefer"
    
    SQLALCHEMY_TRACK_MODIFICATIONS = False
    
    # Options du moteur simplifiées
    SQLALCHEMY_ENGINE_OPTIONS = {
        "pool_pre_ping": True,
        "pool_recycle": 300,
        "pool_size": 10,
        "max_overflow": 20,
    }
    
    PERMANENT_SESSION_LIFETIME = timedelta(days=7)
    BASE_URL = os.environ.get("BASE_URL", "http://localhost:5000")

    # Bonus Configuration
    REGISTRATION_BONUS = 1000
    DAILY_LOGIN_BONUS = 30
    REFERRAL_PURCHASE_COMMISSION = 0.15
    REFERRAL_DAILY_GAIN_COMMISSION = 0.03
    
    # Withdrawal Configuration
    WITHDRAWAL_FEE_PERCENTAGE = 0.15
    WITHDRAWAL_DELAY_HOURS = 24
    WITHDRAWAL_MIN_AMOUNT = 500

    # Lygos Payment API Configuration
    LYGOS_API_KEY = os.environ.get(
        "LYGOS_API_KEY", "lygosapp-039b7ab9-5c2d-4fbc-ac5f-70154f5ad5d3"
    )
    LYGOS_CREATE_GATEWAY_URL = "https://api.lygosapp.com/v1/gateway"
    LYGOS_GET_PAYIN_STATUS_URL = "https://api.lygosapp.com/v1/gateway/payin/"
    LYGOS_SHOP_NAME = "Apex OresClone"
    LYGOS_COUNTRIES = {
        "+228": "Togo",
        "+229": "Bénin",
        "+226": "Burkina Faso",
        "+225": "Côte d'Ivoire",
        "+224": "Guinée",
        "+223": "Mali",
        "+221": "Sénégal",
        "+237": "Cameroun",
        "+241": "Gabon",
    }


class DevelopmentConfig(Config):
    DEBUG = True


class ProductionConfig(Config):
    DEBUG = False
    raw_db_url = os.environ.get("DATABASE_URL")
    
    if raw_db_url:
        if "?" in raw_db_url:
            raw_db_url = raw_db_url.split("?")[0]
        SQLALCHEMY_DATABASE_URI = f"{raw_db_url}?sslmode=prefer"
    else:
        raise ValueError("DATABASE_URL must be set in production")


config = {
    "development": DevelopmentConfig,
    "production": ProductionConfig,
    "default": DevelopmentConfig,
}