Skip to content

Commit b268531

Browse files
committed
some progress on getting the orm to deliver dicts
1 parent c931944 commit b268531

2 files changed

Lines changed: 32 additions & 4 deletions

File tree

‎orm.py‎

Lines changed: 15 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,19 +1,31 @@
11
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
36

47
metadata = MetaData()
58

69

710
order = Table(
811
'order', metadata,
912
Column('id', Integer, primary_key=True, autoincrement=True),
13+
# relationship('order_lines', secondary='order_lines')
1014
)
1115

1216
order_lines = Table(
1317
'order_lines', metadata,
1418
Column('order_id', ForeignKey('order.id'), primary_key=True),
1519
Column('sku', String(255), primary_key=True),
16-
Column('quantity', Integer),
17-
# order=relationship(order, back_populates="lines")
20+
Column('qty', Integer),
1821
)
1922

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}

‎test_orm.py‎

Lines changed: 17 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,11 +3,13 @@
33
from sqlalchemy.orm import sessionmaker
44

55
from orm import metadata
6+
from domain_model import Order
67

78

89
@pytest.fixture
910
def db():
10-
engine = create_engine('sqlite:///:memory:', echo=True)
11+
# engine = create_engine('sqlite:///:memory:', echo=True)
12+
engine = create_engine('sqlite:///:memory:')
1113
metadata.create_all(engine)
1214
return engine
1315

@@ -25,3 +27,17 @@ def test_smoke(session):
2527
(1, 1, "sku2", 13),
2628
]
2729

30+
def test_order_mapper_no_lines(session):
31+
order = Order({})
32+
session.add(order)
33+
assert session.query(Order).first() == order
34+
35+
def test_order_mapper_with_lines(session):
36+
session.execute('INSERT INTO "order" VALUES (1)')
37+
session.execute('INSERT INTO "order" VALUES (2)')
38+
session.execute('INSERT INTO "order_lines" VALUES (1, "sku1", 12)')
39+
session.execute('INSERT INTO "order_lines" VALUES (1, "sku2", 13)')
40+
session.execute('INSERT INTO "order_lines" VALUES (2, "sku3", 14)')
41+
expected_order = Order({'sku1': 12, 'sku2': 13})
42+
retrieved_order = session.query(Order).first()
43+
assert retrieved_order.lines == expected_order.lines

0 commit comments

Comments
 (0)