WebSVN – SmartDukaan – Diff – //trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py

         return True
     except Exception as e:
         print 'Exception in updating private deals'
         print e
         return False
+def get_private_deals_query():
+        return session.query(Item).join((PrivateDeals,Item.id==PrivateDeals.item_id)).filter(PrivateDeals.isActive==True).group_by(Item.catalog_item_id)
+def get_private_deals_count():
+        return get_private_deals_query().count()
 def get_private_deals_catalog_ids(offset,limit):
-    print session.query(Item).join((PrivateDeals,Item.id==PrivateDeals.item_id)).filter(PrivateDeals.isActive==True).group_by(Item.catalog_item_id).offset(offset).limit(limit).all()
-    private_deal_items = session.query(Item).join((PrivateDeals,Item.id==PrivateDeals.item_id)).filter(PrivateDeals.isActive==True).group_by(Item.catalog_item_id).offset(offset).limit(limit).all()
+    private_deal_items = get_private_deals_query().offset(offset).limit(limit).all()
     if private_deal_items is None:
-        return None
+        return []
     else:
         return [item.catalog_item_id for item in private_deal_items]

Subversion Repositories SmartDukaan