import ssl, os
from App.discovery import discover_models

# Set up SSL context for secure database connections
ssl_context = ssl.create_default_context(ssl.Purpose.SERVER_AUTH)
ssl_context.check_hostname = True
ssl_context.verify_mode = ssl.CERT_REQUIRED

# Discover models
models = discover_models("Model.py")
print("Discovered models:", models)

## for migrations
models.append("aerich.models")

# TORTOISE_ORM = {
#     "connections": {
#         "default": {
#             "engine": "tortoise.backends.asyncpg",
#             "credentials": {
#                 "host": "ep-patient-darkness-a5bmmt9r.us-east-2.aws.neon.tech",
#                 "port": "5432",
#                 "user": "neondb_owner",
#                 "password": "l2kE5dbMyqfx",
#                 "database": "neondb",
#                 "ssl": ssl_context,  # Pass the SSL context here
#             },
#         }
#     },
#     "apps": {
#         "models": {
#             "models": models,
#             "default_connection": "default",
#         }
#     },
# }


TORTOISE_ORM = {
    "connections": {
        "default": {
            "engine": "tortoise.backends.asyncpg",
            "credentials": {
                "host": "aws-0-us-west-1.pooler.supabase.com",
                "port": "5432",
                "user": os.getenv("DB_USER"),
                "password": os.getenv("DB_PASSWORD"),
                "database": "postgres",
                # "ssl": ssl_context,  # Uncomment this if SSL is required
            },
        }
    },
    "apps": {
        "models": {
            "models": models,
            "default_connection": "default",
        }
    },
}