aboutsummaryrefslogtreecommitdiff
path: root/webmentions_ssg/cli/database.py
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--webmentions_ssg/cli/database.py49
1 files changed, 0 insertions, 49 deletions
diff --git a/webmentions_ssg/cli/database.py b/webmentions_ssg/cli/database.py
deleted file mode 100644
index e918600..0000000
--- a/webmentions_ssg/cli/database.py
+++ /dev/null
@@ -1,49 +0,0 @@
-# SPDX-FileCopyrightText: 2026 Dennis Fink <me+coding@dennisfink.me>
-#
-# SPDX-License-Identifier: BSD-3-Clause
-
-"""Simple database commands built on Flask-Migrate."""
-
-import click
-from flask.cli import AppGroup
-from flask_migrate import upgrade as migrate_upgrade
-from sqlalchemy import inspect
-
-from .. import DATABASE
-
-DB_CLI = AppGroup("db", help="Handle database")
-
-
-def _table_names() -> set[str]:
- """Return existing table names without modifying the database schema."""
- with DATABASE.engine.connect() as connection:
- return set(inspect(connection).get_table_names())
-
-
-@DB_CLI.command("create-db", help="Create a new database using all migrations")
-def create_db() -> None:
- """Initialize an empty database and record its Alembic revision."""
- if _table_names():
- raise click.ClickException(
- "The database already contains tables. "
- "Use 'flask db upgrade' for an existing migrated database."
- )
-
- # Applying migrations (rather than create_all()) keeps alembic_version in sync.
- migrate_upgrade()
- click.echo("Database created at the latest migration revision.")
-
-
-@DB_CLI.command("upgrade", help="Upgrade an existing database to the latest revision")
-def upgrade_db() -> None:
- """Apply pending migrations to a previously initialized database."""
- if "alembic_version" not in _table_names():
- raise click.ClickException(
- "No Flask-Migrate revision table found. "
- "For a new, empty database run 'flask db create-db'. "
- "For a legacy database, inspect its schema and use "
- "'flask migrate stamp' only if appropriate."
- )
-
- migrate_upgrade()
- click.echo("Database upgraded to the latest migration revision.")