Spaces:
Sleeping
Sleeping
File size: 5,624 Bytes
08af9fd | 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 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 | from fastapi import APIRouter, Depends, HTTPException, status, Request
from sqlmodel import Session, select
from typing import List
from ..models import Task, TaskCreate, TaskRead, TaskUpdate, User
from ..database.database import get_session
from ..api.deps import get_current_user
from datetime import datetime
router = APIRouter()
@router.get("/")
async def read_tasks(
current_user: User = Depends(get_current_user),
skip: int = 0,
limit: int = 100,
session: Session = Depends(get_session)
):
"""
Retrieve tasks with Extreme Debugging tier.
"""
print(f"DEBUG: read_tasks triggered for User: {current_user.id}")
try:
if not current_user:
raise Exception("User identity lost during transition")
# Verify Session is active
from sqlalchemy import text
session.execute(text("SELECT 1"))
# Build statement explicitly
statement = select(Task).where(Task.user_id == current_user.id).order_by(Task.created_at.desc()).offset(skip).limit(limit)
print(f"DEBUG: Executing statement: {statement}")
tasks = session.exec(statement).all()
print(f"DEBUG: Found {len(tasks)} tasks")
return tasks
except Exception as e:
import traceback
err_detail = f"System Link Error: {str(e)}\n{traceback.format_exc()}"
print(f"CRITICAL ERROR in read_tasks: {err_detail}")
# Send full detail to frontend for absolute clarity
raise HTTPException(
status_code=500,
detail=f"Neural Log Failure: {str(e)} - Check Backend Logs for Trace"
)
@router.post("/", response_model=TaskRead)
def create_task(
task: TaskCreate,
current_user: User = Depends(get_current_user),
session: Session = Depends(get_session)
):
"""
Create a new task for the current authenticated user.
"""
try:
db_task = Task(
title=task.title,
description=task.description,
completed=task.completed,
priority=task.priority,
category=task.category,
user_id=current_user.id
)
session.add(db_task)
session.commit()
session.refresh(db_task)
return db_task
except Exception as e:
session.rollback()
raise HTTPException(status_code=500, detail=f"Drafting Error: {str(e)}")
@router.delete("/delete-all")
async def delete_all_tasks(
current_user: User = Depends(get_current_user),
session: Session = Depends(get_session)
):
"""
Delete ALL tasks for the current authenticated user.
"""
try:
statement = select(Task).where(Task.user_id == current_user.id)
tasks = session.exec(statement).all()
count = len(tasks)
for task in tasks:
session.delete(task)
session.commit()
return {"message": f"Deleted {count} task(s)", "deleted_count": count}
except Exception as e:
session.rollback()
raise HTTPException(status_code=500, detail=f"Wipe Error: {str(e)}")
@router.get("/{task_id}", response_model=TaskRead)
def read_task(
task_id: int,
current_user: User = Depends(get_current_user),
session: Session = Depends(get_session)
):
"""
Get a specific task by ID.
"""
statement = select(Task).where(Task.id == task_id, Task.user_id == current_user.id)
task = session.exec(statement).first()
if not task:
raise HTTPException(status_code=404, detail="Task not found")
return task
@router.put("/{task_id}", response_model=TaskRead)
def update_task(
task_id: int,
task_update: TaskUpdate,
current_user: User = Depends(get_current_user),
session: Session = Depends(get_session)
):
"""
Update a specific task by ID.
"""
statement = select(Task).where(Task.id == task_id, Task.user_id == current_user.id)
db_task = session.exec(statement).first()
if not db_task:
raise HTTPException(status_code=404, detail="Task not found")
# Update task fields if they are provided
for field, value in task_update.model_dump(exclude_unset=True).items():
setattr(db_task, field, value)
db_task.updated_at = datetime.utcnow()
session.add(db_task)
session.commit()
session.refresh(db_task)
return db_task
@router.delete("/{task_id}")
def delete_task(
task_id: int,
current_user: User = Depends(get_current_user),
session: Session = Depends(get_session)
):
"""
Delete a specific task by ID.
"""
statement = select(Task).where(Task.id == task_id, Task.user_id == current_user.id)
db_task = session.exec(statement).first()
if not db_task:
raise HTTPException(status_code=404, detail="Task not found")
session.delete(db_task)
session.commit()
return {"message": "Task deleted successfully"}
@router.patch("/{task_id}/complete", response_model=TaskRead)
def toggle_task_completion(
task_id: int,
current_user: User = Depends(get_current_user),
session: Session = Depends(get_session)
):
"""
Toggle the completion status of a task.
"""
statement = select(Task).where(Task.id == task_id, Task.user_id == current_user.id)
db_task = session.exec(statement).first()
if not db_task:
raise HTTPException(status_code=404, detail="Task not found")
# Toggle completion status
db_task.completed = not db_task.completed
db_task.updated_at = datetime.utcnow()
session.add(db_task)
session.commit()
session.refresh(db_task)
return db_task |