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
|
from typing import List
from typing import Optional
from sqlalchemy import Column
from sqlalchemy import Integer
from sqlalchemy import String
from sqlalchemy.ext.declarative import as_declarative
from sqlalchemy.orm import Mapped
from sqlalchemy.orm import relationship
from sqlalchemy.sql.schema import ForeignKey
@as_declarative()
class Base:
updated_at = Column(Integer)
class Foo(Base):
__tablename__ = "foo"
id: int = Column(Integer(), primary_key=True)
name: Mapped[str] = Column(String)
bar: List["Bar"] = relationship("Bar")
class Bar(Base):
__tablename__ = "bar"
id: int = Column(Integer(), primary_key=True)
foo_id: int = Column(ForeignKey("foo.id"))
foo: Optional[Foo] = relationship(Foo)
f1 = Foo()
val: int = f1.id
p: str = f1.name
Foo.id.property
f2 = Foo(name="some name", updated_at=5)
|
