Debian Codegraph @

docs/examples/data_transfer_objects/factory/excluding_fields.py

raw
1 from datetime import datetime
2 from typing import List
3 from uuid import UUID
4
5 from sqlalchemy import ForeignKey
6 from sqlalchemy.orm import Mapped, mapped_column, relationship
7 from typing_extensions import Annotated
8
9 from litestar import Litestar, post
10 from litestar.dto import DTOConfig, dto_field
11 from litestar.plugins.sqlalchemy import SQLAlchemyDTO
12
13 from .my_lib import Base
14
15
16 class Address(Base):
17 street: Mapped[str]
18 city: Mapped[str]
19 state: Mapped[str]
20 zip: Mapped[str]
21
22
23 class Pets(Base):
24 name: Mapped[str]
25 user_id: Mapped[UUID] = mapped_column(ForeignKey("user.id"))
26
27
28 class User(Base):
29 name: Mapped[str]
30 password: Mapped[str] = mapped_column(info=dto_field("private"))
31 created_at: Mapped[datetime] = mapped_column(info=dto_field("read-only"))
32 address_id: Mapped[UUID] = mapped_column(ForeignKey("address.id"), info=dto_field("private"))
33 address: Mapped[Address] = relationship(info=dto_field("read-only"))
34 pets: Mapped[List[Pets]] = relationship(info=dto_field("read-only"))
35
36
37 UserDTO = SQLAlchemyDTO[User]
38 config = DTOConfig(
39 exclude={
40 "id",
41 "address.id",
42 "address.street",
43 "pets.0.id",
44 "pets.0.user_id",
45 }
46 )
47 ReadUserDTO = SQLAlchemyDTO[Annotated[User, config]]
48
49
50 @post("/users", dto=UserDTO, return_dto=ReadUserDTO, sync_to_thread=False)
51 def create_user(data: User) -> User:
52 data.created_at = datetime.min
53 data.address = Address(street="123 Main St", city="Anytown", state="NY", zip="12345")
54 data.pets = [Pets(id=1, name="Fido"), Pets(id=2, name="Spot")]
55 return data
56
57
58 app = Litestar(route_handlers=[create_user])
59
60 # run: /users -H "Content-Type: application/json" -d '{"name":"Litestar User","password":"xyz","created_at":"2023-04-24T00:00:00Z"}'