diff options
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() |
