Spaces:
Sleeping
Sleeping
File size: 1,678 Bytes
a7a252e | 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 | 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 |