# A generic, single database configuration for Munal LMS.

[alembic]
# Path to migration scripts
script_location = alembic

# Template used to generate migration file names: YYYYMMDD_HHMM_<rev>_<slug>.py
file_template = %%(year)d%%(month).2d%%(day).2d_%%(hour).2d%%(minute).2d_%%(rev)s_%%(slug)s

# Sys.path will be prepended with the project root so "app" can be imported
prepend_sys_path = .

# Timezone for generated dates within migration files and filename templates
timezone = UTC

# Version path separator
version_path_separator = os

# Database URL fallback; dynamically overridden by app.config.settings.DATABASE_URL in alembic/env.py
sqlalchemy.url = postgresql+asyncpg://munal:munal_dev_pass@localhost:5432/munal_lms


[post_write_hooks]
# Post-generation hooks can be added here if needed


# Logging configuration
[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