From fd69f9bc98e730664c4a1c64a095e08c83acf1a3 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Wed, 11 Jun 2025 15:32:35 -0500
Subject: Limit returned results

Limit the number of results returned to make page more
responsive. This is buggy at this point — it doesn't do exactly what I
expect, e.g. when I attempt to scroll, or use pagination, it doesn't
actually display all the pages as expected.
---
 uploader/publications/models.py | 15 +++++++++++----
 1 file changed, 11 insertions(+), 4 deletions(-)

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

diff --git a/uploader/publications/models.py b/uploader/publications/models.py
index 992ebfa..f4e8d33 100644
--- a/uploader/publications/models.py
+++ b/uploader/publications/models.py
@@ -71,16 +71,23 @@ def update_publications(conn: Connection , publications: tuple[dict, ...]) -> tu
 
 def fetch_publications(
         conn: Connection,
-        search: Optional[str] = None
+        search: Optional[str] = None,
+        offset: int = 0,
+        limit: int = -1
 ) -> Iterable[dict]:
     """Fetch publications from the database."""
     _query = "SELECT * FROM Publication"
     _params = None
     if search is not None and bool(search):
         _query = (f"{_query} "
-                  "WHERE CONCAT(PubMed_ID, ' ', Authors, ' ', Title) "
-                  "LIKE %s")
-        _params = (f"%{search}%",)
+                  "WHERE PubMed_ID LIKE %s "
+                  "OR Authors LIKE %s "
+                  "OR Title LIKE %s")
+        _params = (f"%{search}%",) * 3
+
+    if limit > 0:
+        _query = (f"{_query} LIMIT {limit} OFFSET {offset}")
+
     with conn.cursor(cursorclass=DictCursor) as cursor:
         cursor.execute(_query, _params)
         debug_query(_query, logger)
-- 
cgit v1.2.3