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