Simpler view based on a new read model table

hjwp · hjwp · commit 50905cf8da30 · 2021-02-24T20:08:31.000Z
diff --git a/src/allocation/views.py b/src/allocation/views.py
@@ -1,12 +1,12 @@
-from allocation.domain import model
 from allocation.service_layer import unit_of_work
 
 
 def allocations(orderid: str, uow: unit_of_work.SqlAlchemyUnitOfWork):
     with uow:
-        batches = (
-            uow.session.query(model.Batch)
-            .join(model.OrderLine, model.Batch._allocations)
-            .filter(model.OrderLine.orderid == orderid)
+        results = list(
+            uow.session.execute(
+                "SELECT sku, batchref FROM allocations_view WHERE orderid = :orderid",
+                dict(orderid=orderid),
+            )
         )
-        return [{"sku": b.sku, "batchref": b.reference} for b in batches]
+    return [dict(r) for r in results]
