zhufuquanzi_recommend_new.py 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396
  1. # -*- coding: utf-8 -*-
  2. # @Time: 2023/11/17
  3. import json
  4. import os
  5. import sys
  6. import time
  7. import uuid
  8. from hashlib import md5
  9. from appium import webdriver
  10. from appium.webdriver.extensions.android.nativekey import AndroidKey
  11. from appium.webdriver.webdriver import WebDriver
  12. from bs4 import BeautifulSoup
  13. from selenium.common import NoSuchElementException
  14. from selenium.webdriver.common.by import By
  15. sys.path.append(os.getcwd())
  16. from common import AliyunLogger, PiaoQuanPipeline, get_redirect_url
  17. from common.common import Common
  18. from common.mq import MQ
  19. from common.scheduling_db import MysqlHelper
  20. class ZFQZRecommend:
  21. platform = "祝福圈子"
  22. download_cnt = 0
  23. element_list = []
  24. i = 0
  25. @classmethod
  26. def start_wechat(cls, log_type, crawler, env, rule_dict, our_uid):
  27. if env == "dev":
  28. chromedriverExecutable = "/Users/piaoquan/Downloads/chromedriver"
  29. else:
  30. chromedriverExecutable = "/Users/piaoquan/Downloads/chromedriver"
  31. Common.logger(log_type, crawler).info("启动微信")
  32. # Common.logging(log_type, crawler, env, '启动微信')
  33. caps = {
  34. "platformName": "Android",
  35. "devicesName": "Android",
  36. # "platformVersion": "11",
  37. # "udid": "emulator-5554",
  38. "appPackage": "com.tencent.mm",
  39. "appActivity": ".ui.LauncherUI",
  40. "autoGrantPermissions": "true",
  41. "noReset": True,
  42. "resetkeyboard": True,
  43. "unicodekeyboard": True,
  44. "showChromedriverLog": True,
  45. "printPageSourceOnFailure": True,
  46. "recreateChromeDriverSessions": True,
  47. "enableWebviewDetailsCollection": True,
  48. "setWebContentsDebuggingEnabled": True,
  49. "newCommandTimeout": 6000,
  50. "automationName": "UiAutomator2",
  51. "chromedriverExecutable": chromedriverExecutable,
  52. "chromeOptions": {"androidProcess": "com.tencent.mm:appbrand0"},
  53. }
  54. try:
  55. driver = webdriver.Remote("http://localhost:4723/wd/hub", caps)
  56. except Exception as e:
  57. AliyunLogger.logging(
  58. code="3002",
  59. platform=ZFQZRecommend.platform,
  60. mode=log_type,
  61. env=env,
  62. message="appium 启动异常, 报错原因是{}".format(e)
  63. )
  64. return
  65. driver.implicitly_wait(30)
  66. for i in range(120):
  67. try:
  68. if driver.find_elements(By.ID, "com.tencent.mm:id/f2s"):
  69. Common.logger(log_type, crawler).info("微信启动成功")
  70. AliyunLogger.logging(
  71. code="1000",
  72. platform=ZFQZRecommend.platform,
  73. mode=log_type,
  74. env=env,
  75. message="启动微信成功"
  76. )
  77. break
  78. elif driver.find_element(By.ID, "com.android.systemui:id/dismiss_view"):
  79. Common.logger(log_type, crawler).info("发现并关闭系统下拉菜单")
  80. AliyunLogger.logging(
  81. code="1000",
  82. platform=ZFQZRecommend.platform,
  83. mode=log_type,
  84. env=env,
  85. message="发现并关闭系统下拉菜单"
  86. )
  87. driver.find_element(By.ID, "com.android.system:id/dismiss_view").click()
  88. else:
  89. pass
  90. except NoSuchElementException:
  91. AliyunLogger.logging(
  92. code="3001",
  93. platform=ZFQZRecommend.platform,
  94. mode=log_type,
  95. env=env,
  96. message="打开微信异常"
  97. )
  98. time.sleep(1)
  99. Common.logger(log_type, crawler).info("下滑,展示小程序选择面板")
  100. AliyunLogger.logging(
  101. code="1000",
  102. platform=ZFQZRecommend.platform,
  103. mode=log_type,
  104. env=env,
  105. message="下滑,展示小程序选择面板"
  106. )
  107. size = driver.get_window_size()
  108. driver.swipe(int(size['width'] * 0.5), int(size['height'] * 0.2),
  109. int(size['width'] * 0.5), int(size['height'] * 0.8), 200)
  110. time.sleep(1)
  111. Common.logger(log_type, crawler).info('打开小程序"祝福圈子"')
  112. driver.find_elements(By.XPATH, '//*[@text="祝福圈子"]')[-1].click()
  113. AliyunLogger.logging(
  114. code="1000",
  115. platform=ZFQZRecommend.platform,
  116. mode=log_type,
  117. env=env,
  118. message='打开小程序"祝福圈子"成功'
  119. )
  120. time.sleep(5)
  121. cls.get_videoList(log_type, crawler, driver, env, rule_dict, our_uid)
  122. time.sleep(1)
  123. driver.quit()
  124. @classmethod
  125. def search_elements(cls, driver: WebDriver, xpath):
  126. time.sleep(1)
  127. windowHandles = driver.window_handles
  128. for handle in windowHandles:
  129. driver.switch_to.window(handle)
  130. time.sleep(1)
  131. try:
  132. elements = driver.find_elements(By.XPATH, xpath)
  133. if elements:
  134. return elements
  135. except NoSuchElementException:
  136. pass
  137. @classmethod
  138. def check_to_applet(cls, log_type, crawler, env, driver: WebDriver, xpath):
  139. time.sleep(1)
  140. webViews = driver.contexts
  141. driver.switch_to.context(webViews[-1])
  142. windowHandles = driver.window_handles
  143. for handle in windowHandles:
  144. driver.switch_to.window(handle)
  145. time.sleep(1)
  146. try:
  147. driver.find_element(By.XPATH, xpath)
  148. Common.logger(log_type, crawler).info("切换到小程序成功\n")
  149. return
  150. except NoSuchElementException:
  151. time.sleep(1)
  152. @classmethod
  153. def repeat_video(cls, log_type, crawler, video_id, env):
  154. sql = f""" select * from crawler_video where platform in ("众妙音信", "刚刚都传", "吉祥幸福", "知青天天看", "zhufuquanzi", "祝福圈子", "haitunzhufu", "海豚祝福") and out_video_id="{video_id}"; """
  155. repeat_video = MysqlHelper.get_values(log_type, crawler, sql, env)
  156. return len(repeat_video)
  157. @classmethod
  158. def swipe_up(cls, driver: WebDriver):
  159. cls.search_elements(driver, '//*[@class="bless--list"]')
  160. size = driver.get_window_size()
  161. driver.swipe(int(size["width"] * 0.5), int(size["height"] * 0.8),
  162. int(size["width"] * 0.5), int(size["height"] * 0.4), 200)
  163. @classmethod
  164. def get_video_url(cls, log_type, crawler, driver: WebDriver, video_title_element):
  165. for i in range(3):
  166. cls.search_elements(driver, '//*[@class="bless--list"]')
  167. Common.logger(log_type, crawler).info(f"video_title_element:{video_title_element[0]}")
  168. time.sleep(1)
  169. Common.logger(log_type, crawler).info("滑动标题至可见状态")
  170. driver.execute_script("arguments[0].scrollIntoView({block:'center',inline:'center'});", video_title_element[0])
  171. time.sleep(3)
  172. Common.logger(log_type, crawler).info("点击标题")
  173. video_title_element[0].click()
  174. # driver.execute_script("arguments[0].click();", video_title_element[0])
  175. Common.logger(log_type, crawler).info("点击标题完成")
  176. time.sleep(1)
  177. video_url_elements = cls.search_elements(driver, '//*[@class="index--video-item index--video"]')
  178. if video_url_elements:
  179. return video_url_elements[0].get_attribute("src")
  180. @classmethod
  181. def get_videoList(cls, log_type, crawler, driver: WebDriver, env, rule_dict, our_uid):
  182. mq = MQ(topic_name="topic_crawler_etl_" + env)
  183. driver.implicitly_wait(20)
  184. cls.check_to_applet(log_type=log_type, crawler=crawler, env=env, driver=driver,
  185. xpath='//*[@class="tags--tag tags--tag-0 tags--checked"]')
  186. time.sleep(1)
  187. page = 0
  188. while True:
  189. if cls.search_elements(driver, '//*[@class="bless--list"]') is None:
  190. Common.logger(log_type, crawler).info("窗口已销毁\n")
  191. AliyunLogger.logging(
  192. code="3000",
  193. platform=ZFQZRecommend.platform,
  194. mode=log_type,
  195. env=env,
  196. message='窗口已销毁'
  197. )
  198. cls.i = 0
  199. cls.download_cnt = 0
  200. cls.element_list = []
  201. return
  202. cls.swipe_up(driver)
  203. page_source = driver.page_source
  204. soup = BeautifulSoup(page_source, 'html.parser')
  205. soup.prettify()
  206. video_list_elements = soup.findAll("wx-view", class_="expose--adapt-parent")
  207. # video_list_elements 有,cls.element_list 中没有的元素
  208. video_list_elements = list(set(video_list_elements).difference(set(cls.element_list)))
  209. # video_list_elements 与 cls.element_list 的并集
  210. cls.element_list = list(set(video_list_elements) | set(cls.element_list))
  211. Common.logger(log_type, crawler).info(f"正在抓取第{page + 1}页,共:{len(video_list_elements)}条视频")
  212. AliyunLogger.logging(
  213. code="1000",
  214. platform=ZFQZRecommend.platform,
  215. mode=log_type,
  216. env=env,
  217. message=f"正在抓取第{page + 1}页,共:{len(video_list_elements)}条视频"
  218. )
  219. if len(video_list_elements) == 0:
  220. for i in range(10):
  221. Common.logger(log_type, crawler).info(f"向上滑动第{i+1}次")
  222. AliyunLogger.logging(
  223. code="1000",
  224. platform=ZFQZRecommend.platform,
  225. mode=log_type,
  226. env=env,
  227. message=f"向上滑动第{i+1}次"
  228. )
  229. cls.swipe_up(driver)
  230. time.sleep(0.5)
  231. continue
  232. for i, video_element in enumerate(video_list_elements):
  233. try:
  234. Common.logger(log_type, crawler).info(f"本轮已抓取{cls.download_cnt}条视频\n")
  235. AliyunLogger.logging(
  236. code="1000",
  237. platform=ZFQZRecommend.platform,
  238. mode=log_type,
  239. env=env,
  240. message=f"本轮已抓取{cls.download_cnt}条视频\n"
  241. )
  242. if cls.download_cnt >= int(rule_dict.get("videos_cnt", {}).get("min", 10)):
  243. cls.i = 0
  244. cls.download_cnt = 0
  245. cls.element_list = []
  246. return
  247. trace_id = crawler + str(uuid.uuid1())
  248. AliyunLogger.logging(
  249. code="1001",
  250. platform=ZFQZRecommend.platform,
  251. mode=log_type,
  252. env=env,
  253. trace_id=trace_id,
  254. message="扫描到一条视频",
  255. )
  256. cls.i += 1
  257. video_title = video_element.find("wx-view", class_="dynamic--title").text
  258. play_str = video_element.find("wx-view", class_="dynamic--views").text
  259. like_str = video_element.findAll("wx-view", class_="dynamic--commerce-btn-text")[0].text
  260. comment_str = video_element.findAll("wx-view", class_="dynamic--commerce-btn-text")[1].text
  261. duration_str = video_element.find("wx-view", class_="dynamic--duration").text
  262. user_name = video_element.find("wx-view", class_="dynamic--nick-top").text
  263. avatar_url = video_element.find("wx-image", class_="avatar--avatar")["src"]
  264. cover_url = video_element.find("wx-image", class_="dynamic--bg-image")["src"]
  265. play_cnt = int(play_str.replace("+", "").replace("次播放", ""))
  266. duration = int(duration_str.split(":")[0].strip()) * 60 + int(duration_str.split(":")[-1].strip())
  267. if "点赞" in like_str:
  268. like_cnt = 0
  269. elif "万" in like_str:
  270. like_cnt = int(like_str.split("万")[0]) * 10000
  271. else:
  272. like_cnt = int(like_str)
  273. if "评论" in comment_str:
  274. comment_cnt = 0
  275. elif "万" in comment_str:
  276. comment_cnt = int(comment_str.split("万")[0]) * 10000
  277. else:
  278. comment_cnt = int(comment_str)
  279. out_video_id = md5(video_title.encode('utf8')).hexdigest()
  280. out_user_id = md5(user_name.encode('utf8')).hexdigest()
  281. Common.logger(log_type, crawler).warning(f"视频标题:{video_title},点赞:{like_str},播放:{play_cnt},用户名称:{user_name},")
  282. video_dict = {
  283. "video_title": video_title,
  284. "video_id": out_video_id,
  285. 'out_video_id': out_video_id,
  286. "duration_str": duration_str,
  287. "duration": duration,
  288. "play_str": play_str,
  289. "play_cnt": play_cnt,
  290. "like_str": like_str,
  291. "like_cnt": like_cnt,
  292. "comment_cnt": comment_cnt,
  293. "share_cnt": 0,
  294. "user_name": user_name,
  295. "user_id": out_user_id,
  296. 'publish_time_stamp': int(time.time()),
  297. 'publish_time_str': time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(int(time.time()))),
  298. 'update_time_stamp': int(time.time()),
  299. "avatar_url": avatar_url,
  300. "cover_url": cover_url,
  301. "session": f"zhufuquanzi-{int(time.time())}"
  302. }
  303. pipeline = PiaoQuanPipeline(
  304. platform=ZFQZRecommend.platform,
  305. mode=log_type,
  306. item=video_dict,
  307. rule_dict=rule_dict,
  308. env=env,
  309. trace_id=trace_id
  310. )
  311. flag = pipeline.process_item()
  312. if flag:
  313. video_title_element = cls.search_elements(driver, f'//*[contains(text(), "{video_title}")]')
  314. if video_title_element is None:
  315. Common.logger(log_type, crawler).warning(f"未找到该视频标题的element:{video_title_element}")
  316. continue
  317. Common.logger(log_type, crawler).info("点击标题,进入视频详情页")
  318. AliyunLogger.logging(
  319. code="1000",
  320. platform=ZFQZRecommend.platform,
  321. mode=log_type,
  322. env=env,
  323. message=f"点击标题,进入视频详情页\n"
  324. )
  325. video_url = cls.get_video_url(log_type, crawler, driver, video_title_element)
  326. video_url = get_redirect_url(video_url)
  327. if video_url is None:
  328. driver.press_keycode(AndroidKey.BACK)
  329. time.sleep(5)
  330. continue
  331. video_dict['video_url'] = video_url
  332. Common.logger(log_type, crawler).info(f"video_url:{video_url}")
  333. video_dict["platform"] = crawler
  334. video_dict["strategy"] = log_type
  335. video_dict["out_video_id"] = video_dict["video_id"]
  336. video_dict["crawler_rule"] = json.dumps(rule_dict)
  337. video_dict["user_id"] = our_uid
  338. video_dict["publish_time"] = video_dict["publish_time_str"]
  339. mq.send_msg(video_dict)
  340. cls.download_cnt += 1
  341. driver.press_keycode(AndroidKey.BACK)
  342. time.sleep(5)
  343. cls.swipe_up(driver)
  344. except Exception as e:
  345. Common.logger(log_type, crawler).error(f"抓取单条视频异常:{e}\n")
  346. AliyunLogger.logging(
  347. code="3001",
  348. platform=ZFQZRecommend.platform,
  349. mode=log_type,
  350. env=env,
  351. message=f"抓取单条视频异常:{e}\n"
  352. )
  353. Common.logger(log_type, crawler).info("已抓取完一组,休眠 5 秒\n")
  354. AliyunLogger.logging(
  355. code="1000",
  356. platform=ZFQZRecommend.platform,
  357. mode=log_type,
  358. env=env,
  359. message="已抓取完一组,休眠 5 秒\n"
  360. )
  361. time.sleep(5)
  362. page += 1
  363. if __name__ == "__main__":
  364. rule_dict1 = {"period": {"min": 365, "max": 365},
  365. "duration": {"min": 30, "max": 1800},
  366. "favorite_cnt": {"min": 5000, "max": 0},
  367. "videos_cnt": {"min": 10, "max": 20},
  368. "share_cnt": {"min": 1000, "max": 0}}
  369. ZFQZRecommend.start_wechat("recommend", "zhufuquanzi", "dev", rule_dict1, 6267141)