from sqlalchemy import Table, MetaData, Column, Integer, String, ForeignKey, Date

from sqlalchemy.orm import mapper, relationship

import domain_model

# minimal mappings, just order and warehouse + their lines

metadata = MetaData()

order = Table(

'order', metadata,

Column('id', Integer, primary_key=True, autoincrement=True),

)

order_lines = Table(

'order_lines', metadata,

Column('order_id', ForeignKey('order.id'), primary_key=True),

Column('sku', String(255), primary_key=True),

Column('qty', Integer),

)

mapper(domain_model.Line, order_lines)

mapper(domain_model.Order, order, properties={

'lines': relationship(domain_model.Line, cascade="all, delete-orphan")

})

warehouse = Table(

'warehouse', metadata,

Column('id', Integer, primary_key=True, autoincrement=True),

)

warehouse_lines = Table(

'warehouse_lines', metadata,

Column('warehouse_id', ForeignKey('warehouse.id'), primary_key=True),

Column('sku', String(255), primary_key=True),

Column('qty', Integer),

)

warehouse_line_mapper = mapper(domain_model.Line, warehouse_lines, non_primary=True)

mapper(domain_model.Warehouse, warehouse, properties={

'lines': relationship(warehouse_line_mapper, cascade="all, delete-orphan")

})