From 17ab56a3c7d3dbb3d66edf380ab637a61cefe50c Mon Sep 17 00:00:00 2001 From: Dennis Fink Date: Tue, 27 Oct 2026 23:16:27 +0100 Subject: feat(core): add database CLI Make database initialization and upgrades explicit so new installations cannot silently modify an existing or unversioned schema. Keep Flask-Migrate commands available separately and package the migration environment with the application for reliable deployment. --- webmentions_ssg/__init__.py | 22 ++++++++++------------ 1 file changed, 10 insertions(+), 12 deletions(-) (limited to 'webmentions_ssg/__init__.py') diff --git a/webmentions_ssg/__init__.py b/webmentions_ssg/__init__.py index 3dda31b..7eb8b98 100644 --- a/webmentions_ssg/__init__.py +++ b/webmentions_ssg/__init__.py @@ -9,10 +9,9 @@ from pathlib import Path import coloredlogs from flask import Flask -from flask.cli import AppGroup from flask_bootstrap import Bootstrap5 from flask_mail import Mail -from flask_migrate import Migrate, upgrade +from flask_migrate import Migrate from flask_sqlalchemy import SQLAlchemy from flask_wtf.csrf import CSRFProtect from sqlalchemy.orm import DeclarativeBase @@ -36,8 +35,6 @@ MIGRATE = Migrate() HUEY = Huey() MAIL = Mail() -DB_CLI = AppGroup("db", help="Handle database") - def create_app(config_class: type[DefaultConfig] | None = None) -> Flask: """ @@ -103,7 +100,12 @@ def create_app(config_class: type[DefaultConfig] | None = None) -> Flask: ) DATABASE.init_app(app) - MIGRATE.init_app(app, db=DATABASE) + MIGRATE.init_app( + app, + db=DATABASE, + directory=str(Path(__file__).resolve().parent / "migrations"), + command="migrate", + ) CSRF.init_app(app) MAIL.init_app(app) @@ -134,12 +136,8 @@ def create_app(config_class: type[DefaultConfig] | None = None) -> Flask: app.cli.add_command(MAIL_CLI) - return app + from .cli.database import DB_CLI + app.cli.add_command(DB_CLI) -@DB_CLI.command("create") -def create_db() -> None: - """ - Upgrade the database to the latest migration revision. - """ - upgrade() + return app -- cgit v1.3.1