From 60c6f059c3f62807f1a4520e3a0a9af940ebe4af Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Mon, 28 Apr 2025 03:52:35 -0500
Subject: Fetch a publication by its ID.

---
 uploader/publications/models.py | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'uploader/publications/models.py')

diff --git a/uploader/publications/models.py b/uploader/publications/models.py
index 6034c9e..22690f8 100644
--- a/uploader/publications/models.py
+++ b/uploader/publications/models.py
@@ -80,3 +80,11 @@ def fetch_publications(conn: Connection) -> Iterable[dict]:
         cursor.execute("SELECT * FROM Publication")
         for row in cursor.fetchall():
             yield dict(row)
+
+
+def fetch_publication_by_id(conn: Connection, publication_id: int) -> dict:
+    """Fetch a specific publication from the database."""
+    with conn.cursor(cursorclass=DictCursor) as cursor:
+        cursor.execute("SELECT * FROM Publication WHERE Id=%s",
+                       (publication_id,))
+        return dict(cursor.fetchone())
-- 
cgit v1.2.3