From 2a2ff0749f18670ab82c304c8c3468aeea47846f Mon Sep 17 00:00:00 2001 From: Ben Sima Date: Thu, 4 Sep 2025 14:07:47 -0400 Subject: Add Default Titles for Queue Items Implement a migration to add default titles to queue items with NULL titles. This ensures that every queue item has a meaningful title, improving user experience and data consistency. The migration updates items with 'Untitled Article' when no title is present. --- Biz/PodcastItLater/Core.py | 27 +++++++++++++++++++++++++++ 1 file changed, 27 insertions(+) (limited to 'Biz/PodcastItLater/Core.py') diff --git a/Biz/PodcastItLater/Core.py b/Biz/PodcastItLater/Core.py index 1756fc6..278b97e 100644 --- a/Biz/PodcastItLater/Core.py +++ b/Biz/PodcastItLater/Core.py @@ -128,6 +128,9 @@ class Database: # noqa: PLR0904 # Run migration to add user status field Database.migrate_add_user_status(db_path) + # Run migration to add default titles + Database.migrate_add_default_titles(db_path) + @staticmethod def add_to_queue( # noqa: PLR0913, PLR0917 url: str, @@ -588,6 +591,30 @@ class Database: # noqa: PLR0904 conn.commit() logger.info("Database migrated to support user status") + @staticmethod + def migrate_add_default_titles(db_path: str | None = None) -> None: + """Add default titles to queue items that have None titles.""" + if db_path is None: + db_path = Database.get_default_db_path() + with Database.get_connection(db_path) as conn: + cursor = conn.cursor() + + # Update queue items with NULL titles to have a default + cursor.execute(""" + UPDATE queue + SET title = 'Untitled Article' + WHERE title IS NULL + """) + + # Get count of updated rows + updated_count = cursor.rowcount + + conn.commit() + logger.info( + "Updated %s queue items with default titles", + updated_count, + ) + @staticmethod def create_user(email: str, db_path: str | None = None) -> tuple[int, str]: """Create a new user and return (user_id, token). -- cgit v1.2.3