from datetime import datetime from uuid import UUID, uuid4 from sqlmodel import SQLModel, Field from sqlalchemy import Column, String, Text, ForeignKey, Boolean from typing import Optional class TaskBase(SQLModel): title: str = Field( sa_column=Column(String(200), nullable=False) ) description: Optional[str] = Field( default=None, sa_column=Column(Text, nullable=True) ) user_id: UUID = Field( sa_column=Column( ForeignKey("users.id", ondelete="CASCADE"), nullable=False, index=True ) ) class Task(TaskBase, table=True): __tablename__ = "tasks" id: UUID = Field(default_factory=uuid4, primary_key=True) title: str = Field( sa_column=Column(String(200), nullable=False) ) description: Optional[str] = Field( default=None, sa_column=Column(Text, nullable=True) ) user_id: UUID = Field( sa_column=Column( ForeignKey("users.id", ondelete="CASCADE"), nullable=False, index=True ) ) is_completed: bool = Field( default=False, sa_column=Column(Boolean, nullable=False, default=False) ) created_at: datetime = Field(default_factory=datetime.utcnow, nullable=False) updated_at: datetime = Field(default_factory=datetime.utcnow, nullable=False) class TaskCreate(TaskBase): title: str description: Optional[str] = None class TaskUpdate(SQLModel): title: Optional[str] = None description: Optional[str] = None class TaskRead(TaskBase): id: UUID is_completed: bool created_at: datetime updated_at: datetime