|
1 | 1 | from sqlalchemy import Table, MetaData, Column, Integer, String, ForeignKey |
2 | | -from sqlalchemy import event |
3 | 2 | from sqlalchemy.orm import mapper, relationship |
4 | 3 |
|
5 | | -from domain_model import Order |
| 4 | +from domain_model import Order, Line |
6 | 5 |
|
7 | 6 |
|
8 | 7 | metadata = MetaData() |
|
19 | 18 | Column('qty', Integer), |
20 | 19 | ) |
21 | 20 |
|
22 | | -from dataclasses import dataclass |
23 | 21 |
|
24 | | -@dataclass |
25 | | -class _DummyOrderLine: |
26 | | - '''dummy type to map order lines, will convert them to and from dicts in events below''' |
27 | | - order_id: int |
28 | | - sku: str |
29 | | - qty: int |
30 | | - |
31 | | - |
32 | | -mapper(_DummyOrderLine, order_lines) |
| 22 | +mapper(Line, order_lines) |
33 | 23 | mapper(Order, order, properties={ |
34 | | - '__lines': relationship(_DummyOrderLine), |
| 24 | + 'lines': relationship(Line, cascade="all, delete-orphan") |
35 | 25 | }) |
36 | 26 |
|
37 | | - |
38 | | - |
39 | | -@event.listens_for(Order, 'load') |
40 | | -def custom_load(target, context): |
41 | | - target._lines = {l.sku: l.qty for l in target.__lines} |
42 | | - target.__lines.clear() |
43 | | - |
44 | | -@event.listens_for(Order, 'after_insert') |
45 | | -def custom_insert(mapper, connection, target): |
46 | | - for sku, qty in target._lines.items(): |
47 | | - target.__lines.append(_DummyOrderLine(order_id=target.id, sku=sku, qty=qty)) |
48 | | - |
49 | | -@event.listens_for(_DummyOrderLine, 'before_insert') |
50 | | -def custom_update(mapper, connection, target): |
51 | | - breakpoint() |
52 | | - print(target) |
0 commit comments