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 Column
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 relationship
Base = declarative_base()
class User(Base):
__tablename__ = "user"
id = Column(Integer, primary_key=True)
name = Column(String)
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 = Column(Integer, primary_key=True)
user_id: int = Column(ForeignKey("user.id"))
user: "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))
|
