• 新写了,发送邮件的方法,以及怎么怎么去分页循环查数据处理


    import pymysql
    import requests
    import json
    import  smtplib
    import email.mime.multipart
    import email.mime.text
    from email.mime.application import MIMEApplication
    
    
    
    def request_jiuyitong(uid,depid,doctorid):
        url="https://wsapitest2.91160.com/index.php?c=sch&a=getDoctor"
        data={
            "cid" : "100012848",
            "token" : "85422afb467e9456013a2a51d4dff702",
            "uid" : uid,
            "depid" : depid,
            "doctorid": doctorid
        }
        response=requests.request(method="POST",url=url,data=data,verify=False)
        state=str(json.loads(response.text).get("state"))
        msg=str(json.loads(response.text).get("msg"))
        return state,msg
    
    def select_data(now):
        coon=pymysql.connect(host="10.1.22.107",port=3306,user="zhongtai",password="km5YFa1m9OWKJinw",database="cooperation_avatar",charset='utf8')
        cur=coon.cursor()
        sql="SELECT partnerhospitalid,partnerfacultyid,partnerdoctorid,doctorid FROM cooperation_avatar.`cooperations` WHERE partnersource='Jiuyitong' AND STATUS = 'Valid' ORDER BY ctime DESC LIMIT {m},1000".format(m=now)
        cur.execute(sql)
        results=cur.fetchall()
        return results
    
    
    def sendmail(content):
        '''
        :param smtpHost: 域名
        :param sendAddr: 发送邮箱
        :param password: 邮箱密码
        :param QQ_ShouQuanMa: # qq邮箱需要开启的授权码
        :param recipientAddrs: 发送地址
        :param subject: 标题
        :param content: 内容
        :return: 无
        '''
    
    
    
    
        QQ_ShouQuanMa = "eellpsozuujmbafa"  # qq邮箱需要开启授权
        CONTENT = str(content)  #邮箱发送的内容,需要转化成字符串
        # 设置邮件信息
        sendAddr = "1173829775@qq.com"  # 发件人邮箱
        password = QQ_ShouQuanMa  # 发件人邮箱密码(需要填写的授权码,不是密码)
        recipientAddrs = ["zhangzhenglai@haodf.com","540751032@qq.com"]  # 收件人邮箱
        subject = "合作挂号有问题的医生"  # 标题
        content = CONTENT  # 内容
    
    
    
        msg = email.mime.multipart.MIMEMultipart()
        msg['from'] = sendAddr
        msg['to'] = recipientAddrs
        msg['subject'] = subject
        txt = email.mime.text.MIMEText(content, 'plain', 'utf-8')
        msg.attach(txt)
    
        # 附件
        # directory = "test3"  # 目录
        # file_name = "test.zip"  # 文件名
        # attachment_url = "C:\test\test2\ " + directory + "\ " + file_name
        # attachment_url = ''.join(attachment_url.split())
    
        # 添加附件地址
        # part = MIMEApplication(open(r"" + attachment_url + "", 'rb').read())
        # part.add_header('Content-Disposition', 'attachment', filename="邮件中显示的文件名称.zip")  # 发送文件名称
        # msg.attach(part)
    
        smtp = smtplib.SMTP('smtp.qq.com', 25)  # SMTP服务器
        # 新浪邮箱:smtp.sina.com,新浪VIP:smtp.vip.sina.com,搜狐邮箱:smtp.sohu.com,126邮箱:smtp.126.com,139邮箱:smtp.139.com,163网易邮箱:smtp.163.com。
        smtp.login(sendAddr, password)
        text=smtp.sendmail(sendAddr, recipientAddrs, str(msg))
        print(text)
        print("发送成功!")
    
    
    def find_problem_doctor():
        doctorlist = {}
        now = 0
        while True:
            results=select_data(now)
            if results is None:
                break
            for data in results:
                partnerhospitalid = data[0]
                partnerfacultyid = data[1]
                partnerdoctorid = data[2]
                doctorid = data[3]
                DOCTORID = "doctorId" + ":" + str(doctorid)
                now=now+1000
                text, msg = request_jiuyitong(partnerhospitalid, partnerfacultyid, partnerdoctorid)
                if text != "1":
                    doctorlist[DOCTORID] = msg
        sendmail(doctorlist)
    
    
    find_problem_doctor()
  • 相关阅读:
    面向对象 委托
    面向对象 继承 接口
    C# 面向对象 , 类与对象
    C# 知识点回顾
    SQL 数据库知识点回顾
    C# 10 总复习
    spring boot jpa 表关联查询分组 group by 去重
    钉钉新增考勤组 设置考勤规则
    elasticsearch 学习之父子关联查询 parent/child
    Elasticsearch 查询学习
  • 原文地址:https://www.cnblogs.com/zhenglai/p/13229470.html
Copyright © 2020-2023  润新知