codeverseinnovation
updarte code
9f99698
Raw History Blame Contribute Delete
1.89 kB
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):
"""
Task model extended for AI agent integration.
Validation rules:
- Title must not be empty
- User_id must reference existing user
- Task cannot be completed before creation
"""
__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