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