codeverseinnovation
update files
a7a252e
Raw History Blame Contribute Delete
1.68 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):
__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