#-*-coding:utf-8-*-
# @Time :2021/4/17 14:58
# @Author:shuaichao
# @File :.py
# @Software: PyCharm
from bs4 import BeautifulSoup #网页解析，获悉数据.231
import re #正则表达式
import urllib.request,urllib.error #制定URL，获取网页数据
import pymysql
import traceback
import time
import requests
import json
#得到制定一个URL的网页内容
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="",
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 insert_news():
# cursor = None
# conn = None
# try:
# dic = getdata()[0] # 0是历史数据字典，1是最新详细数据列表
# print(f"{time.asctime()}开始插入历史数据")
# conn, cursor = get_conn()
# sql = "insert into history values(%s,%s,%s,%s,%s,%s,%s,%s,%s)"
# for k, v in dic.items():
# cursor.execute(sql, [k, v.get("confirm"), v.get("confirm_add"),
# v.get("suspect"), v.get("suspect_add"),
# v.get("heal"), v.get("heal_add"),
# v.get("dead"), v.get("dead_add"),
# v.get("confirm"),
# ])
# 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__":
baseurl = "https://news.sohu.com/"
html = askUrl(baseurl)
bs = BeautifulSoup(html, "html.parser")
ex_info = bs.find_all(class_="head-nav left")
info = str(ex_info)
findLink = re.compile(r'<a href="(.*?)">')
link = re.findall(findLink, info)
del link[0]
del link[0]
del link[9]
#新闻分类总个数
# for item in link:
# print(item)
#*************************************************************************************
'''
******************
体育类新闻
******************
'''
#第一块上
bs = get_info(link[0])
ex_info, info = transport(bs, "theme__color__hover")
print("************************************************************")
findinfo = re.compile(r'<a class="theme__color__hover" href="(.*?)" target="_blank">')
link0 = re.findall(findinfo, info)
# print(len(link0))
# for item in link0:
# print(item)
print("************************************************************")
#第一块下
ex_info, info = transport(bs, "s-one_center")
findinfo = re.compile(r'<a href="(.*?)" target="_blank">')
link1 = re.findall(findinfo, info)
# print(len(link1))
# for item in link1:
# print(item)
# print("************************************************************")
ex_info, info = transport(bs, "z-c-block-list-item")
findinfo = re.compile(r'<a href="(.*?)" target="_blank">')
link2 = re.findall(findinfo, info)
# print(len(link2))
# for item in link2:
# print(item)
# print("************************************************************")
ex_info, info = transport(bs, "z-c-block-list-item z-c-block-list-item-first")
findinfo = re.compile(r'<a href="(.*?)" target="_blank">')
link3 = re.findall(findinfo, info)
# print(len(link3))
# for item in link3:
# print(item)
# print("************************************************************")
ex_info, info = transport(bs, "z-c-block-list clear")
findinfo = re.compile(r'<a href="(.*?)" target="_blank">')
link4 = re.findall(findinfo, info)
# print(len(link4))
# for item in link4:
# print(item)
# print("************************************************************")
ex_info, info = transport(bs, "z-c-block")
findinfo = re.compile(r'<a href="(.*?)" target="_blank">')
link5 = re.findall(findinfo, info)
# print(len(link5))
# for item in link5:
# print(item)
# print("************************************************************")
ex_info, info = transport(bs, "z-head-news_item")
findinfo = re.compile(r'<a href="(.*?)" target="_blank">')
link6 = re.findall(findinfo, info)
# print(len(link5))
# for item in link5:
# print(item)
# print("************************************************************")
#所有链接相加
linkall = link0+link1+link2+link3+link4+link5+link6
#去除非文本类新闻
i =0
j =0
h =0
for index, value in enumerate(linkall):
if len(value) < 73:
del linkall[index]
for index, value in enumerate(linkall):
if len(value) < 73:
del linkall[index]
for index, value in enumerate(linkall):
if len(value) < 73:
del linkall[index]
# print(len(linkall))
#测试
# for item in linkall:
# print(item)
#去除重复链接
for index, value in enumerate(linkall):
for index1, value1 in enumerate(linkall):
if value == value1 and index != index1:
del linkall[index1]
for item in linkall:
print(item)
print(len(linkall))
# print("************************************************************")
allTitle = []
allArticle = []
allImg = []
#去除空页
for index, value in enumerate(linkall):
bs = get_info(value)
title = bs.select("h1")
if title:
#总标题表添加标题
continue
else:
print(index)
print(value)
del linkall[index]
#爬取数据
for index, value in enumerate(linkall):
bs = get_info(value)
title = bs.select("h1")
if title:
a = []
str = ''
#总标题表添加标题
allTitle.append(title[0].get_text().strip().replace("原创", "").replace("\n", ""))
print(index)
print(value)
print(title[0].get_text().strip().replace("原创", ""))
#总文章表添加文章
article = bs.select("article > p")
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]
#测试
print(len(linkall))
print(len(allTitle))
print(len(allArticle))
# print(len(allImg))
#插入mysql体育新闻数据
allinfo = []
for index, value in enumerate(allTitle):
allinfo.append([value])
allinfo[index].append(allArticle[index])
allinfo[index].append('体育')
# for item in allinfo:
# print(item)
update_news(allinfo)
浙公网安备 33010602011771号