EKXt4y8L

1from email.mime.text import MIMEText
2from email.mime.image import MIMEImage
3from email.mime.base import MIMEBase
4import mysql.connector
5import csv
6
7
8my_db = mysql.connector.connect(
9    host="localhost",
10    user="root",
11    passwd="admin",
12    database="simplymacstaging"
13)
14
15my_cursor = my_db.cursor()
16
17my_cursor.execute("SELECT CONVERT(DateCreated, Date) 'Date', StoreName, ROUND(sum(TotalCost), 2) 'TotalCost' "
18                  "FROM simplymacstaging.ajdustmenthistory  WHERE ReasonCode = 'Negligence - Service' AND  "
19                  "CONVERT(DateCreated, Date) >= '2019-02-03' GROUP by StoreName, Date")
20
21
22databases = my_cursor.fetchall()
23fp = open('C:#Emailproject/emailtest.csv', 'w')
24attach_file = csv.writer(fp)
25attach_file.writerows(databases)
26fp.close()
27
28# My email
29fromaddr = "******************@gmail.com"
30# EMAIL ADDRESS YOU SEND TO
31toaddr = "**********@gmail.com"
32
33msg = MIMEMultipart()
34
35msg['From'] = fromaddr
36msg['To'] = toaddr
37msg['Subject'] = "Test Email Data"  # SUBJECT OF THE EMAIL
38
39body = "Hello, Please see the attched report for  week. Thank you, ****"
40
41msg.attach(MIMEText(body, 'plain'))
42
43filename = "Test Email.csv"  # NAME OF THE FILE WITH ITS EXTENSION
44attachment = open("C:#Emailproject/emailtest.csv", "rb")  # PATH OF THE FILE
45
46part = MIMEBase('application', 'octet-stream')
47part.set_payload((attachment).read())
48encoders.encode_base64(part)
49part.add_header('Content-Disposition', "attachment; filename= %s" % filename)
50
51msg.attach(part)
52
53server = smtplib.SMTP('smtp.gmail.com', 587)
54server.starttls()
55server.login(fromaddr, "***********")  # YOUR PASSWORD
56text = msg.as_string()
57server.sendmail(fromaddr, toaddr, text)
58server.quit()