python简单邮件发送实例

import pymysql
import datetime
import sys
def resinsert(testmodule,testfuction,testresult,testlev,description):
    db = pymysql.connect(host='192.168.0.19', user="root", passwd="123456", db='test', port=3306, charset='utf8')
    cursor = db.cursor()
    sql="INSERT into ismp_runlog.runlog VALUES(null,4,'" + testmodule +"','" + testfuction +"',DATE_SUB(CURDATE(),INTERVAL 0 DAY),1,'" + testresult + "','" + testlev + "','" + description +"');"
    #print(sql)
    cursor.execute(sql)
    #desc = cursor.description  # 获取字段的描述，默认获取数据库字段名称，重新定义时通过AS关键重新命名即可
    #data_dict = [dict(zip([col[0] for col in desc], row)) for row in cursor.fetchall()]  # 列表表达式把数据组装起来
    db.commit()
    cursor.close()
    db.close()

#resinsert('a','b','c','1','d')
resinsert(sys.argv[1],sys.argv[2],sys.argv[3],sys.argv[4],sys.argv[5])

 

使用方法

1.系统安装python3,pymsql

2.命令行敲：python3 result.py "module" "function" "pass" "2" "no problem"

3.