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

     return query.count()
 def get_count_for_snapdeal_items():
     return session.query(func.count(SnapdealItem.item_id)).scalar()
+def get_snapdealitem_by_skuatsnapdeal(sku):
+    snapdeal_item = SnapdealItem.get_by(skuAtSnapdeal=sku)
+    if snapdeal_item is not None:
+        item = session.query(SnapdealItem,Item).join((Item,SnapdealItem.item_id==Item.id)).filter(SnapdealItem.item_id==snapdeal_item.item_id).first()
+    else:
+        return None
+    print item
+    return item

Subversion Repositories SmartDukaan