FilesExpand file tree

 master

/

sendMail.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

46 lines (38 loc) · 1.09 KB

 master

/

sendMail.py

Top

File metadata and controls

• Code
• Blame

46 lines (38 loc) · 1.09 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

#! /usr/local/bin/python2.7

#coding: UTF-8

import os

import sys

import MySQLdb

import datetime

import smtplib

from email.MIMEText import MIMEText

from email.Header import Header

today=datetime.date.today()

deltaDay=datetime.timedelta(days=1)

yesterday=today-deltaDay

IOSFORMAT='%Y-%m-%d'

print today.strftime(IOSFORMAT)

print yesterday.strftime(IOSFORMAT)

db = MySQLdb.connect("$ip","username","password","dbname",charset="utf8")

cursor = db.cursor()

sql=""

s=cursor.execute(sql)

result=cursor.fetchone()

tcount=result[0]

sql=""

s=cursor.execute(sql)

count=cursor.fetchone()

vcount=count[0]

sender = '[email protected]'

receiver = 'ss@socom'

subject = 'subetc'

smtpserver = 'smtp.163.com'

username = '[email protected]'

password = 'ss'

msg = MIMEText('完成任务数：'+str(tcount)+'\n覆盖视频数：'+str(vcount),'plain','utf-8')#中文需参数‘utf-8’，单字节字符不需要

msg['Subject'] = Header(subject, 'utf-8')

smtp = smtplib.SMTP()

smtp.connect('smtp.163.com')

smtp.login(username, password)

smtp.sendmail(sender, receiver, msg.as_string())

smtp.quit()