爬取天气网站获取天气信息,并生成语音播报
#!/usr/bin/env python3
# -*- coding : utf-8 -*-
'''从数据库中获取城市代码,城市code可从new_city_code.py中获取
即我另一篇文章城市code中
2017-8-9增加生成语音播报文件 参考yuyin.baidu.com
'''
from bs4 import BeautifulSoup
import requests
import pymysql
from aip import AipSpeech
import os
app_id = 'yours'
api_key = 'yours'
secret_key = 'yours'
db = pymysql.connect(host='localhost', user='dev', passwd='000000', db='test', use_unicode=True, charset='utf8')
cursor = db.cursor()
city_rul = 'https://my.oschina.net/joanfen/blog/140364'
header = {
'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8