diff options
| author | Alexander_Kabui | 2025-06-05 14:25:36 +0300 |
|---|---|---|
| committer | BonfaceKilz | 2025-07-07 07:56:57 +0300 |
| commit | f03bb0b3047de47380d3907fb476547e4526e2dd (patch) | |
| tree | eb2f38c602287f9c463b6835101d103eff216c04 | |
| parent | 0976736c8efef8a8620e4713d8cdb0c25aad68a3 (diff) | |
| download | genenetwork3-f03bb0b3047de47380d3907fb476547e4526e2dd.tar.gz | |
feat: Expand previous query search window from 1 to 21 days
* Now searches for previous queries without requiring a user ID.
| -rw-r--r-- | gn3/api/llm.py | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/gn3/api/llm.py b/gn3/api/llm.py index d6cd737..281cd22 100644 --- a/gn3/api/llm.py +++ b/gn3/api/llm.py @@ -60,17 +60,15 @@ def search(auth_token=None): if not fahamu_token: raise LLMError( "Request failed: an LLM authorisation token is required ", query) - user_id = get_user_id(auth_token) database_setup() with db.connection(current_app.config["LLM_DB_PATH"]) as conn: cursor = conn.cursor() previous_answer_query = """ SELECT user_id, task_id, query, results FROM history - WHERE created_at > DATE('now', '-1 day') AND - user_id = ? AND + WHERE created_at > DATE('now', '-21 day') AND query = ? ORDER BY created_at DESC LIMIT 1 """ - res = cursor.execute(previous_answer_query, (user_id, query)) + res = cursor.execute(previous_answer_query, (query,)) previous_result = res.fetchone() if previous_result: _, _, _, response = previous_result @@ -84,6 +82,7 @@ def search(auth_token=None): "answer": answer, "references": refs } + user_id = get_user_id(auth_token) cursor.execute( """INSERT INTO history(user_id, task_id, query, results) VALUES(?, ?, ?, ?) |
