| Line 2073... |
Line 2073... |
| 2073 |
# sheet_iterator+=1
|
2073 |
# sheet_iterator+=1
|
| 2074 |
|
2074 |
|
| 2075 |
filename = "/tmp/flipkart-report-"+runType+" " + str(timestamp) + ".xls"
|
2075 |
filename = "/tmp/flipkart-report-"+runType+" " + str(timestamp) + ".xls"
|
| 2076 |
wbk.save(filename)
|
2076 |
wbk.save(filename)
|
| 2077 |
try:
|
2077 |
try:
|
| 2078 |
EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Flipkart Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
|
2078 |
#EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Flipkart Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
|
| 2079 |
#EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["chandan.kumar@saholic.com","manoj.kumar@saholic.com","yukti.jain@saholic.com","ankush.dhingra@saholic.com","manoj.pal@saholic.com"], " Flipkart Scraping "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], ["rajneesh.arora@saholic.com","anikendra.das@saholic.com","vikram.raghav@saholic.com","kshitij.sood@saholic.com","chaitnaya.vats@saholic.com","khushal.bhatia@saholic.com"], [])
|
2079 |
EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["chandan.kumar@saholic.com","manoj.kumar@saholic.com","yukti.jain@saholic.com","ankush.dhingra@saholic.com","manoj.pal@saholic.com"], " Flipkart Scraping "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], ["rajneesh.arora@saholic.com","anikendra.das@saholic.com","vikram.raghav@saholic.com","kshitij.sood@saholic.com","chaitnaya.vats@saholic.com","khushal.bhatia@saholic.com"], [])
|
| 2080 |
except Exception as e:
|
2080 |
except Exception as e:
|
| 2081 |
print e
|
2081 |
print e
|
| 2082 |
print "Unable to send report.Trying with local SMTP"
|
2082 |
print "Unable to send report.Trying with local SMTP"
|
| 2083 |
smtpServer = smtplib.SMTP('localhost')
|
2083 |
smtpServer = smtplib.SMTP('localhost')
|
| 2084 |
smtpServer.set_debuglevel(1)
|
2084 |
smtpServer.set_debuglevel(1)
|
| 2085 |
sender = 'build@shop2020.in'
|
2085 |
sender = 'build@shop2020.in'
|
| 2086 |
recipients = ["kshitij.sood@saholic.com"]
|
2086 |
#recipients = ["kshitij.sood@saholic.com"]
|
| 2087 |
msg = MIMEMultipart()
|
2087 |
msg = MIMEMultipart()
|
| 2088 |
msg['Subject'] = "Flipkart Scraping" + ' '+runType+' - ' + str(datetime.now())
|
2088 |
msg['Subject'] = "Flipkart Scraping" + ' '+runType+' - ' + str(datetime.now())
|
| 2089 |
msg['From'] = sender
|
2089 |
msg['From'] = sender
|
| 2090 |
#recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
2090 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
| 2091 |
msg['To'] = ",".join(recipients)
|
2091 |
msg['To'] = ",".join(recipients)
|
| 2092 |
fileMsg = email.mime.base.MIMEBase('application','vnd.ms-excel')
|
2092 |
fileMsg = email.mime.base.MIMEBase('application','vnd.ms-excel')
|
| 2093 |
fileMsg.set_payload(file(filename).read())
|
2093 |
fileMsg.set_payload(file(filename).read())
|
| 2094 |
email.encoders.encode_base64(fileMsg)
|
2094 |
email.encoders.encode_base64(fileMsg)
|
| 2095 |
fileMsg.add_header('Content-Disposition','attachment;filename=flipkart.xls')
|
2095 |
fileMsg.add_header('Content-Disposition','attachment;filename=flipkart.xls')
|
| Line 2260... |
Line 2260... |
| 2260 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
2260 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
| 2261 |
mailServer.ehlo()
|
2261 |
mailServer.ehlo()
|
| 2262 |
mailServer.starttls()
|
2262 |
mailServer.starttls()
|
| 2263 |
mailServer.ehlo()
|
2263 |
mailServer.ehlo()
|
| 2264 |
|
2264 |
|
| 2265 |
recipients = ['kshitij.sood@saholic.com']
|
2265 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2266 |
#recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
2266 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
| 2267 |
msg = MIMEMultipart()
|
2267 |
msg = MIMEMultipart()
|
| 2268 |
msg['Subject'] = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
2268 |
msg['Subject'] = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
| 2269 |
msg['From'] = ""
|
2269 |
msg['From'] = ""
|
| 2270 |
msg['To'] = ",".join(recipients)
|
2270 |
msg['To'] = ",".join(recipients)
|
| 2271 |
msg.preamble = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
2271 |
msg.preamble = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
| Line 2441... |
Line 2441... |
| 2441 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
2441 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
| 2442 |
mailServer.ehlo()
|
2442 |
mailServer.ehlo()
|
| 2443 |
mailServer.starttls()
|
2443 |
mailServer.starttls()
|
| 2444 |
mailServer.ehlo()
|
2444 |
mailServer.ehlo()
|
| 2445 |
|
2445 |
|
| 2446 |
recipients = ['kshitij.sood@saholic.com']
|
2446 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2447 |
#recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
2447 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
| 2448 |
msg = MIMEMultipart()
|
2448 |
msg = MIMEMultipart()
|
| 2449 |
msg['Subject'] = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
2449 |
msg['Subject'] = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
| 2450 |
msg['From'] = ""
|
2450 |
msg['From'] = ""
|
| 2451 |
msg['To'] = ",".join(recipients)
|
2451 |
msg['To'] = ",".join(recipients)
|
| 2452 |
msg.preamble = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
2452 |
msg.preamble = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
| Line 2527... |
Line 2527... |
| 2527 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
2527 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
| 2528 |
mailServer.ehlo()
|
2528 |
mailServer.ehlo()
|
| 2529 |
mailServer.starttls()
|
2529 |
mailServer.starttls()
|
| 2530 |
mailServer.ehlo()
|
2530 |
mailServer.ehlo()
|
| 2531 |
|
2531 |
|
| 2532 |
recipients = ['kshitij.sood@saholic.com']
|
2532 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2533 |
#recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
2533 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
| 2534 |
msg = MIMEMultipart()
|
2534 |
msg = MIMEMultipart()
|
| 2535 |
msg['Subject'] = "Flipkart Price Mismatch" + ' - ' + str(datetime.now())
|
2535 |
msg['Subject'] = "Flipkart Price Mismatch" + ' - ' + str(datetime.now())
|
| 2536 |
msg['From'] = ""
|
2536 |
msg['From'] = ""
|
| 2537 |
msg['To'] = ",".join(recipients)
|
2537 |
msg['To'] = ",".join(recipients)
|
| 2538 |
msg.preamble = "Flipkart Price Mismatch" + ' - ' + str(datetime.now())
|
2538 |
msg.preamble = "Flipkart Price Mismatch" + ' - ' + str(datetime.now())
|
| Line 2608... |
Line 2608... |
| 2608 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
2608 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
| 2609 |
mailServer.ehlo()
|
2609 |
mailServer.ehlo()
|
| 2610 |
mailServer.starttls()
|
2610 |
mailServer.starttls()
|
| 2611 |
mailServer.ehlo()
|
2611 |
mailServer.ehlo()
|
| 2612 |
|
2612 |
|
| 2613 |
recipients = ['kshitij.sood@saholic.com']
|
2613 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2614 |
#recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
2614 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
| 2615 |
msg = MIMEMultipart()
|
2615 |
msg = MIMEMultipart()
|
| 2616 |
msg['Subject'] = "Flipkart Negative Margin" + ' - ' + str(datetime.now())
|
2616 |
msg['Subject'] = "Flipkart Negative Margin" + ' - ' + str(datetime.now())
|
| 2617 |
msg['From'] = ""
|
2617 |
msg['From'] = ""
|
| 2618 |
msg['To'] = ",".join(recipients)
|
2618 |
msg['To'] = ",".join(recipients)
|
| 2619 |
msg.preamble = "Flipkart Negative Margin" + ' - ' + str(datetime.now())
|
2619 |
msg.preamble = "Flipkart Negative Margin" + ' - ' + str(datetime.now())
|
| Line 2664... |
Line 2664... |
| 2664 |
commitCheapButNotPref(cheapButNotPref,timestamp)
|
2664 |
commitCheapButNotPref(cheapButNotPref,timestamp)
|
| 2665 |
commitPrefButNotCheap(prefButNotCheap, timestamp)
|
2665 |
commitPrefButNotCheap(prefButNotCheap, timestamp)
|
| 2666 |
cantCompete[:], buyBoxItems[:], competitive[:], competitiveNoInventory[:], exceptionItems[:], negativeMargin[:], cheapButNotPref[:], prefButNotCheap[:] =[],[],[],[],[],[],[],[]
|
2666 |
cantCompete[:], buyBoxItems[:], competitive[:], competitiveNoInventory[:], exceptionItems[:], negativeMargin[:], cheapButNotPref[:], prefButNotCheap[:] =[],[],[],[],[],[],[],[]
|
| 2667 |
collected = gc.collect()
|
2667 |
collected = gc.collect()
|
| 2668 |
print "Garbage collector: collected %d objects." % (collected)
|
2668 |
print "Garbage collector: collected %d objects." % (collected)
|
| 2669 |
time.sleep(4)
|
- |
|
| 2670 |
|
2669 |
|
| 2671 |
successfulAutoDecrease = fetchItemsForAutoDecrease(timestamp)
|
2670 |
successfulAutoDecrease = fetchItemsForAutoDecrease(timestamp)
|
| 2672 |
successfulAutoIncrease = fetchItemsForAutoIncrease(timestamp)
|
2671 |
successfulAutoIncrease = fetchItemsForAutoIncrease(timestamp)
|
| 2673 |
if options.runType=='FULL':
|
2672 |
if options.runType=='FULL':
|
| 2674 |
previousAutoFav, nowAutoFav = markAutoFavourite()
|
2673 |
previousAutoFav, nowAutoFav = markAutoFavourite()
|