| Line 1966... |
Line 1966... |
| 1966 |
sheet_iterator+=1
|
1966 |
sheet_iterator+=1
|
| 1967 |
|
1967 |
|
| 1968 |
filename = "/tmp/flipkart-report-"+runType+" " + str(timestamp) + ".xls"
|
1968 |
filename = "/tmp/flipkart-report-"+runType+" " + str(timestamp) + ".xls"
|
| 1969 |
wbk.save(filename)
|
1969 |
wbk.save(filename)
|
| 1970 |
try:
|
1970 |
try:
|
| 1971 |
EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Flipkart Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
|
1971 |
#EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Flipkart Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
|
| 1972 |
#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"], [])
|
1972 |
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"], [])
|
| 1973 |
except Exception as e:
|
1973 |
except Exception as e:
|
| 1974 |
print e
|
1974 |
print e
|
| 1975 |
print "Unable to send report.Trying with local SMTP"
|
1975 |
print "Unable to send report.Trying with local SMTP"
|
| 1976 |
smtpServer = smtplib.SMTP('localhost')
|
1976 |
smtpServer = smtplib.SMTP('localhost')
|
| 1977 |
smtpServer.set_debuglevel(1)
|
1977 |
smtpServer.set_debuglevel(1)
|
| 1978 |
sender = 'support@shop2020.in'
|
1978 |
sender = 'support@shop2020.in'
|
| 1979 |
recipients = ["kshitij.sood@saholic.com"]
|
1979 |
#recipients = ["kshitij.sood@saholic.com"]
|
| 1980 |
msg = MIMEMultipart()
|
1980 |
msg = MIMEMultipart()
|
| 1981 |
msg['Subject'] = "Flipkart Scraping" + ' '+runType+' - ' + str(datetime.now())
|
1981 |
msg['Subject'] = "Flipkart Scraping" + ' '+runType+' - ' + str(datetime.now())
|
| 1982 |
msg['From'] = sender
|
1982 |
msg['From'] = sender
|
| 1983 |
#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']
|
1983 |
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']
|
| 1984 |
msg['To'] = ",".join(recipients)
|
1984 |
msg['To'] = ",".join(recipients)
|
| 1985 |
fileMsg = email.mime.base.MIMEBase('application','vnd.ms-excel')
|
1985 |
fileMsg = email.mime.base.MIMEBase('application','vnd.ms-excel')
|
| 1986 |
fileMsg.set_payload(file(filename).read())
|
1986 |
fileMsg.set_payload(file(filename).read())
|
| 1987 |
email.encoders.encode_base64(fileMsg)
|
1987 |
email.encoders.encode_base64(fileMsg)
|
| 1988 |
fileMsg.add_header('Content-Disposition','attachment;filename=flipkart.xls')
|
1988 |
fileMsg.add_header('Content-Disposition','attachment;filename=flipkart.xls')
|
| Line 2143... |
Line 2143... |
| 2143 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
2143 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
| 2144 |
mailServer.ehlo()
|
2144 |
mailServer.ehlo()
|
| 2145 |
mailServer.starttls()
|
2145 |
mailServer.starttls()
|
| 2146 |
mailServer.ehlo()
|
2146 |
mailServer.ehlo()
|
| 2147 |
|
2147 |
|
| 2148 |
recipients = ['kshitij.sood@saholic.com']
|
2148 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2149 |
#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']
|
2149 |
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']
|
| 2150 |
msg = MIMEMultipart()
|
2150 |
msg = MIMEMultipart()
|
| 2151 |
msg['Subject'] = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
2151 |
msg['Subject'] = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
| 2152 |
msg['From'] = ""
|
2152 |
msg['From'] = ""
|
| 2153 |
msg['To'] = ",".join(recipients)
|
2153 |
msg['To'] = ",".join(recipients)
|
| 2154 |
msg.preamble = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
2154 |
msg.preamble = "Flipkart Auto Pricing" + ' - ' + str(datetime.now())
|
| Line 2226... |
Line 2226... |
| 2226 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
2226 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
| 2227 |
mailServer.ehlo()
|
2227 |
mailServer.ehlo()
|
| 2228 |
mailServer.starttls()
|
2228 |
mailServer.starttls()
|
| 2229 |
mailServer.ehlo()
|
2229 |
mailServer.ehlo()
|
| 2230 |
|
2230 |
|
| 2231 |
recipients = ['kshitij.sood@saholic.com']
|
2231 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2232 |
#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']
|
2232 |
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']
|
| 2233 |
msg = MIMEMultipart()
|
2233 |
msg = MIMEMultipart()
|
| 2234 |
msg['Subject'] = "Flipkart Lost Buy Box" + ' - ' + str(datetime.now())
|
2234 |
msg['Subject'] = "Flipkart Lost Buy Box" + ' - ' + str(datetime.now())
|
| 2235 |
msg['From'] = ""
|
2235 |
msg['From'] = ""
|
| 2236 |
msg['To'] = ",".join(recipients)
|
2236 |
msg['To'] = ",".join(recipients)
|
| 2237 |
msg.preamble = "Flipkart Lost Buy Box" + ' - ' + str(datetime.now())
|
2237 |
msg.preamble = "Flipkart Lost Buy Box" + ' - ' + str(datetime.now())
|
| Line 2252... |
Line 2252... |
| 2252 |
print "Successfully sent email"
|
2252 |
print "Successfully sent email"
|
| 2253 |
except:
|
2253 |
except:
|
| 2254 |
print "Error: unable to send email."
|
2254 |
print "Error: unable to send email."
|
| 2255 |
|
2255 |
|
| 2256 |
def cheapButNotPrefAlert(timestamp):
|
2256 |
def cheapButNotPrefAlert(timestamp):
|
| 2257 |
cheap_but_not_pref = session.query(MarketPlaceHistory,Item).join(Item,MarketPlaceHistory.item_id==Item.id).filter(MarketPlaceHistory.timestamp==timestamp).filter(MarketPlaceHistory.source==OrderSource.FLIPKART).filter(MarketPlaceHistory.competitiveCategory==CompetitionCategory.CHEAP_BUT_NOT_PREF).all()
|
2257 |
cheap_but_not_pref = session.query(MarketPlaceHistory,Item).join((Item,MarketPlaceHistory.item_id==Item.id)).filter(MarketPlaceHistory.timestamp==timestamp).filter(MarketPlaceHistory.source==OrderSource.FLIPKART).filter(MarketPlaceHistory.competitiveCategory==CompetitionCategory.CHEAP_BUT_NOT_PREF).all()
|
| 2258 |
if cheap_but_not_pref is None:
|
2258 |
if cheap_but_not_pref is None:
|
| 2259 |
return
|
2259 |
return
|
| 2260 |
xstr = lambda s: s or ""
|
2260 |
xstr = lambda s: s or ""
|
| 2261 |
message="""<html>
|
2261 |
message="""<html>
|
| 2262 |
<body>
|
2262 |
<body>
|
| Line 2300... |
Line 2300... |
| 2300 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
2300 |
mailServer = smtplib.SMTP("smtp.gmail.com", 587)
|
| 2301 |
mailServer.ehlo()
|
2301 |
mailServer.ehlo()
|
| 2302 |
mailServer.starttls()
|
2302 |
mailServer.starttls()
|
| 2303 |
mailServer.ehlo()
|
2303 |
mailServer.ehlo()
|
| 2304 |
|
2304 |
|
| 2305 |
recipients = ['kshitij.sood@saholic.com']
|
2305 |
#recipients = ['kshitij.sood@saholic.com']
|
| 2306 |
#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']
|
2306 |
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']
|
| 2307 |
msg = MIMEMultipart()
|
2307 |
msg = MIMEMultipart()
|
| 2308 |
msg['Subject'] = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
2308 |
msg['Subject'] = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
| 2309 |
msg['From'] = ""
|
2309 |
msg['From'] = ""
|
| 2310 |
msg['To'] = ",".join(recipients)
|
2310 |
msg['To'] = ",".join(recipients)
|
| 2311 |
msg.preamble = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|
2311 |
msg.preamble = "Flipkart Cheap But Not In BuyBox Items" + ' - ' + str(datetime.now())
|