|
1 | | -from sqlalchemy import Table, MetaData, Column, Integer, String, ForeignKey |
| 1 | +from sqlalchemy import Table, MetaData, Column, Integer, String, ForeignKey, Date |
2 | 2 | from sqlalchemy.orm import mapper, relationship |
3 | 3 |
|
4 | | -from domain_model import Order, Line |
| 4 | +import domain_model |
5 | 5 |
|
6 | 6 |
|
7 | 7 | metadata = MetaData() |
|
10 | 10 | 'order', metadata, |
11 | 11 | Column('id', Integer, primary_key=True, autoincrement=True), |
12 | 12 | ) |
13 | | - |
14 | 13 | order_lines = Table( |
15 | 14 | 'order_lines', metadata, |
16 | 15 | Column('order_id', ForeignKey('order.id'), primary_key=True), |
17 | 16 | Column('sku', String(255), primary_key=True), |
18 | 17 | Column('qty', Integer), |
19 | 18 | ) |
| 19 | +mapper(domain_model.Line, order_lines) |
| 20 | +mapper(domain_model.Order, order, properties={ |
| 21 | + 'lines': relationship(domain_model.Line, cascade="all, delete-orphan") |
| 22 | +}) |
20 | 23 |
|
21 | 24 |
|
22 | | -mapper(Line, order_lines) |
23 | | -mapper(Order, order, properties={ |
24 | | - 'lines': relationship(Line, cascade="all, delete-orphan") |
| 25 | +warehouse = Table( |
| 26 | + 'warehouse', metadata, |
| 27 | + Column('id', Integer, primary_key=True, autoincrement=True), |
| 28 | +) |
| 29 | +warehouse_lines = Table( |
| 30 | + 'warehouse_lines', metadata, |
| 31 | + Column('warehouse_id', ForeignKey('warehouse.id'), primary_key=True), |
| 32 | + Column('sku', String(255), primary_key=True), |
| 33 | + Column('qty', Integer), |
| 34 | +) |
| 35 | +warehouse_line_mapper = mapper(domain_model.Line, warehouse_lines, non_primary=True) |
| 36 | +mapper(domain_model.Warehouse, warehouse, properties={ |
| 37 | + 'lines': relationship(warehouse_line_mapper, cascade="all, delete-orphan") |
25 | 38 | }) |
26 | 39 |
|
| 40 | + |
| 41 | +shipment = Table( |
| 42 | + 'shipment', metadata, |
| 43 | + Column('id', Integer, primary_key=True, autoincrement=True), |
| 44 | + Column('eta', Date), |
| 45 | +) |
| 46 | +shipment_lines = Table( |
| 47 | + 'shipment_lines', metadata, |
| 48 | + Column('shipment_id', ForeignKey('shipment.id'), primary_key=True), |
| 49 | + Column('sku', String(255), primary_key=True), |
| 50 | + Column('qty', Integer), |
| 51 | +) |
| 52 | + |
| 53 | +shipment_line_mapper = mapper(domain_model.Line, shipment_lines, non_primary=True) |
| 54 | +mapper(domain_model.Shipment, shipment, properties={ |
| 55 | + 'lines': relationship(shipment_line_mapper, cascade="all, delete-orphan") |
| 56 | +}) |
| 57 | + |
| 58 | +allocation = Table( |
| 59 | + 'allocation', metadata, |
| 60 | + Column('id', Integer, primary_key=True, autoincrement=True), |
| 61 | + Column('order_id', ForeignKey('order.id')) |
| 62 | +) |
| 63 | + |
| 64 | +allocation_lines = Table( |
| 65 | + 'allocation_lines', metadata, |
| 66 | + Column('allocation_id', ForeignKey('allocation.id'), primary_key=True), |
| 67 | + Column('sku', String(255), primary_key=True), |
| 68 | + Column('shipment_id', ForeignKey('shipment.id'), nullable=True), |
| 69 | +) |
| 70 | + |
| 71 | +mapper(domain_model.AllocationLine, allocation_lines) |
| 72 | +mapper(domain_model.Allocation, allocation, properties={ |
| 73 | + 'lines': relationship(domain_model.AllocationLine, cascade="all, delete-orphan"), |
| 74 | +}) |
0 commit comments