Spaces:
Sleeping
Sleeping
File size: 3,780 Bytes
f10fe83 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 | import sqlite3
import json
import logging
from datetime import datetime
from typing import List, Optional
from pathlib import Path
logger = logging.getLogger(__name__)
DB_PATH = Path(__file__).parent.parent / "nexusai_history.db"
def _safe_json_loads(data: str) -> List[dict]:
if not data:
return []
try:
return json.loads(data)
except (json.JSONDecodeError, TypeError) as e:
logger.warning(f"Failed to parse JSON from database: {e}")
return []
def get_connection():
return sqlite3.connect(DB_PATH, check_same_thread=False)
def init_db():
conn = get_connection()
cursor = conn.cursor()
cursor.execute("""
CREATE TABLE IF NOT EXISTS research_history (
id INTEGER PRIMARY KEY AUTOINCREMENT,
query TEXT NOT NULL,
answer TEXT,
sources TEXT,
trace TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)
""")
conn.commit()
conn.close()
def save_research(query: str, answer: str, sources: List[dict], trace: List[str] = None) -> int:
conn = get_connection()
cursor = conn.cursor()
sources_json = json.dumps(sources)
trace_json = json.dumps(trace if trace else [])
cursor.execute(
"INSERT INTO research_history (query, answer, sources, trace) VALUES (?, ?, ?, ?)",
(query, answer, sources_json, trace_json),
)
conn.commit()
research_id = cursor.lastrowid
conn.close()
return research_id
def get_all_research(limit: int = 50) -> List[dict]:
conn = get_connection()
cursor = conn.cursor()
cursor.execute(
"SELECT id, query, answer, sources, created_at, trace FROM research_history ORDER BY created_at DESC LIMIT ?",
(limit,),
)
rows = cursor.fetchall()
conn.close()
results = []
for row in rows:
results.append(
{
"id": row[0],
"query": row[1],
"answer": row[2],
"sources": _safe_json_loads(row[3]),
"created_at": row[4],
"trace": _safe_json_loads(row[5]),
}
)
return results
def get_research_by_id(research_id: int) -> Optional[dict]:
conn = get_connection()
cursor = conn.cursor()
cursor.execute(
"SELECT id, query, answer, sources, created_at, trace FROM research_history WHERE id = ?",
(research_id,),
)
row = cursor.fetchone()
conn.close()
if row:
return {
"id": row[0],
"query": row[1],
"answer": row[2],
"sources": _safe_json_loads(row[3]),
"created_at": row[4],
"trace": _safe_json_loads(row[5]),
}
return None
def delete_research(research_id: int) -> bool:
conn = get_connection()
cursor = conn.cursor()
cursor.execute("DELETE FROM research_history WHERE id = ?", (research_id,))
deleted = cursor.rowcount > 0
conn.commit()
conn.close()
return deleted
def search_history(search_term: str, limit: int = 20) -> List[dict]:
conn = get_connection()
cursor = conn.cursor()
cursor.execute(
"SELECT id, query, answer, sources, created_at, trace FROM research_history WHERE query LIKE ? ORDER BY created_at DESC LIMIT ?",
(f"%{search_term}%", limit),
)
rows = cursor.fetchall()
conn.close()
results = []
for row in rows:
results.append(
{
"id": row[0],
"query": row[1],
"answer": row[2],
"sources": _safe_json_loads(row[3]),
"created_at": row[4],
"trace": _safe_json_loads(row[5]),
}
)
return results
init_db()
|