from datetime importdatetimeimportjsonimporturllib.requestimportpymysql as pmsfrom apscheduler.schedulers.blocking importBlockingSchedulerfrom apscheduler.schedulers.background importBackgroundSchedulerimporttimeimportos#Mac下关闭ssl验证用到以下模块
importssl'''----------------------------------------------
# 需要CMD命令下安装以下支持库:
# pip install apscheduler
# pip install pymysql
# By wzy 2018-9-28
----------------------------------------------'''
#Mac下关闭ssl验证,不然会报错
ssl._create_default_https_context =ssl._create_unverified_context#你的钉钉机器人url
globalmyurl
my_url= "https://oapi.dingtalk.com/robot/send?access_token=XXXXXXXXXXXX"
defsend_request(url, datas):#传入url和内容发送请求
#构建一下请求头部
header ={"Content-Type": "application/json","Charset": "UTF-8"}
sendData= json.dumps(datas) #将字典类型数据转化为json格式
sendDatas = sendData.encode("utf-8") #python3的Request要求data为byte类型
#发送请求
request = urllib.request.Request(url=url, data=sendDatas, headers=header)#将请求发回的数据构建成为文件格式
opener =urllib.request.urlopen(request)#打印返回的结果
print(opener.read())defget_mysqldatas(sql):#一个