settings.py

import os


class Config(object):
    """Base configuration"""

    PROJECT_ROOT = os.path.abspath(os.path.dirname(__file__))
    SQLALCHEMY_TRACK_MODIFICATIONS = False
    SWAGGER_UI_DOC_EXPANSION = "list"
    # pool_pre_ping should help handle DB connection drops
    SQLALCHEMY_ENGINE_OPTIONS = {"pool_pre_ping": True}


class ProductionConfig(Config):
    """Production configuration"""

    # if deployed to Fly.io, injected env var DATABASE_URL is used
    conn = os.environ.get("DATABASE_URL")
    if conn is None:
        conn = (
            "postgresql://"
            + os.environ.get("DB_USER", "")
            + ":"
            + os.environ.get("DB_PASSWORD", "")
            + "@"
            + os.environ.get("DB_HOST", "")
            + ":"
            + os.environ.get("DB_PORT", "")
            + "/"
            + os.environ.get("DB_NAME", "")
        )
    else:
        if conn.startswith("postgres://"):
            conn = conn.replace("postgres://", "postgresql://", 1)

    SQLALCHEMY_DATABASE_URI = conn


class TestingConfig(Config):
    """Testing configuration"""

    DEBUG = True
    TESTING = True
    SQLALCHEMY_DATABASE_URI = "sqlite:///:memory:"
    os.environ["API_KEY"] = "12345678"


class DevelopmentConfig(Config):
    """Development configuration"""

    DEBUG = True
    DB_NAME = "dev.db"
    DB_PATH = os.path.join(Config.PROJECT_ROOT, DB_NAME)
    SQLALCHEMY_DATABASE_URI = "sqlite:///{0}".format(DB_PATH)


class WithoutPersistentDatabaseConfig(Config):
    """Development configuration"""

    DB_NAME = "dev.db"
    DB_PATH = os.path.join(Config.PROJECT_ROOT, DB_NAME)
    SQLALCHEMY_DATABASE_URI = "sqlite:///{0}".format(DB_PATH)

config_dict = {
    "dev": DevelopmentConfig,
    "test": TestingConfig,
    "without_persistent_database": WithoutPersistentDatabaseConfig,
    "prod": ProductionConfig,
}