class CountFrame(Frame): # 继承Frame类
def __init__(self, master=None):
Frame.__init__(self, master)
self.root = master # 定义内部变量root
self.mysqlClient = MysqlClient()
self.message = StringVar()
# self.createPage()
def createPage(self):
Label(self).grid(row=0, stick=W, pady=10)
Label(self, text='请输入: ').grid(row=1, stick=W, pady=10)
Entry(self, textvariable=self.message, width=40).grid(row=2, stick=W)
Button(self, text='发布', command=self.set_message).grid(row=10,
column=2,
stick=E,
pady=10)
def set_message(self):
name = config.USERNAME
message = self.message.get()
publishDateStr = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
publishDate = int(time.time())
sql = "insert into content(name,message,publishDateStr,publishDate) values ('%s','%s','%s','%s')" % (
name, message, publishDateStr, publishDate)
save_res = self.mysqlClient.save(sql)
if save_res:
showinfo(title='成功', message='发布成功')
else:
showinfo(title='失败', message='发布失败')
return save_res
class RegPage(object):
def __init__(self, master=None):
self.root = master # 定义内部变量root
self.root.geometry('%dx%d' % (300, 200)) # 设置窗口大小
self.username = StringVar()
self.password = StringVar()
self.repassword = StringVar()
self.createPage()
self.mysqlClient = MysqlClient()
def createPage(self):
self.page = Frame(self.root) # 创建Frame
self.page.pack()
Label(self.page).grid(row=0, stick=W)
Label(self.page, text='账户: ').grid(row=1, stick=W, pady=10)
Entry(self.page, textvariable=self.username).grid(row=1,
column=1,
stick=E)
Label(self.page, text='密码: ').grid(row=2, stick=W, pady=10)
Entry(self.page, textvariable=self.password, show='*').grid(row=2,
column=1,
stick=E)
Label(self.page, text='确认密码: ').grid(row=3, stick=W, pady=10)
Entry(self.page, textvariable=self.repassword, show='*').grid(row=3,
column=1,
stick=E)
# Button(self.page, text='退出', command=self.page.quit).grid(row=3, column=1, stick=E)
Button(self.page, text='注册', command=self.register).grid(row=4,
column=1,
stick=E)
def register(self):
name = self.username.get()
password = self.password.get()
repassword = self.repassword.get()
if name.strip() == '' or password.strip() == '' or repassword.strip(
) == '':
showinfo(title='注册失败', message='账户名或者密码不能为空')
return
if password == repassword:
sql = "select * from user where(name='%s')" % (name)
find_res = self.mysqlClient.find_one(sql)
if find_res:
showinfo(title='错误', message='该用户已存在')
else:
sql = "insert into user(name,password) values ('%s','%s')" % (
name, password)
add_res = self.mysqlClient.save(sql)
if add_res:
showinfo(title='注册成功', message='注册成功')
self.page.destroy()
login = LoginPage.LoginPage(self.root)
else:
showinfo(title='注册失败', message='注册失败')
else:
showinfo(title='错误', message='两次输入的密码不一致')
class Scheduler(object):
def __init__(self):
self.download = Download()
self.db = MysqlClient()
self.redisClient = RedisClient()
def run(self):
#self.get_qu()
#self.get_zhen()
# self.push_url_to_redis()
self.get_position()
def get_qu(self):
sql = 'select * from shi'
results = self.db.find_all(sql)
for res in results:
shi_id = res[2]
url = SHI_URL.format(shi_id='c' + shi_id)
print(url)
html = self.download.get_html(url)
if html.status_code == 200 and html is not None:
html = HTML(html.text)
qu_id_list = html.xpath(
'//dl[@class="condition-district show-condition-district"]/dd/a/@href'
)
qu_name_list = html.xpath(
'//dl[@class="condition-district show-condition-district"]/dd/a/text()'
)
for qu_id, name in zip(qu_id_list[1:], qu_name_list[1:]):
qu_id = qu_id.split('/')
qu_id = qu_id[2]
sql = '''insert into qu(pid,qu_id,name) VALUES ('{pid}','{qu_id}','{name}')'''\
.format(pid=shi_id,qu_id=qu_id, name=name)
print(sql)
self.db.save(sql)
else:
print('该url无数据')
def get_zhen(self):
sql = 'select * from qu'
results = self.db.find_all(sql)
for res in results:
shi_id = res[1]
qu_id = res[2]
url = QU_URL.format(shi_id='c' + shi_id, qu_id=qu_id)
print(url)
html = self.download.get_html(url)
if html is not None and html.status_code == 200:
html = HTML(html.text)
zhen_id_list = html.xpath(
'//dl[@class="condition-area show-condition-area"]/dd/a/@href'
)
zhen_name_list = html.xpath(
'//dl[@class="condition-area show-condition-area"]/dd/a/text()'
)
for zhen_id, name in zip(zhen_id_list[1:], zhen_name_list[1:]):
zhen_id = zhen_id.split('/')
zhen_id = zhen_id[2]
sql = '''insert into zhen(pid,qu_id, zhen_id,name) VALUES ('{pid}','{qu_id}','{zhen_id}','{name}')'''\
.format(pid=shi_id,qu_id=qu_id,zhen_id=zhen_id, name=name)
print(sql)
self.db.save(sql)
else:
print('该url无数据')
def get_position(self):
redis_results = self.redisClient.pop('employment')
try:
json_obj = json.loads(redis_results[1].decode('utf8'))
except:
return None
if json_obj:
flag = True
pageToken = 1
#处理翻页问题
while flag:
detail_url_list = []
url = json_obj['url']
pre_page = re.search('\/\?page=(.*?)&', url).group(1)
if int(pageToken) > 10:
break
url = url.replace(
'page=' + pre_page + '&sort=2&ka=page-' + pre_page,
'page=' + str(pageToken) + '&sort=2&ka=page-' +
str(pageToken))
cityId = json_obj['cityId']
zhiweiId = json_obj['zhiweiId']
print(url)
html = self.download.get_html(url)
if html is not None and html.status_code == 200:
html = HTML(html.text)
#判断是否是当天发布，是的话请求详情页, 判断数据库是否有这条数据，有的话不请求（暂时）
li_xpath = html.xpath('//div[@class="job-list"]/ul/li')
for li in li_xpath:
content = etree.tostring(li)
content = HT.unescape(content.decode())
content = HTML(content)
li_time = content.xpath(
'string(//div[@class="info-publis"]/p)')
href_url = content.xpath(
'string(//div[@class="info-primary"]//h3/a/@href)')
try:
last_str = li_time.split('发布于')[1]
minute = last_str.split(':')[1]
#判断是否当天发布
if minute:
#判断数据库存不存在：
try:
cid = re.match('^/job_detail/(.*?)\.html',
href_url).group(1)
sql = "select * from positions where cid='%s'" % (
cid)
find_one_res = self.db.find_one(sql)
if find_one_res is None:
#先把cid插入，避免重复抓取
sql = "insert into positions(cid) values ('%s')" % (
cid)
self.db.save(sql)
detail_url_list.append(
config.HOST_URL + href_url)
elif find_one_res[2] is None:
detail_url_list.append(
config.HOST_URL + href_url)
else:
print('数据库存在该记录：' + str(cid))
except:
print('查询数据库出错：' + str(cid))
except:
print('该URL发布日期小于当天：' + config.HOST_URL + href_url)
results = self.get_detail(detail_url_list, cityId,
zhiweiId)
#判断是否翻页
try:
last_li = html.xpath(
'string(//div[@class="job-list"]/ul/li[last()]//div[@class="info-publis"]/p)'
)
last_str = last_li.split('发布于')[1]
minute = last_str.split(':')[1]
if minute:
pageToken = str(int(pageToken) + 1)
except:
flag = False
else:
print('该url无数据')
def get_detail(self, detail_url_list, cityId, zhiweiId):
for url in detail_url_list:
print('下载该详情页：' + url)
html = self.download.get_html(url)
if html is not None and html.status_code == 200:
html = HTML(html.text)
try:
cid = re.match(
'^https://www.zhipin.com/job_detail/(.*?)\.html',
url).group(1)
except:
print('获取cid失败')
continue
title = html.xpath('string(//h1)')
url = url
try:
publishDateStr = html.xpath(
'string(//span[@class="time"])').split('发布于')[1]
publishDate = int(
time.mktime(
time.strptime(publishDateStr, "%Y-%m-%d %H:%M")))
except:
publishDateStr = None
publishDate = None
try:
info = html.xpath(
'string(//div[@class="job-banner"]//div[@class="info-primary"]/p)'
)
info = info.split('：')
city = info[1][:-2]
jingyan = info[2][:-2]
xueli = info[3]
except:
city = None
jingyan = None
xueli = None
price = html.xpath(
'string(//div[@class="info-primary"]//span[@class="badge"])'
)
posterName = html.xpath('string(//h2)')
posterId = None
posterUrl = html.xpath(
'string(//div[@class="detail-figure"]/img/@src)')
content = html.xpath(
'string(//div[@class="job-sec"]/div[@class="text"])'
).strip()
try:
company_text = html.xpath(
'string(//a[@ka="job-cominfo"]/@href)')
companyID = re.match('/gongsi/(.*?)\.html',
company_text).group(1)
except:
companyID = None
createDate = int(time.time())
#判断是否是当天发布
temp_time = time.localtime(int(time.time()))
now_DateStr = time.strftime("%Y-%m-%d", temp_time)
lt = time.strptime(now_DateStr, "%Y-%m-%d")
now_timestamp = int(time.mktime(lt))
if publishDate == None or publishDate < now_timestamp or publishDate >= (
now_timestamp + 86400):
print('特例.该url不是当天发布：' + str(url))
continue
res_obj = {
'cid': cid,
'title': title,
'url': url,
'publishDateStr': publishDateStr,
'publishDate': publishDate,
'city': city,
'jingyan': jingyan,
'xueli': xueli,
'price': price,
'posterName': posterName,
'posterId': posterId,
'posterUrl': posterUrl,
'content': content,
'companyID': companyID,
'createDate': createDate,
'cityId': cityId,
'zhiweiId': zhiweiId
}
print(res_obj)
sql = "insert into positions(cid,title,url,publishDate,publishDateStr,city,jingyan,xueli,price,posterName,posterId,posterUrl,content,companyID,createDate,cityId, zhiweiId)" \
" VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" \
% (cid,title,url,publishDate,publishDateStr,city,jingyan,xueli,price,posterName,posterId,posterUrl,content,companyID,createDate,cityId, zhiweiId)\
+ "ON DUPLICATE KEY UPDATE title='%s', url='%s', publishDate='%s', publishDateStr='%s', city='%s', jingyan='%s', xueli='%s', price='%s', posterName='%s', posterId='%s', posterUrl='%s', content='%s', companyID='%s', createDate='%s',cityId='%s', zhiweiId='%s'" \
%(title,url,publishDate,publishDateStr,city,jingyan,xueli,price,posterName,posterId,posterUrl,content,companyID,createDate,cityId, zhiweiId)
self.db.save(sql)
else:
print('请求详情页失败：' + str(url))
def push_url_to_redis(self):
# zhiwei_list = []
# zhiwei_sql = 'select * from zhiwei'
# zhiwei_results = self.db.find_all(zhiwei_sql)
# for zhiwei in zhiwei_results:
# zhiwei_list.append(zhiwei[2])
#
# zhen_sql = 'select * from zhen'
# zhen_results = self.db.find_all(zhen_sql)
#
# for res in zhen_results:
# pid = res[1]
# zhen_id = res[2]
# for zhiwei_id in zhiwei_list:
# url = POSITION_URL.format(pid=pid, zhen_id=zhen_id, zhiwei_id=zhiwei_id, pageToken='1')
# self.redisClient.push('employment',url)
zhiwei_list = []
zhiwei_sql = 'select * from zhiwei'
zhiwei_results = self.db.find_all(zhiwei_sql)
for zhiwei in zhiwei_results:
zhiwei_list.append(zhiwei[2])
shi_sql = 'select * from shi'
shi_results = self.db.find_all(shi_sql)
for res in shi_results:
pid = res[2]
for zhiwei_id in zhiwei_list:
url = NEW_POSITION_URL.format(pid=pid,
zhiwei_id=zhiwei_id,
pageToken='1')
url_obj = {"url": url, "cityId": pid, "zhiweiId": zhiwei_id}
self.redisClient.push('employment', json.dumps(url_obj))
class InputFrame(Frame): # 继承Frame类
def __init__(self, master=None):
Frame.__init__(self, master)
self.root = master # 定义内部变量root
self.word = StringVar()
self.mean = StringVar()
self.createPage()
self.mysqlClient = MysqlClient()
self.spider = spider.Spider()
def createPage(self,
query_res={
'fanyi': '',
'phonetic': '',
'translation': ''
}):
Label(self).grid(row=0, stick=W, pady=10)
Label(self, text='请输入: ').grid(row=1, stick=W, pady=10)
Entry(self, textvariable=self.word, width=40).grid(row=2, stick=W)
Label(self, text='结果如下: ').grid(row=4, stick=W, pady=10)
Label(self,
text=query_res['fanyi'],
height=2,
width=40,
justify='left').grid(row=5, stick=W, pady=10)
Label(self,
text=query_res['phonetic'],
height=2,
width=40,
justify='left').grid(row=6, stick=W, pady=10)
Label(self,
text=query_res['translation'],
height=2,
width=40,
justify='left').grid(row=7, stick=W, pady=10)
# Entry(self, textvariable=self.mean).grid(row=3, column=1, stick=E)
# Text(self, height=5, width=50).grid(row=4, column=1, stick=W)
Button(self, text='查询', command=self.query_word).grid(row=10,
column=1,
stick=E,
pady=10)
Button(self, text='收藏', command=self.collect_word).grid(row=10,
column=2,
stick=E,
pady=10)
def query_word(self):
#插入到历史查询记录
word = self.word.get()
eng = '1'
# 是中文
if '\u4e00' <= word[0] <= '\u9fff':
eng = '0'
query_res = self.spider.get_dic(word, eng=eng)
self.createPage(query_res)
#添加到历史查询记录
name = config.USERNAME
mean = json.dumps(query_res['fanyi'])
mytime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
timestamp = int(time.time())
sql = "insert into history(word,mean,name,time,timestamp) values('%s','%s','%s','%s','%s')" % (
word, mean, name, mytime, timestamp)
print(sql)
self.mysqlClient.save(sql)
def collect_word(self):
word = self.word.get()
eng = '1'
# 是中文
if '\u4e00' <= word[0] <= '\u9fff':
eng = '0'
query_res = self.spider.get_dic(word, eng=eng)
self.createPage(query_res)
# 添加到我的收藏
name = config.USERNAME
mean = json.dumps(query_res)
mytime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
timestamp = int(time.time())
sql = "insert into collection(word,mean,name,time,timestamp) values('%s','%s','%s','%s','%s')" % (
word, mean, name, mytime, timestamp)
save_res = self.mysqlClient.save(sql)
if save_res:
showinfo(title='成功', message='收藏成功')
else:
showinfo(title='失败', message='收藏失败！')
class InputFrame(Frame): # 继承Frame类
def __init__(self, master=None):
Frame.__init__(self, master)
self.root = master # 定义内部变量root
self.word = StringVar()
self.mean = StringVar()
self.createPage()
self.mysqlClient = MysqlClient()
self.spider = spider.Spider()
def createPage(self,
query_res={
'fanyi': '',
'phonetic': '',
'translation': ''
}):
# self.fm2 = Frame(self.root)
# Button(self, text='Left').pack(side=LEFT)
# Button(self, text='This is the Center button').pack(side=LEFT)
# Button(self, text='Right').pack(side=LEFT)
# self.fm2.pack(side=LEFT, padx=10)
Label(self).grid(row=0, stick=W, pady=10)
Label(self, text='请输入: ').grid(row=1, stick=W, pady=10)
Entry(self, textvariable=self.word, width=40).grid(row=2, stick=W)
Label(self, text='结果如下: ').grid(row=4, stick=W, pady=10)
Label(self,
text='翻译：' + query_res['fanyi'],
height=2,
width=40,
justify='left').grid(row=5, stick=W, pady=10)
Label(self,
text='发音：' + query_res['phonetic'],
height=2,
width=40,
justify='left').grid(row=6, stick=W, pady=10)
Label(self,
text='其他：' + query_res['translation'],
height=2,
width=40,
justify='left').grid(row=7, stick=W, pady=10)
# Entry(self, textvariable=self.mean).grid(row=3, column=1, stick=E)
# Text(self, height=5, width=50).grid(row=4, column=1, stick=W)
Button(self, text='查询', command=self.query_word).grid(row=10,
column=1,
stick=E,
pady=10)
Button(self, text='收藏', command=self.collect_word).grid(row=10,
column=2,
stick=E,
pady=10)
def query_word(self):
word = self.word.get()
#是英文
eng = '1'
# 是中文
if '\u4e00' <= word[0] <= '\u9fff':
eng = '0'
#先判断在不在当前数据库，不在再用360翻译接口
sql1 = "select * from words where en_word like '%s'" % (word)
find_res1 = self.mysqlClient.find_one(sql1)
sql2 = "select * from words where cn_word like '%s'" % (word)
find_res2 = self.mysqlClient.find_one(sql2)
if find_res1:
query_res = {
'fanyi': find_res1[2],
'phonetic': '',
'translation': '',
}
self.createPage(query_res)
elif find_res2:
query_res = {
'fanyi': find_res2[1],
'phonetic': '',
'translation': '',
}
self.createPage(query_res)
else:
query_res = self.spider.get_dic(word, eng=eng)
if query_res:
self.createPage(query_res)
else:
showinfo(title='查询失败', message='查询失败，请检查您的网络')
#添加到历史查询记录
name = config.USERNAME
mean = json.dumps(query_res['fanyi'])
mytime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
timestamp = int(time.time())
sql = "insert into history(word,mean,name,time,timestamp) values('%s','%s','%s','%s','%s')" % (
word, mean, name, mytime, timestamp)
print(sql)
self.mysqlClient.save(sql)
def collect_word(self):
word = self.word.get()
# 是英文
eng = '1'
# 是中文
if '\u4e00' <= word[0] <= '\u9fff':
eng = '0'
# 先判断在不在当前数据库，不在再用360翻译接口
sql1 = "select * from words where en_word like '%s'" % (word)
find_res1 = self.mysqlClient.find_one(sql1)
sql2 = "select * from words where cn_word like '%s'" % (word)
find_res2 = self.mysqlClient.find_one(sql2)
if find_res1:
query_res = {
'fanyi': find_res1[2],
'phonetic': '',
'translation': '',
}
self.createPage(query_res)
elif find_res2:
query_res = {
'fanyi': find_res2[1],
'phonetic': '',
'translation': '',
}
self.createPage(query_res)
else:
query_res = self.spider.get_dic(word, eng=eng)
if query_res:
self.createPage(query_res)
else:
showinfo(title='查询失败', message='查询失败，请检查您的网络')
# 添加到我的收藏
name = config.USERNAME
mean = str(query_res['fanyi'])
mytime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
timestamp = int(time.time())
sql = "insert into collection(word,mean,name,time,timestamp) values('%s','%s','%s','%s','%s')" % (
word, mean, name, mytime, timestamp)
print(sql)
save_res = self.mysqlClient.save(sql)
if save_res:
showinfo(title='成功', message='收藏成功')
else:
showinfo(title='失败', message='收藏失败！')
class Scheduler(object):
def __init__(self):
self.download = Download()
self.db = MysqlClient()
def run(self):
self.get_books()
def get_books(self):
kw = input('请输入要查找的书籍（例如:python编程）:')
host_url = 'http://search.dangdang.com/?key={kw}&act=input&page_index={page}'
#删除原有数据
sql = 'delete from books'
self.db.save(sql)
for i in range(1, 10):
print('当前页：'+str(i))
start_url = host_url.format(kw=kw, page=i)
print(start_url)
response = self.download.get_html(start_url)
response.encoding = 'gbk'
# print(response.text)
html = HTML(response.text)
item_xpath_list = html.xpath('//div[@id="search_nature_rg"]/ul/li')
for item in item_xpath_list:
url = item.xpath('string(.//a[@name="itemlist-title"]/@href)')
bookId = re.search('http://product.dangdang.com/(\d+).html',url)
if bookId:
bookId = bookId.group(1)
else:
bookId = ''
title = item.xpath('string(.//a[@name="itemlist-title"]/@title)').strip()
now_price = item.xpath('string(.//span[@class="search_now_price"]/text())').replace('¥','')
old_price = item.xpath('string(.//span[@class="search_pre_price"]/text())').replace('¥','')
discount = item.xpath('string(.//span[@class="search_discount"]/text())').replace('(','').replace(')','').replace('折','').strip()
commentCount = item.xpath('string(.//a[@class="search_comment_num"]/text())').replace('条评论','')
author = item.xpath('string(.//p[@class="search_book_author"]/span[1]/a/@title)')
publishDateStr = item.xpath('string(.//p[@class="search_book_author"]/span[2]/text())').replace('/','').strip()
publishing = item.xpath('string(.//p[@class="search_book_author"]/span[3]/a/text())')
# print(url)
# print(title)
# print(now_price)
# print(old_price)
# print(discount)
# print(commentCount)
# print(author)
# print(publishDateStr)
# print(publishing)
sql = "insert into books(bookId,url,title,now_price,old_price,discount,commentCount,publishDateStr,author,publishing)" \
" VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" \
% (bookId,url,title,now_price,old_price,discount,commentCount,publishDateStr,author,publishing) \
+ "ON DUPLICATE KEY UPDATE title='%s'" % (title)
print(sql)
self.db.save(sql)
class Scheduler(object):
def __init__(self):
self.download = Download()
self.db = MysqlClient()
# self.redisClient = RedisClient()
def run(self):
bestseller = get_bestseller.Bestseller()
bestseller.start()
# for i in range(1,11):
# self.get_kw('apple',str(i))
def get_kw(self, kw, page):
url = 'https://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords={kw}&page={page}'.format(
kw=kw, page=page)
print(url)
response = self.download.get_html(url)
if response is not None:
html = HTML(response.text)
# titles = html.xpath('//div[@class="a-row a-spacing-small"]//a/h2/text()')
urls = html.xpath('//div[@class="a-row a-spacing-small"]//a/@href')
for url in urls:
if url[:3] == '/gp':
url = 'https://www.amazon.com' + url
detail_response = self.download.get_html(url)
try:
url = re.search('<link rel="canonical" href="(.*?)"',
detail_response.text).group(1)
except:
url = url
detail_html = HTML(detail_response.text)
product_id = hashlib.md5(url.encode()).hexdigest()
title = detail_html.xpath('string(//h1[@id="title"])').strip()
price = detail_html.xpath(
'string(//span[@id="priceblock_ourprice"])').replace(
',', '').replace('$', '')
if price == '':
price = 0
color = detail_html.xpath(
'string(//div[@id="variation_color_name"]//span)').strip()
size = detail_html.xpath(
'string(//div[@id="variation_size_name"]//span)').strip()
commentCount = detail_html.xpath(
'string(//span[@id="acrCustomerReviewText"])').split(
' ')[0].replace(',', '')
if commentCount == '':
commentCount = 0
commentRating = detail_html.xpath(
'string(//a[@class="a-popover-trigger a-declarative"]/i/span)'
).split(' ')[0]
if commentRating == '':
commentRating = 0
crawled_timestamp = int(time.time())
crawled_time = time.strftime("%Y-%m-%d %H:%M:%S",
time.localtime())
crawled_date = time.strftime("%Y-%m-%d", time.localtime())
keywordtype = kw
#编号
try:
asin = re.search(
'.*?productDetails_detailBullets_sections1.*?ASIN.*?<td class="a-size-base">(.*?)</td>',
detail_response.text, re.S).group(1).strip()
except:
asin = None
#类目排名
try:
category_res1 = re.search(
'.*?productDetails_detailBullets_sections1.*?Best Sellers Rank.*?<span>.*?(<span>.*?</span>)',
detail_response.text, re.S)
category_res2 = re.search(
'.*?productDetails_detailBullets_sections1.*?Best Sellers Rank.*?<span>.*?<span>.*?</span>.*?(<span>.*?</span>).*?</span>',
detail_response.text, re.S)
if category_res1:
# rank_search = re.search('.*?#(.*?)in.*?', category_res1.group(1))
# if rank_search:
# rank1 = rank_search.group(1)
# else:
# rank1 = None
# print(rank1)
html = HTML(category_res1.group(1))
list_res = html.xpath('//text()')
rank1 = ''.join(list_res)
if category_res2:
html = HTML(category_res2.group(1))
list_res = html.xpath('//text()')
rank2 = ''.join(list_res)
except:
rank1 = None
rank2 = None
#图片信息入库
try:
imageUrls = []
img_res = re.search(
"var data = {};.*?var obj = jQuery.parseJSON\('(.*?)'\);",
detail_response.text, re.S)
img_obj = json.loads(img_res.group(1))
key_one = list(img_obj['colorImages'].keys())[0]
for data in img_obj['colorImages'][key_one]:
imageUrls.append(data['large'])
for img in imageUrls:
img_id = hashlib.md5(img.encode()).hexdigest()
img_url = img
sql = "insert into image(product_id,img_id,img_url,crawled_timestamp,crawled_time) values ('%s','%s','%s','%s','%s')" \
% (product_id,img_id,img_url,crawled_timestamp,crawled_time) \
+ "ON DUPLICATE KEY UPDATE crawled_timestamp='%s',crawled_time='%s'" % (crawled_timestamp, crawled_time)
print(sql)
self.db.save(sql)
except:
pass
#跟卖信息入库
have_follow_sale = '0'
follow_sale_num = 0
follow_sale_str = detail_html.xpath(
'string(//div[@id="olp_feature_div"]/div/span)')
if follow_sale_str != '':
have_follow_sale = '1'
follow_sale_num = re.search('\((\d+)\)',
follow_sale_str).group(1)
follow_sale_url = detail_html.xpath(
'string(//div[@id="olp_feature_div"]/div/span/a/@href)')
if follow_sale_url[0:4] == 'http':
follow_sale_url = follow_sale_url
else:
follow_sale_url = 'https://www.amazon.com' + follow_sale_url + '&startIndex={startIndex}'
follow_response = self.get_follow_sale(follow_sale_url,
follow_sale_num)
for item in follow_response:
follow_sale_id = item['follow_sale_id']
price = item['price']
seller = item['seller']
type = item['type']
sql = "insert into follow_sale(product_id,follow_sale_id,price,seller,type,crawled_timestamp,crawled_time) values ('%s','%s','%s','%s','%s','%s','%s')" \
% (product_id,follow_sale_id,price,seller,type,crawled_timestamp,crawled_time) \
+ "ON DUPLICATE KEY UPDATE crawled_timestamp='%s',crawled_time='%s'" % (crawled_timestamp, crawled_time)
print(sql)
self.db.save(sql)
#商品信息入库
obj = {
'product_id': product_id,
'title': title,
'url': url,
'price': price,
'color': color,
'size': size,
'commentCount': commentCount,
'commentRating': commentRating,
# 'imageUrls': imageUrls,
'crawled_timestamp': crawled_timestamp,
'crawled_time': crawled_time,
'have_follow_sale': have_follow_sale,
'follow_sale_num': follow_sale_num,
}
print(obj)
sql = "insert into keyword_res(product_id,title,url,price,color,size,commentCount,commentRating,have_follow_sale,follow_sale_num,asin,rank1,rank2,crawled_timestamp,crawled_time,crawled_date,keywordtype) values ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')"\
% (product_id, title, url, price, color, size, commentCount, commentRating,have_follow_sale,follow_sale_num,asin,rank1,rank2, crawled_timestamp, crawled_time,crawled_date,keywordtype)\
+ "ON DUPLICATE KEY UPDATE title='%s', url='%s', price='%s',commentCount='%s',crawled_timestamp='%s',crawled_time='%s',crawled_date='%s'"%(title,url,price,commentCount,crawled_timestamp,crawled_time,crawled_date)
print(sql)
self.db.save(sql)
def get_follow_sale(self, url, follow_sale_num):
if follow_sale_num == 0:
return []
if int(follow_sale_num) > 10:
pageNum = math.ceil(int(follow_sale_num) / 10)
else:
pageNum = 1
item_list = []
for page in range(0, pageNum):
startIndex = page * 10
url = url.format(startIndex=startIndex)
print(url)
follow_response = self.download.get_html(url)
if follow_response is None:
return []
follow_html = HTML(follow_response.text)
html_list = follow_html.xpath(
'//div[@class="a-row a-spacing-mini olpOffer"]')
for html in html_list:
html = etree.tostring(html).decode()
html = HTML(html)
price = html.xpath(
'string(//div[@class="a-column a-span2 olpPriceColumn"]/span)'
).strip().replace('$', '')
seller = html.xpath('string(//h3/span)').strip()
FBA = html.xpath('string(//div[@class="olpBadge"])')
type = 'FBM'
if FBA != '':
type = 'FBA'
follow_sale_id = hashlib.md5(
(seller + price + type).encode()).hexdigest()
obj = {
'follow_sale_id': follow_sale_id,
'price': price,
'seller': seller,
'type': type
}
print(obj)
item_list.append(obj)
return item_list
class Bestseller(object):
def __init__(self):
self.download = Download()
self.mysql = MysqlClient()
def start(self):
# res1 = self.get_url('onedepa')
# res2 = self.get_url('twodepa')
res3 = self.get_url('threedepa')
# self.get_html(res1)
# self.get_html(res2)
self.get_html(res3[4317:4319])
def get_url(self, typename):
sql = "select * from %s" % (typename)
results = self.mysql.find_all(sql)
return results
def get_html(self, results):
for res in results:
url = res[5]
typeid = res[1]
temp_url_lit = []
url_one = url
page2_replace = re.search(
'https://www.amazon.com.*?ref=zg_bs_(.*?/\d+-\d+-\d+)',
url).group(1)
url_tow = url.replace(page2_replace, 'pg_2?&pg=2')
temp_url_lit.append(url_one)
temp_url_lit.append(url_tow)
for url in temp_url_lit:
response = self.download.get_html(url)
if response:
html = HTML(response.text)
url_list = html.xpath(
'//div[@id="zg-center-div"]/ol/li//a[@class="a-link-normal a-text-normal"]/@href'
)
for detail_url in url_list:
spider_url = 'https://www.amazon.com' + detail_url
detail_response = self.download.get_html(spider_url)
if detail_response:
detail_html = HTML(detail_response.text)
sellrank = re.search(
'https://www.amazon.com/.*?/dp/.*?ref=.*?_(\d+)/\d+-\d+-\d+\?',
spider_url).group(1)
print('sellrank:' + sellrank)
product_id = hashlib.md5(
detail_url.encode()).hexdigest()
title = detail_html.xpath(
'string(//h1[@id="title"])').strip()
price = detail_html.xpath(
'string(//span[@id="priceblock_ourprice"])'
).replace(',', '').replace('$', '')
if price == '':
price = 0
color = detail_html.xpath(
'string(//div[@id="variation_color_name"]//span)'
).strip()
size = detail_html.xpath(
'string(//div[@id="variation_size_name"]//span)'
).strip()
commentCount = detail_html.xpath(
'string(//span[@id="acrCustomerReviewText"])'
).split(' ')[0].replace(',', '')
if commentCount == '':
commentCount = 0
commentRating = detail_html.xpath(
'string(//a[@class="a-popover-trigger a-declarative"]/i/span)'
).split(' ')[0]
if commentRating == '':
commentRating = 0
crawled_timestamp = int(time.time())
crawled_time = time.strftime(
"%Y-%m-%d %H:%M:%S", time.localtime())
crawled_date = time.strftime(
"%Y-%m-%d", time.localtime())
# 编号
try:
asin = re.search(
'https://www.amazon.com/.*?/dp/(.*?)/ref=.*?',
spider_url).group(1)
except:
asin = None
# 类目排名
rank1 = None
rank2 = None
# try:
# category_res1 = re.search('.*?productDetails_detailBullets_sections1.*?Best Sellers Rank.*?<span>.*?(<span>.*?</span>)',detail_response.text, re.S)
# category_res2 = re.search('.*?productDetails_detailBullets_sections1.*?Best Sellers Rank.*?<span>.*?<span>.*?</span>.*?(<span>.*?</span>).*?</span>', detail_response.text, re.S)
# if category_res1:
# # rank_search = re.search('.*?#(.*?)in.*?', category_res1.group(1))
# # if rank_search:
# # rank1 = rank_search.group(1)
# # else:
# # rank1 = None
# # print(rank1)
# html = HTML(category_res1.group(1))
# list_res = html.xpath('//text()')
# rank1 = ''.join(list_res)
# if category_res2:
# html = HTML(category_res2.group(1))
# list_res = html.xpath('//text()')
# rank2 = ''.join(list_res)
# except:
# rank1 = None
# rank2 = None
# 图片信息入库
try:
imageUrls = []
img_res = re.search(
"var data = {};.*?var obj = jQuery.parseJSON\('(.*?)'\);",
detail_response.text, re.S)
img_obj = json.loads(img_res.group(1))
key_one = list(
img_obj['colorImages'].keys())[0]
for data in img_obj['colorImages'][key_one]:
imageUrls.append(data['large'])
for img in imageUrls:
img_id = hashlib.md5(
img.encode()).hexdigest()
img_url = img
sql = "insert into image(product_id,img_id,img_url,crawled_timestamp,crawled_time) values ('%s','%s','%s','%s','%s')" \
% (asin, img_id, img_url, crawled_timestamp, crawled_time) \
+ "ON DUPLICATE KEY UPDATE crawled_timestamp='%s',crawled_time='%s'" % (crawled_timestamp, crawled_time)
print(sql)
self.mysql.save(sql)
except:
pass
# 跟卖信息入库
have_follow_sale = '0'
follow_sale_num = 0
follow_sale_str = detail_html.xpath(
'string(//div[@id="olpPocs_feature_div"]/div/span)'
)
if follow_sale_str != '':
have_follow_sale = '1'
follow_sale_num = re.search(
'\((\d+)\)', follow_sale_str).group(1)
follow_sale_url = detail_html.xpath(
'string(//div[@id="olpPocs_feature_div"]/div/span/a/@href)'
)
if follow_sale_url[0:4] == 'http':
follow_sale_url = follow_sale_url
else:
follow_sale_url = 'https://www.amazon.com' + follow_sale_url + '&startIndex={startIndex}'
follow_response = self.get_follow_sale(
follow_sale_url, follow_sale_num)
for item in follow_response:
follow_sale_id = item['follow_sale_id']
price = item['price']
seller = item['seller']
type = item['type']
sql = "insert into follow_sale(product_id,follow_sale_id,price,seller,type,crawled_timestamp,crawled_time) values ('%s','%s','%s','%s','%s','%s','%s')" \
% (asin, follow_sale_id, price, seller, type, crawled_timestamp, crawled_time) \
+ "ON DUPLICATE KEY UPDATE crawled_timestamp='%s',crawled_time='%s'" % (crawled_timestamp, crawled_time)
print(sql)
self.mysql.save(sql)
# 商品信息入库
sql = "insert into bestseller(typeid,sellrank,product_id,title,url,price,color,size,commentCount,commentRating,have_follow_sale,follow_sale_num,asin,rank1,rank2,crawled_timestamp,crawled_time,crawled_date) values ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" \
% (typeid,sellrank,product_id,title,url,price,color,size,commentCount,commentRating,have_follow_sale,follow_sale_num,asin,rank1,rank2,crawled_timestamp,crawled_time,crawled_date) \
+ "ON DUPLICATE KEY UPDATE sellrank='%s',title='%s', url='%s', price='%s',commentCount='%s',crawled_timestamp='%s',crawled_time='%s',crawled_date='%s',follow_sale_num='%s'" % (
sellrank, title, spider_url, price, commentCount, crawled_timestamp, crawled_time,crawled_date,follow_sale_num)
print(sql)
self.mysql.save(sql)
def get_follow_sale(self, url, follow_sale_num):
if follow_sale_num == 0:
return []
if int(follow_sale_num) > 10:
pageNum = math.ceil(int(follow_sale_num) / 10)
else:
pageNum = 1
item_list = []
for page in range(0, pageNum):
startIndex = page * 10
url = url.format(startIndex=startIndex)
print(url)
follow_response = self.download.get_html(url)
if follow_response is None:
return []
follow_html = HTML(follow_response.text)
html_list = follow_html.xpath(
'//div[@class="a-row a-spacing-mini olpOffer"]')
for html in html_list:
html = etree.tostring(html).decode()
html = HTML(html)
price = html.xpath(
'string(//div[@class="a-column a-span2 olpPriceColumn"]/span)'
).strip().replace('$', '')
seller = html.xpath('string(//h3/span)').strip()
FBA = html.xpath('string(//div[@class="olpBadge"])')
type = 'FBM'
if FBA != '':
type = 'FBA'
follow_sale_id = hashlib.md5(
(seller + price + type).encode()).hexdigest()
obj = {
'follow_sale_id': follow_sale_id,
'price': price,
'seller': seller,
'type': type
}
print(obj)
item_list.append(obj)
return item_list