File size: 3,003 Bytes
507973e
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
from datetime import datetime
from typing import Optional

from pydantic import field_validator
from sqlalchemy import ARRAY, String
from sqlmodel import Column, Field, SQLModel


class Todo(SQLModel, table=True):
    id: int | None = Field(default=None, primary_key=True)
    title: str = Field(index=True)
    description: str | None = Field(default=None)
    completed: bool = False
    user_id: str = Field(foreign_key="user.id", index=True)  # UUID string to match Better Auth
    created_at: datetime = Field(
        default_factory=datetime.utcnow  # Timezone-naive for PostgreSQL TIMESTAMP
    )
    updated_at: datetime = Field(
        default_factory=datetime.utcnow  # Timezone-naive for PostgreSQL TIMESTAMP
    )
    # --- Phase V fields ---
    priority: str = Field(default="medium")  # high | medium | low
    tags: list[str] = Field(default_factory=list, sa_column=Column(ARRAY(String)))
    due_date: datetime | None = Field(default=None)
    reminder_at: datetime | None = Field(default=None)
    recurrence: str = Field(default="none")  # none | daily | weekly | monthly
    parent_id: int | None = Field(default=None, foreign_key="todo.id")


class TodoCreate(SQLModel):
    title: str
    description: str | None = None
    priority: str = "medium"
    tags: list[str] = Field(default_factory=list)
    due_date: datetime | None = None
    reminder_at: datetime | None = None
    recurrence: str = "none"

    @field_validator("title")
    @classmethod
    def title_length(cls, v: str) -> str:
        if not v or len(v) > 200:
            raise ValueError("Title must be 1-200 characters")
        return v

    @field_validator("description")
    @classmethod
    def description_length(cls, v: str | None) -> str | None:
        if v is not None and len(v) > 1000:
            raise ValueError("Description must be 1000 characters or fewer")
        return v

    @field_validator("priority")
    @classmethod
    def priority_valid(cls, v: str) -> str:
        if v not in ("high", "medium", "low"):
            raise ValueError("Priority must be high, medium, or low")
        return v

    @field_validator("recurrence")
    @classmethod
    def recurrence_valid(cls, v: str) -> str:
        if v not in ("none", "daily", "weekly", "monthly"):
            raise ValueError("Recurrence must be none, daily, weekly, or monthly")
        return v


class TodoUpdate(SQLModel):
    title: str | None = None
    description: str | None = None
    completed: bool | None = None
    priority: str | None = None
    tags: list[str] | None = None
    due_date: Optional[datetime] = None
    reminder_at: Optional[datetime] = None
    recurrence: str | None = None


class TodoRead(SQLModel):
    id: int
    title: str
    description: str | None
    completed: bool
    user_id: str
    priority: str
    tags: list[str]
    due_date: datetime | None
    reminder_at: datetime | None
    recurrence: str
    parent_id: int | None
    created_at: datetime
    updated_at: datetime