Improve publication fetching for datatables.

1 files changed, 0 insertions, 26 deletions

diff --git a/uploader/publications/models.py b/uploader/publications/models.py
index f4e8d33..b199991 100644
--- a/uploader/publications/models.py
+++ b/uploader/publications/models.py
@@ -69,32 +69,6 @@ def update_publications(conn: Connection , publications: tuple[dict, ...]) -> tu
     return tuple()
 
 
-def fetch_publications(
-        conn: Connection,
-        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 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)
-        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: