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
|
from typing import List
from typing import Optional
from sqlalchemy import ForeignKey
from sqlalchemy import Integer
from sqlalchemy import select
from sqlalchemy import String
from sqlalchemy.orm import declarative_base
from sqlalchemy.orm import Mapped
from sqlalchemy.orm import mapped_column
from sqlalchemy.orm import relationship
Base = declarative_base()
class User(Base):
__tablename__ = "user"
id = mapped_column(Integer, primary_key=True)
name: Mapped[Optional[str]] = mapped_column(String, nullable=True)
addresses: Mapped[List["Address"]] = relationship(
"Address", back_populates="user"
)
@property
def some_property(self) -> List[Optional[int]]:
return [i.id for i in self.addresses]
class Address(Base):
__tablename__ = "address"
id = mapped_column(Integer, primary_key=True)
user_id: Mapped[int] = mapped_column(ForeignKey("user.id"))
user: Mapped["User"] = relationship("User", back_populates="addresses")
@property
def some_other_property(self) -> Optional[str]:
return self.user.name
# it's in the constructor, correct type
u1 = User(addresses=[Address()])
# knows it's an iterable
[x for x in u1.addresses]
# knows it's Mapped
stmt = select(User).where(User.addresses.any(id=5))
|
