|
1 | 1 | from sqlalchemy import Table, MetaData, Column, Integer, String, ForeignKey |
2 | | -from sqlalchemy.orm import mapper, relationship |
| 2 | +from sqlalchemy.orm import mapper, relationship, column_property |
| 3 | +from sqlalchemy.orm.collections import attribute_mapped_collection, mapped_collection, collection |
| 4 | + |
| 5 | +from domain_model import Order |
3 | 6 |
|
4 | 7 | metadata = MetaData() |
5 | 8 |
|
6 | 9 |
|
7 | 10 | order = Table( |
8 | 11 | 'order', metadata, |
9 | 12 | Column('id', Integer, primary_key=True, autoincrement=True), |
| 13 | + # relationship('order_lines', secondary='order_lines') |
10 | 14 | ) |
11 | 15 |
|
12 | 16 | order_lines = Table( |
13 | 17 | 'order_lines', metadata, |
14 | 18 | Column('order_id', ForeignKey('order.id'), primary_key=True), |
15 | 19 | Column('sku', String(255), primary_key=True), |
16 | | - Column('quantity', Integer), |
17 | | - # order=relationship(order, back_populates="lines") |
| 20 | + Column('qty', Integer), |
18 | 21 | ) |
19 | 22 |
|
| 23 | +mapper(Order, order) |
| 24 | + |
| 25 | + |
| 26 | +from sqlalchemy import event |
| 27 | + |
| 28 | +@event.listens_for(Order, 'load') |
| 29 | +def custom_load(target, context): |
| 30 | + raw_lines = context.session.query(order_lines).join(order).filter_by(id=target.id).all() |
| 31 | + target._lines = {sku: qty for _, sku, qty in raw_lines} |
0 commit comments