| Line 77... |
Line 77... |
| 77 |
fetchedItems = []
|
77 |
fetchedItems = []
|
| 78 |
items = session.query(SnapdealItem,MarketplaceItems).join((MarketplaceItems,SnapdealItem.item_id==MarketplaceItems.itemId)).filter(MarketplaceItems.source==OrderSource.SNAPDEAL).all()
|
78 |
items = session.query(SnapdealItem,MarketplaceItems).join((MarketplaceItems,SnapdealItem.item_id==MarketplaceItems.itemId)).filter(MarketplaceItems.source==OrderSource.SNAPDEAL).all()
|
| 79 |
for item in items:
|
79 |
for item in items:
|
| 80 |
snapdealItem = item[0]
|
80 |
snapdealItem = item[0]
|
| 81 |
marketplaceItem = item[1]
|
81 |
marketplaceItem = item[1]
|
| 82 |
try:<
|
82 |
try:
|
| 83 |
print "Inside try for fetch data"
|
83 |
print "Inside try for fetch data"
|
| 84 |
snapdealInfo = fetchData(br,snapdealItem.supc)
|
84 |
snapdealInfo = fetchData(br,snapdealItem.supc)
|
| 85 |
except Exception as e:
|
85 |
except Exception as e:
|
| 86 |
exceptionList.append(item)
|
86 |
exceptionList.append(item)
|
| 87 |
print "Unable to fetch details ",e
|
87 |
print "Unable to fetch details ",e
|
| 88 |
continue
|
88 |
continue
|
| 89 |
snapdealInfo.sellingPrice = snapdealItem.sellingPrice
|
89 |
snapdealInfo.sellingPrice = snapdealItem.sellingPrice
|
| 90 |
snapdealInfo.courierCost = snapdealItem.courierCost
|
90 |
snapdealInfo.courierCost = snapdealItem.courierCost
|
| 91 |
snapdealInfo.transferPrice = snapdealItem.transferPrice
|
91 |
snapdealInfo.transferPrice = snapdealItem.transferPrice
|
| 92 |
snapdealInfo.commissionPercentage = marketplaceItem.commission
|
92 |
snapdealInfo.commissionPercentage = marketplaceItem.commission
|
| 93 |
snapdealInfo.commission = snapdealItem.commission
|
93 |
snapdealInfo.commission = snapdealItem.commission
|
| 94 |
snapdealInfo.itemId = snapdealItem.item_id
|
94 |
snapdealInfo.itemId = snapdealItem.item_id
|
| 95 |
fetchedItems.append(snapdealInfo)
|
95 |
fetchedItems.append(snapdealInfo)
|
| 96 |
return exceptionList, fetchedItems
|
96 |
return exceptionList, fetchedItems
|
| 97 |
|
97 |
|
| 98 |
def fetchData(br,supc):
|
98 |
def fetchData(br,supc):
|
| 99 |
url="http://seller.snapdeal.com/pricing/search?searchType=SUPC&searchValue=%s&gridType=normal&_search=false&nd=1396007375971&rows=30&page=1&sidx=&sord=asc"%(supc)
|
99 |
url="http://seller.snapdeal.com/pricing/search?searchType=SUPC&searchValue=%s&gridType=normal&_search=false&nd=1396007375971&rows=30&page=1&sidx=&sord=asc"%(supc)
|
| 100 |
sleep(1)
|
100 |
sleep(1)
|