diff options
| author | Dennis Fink | 2026-11-13 21:20:40 +0100 |
|---|---|---|
| committer | Dennis Fink | 2026-11-13 21:20:40 +0100 |
| commit | a285fdf29e59c3b957247ea9241943c7202e9a28 (patch) | |
| tree | 17ceeb703de23af1e67081d99a8864bbe353fb46 /tests/test_db_helpers.py | |
| parent | 78ecd8bc227bdcbbd0e45eea025f7223252ed0da (diff) | |
| download | webmentions-ssg-a285fdf29e59c3b957247ea9241943c7202e9a28.tar.gz webmentions-ssg-a285fdf29e59c3b957247ea9241943c7202e9a28.zip | |
refactor(core): consolidate repeated helper logic
Centralize SQL row counts, hostname parsing, and content-type
normalization so tasks, forms, and scanners share consistent
implementations.
Simplify periodic task registration and admin lookups with table-driven
setup and Flask-SQLAlchemy's built-in 404 helper.
Diffstat (limited to '')
| -rw-r--r-- | tests/test_db_helpers.py | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/tests/test_db_helpers.py b/tests/test_db_helpers.py new file mode 100644 index 0000000..ac97f2b --- /dev/null +++ b/tests/test_db_helpers.py @@ -0,0 +1,28 @@ +# SPDX-FileCopyrightText: 2026 Dennis Fink <me+coding@dennisfink.me> +# +# SPDX-License-Identifier: BSD-3-Clause + +"""Regression tests for shared SQLAlchemy row-count handling.""" + +from sqlalchemy import create_engine, text + +from webmentions_ssg.db_helpers import rows_affected + + +def test_rows_affected_for_update_and_delete() -> None: + engine = create_engine("sqlite://") + try: + with engine.begin() as connection: + connection.execute(text("CREATE TABLE entries (id INTEGER PRIMARY KEY)")) + connection.execute(text("INSERT INTO entries (id) VALUES (1)")) + + result = connection.execute(text("UPDATE entries SET id = 2 WHERE id = 1")) + assert rows_affected(result) == 1 + + result = connection.execute(text("DELETE FROM entries WHERE id = 1")) + assert rows_affected(result) == 0 + + result = connection.execute(text("DELETE FROM entries WHERE id = 2")) + assert rows_affected(result) == 1 + finally: + engine.dispose() |
