Subversion Repositories SmartDukaan

def get_created_orders_for_flipkart(flipkartorderids):

    item_ordercount = dict()

    orders = []

    flipkart_orders = session.query(FlipkartOrder).filter(FlipkartOrder.flipkartOrderId.in_(tuple(flipkartorderids))).all()

    print flipkart_orders 

    if len(flipkart_orders)!=0:

        for order in flipkart_orders:

            print order.orderId 

            orders.append(order.orderId)

        items =session.query(LineItem.item_id,func.count(LineItem.quantity)).join((Order,LineItem.order_id==Order.id)).filter(Order.id.in_(tuple(orders))).filter(Order.status >=3).group_by(LineItem.item_id).all()

    else:

        return item_ordercount

    print "items map after query"     

    print items

    for item in items:

        print "item id"

        print item[0]

        print "order count"

        print item[1]

        item_ordercount[item[0]] = item[1]

    print item_ordercount    

    return item_ordercount