Skip to content

Commit 26b997e

Browse files
committed
batches with no allocations
1 parent 527b320 commit 26b997e

2 files changed

Lines changed: 25 additions & 1 deletion

File tree

‎orm.py‎

Lines changed: 11 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
from sqlalchemy import Table, MetaData, Column, Integer, String
1+
from sqlalchemy import Table, MetaData, Column, Integer, String, Date
22
from sqlalchemy.orm import mapper
33

44
import model
@@ -14,6 +14,16 @@
1414
Column("qty", Integer),
1515
)
1616

17+
batches = Table(
18+
"batches",
19+
metadata,
20+
Column("reference", String(255), primary_key=True),
21+
Column("sku", String(255), primary_key=True),
22+
Column("_purchased_qty", Integer),
23+
Column("eta", Date),
24+
)
25+
1726

1827
def start_mappers():
1928
mapper(model.OrderLine, order_lines)
29+
mapper(model.Batch, batches)

‎test_orm.py‎

Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,5 @@
11
import model
2+
from datetime import date
23

34

45
def test_orderline_mapper_can_load_lines(session):
@@ -23,3 +24,16 @@ def test_orderline_mapper_can_save_lines(session):
2324

2425
rows = list(session.execute('SELECT orderid, sku, qty FROM "order_lines"'))
2526
assert rows == [("order1", "DECORATIVE-WIDGET", 12)]
27+
28+
29+
def test_batches(session):
30+
session.execute('INSERT INTO "batches" VALUES ("batch1", "sku1", 100, null)')
31+
session.execute(
32+
'INSERT INTO "batches" VALUES ("batch2", "sku2", 200, "2011-04-11")'
33+
)
34+
expected = [
35+
model.Batch("batch1", "sku1", 100, eta=None),
36+
model.Batch("batch2", "sku2", 200, eta=date(2011, 4, 11)),
37+
]
38+
39+
assert session.query(model.Batch).all() == expected

0 commit comments

Comments
 (0)