new table in orm

hjwp · hjwp · commit 7e58f4b17180 · 2021-02-24T20:08:31.000Z
diff --git a/src/allocation/adapters/orm.py b/src/allocation/adapters/orm.py
@@ -49,6 +49,14 @@
     Column("batch_id", ForeignKey("batches.id")),
 )
 
+allocations_view = Table(
+    "allocations_view",
+    metadata,
+    Column("orderid", String(255)),
+    Column("sku", String(255)),
+    Column("batchref", String(255)),
+)
+
 
 def start_mappers():
     lines_mapper = mapper(model.OrderLine, order_lines)
