aboutsummaryrefslogtreecommitdiff
path: root/tests/test_db_helpers.py
diff options
context:
space:
mode:
Diffstat (limited to 'tests/test_db_helpers.py')
-rw-r--r--tests/test_db_helpers.py28
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()