WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py



def create_purchase_order(warehouseId):
    if not warehouseId:
        raise TransactionServiceException(101, "bad warehouse id")
    
    query = Order.query.with_lockmode("update").filter_by(warehouse_id=warehouseId)
    query = query.filter(or_(Order.status == OrderStatus.SUBMITTED_FOR_PROCESSING, Order.status == OrderStatus.INVENTORY_LOW))
    query = query.filter_by(purchase_order_id=None)
    query = query.order_by(Order.created_timestamp)
    pending_orders = query.all()
    
    if not pending_orders:

Rev 4369	Rev 4380
Line 1324...	Line 1324...
1324	`def create_purchase_order(warehouseId):`	1324	`def create_purchase_order(warehouseId):`
1325	`if not warehouseId:`	1325	`if not warehouseId:`
1326	`raise TransactionServiceException(101, "bad warehouse id")`	1326	`raise TransactionServiceException(101, "bad warehouse id")`
1327		1327
1328	`query = Order.query.with_lockmode("update").filter_by(warehouse_id=warehouseId)`	1328	`query = Order.query.with_lockmode("update").filter_by(warehouse_id=warehouseId)`
1329	`query = query.filter_by(status=OrderStatus.SUBMITTED_FOR_PROCESSING)`	1329	`query = query.filter(or_(Order.status == OrderStatus.SUBMITTED_FOR_PROCESSING, Order.status == OrderStatus.INVENTORY_LOW))`
1330	`query = query.filter_by(purchase_order_id=None)`	1330	`query = query.filter_by(purchase_order_id=None)`
1331	`query = query.order_by(Order.created_timestamp)`	1331	`query = query.order_by(Order.created_timestamp)`
1332	`pending_orders = query.all()`	1332	`pending_orders = query.all()`
1333		1333
1334	`if not pending_orders:`	1334	`if not pending_orders:`

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py – Rev 4369 → 4380