# Alembic Configuration — FastAPI Data Gateway
# -----------------------------------------------
# Run migrations:
#   alembic upgrade head          (apply all pending)
#   alembic downgrade -1          (roll back one step)
#   alembic revision --autogenerate -m "description"   (generate new migration)

[alembic]
# Path to migration scripts
script_location = alembic

# Template for new revision filenames
# %%(year)d%%(month).2d%%(day).2d_%%(rev)s_%%(slug)s.py
file_template = %%(year)d%%(month).2d%%(day).2d_%%(rev)s_%%(slug)s

# sys.path addition for finding your app package
prepend_sys_path = .

# Timezone for migration file timestamps — leave unset to use local time
# timezone = UTC

# Max length of slug in filename
truncate_slug_length = 40

# Revision identifier sorting — numeric for deterministic order
revision_environment = false

# Whether to compare server defaults in autogenerate
compare_server_default = false

# --- DATABASE URL ---
# Override this with DATABASE_URL env var in env.py (do NOT hardcode here)
# sqlalchemy.url is left empty; env.py reads from os.environ["DATABASE_URL"]
sqlalchemy.url =

# --- Logging ---
[loggers]
keys = root,sqlalchemy,alembic

[handlers]
keys = console

[formatters]
keys = generic

[logger_root]
level = WARN
handlers = console
qualname =

[logger_sqlalchemy]
level = WARN
handlers =
qualname = sqlalchemy.engine

[logger_alembic]
level = INFO
handlers =
qualname = alembic

[handler_console]
class = StreamHandler
args = (sys.stderr,)
level = NOTSET
formatter = generic

[formatter_generic]
format = %(levelname)-5.5s [%(name)s] %(message)s
datefmt = %H:%M:%S