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
|
from sqlalchemy import Column
from sqlalchemy import Integer
from sqlalchemy import String
from sqlalchemy.orm import declarative_base
from sqlalchemy.orm import registry
from sqlalchemy.sql.schema import ForeignKey
from sqlalchemy.sql.schema import MetaData
from sqlalchemy.sql.schema import Table
Base = declarative_base()
class Foo(Base):
__tablename__ = "foo"
id: int = Column(Integer(), primary_key=True)
name: str = Column(String)
class Bar(Foo):
__tablename__ = "bar"
id: int = Column(ForeignKey("foo.id"), primary_key=True)
class Bat(Foo):
pass
m0: MetaData = Base.metadata
r0: registry = Base.registry
t1: Table = Foo.__table__
m1: MetaData = Foo.metadata
t2: Table = Bar.__table__
m2: MetaData = Bar.metadata
t3: Table = Bat.__table__
m3: MetaData = Bat.metadata
|
