1 files changed, 17 insertions, 0 deletions
diff --git a/Biz/PodcastItLater/Core.py b/Biz/PodcastItLater/Core.py
index f32e81b..9e3f830 100644
--- a/Biz/PodcastItLater/Core.py
+++ b/Biz/PodcastItLater/Core.py
@@ -323,6 +323,23 @@ class Database:  # noqa: PLR0904
             return [dict(row) for row in rows]
 
     @staticmethod
+    def get_episode_by_id(episode_id: int) -> dict[str, Any] | None:
+        """Fetch single episode by ID."""
+        with Database.get_connection() as conn:
+            cursor = conn.cursor()
+            cursor.execute(
+                """
+                SELECT id, title, audio_url, duration, created_at,
+                       content_length, author, original_url, user_id
+                FROM episodes
+                WHERE id = ?
+            """,
+                (episode_id,),
+            )
+            row = cursor.fetchone()
+            return dict(row) if row is not None else None
+
+    @staticmethod
     def get_all_episodes(
         user_id: int | None = None,
     ) -> list[dict[str, Any]]: