dto

Command /fastapi:dto

Create Pydantic DTOs (Create, Read, Update) based on SQLAlchemy model.

Instructions

Step 1: Read model

Find and read SQLAlchemy model:

# If path is provided
cat {{ model }}

# If name is provided
grep -r "class {{ model }}" src/

Step 2: Extract fields

Determine:

• All model fields
• Field types
• Nullable fields
• Fields with default values
• Relationships

Step 3: Create DTOs

SQLAlchemy → Pydantic Type Mapping

SQLAlchemy	Pydantic
Integer	int
String	str
Boolean	bool
Float	float
DateTime	datetime
Date	date
Text	str
JSON	dict or list
Enum	Literal[...] or Enum
UUID	uuid.UUID

BaseDTO

"""{{ model }} DTOs."""

from datetime import datetime
from pydantic import BaseModel, ConfigDict, Field


class {{ model }}BaseDTO(BaseModel):
    """Base DTO with common configuration."""

    model_config = ConfigDict(
        from_attributes=True,
        populate_by_name=True,
        str_strip_whitespace=True,
    )

CreateDTO

class {{ model }}CreateDTO({{ model }}BaseDTO):
    """DTO for creating {{ model }}.

    Excludes: id, created_at, updated_at (auto-generated).
    """

    # Required fields (without default)
    name: str = Field(..., min_length=1, max_length=255)
    email: str = Field(..., pattern=r"^[\w\.-]+@[\w\.-]+\.\w+$")

    # Optional fields
    description: str | None = None
    is_active: bool = True

ReadDTO

class {{ model }}ReadDTO({{ model }}BaseDTO):
    """DTO for reading {{ model }}.

    Includes all fields including auto-generated.
    """

    id: int
    name: str
    email: str
    description: str | None
    is_active: bool
    created_at: datetime
    updated_at: datetime | None

UpdateDTO

class {{ model }}UpdateDTO(BaseModel):
    """DTO for updating {{ model }}.

    All fields are optional.
    """

    model_config = ConfigDict(from_attributes=True)

    name: str | None = Field(None, min_length=1, max_length=255)
    email: str | None = Field(None, pattern=r"^[\w\.-]+@[\w\.-]+\.\w+$")
    description: str | None = None
    is_active: bool | None = None