#-*-coding:utf-8-*-
# @Time :2021/4/17 14:58
# @Author:shuaichao
# @File :.py
# @Software: PyCharm
from bs4 import BeautifulSoup #网页解析，获悉数据.231
import urllib.request,urllib.error #制定URL，获取网页数据
import pymysql
import traceback
import time
import requests
import json
#得到制定一个URL的网页内容
from pip._vendor.six \
import BytesIO
def askUrl(url):
head={
# "Cookie": "pgv_pvid = 2445437098;RK = IWJFENCj / 2;ptcz = 0dc31e9c452a0701259378ea4d93881f2a4d4ab7d29d637d6da1b0b24d857f4c;Qs_lvt_323937 = 1588214559;Qs_pv_323937 = 3783410537228747000;pgv_pvi = 5491528704;eas_sid = t196y05258V4B6g478m7t073P2;luin = o0775929901;lskey = 000100001264ed0bece633b72b741fb54e5137a729bfa3647db8a18c0ee96579fd05aff03206e6cafbeb0f88",
# "Connection": "keep-alive",
# "Cache-Control": "max-age = 0",
# "Accept-Language": "zh - CN, zh;q = 0.9",
# "Accept-Encoding": "gzip, deflate, br",
# "Accept": "text / html, application / xhtml + xml, application / xml;q = 0.9, image / webp, image / apng, * / *;q = 0.8",
"User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36 Edg/89.0.774.57"
}
if __name__ == '__main__':
request = urllib.request.Request(url, headers=head)
html = ""
try:
response = urllib.request.urlopen(request)
html = response.read().decode("utf-8")
except urllib.error.URLError as e:
if hasattr(e,"code"):
print(e.code)
if hasattr(e,"reason"):
print(e.reasen)
return html
#链接数据库
def get_conn():
conn = pymysql.connect(
host="localhost",
user="root",
passwd="qwer1234",
db="news",
charset="utf8mb4"
)
cursor = conn.cursor()
return conn, cursor
#关闭数据库
def close_conn(conn, cursor):
if cursor:
cursor.close()
if conn:
conn.close()
#更新新闻数据
def update_news(allinfo):
cursor = None
conn = None
try:
conn, cursor = get_conn()
sql = "insert into new(title, article, fenlei) values(%s,%s,%s)"
print(f"{time.asctime()}开始更新最新数据")
for item in allinfo:
cursor.execute(sql, item)
conn.commit()
print(f"{time.asctime()}更新最新数据完毕")
except:
traceback.print_exc()
finally:
close_conn(conn, cursor)
#爬取网页信息
def get_info(baseurl):
html = askUrl(baseurl)
bs = BeautifulSoup(html, "html.parser")
return bs
#soup处理并转换成字符串
def transport(bs, info):
ex_info = bs.find_all(class_=info)
info = str(ex_info)
return ex_info, info
if __name__=="__main__":
head = {
# "Cookie": "pgv_pvid = 2445437098;RK = IWJFENCj / 2;ptcz = 0dc31e9c452a0701259378ea4d93881f2a4d4ab7d29d637d6da1b0b24d857f4c;Qs_lvt_323937 = 1588214559;Qs_pv_323937 = 3783410537228747000;pgv_pvi = 5491528704;eas_sid = t196y05258V4B6g478m7t073P2;luin = o0775929901;lskey = 000100001264ed0bece633b72b741fb54e5137a729bfa3647db8a18c0ee96579fd05aff03206e6cafbeb0f88",
# "Connection": "keep-alive",
# "Cache-Control": "max-age = 0",
# "Accept-Language": "zh - CN, zh;q = 0.9",
# "Accept-Encoding": "gzip, deflate, br",
# "Accept": "text / html, application / xhtml + xml, application / xml;q = 0.9, image / webp, image / apng, * / *;q = 0.8",
"User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36 Edg/89.0.774.57"
}
# 存放所有的新闻网址
linkall = []
# 所有存放新闻的.js文件
linkJQ = []
# 所有超链接id
Linkid = []
# 所有超链接Authorid
LinkAid = []
# 存放所有标题
allTitle = []
# 存放所有文章
allArticle = []
# 存放所有图片链接
allImg = []
# 汇总所有存入mysql的数据
allinfo = []
#去除json数据中的非法字符
# str = 'https://v2.sohu.com/integration-api/mix/region/10459?size=25&adapter=pc&secureScore=50&page=2&pvId=16193134284174ePlzLC&requestId=2011032041009993_1619313472935&callback=jQuery1124048872472139460466_1619313428177&_=1619313428180'
# res = requests.get(str, headers=head)
# r = res.text.replace('/**/jQuery1124048872472139460466_1619313428177(', '')[:-2]
# response_data = json.loads(r, strict=False)
# print(response_data['data'][0]['authorId'])
# print(response_data['data'][0]['id'])
# 制作每个js网页的链接
index = 'https://v2.sohu.com/integration-api/mix/region/10459?page=1&size=500'
res = requests.get(index, headers=head)
response_data = json.loads(res.text)
#存入每个新闻的id和authorid
for index, value in enumerate(response_data['data']):
if int(response_data['data'][index]['id']) > 1000000:
Linkid.append(response_data['data'][index]['id'])
LinkAid.append(response_data['data'][index]['authorId'])
# 制作旅游新闻所有网址
for index, value in enumerate(Linkid):
linkall.append('https://www.sohu.com/a/' + str(Linkid[index])+'_' + str(LinkAid[index]) + '?scm=1002.590044.0.10372-1021&spm=smpc.ch25.content1-n-1.3.1619334835898hGaWxuo')
# 最后一个链接是广告，删除
# linkall.pop()
#开始爬取主要数据
for index, value in enumerate(linkall):
bs = get_info(value)
title = bs.select("h1")
article = bs.select("article > p")
if title and article:
a = []
str = ''
# 总标题表添加标题
allTitle.append(title[0].get_text().strip().replace("原创", "").replace("\n", ""))
print(index)
print(value)
print(title[0].get_text().strip().replace("原创", ""))
# 总文章表添加文章
for item in range(1, len(article)):
str += article[item].get_text()
# article = article[0].get_text().replace("返回搜狐，查看更多", "").replace("责任编辑：", "").replace(r"\n", "")
allArticle.append(str.replace("返回搜狐，查看更多", "").replace("责任编辑：", ""))
# 总图片表添加图片
# ex_info, info = transport(bs, "ql-align-center")
# findImg = re.compile(r'<p class="ql-align-center"><img max-width="600" src="(.*?)"/></p>')
# Img = re.findall(findImg, info)
# if Img:
# allImg.append(Img)
# else:
# allImg.append("")
else:
print(index)
print(value)
del linkall[index]
for index, value in enumerate(allTitle):
allinfo.append([value])
allinfo[index].append(allArticle[index])
allinfo[index].append('教育')
update_news(allinfo)
