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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
from typing import Any
from typing import Tuple
from sqlalchemy import Column
from sqlalchemy import Integer
from sqlalchemy import select
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import composite
Base = declarative_base()
class Point:
def __init__(self, x: int, y: int):
self.x = x
self.y = y
def __composite_values__(self) -> Tuple[int, int]:
return self.x, self.y
def __repr__(self) -> str:
return "Point(x=%r, y=%r)" % (self.x, self.y)
def __eq__(self, other: Any) -> bool:
return (
isinstance(other, Point)
and other.x == self.x
and other.y == self.y
)
def __ne__(self, other: Any) -> bool:
return not self.__eq__(other)
class Vertex(Base):
__tablename__ = "vertices"
id = Column(Integer, primary_key=True)
x1 = Column(Integer)
y1 = Column(Integer)
x2 = Column(Integer)
y2 = Column(Integer)
# inferred from right hand side
start = composite(Point, x1, y1)
# taken from left hand side
end: Point = composite(Point, x2, y2)
v1 = Vertex(start=Point(3, 4), end=Point(5, 6))
# I'm not even sure composites support this but it should work from a
# typing perspective
stmt = select(Vertex).where(Vertex.start.in_([Point(3, 4)]))
p1: Point = v1.start
p2: Point = v1.end
y3: int = v1.end.y
|
