| Line 2287... |
Line 2287... |
| 2287 |
except:
|
2287 |
except:
|
| 2288 |
print "Error: unable to send email."
|
2288 |
print "Error: unable to send email."
|
| 2289 |
|
2289 |
|
| 2290 |
def processLostBuyBoxItems(previousProcessingTimestamp,currentTimestamp):
|
2290 |
def processLostBuyBoxItems(previousProcessingTimestamp,currentTimestamp):
|
| 2291 |
previous_buy_box = session.query(MarketPlaceHistory.item_id).filter(MarketPlaceHistory.timestamp==previousProcessingTimestamp).filter(MarketPlaceHistory.source==OrderSource.FLIPKART).filter(or_(MarketPlaceHistory.competitiveCategory==CompetitionCategory.BUY_BOX,MarketPlaceHistory.competitiveCategory==CompetitionCategory.PREF_BUT_NOT_CHEAP)).all()
|
2291 |
previous_buy_box = session.query(MarketPlaceHistory.item_id).filter(MarketPlaceHistory.timestamp==previousProcessingTimestamp).filter(MarketPlaceHistory.source==OrderSource.FLIPKART).filter(or_(MarketPlaceHistory.competitiveCategory==CompetitionCategory.BUY_BOX,MarketPlaceHistory.competitiveCategory==CompetitionCategory.PREF_BUT_NOT_CHEAP)).all()
|
| - |
|
2292 |
print "previous buy box ",previous_buy_box
|
| 2292 |
cant_compete = session.query(MarketPlaceHistory.item_id).filter(MarketPlaceHistory.timestamp==currentTimestamp).filter(MarketPlaceHistory.source==OrderSource.FLIPKART).filter(MarketPlaceHistory.competitiveCategory==CompetitionCategory.CANT_COMPETE).all()
|
2293 |
cant_compete = session.query(MarketPlaceHistory.item_id).filter(MarketPlaceHistory.timestamp==currentTimestamp).filter(MarketPlaceHistory.source==OrderSource.FLIPKART).filter(MarketPlaceHistory.competitiveCategory==CompetitionCategory.CANT_COMPETE).all()
|
| - |
|
2294 |
print "cant compete ",cant_compete
|
| 2293 |
if previous_buy_box is None or previous_buy_box==[]:
|
2295 |
if previous_buy_box is None or previous_buy_box==[]:
|
| 2294 |
print "No item in buy box for last run"
|
2296 |
print "No item in buy box for last run"
|
| 2295 |
return
|
2297 |
return
|
| 2296 |
lost_buy_box = list(set(list(zip(*previous_buy_box)[0]))&set(list(zip(*cant_compete)[0])))
|
2298 |
lost_buy_box = list(set(list(zip(*previous_buy_box)[0]))&set(list(zip(*cant_compete)[0])))
|
| 2297 |
if len(lost_buy_box)==0:
|
2299 |
if len(lost_buy_box)==0:
|