# =============================================================================
# Alembic 設定檔
# =============================================================================
# Alembic 是 SQLAlchemy 官方推薦的 migration 工具。
# Migration 是「如何把資料庫從舊版本升級到新版本」的腳本。
#
# 常用指令(在 docker compose 裡執行):
#   docker compose exec api alembic revision --autogenerate -m "描述"
#       └─ 比對 Model 跟資料庫差異,自動產生升級腳本
#
#   docker compose exec api alembic upgrade head
#       └─ 把資料庫升級到最新版本
#
#   docker compose exec api alembic downgrade -1
#       └─ 退回上一個版本
#
# DB URL 不寫在這裡,改在 alembic/env.py 從 settings 讀(才有 .env 支援)
# =============================================================================

[alembic]
script_location = alembic
prepend_sys_path = .
version_path_separator = os
sqlalchemy.url =


[post_write_hooks]


[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