qshub / api /projects.py
basel00omar's picture
fix: wait out the 60s cooldown instead of silently failing extraction when keys are rate-limited
e9f689e
Raw History Blame
7.28 kB
from fastapi import APIRouter, HTTPException, Depends
from pydantic import BaseModel
from typing import Optional, Dict, Any
from utils.db import safe_query, safe_execute
from api.auth import get_current_user
from engine.project_history import save_project, load_all_projects
router = APIRouter()
class SaveProjectReq(BaseModel):
project_id: Optional[int] = None
project_name: str
state_data: Optional[Dict[str, Any]] = None
boq_data: Optional[Dict[str, Any]] = None
current_step: int = 1
@router.get("")
@router.get("/")
async def list_projects(current_user: dict = Depends(get_current_user)):
projects = load_all_projects(current_user["id"])
return projects
@router.get("/active")
async def get_active_project(project_id: Optional[int] = None, current_user: dict = Depends(get_current_user)):
if project_id:
df = safe_query("SELECT current_step, updated_at, state_data FROM qto_active_projects WHERE user_id=%s AND project_id=%s", (current_user["id"], project_id))
else:
df = safe_query("SELECT current_step, updated_at, state_data, project_id FROM qto_active_projects WHERE user_id=%s ORDER BY updated_at DESC LIMIT 1", (current_user["id"],))
if df.empty:
return {"has_active": False}
row = df.iloc[0]
import json as _json
from api.routers.data_review import reconstruct_project_inputs
raw = row["state_data"]
state_data = _json.loads(raw) if isinstance(raw, str) else (raw or {})
if state_data.get("current_step", 0) >= 3:
reconstruct_project_inputs(state_data)
safe_execute(
"UPDATE qto_active_projects SET state_data=%s WHERE user_id=%s AND project_id=%s",
(_json.dumps(state_data, ensure_ascii=False, default=str), current_user["id"], row.get("project_id") or project_id)
)
res = {
"has_active": True,
"current_step": int(row["current_step"]),
"updated_at": row["updated_at"],
"state_data": state_data
}
if "project_id" in row:
res["project_id"] = int(row["project_id"])
return res
@router.delete("/active")
async def clear_active_project(project_id: Optional[int] = None, current_user: dict = Depends(get_current_user)):
if project_id:
success, err = safe_execute("DELETE FROM qto_active_projects WHERE user_id = %s AND project_id = %s", (current_user["id"], project_id))
else:
success, err = safe_execute("DELETE FROM qto_active_projects WHERE user_id = %s", (current_user["id"],))
if not success:
raise HTTPException(status_code=500, detail=f"Database clear failed: {err}")
return {"message": "Active project state cleared."}
@router.post("")
@router.post("/")
async def save_project_route(req: SaveProjectReq, current_user: dict = Depends(get_current_user)):
# Load existing state to merge
existing_state = {}
project_id = req.project_id
is_new_project = False
if project_id:
df_state = safe_query("SELECT state_data FROM qto_active_projects WHERE user_id=%s AND project_id=%s", (current_user["id"], project_id))
if not df_state.empty and df_state.iloc[0]["state_data"]:
try:
import json as json_lib
existing_state = json_lib.loads(df_state.iloc[0]["state_data"])
except Exception as ex:
print(f"Error parsing existing state: {ex}")
else:
is_new_project = True
# Merge states
def merge_states(existing: dict, incoming: dict) -> dict:
if not existing:
return incoming
if not incoming:
return existing
merged = existing.copy()
for k, v in incoming.items():
if k == "confirmed_auto_data" and isinstance(v, dict):
existing_confirmed = merged.get("confirmed_auto_data") or {}
new_confirmed = v.copy()
# If structured keys are empty/falsy in incoming, preserve existing database ones
for struct_key in ["floors", "walls", "schedules", "openings"]:
if not new_confirmed.get(struct_key) and existing_confirmed.get(struct_key):
new_confirmed[struct_key] = existing_confirmed[struct_key]
merged["confirmed_auto_data"] = new_confirmed
else:
merged[k] = v
return merged
state_to_save = merge_states(existing_state, req.state_data or {})
pid = save_project(
project_name=req.project_name,
boq_data=req.boq_data or {},
user_id=current_user["id"],
state_data=state_to_save,
current_step=req.current_step,
project_id=req.project_id
)
if pid is None:
raise HTTPException(status_code=500, detail="Failed to save project.")
# Update active project state table as well
import json
state_json = json.dumps(state_to_save, ensure_ascii=False, default=str)
from utils.db import is_sqlite
if is_sqlite():
safe_execute(
"""
INSERT INTO qto_active_projects (user_id, project_id, current_step, state_data)
VALUES (%s, %s, %s, %s)
ON CONFLICT(user_id, project_id) DO UPDATE SET
current_step=excluded.current_step,
state_data=excluded.state_data,
updated_at=datetime('now', 'localtime')
""",
(current_user["id"], pid, req.current_step, state_json)
)
else:
safe_execute(
"""
INSERT INTO qto_active_projects (user_id, project_id, current_step, state_data)
VALUES (%s, %s, %s, %s)
ON DUPLICATE KEY UPDATE current_step=%s, state_data=%s, updated_at=CURRENT_TIMESTAMP
""",
(current_user["id"], pid, req.current_step, state_json, req.current_step, state_json)
)
if is_new_project:
from utils.usage import EVENT_PROJECT, log_usage
log_usage(current_user["id"], EVENT_PROJECT, metadata={"project_id": pid, "project_name": req.project_name})
return {"message": "Project saved successfully.", "project_id": pid}
@router.get("/{project_id}")
async def get_project(project_id: int, current_user: dict = Depends(get_current_user)):
df = safe_query(
"SELECT id, name, date, boq_data, state_data, current_step FROM qto_projects WHERE id=%s AND user_id=%s",
(project_id, current_user["id"])
)
if df.empty:
raise HTTPException(status_code=404, detail="Project not found.")
row = df.iloc[0]
return {
"id": int(row["id"]),
"name": row["name"],
"date": row["date"],
"boq_data": row["boq_data"],
"state_data": row["state_data"],
"current_step": int(row["current_step"]) if row["current_step"] else 1
}
@router.delete("/{project_id}")
async def delete_project(project_id: int, current_user: dict = Depends(get_current_user)):
success, err = safe_execute(
"DELETE FROM qto_projects WHERE id=%s AND user_id=%s",
(project_id, current_user["id"])
)
if not success:
raise HTTPException(status_code=500, detail=f"Database delete failed: {err}")
return {"message": "Project deleted successfully."}