WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/dtr/storage/Mongo.py



    if window==None:
        window = 50
    result = {}
    skip = (page-1)*window
    collection = get_mongo_connection().Dtr.merchantOrder
    cursor = collection.find({"userId":userId}).sort([("$natural",-1)])
    total_count = cursor.count()
    pages = total_count/window + (0 if total_count%window==0 else 1)  
    print "total_count", total_count
    if total_count > skip:
        cursor = cursor.skip(skip).limit(window)
        orders = []
        for order in cursor:
            del(order["_id"])
            orders.append(order)
        result['data'] = orders

Rev 13998	Rev 13999
Line 165...	Line 165...
165	`if window==None:`	165	`if window==None:`
166	`window = 50`	166	`window = 50`
167	`result = {}`	167	`result = {}`
168	`skip = (page-1)*window`	168	`skip = (page-1)*window`
169	`collection = get_mongo_connection().Dtr.merchantOrder`	169	`collection = get_mongo_connection().Dtr.merchantOrder`
170	`cursor = collection.find({"userId":userId})`	170	`cursor = collection.find({"userId":userId}).sort([("$natural",-1)])`
171	`total_count = cursor.count()`	171	`total_count = cursor.count()`
172	`pages = total_count/window + (0 if total_count%window==0 else 1)`	172	`pages = total_count/window + (0 if total_count%window==0 else 1)`
173	`print "total_count", total_count`	173	`print "total_count", total_count`
174	`if total_count > skip:`	174	`if total_count > skip:`
175	`cursor = cursor.skip(skip).limit(window).sort([("$natural",-1)])`	175	`cursor = cursor.skip(skip).limit(window)`
176	`orders = []`	176	`orders = []`
177	`for order in cursor:`	177	`for order in cursor:`
178	`del(order["_id"])`	178	`del(order["_id"])`
179	`orders.append(order)`	179	`orders.append(order)`
180	`result['data'] = orders`	180	`result['data'] = orders`

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/dtr/storage/Mongo.py – Rev 13998 → 13999