# SPDX-FileCopyrightText: 2026 Dennis Fink # # 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()