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
|
from typing import List
from typing import Optional
import sqlalchemy as sa
from sqlalchemy import orm as saorm
Base = saorm.declarative_base()
class B(Base):
__tablename__ = "b"
id = sa.Column(sa.Integer, primary_key=True)
a_id: int = sa.Column(sa.ForeignKey("a.id"))
data = sa.Column(sa.String)
a: Optional["A"] = saorm.relationship("A", back_populates="bs")
class A(Base):
__tablename__ = "a"
id = sa.Column(sa.Integer, primary_key=True)
data = sa.Column(sa.String)
bs = saorm.relationship(B, uselist=True, back_populates="a")
a1 = A(bs=[B(data="b"), B(data="b")])
x: List[B] = a1.bs
b1 = B(a=A())
|
