shipinhao_search.py 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350
  1. # -*- coding: utf-8 -*-
  2. # @Author: wangkun
  3. # @Time: 2023/4/25
  4. import difflib
  5. import os
  6. import sys
  7. import time
  8. from datetime import date, timedelta
  9. from hashlib import md5
  10. from appium import webdriver
  11. from appium.webdriver.extensions.android.nativekey import AndroidKey
  12. from appium.webdriver.webdriver import WebDriver
  13. from selenium.common import NoSuchElementException
  14. from selenium.webdriver.common.by import By
  15. sys.path.append(os.getcwd())
  16. from common.feishu import Feishu
  17. from common.publish import Publish
  18. from common.common import Common
  19. from common.public import get_config_from_mysql
  20. class ShipinhaoSearch:
  21. i = 0
  22. @classmethod
  23. def start_wechat(cls, log_type, crawler, word, env):
  24. Common.logger(log_type, crawler).info('启动微信')
  25. if env == "dev":
  26. chromedriverExecutable = "/Users/wangkun/Downloads/chromedriver/chromedriver_v107/chromedriver"
  27. else:
  28. chromedriverExecutable = '/Users/piaoquan/Downloads/chromedriver'
  29. caps = {
  30. "platformName": "Android", # 手机操作系统 Android / iOS
  31. "deviceName": "Android", # 连接的设备名(模拟器或真机),安卓可以随便写
  32. "platforVersion": "13", # 手机对应的系统版本(Android 13)
  33. "appPackage": "com.tencent.mm", # 被测APP的包名,乐活圈 Android
  34. "appActivity": ".ui.LauncherUI", # 启动的Activity名
  35. "autoGrantPermissions": True, # 让 appium 自动授权 base 权限,
  36. # 如果 noReset 为 True,则该条不生效(该参数为 Android 独有),对应的值为 True 或 False
  37. "unicodekeyboard": True, # 使用自带输入法,输入中文时填True
  38. "resetkeyboard": True, # 执行完程序恢复原来输入法
  39. "noReset": True, # 不重置APP
  40. "recreateChromeDriverSessions": True, # 切换到非 chrome-Driver 会 kill 掉 session,就不需要手动 kill 了
  41. "printPageSourceOnFailure": True, # 找不到元素时,appium log 会完整记录当前页面的 pagesource
  42. "newCommandTimeout": 6000, # 初始等待时间
  43. "automationName": "UiAutomator2", # 使用引擎,默认为 Appium,
  44. # 其中 Appium、UiAutomator2、Selendroid、Espresso 用于 Android,XCUITest 用于 iOS
  45. "showChromedriverLog": True,
  46. # "chromeOptions": {"androidProcess": "com.tencent.mm:appbrand0"},
  47. "chromeOptions": {"androidProcess": "com.tencent.mm:tools"},
  48. 'enableWebviewDetailsCollection': True,
  49. 'setWebContentsDebuggingEnabled': True,
  50. 'chromedriverExecutable': chromedriverExecutable,
  51. }
  52. driver = webdriver.Remote("http://localhost:4723/wd/hub", caps)
  53. driver.implicitly_wait(10)
  54. # # 向下滑动页面,展示出小程序选择面板
  55. # for i in range(120):
  56. # try:
  57. # # 发现微信消息 TAB,代表微信已启动成功
  58. # if driver.find_elements(By.ID, 'com.tencent.mm:id/f2s'):
  59. # break
  60. # # 发现并关闭系统菜单栏
  61. # elif driver.find_element(By.ID, 'com.android.systemui:id/dismiss_view'):
  62. # Common.logger(log_type, crawler).info('发现并关闭系统下拉菜单栏')
  63. # driver.find_element(By.ID, 'com.android.systemui:id/dismiss_view').click()
  64. # else:
  65. # pass
  66. # except NoSuchElementException:
  67. # time.sleep(1)
  68. if len(driver.find_elements(By.ID, 'android:id/text1')) != 0:
  69. driver.find_elements(By.ID, 'android:id/text1')[0].click()
  70. time.sleep(5)
  71. cls.search_video(log_type=log_type,
  72. crawler=crawler,
  73. word=word,
  74. driver=driver,
  75. env=env)
  76. cls.close_wechat(log_type=log_type,
  77. crawler=crawler,
  78. driver=driver)
  79. @classmethod
  80. def close_wechat(cls, log_type, crawler, driver: WebDriver):
  81. driver.quit()
  82. Common.logger(log_type, crawler).info(f"微信退出成功\n")
  83. @classmethod
  84. def is_contain_chinese(cls, strword):
  85. for ch in strword:
  86. if u'\u4e00' <= ch <= u'\u9fff':
  87. return True
  88. return False
  89. # 查找元素
  90. @classmethod
  91. def search_elements(cls, driver: WebDriver, xpath):
  92. time.sleep(1)
  93. windowHandles = driver.window_handles
  94. for handle in windowHandles:
  95. driver.switch_to.window(handle)
  96. time.sleep(1)
  97. try:
  98. elements = driver.find_elements(By.XPATH, xpath)
  99. if elements:
  100. return elements
  101. except NoSuchElementException:
  102. pass
  103. @classmethod
  104. def check_to_webview(cls, log_type, crawler, driver: WebDriver):
  105. # Common.logger(log_type, crawler).info('切换到webview')
  106. webviews = driver.contexts
  107. driver.switch_to.context(webviews[1])
  108. time.sleep(1)
  109. windowHandles = driver.window_handles
  110. for handle in windowHandles:
  111. driver.switch_to.window(handle)
  112. try:
  113. shipinhao_webview = driver.find_element(By.XPATH, '//div[@class="unit"]')
  114. if shipinhao_webview:
  115. Common.logger(log_type, crawler).info('切换到视频号 webview 成功')
  116. return "成功"
  117. except Exception as e:
  118. Common.logger(log_type, crawler).info(f"{e}\n")
  119. @classmethod
  120. def search_video(cls, log_type, crawler, word, driver: WebDriver, env):
  121. # 点击微信搜索框,并输入搜索词
  122. driver.implicitly_wait(10)
  123. driver.find_element(By.ID, 'com.tencent.mm:id/j5t').click()
  124. time.sleep(0.5)
  125. Common.logger(log_type, crawler).info(f'输入搜索词:{word}')
  126. driver.find_element(By.ID, 'com.tencent.mm:id/cd7').clear().send_keys(word)
  127. driver.press_keycode(AndroidKey.ENTER)
  128. # driver.find_elements(By.ID, 'com.tencent.mm:id/oi4')[0].click()
  129. driver.find_element(By.ID, 'com.tencent.mm:id/m94').click()
  130. time.sleep(5)
  131. # 切换到微信搜索结果页 webview
  132. check_to_webview = cls.check_to_webview(log_type, crawler, driver)
  133. if check_to_webview is None:
  134. Common.logger(log_type, crawler).info("切换到视频号 webview 失败\n")
  135. return
  136. time.sleep(1)
  137. # 切换到"视频号"分类
  138. shipinhao_tags = cls.search_elements(driver, '//div[@class="unit"]/*[2]')
  139. Common.logger(log_type, crawler).info('点击"视频号"分类')
  140. shipinhao_tags[0].click()
  141. time.sleep(5)
  142. index = 0
  143. while True:
  144. if cls.i >= 100:
  145. Common.logger(log_type, crawler).info(f'搜索词:"{word}",已抓取视频数:{index}')
  146. cls.i = 0
  147. return
  148. # try:
  149. if cls.search_elements(driver, '//*[@class="double-rich double-rich_vertical"]') is None:
  150. Common.logger(log_type, crawler).info('窗口已销毁\n')
  151. return
  152. Common.logger(log_type, crawler).info('获取视频列表\n')
  153. video_elements = cls.search_elements(driver, '//div[@class="vc active__mask"]')
  154. if video_elements is None:
  155. Common.logger(log_type, crawler).warning(f'video_elements:{video_elements}')
  156. return
  157. video_element_temp = video_elements[index:]
  158. if len(video_element_temp) == 0:
  159. Common.logger(log_type, crawler).info('到底啦~~~~~~~~~~~~~\n')
  160. return
  161. for i, video_element in enumerate(video_element_temp):
  162. if video_element is None:
  163. Common.logger(log_type, crawler).info('到底啦~\n')
  164. return
  165. cls.i += 1
  166. cls.search_elements(driver, '//div[@class="vc active__mask"]')
  167. Common.logger(log_type, crawler).info(f'拖动"视频"列表第{cls.i}个至屏幕中间')
  168. time.sleep(3)
  169. driver.execute_script("arguments[0].scrollIntoView({block:'center',inline:'center'})",
  170. video_element)
  171. if len(video_element.find_elements(By.XPATH, "//*[@text='没有更多的搜索结果']")) != 0:
  172. Common.logger(log_type, crawler).info("没有更多的搜索结果\n")
  173. return
  174. video_title = video_element.find_elements(By.XPATH, '//div[@class="title ellipsis_2"]/*[2]')[index + i].text
  175. video_url = video_element.find_elements(By.XPATH, '//div[@class="video-player"]')[index+i].get_attribute('src')
  176. cover_url = video_element.find_elements(By.XPATH, '//div[@class="video-player__bd"]')[index+i].get_attribute('style')
  177. duration = video_element.find_elements(By.XPATH, '//div[@class="play-mask__text"]/*[2]')[index+i].text
  178. duration = int(duration.split(':')[0]) * 60 + int(duration.split(':')[-1])
  179. user_name = video_element.find_elements(By.XPATH, '//p[@class="vc-source__text"]')[index+i].text
  180. avatar_url = video_element.find_elements(By.XPATH, '//div[@class="ui-image-image ui-image vc-source__thumb"]')[index+i].get_attribute('style')
  181. # Common.logger(log_type, crawler).info(f"video_title:{video_title}")
  182. # Common.logger(log_type, crawler).info(f"duration:{duration}")
  183. video_element.click()
  184. time.sleep(3)
  185. video_dict = cls.get_video_info(log_type=log_type,
  186. crawler=crawler,
  187. driver=driver)
  188. video_dict["video_title"] = video_title
  189. video_dict["duration"] = duration
  190. video_dict["video_url"] = video_url
  191. for k, v in video_dict.items():
  192. Common.logger(log_type, crawler).info(f"{k}:{v}")
  193. if video_title in [x for y in Feishu.get_values_batch(log_type, crawler, "xYWCzf") for x in y]:
  194. Common.logger(log_type, crawler).info("视频已存在\n")
  195. else:
  196. cls.download_publish(log_type, crawler, word, video_dict)
  197. Common.logger(log_type, crawler).info('已抓取完一组视频,休眠1秒\n')
  198. time.sleep(1)
  199. index = index + len(video_element_temp)
  200. # except Exception as e:
  201. # Common.logger(log_type, crawler).info(f"get_videoList:{e}\n")
  202. # cls.i = 0
  203. @classmethod
  204. def download_publish(cls, log_type, crawler, word, video_dict):
  205. Feishu.insert_columns(log_type, crawler, "xYWCzf", "ROWS", 1, 2)
  206. time.sleep(0.5)
  207. values = [[time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(int(time.time()))),
  208. "视频号搜索",
  209. word,
  210. video_dict["video_title"],
  211. video_dict["duration"],
  212. video_dict["like_cnt"],
  213. video_dict["share_cnt"],
  214. video_dict["favorite_cnt"],
  215. video_dict["comment_cnt"],
  216. video_dict["publish_time_str"],
  217. "待获取",
  218. "待获取",
  219. "待获取",
  220. video_dict["video_url"]]]
  221. Feishu.update_values(log_type, crawler, "xYWCzf", "F2:Z2", values)
  222. Common.logger(log_type, crawler).info("写入飞书成功\n")
  223. @classmethod
  224. def get_video_info(cls, log_type, crawler, driver: WebDriver):
  225. # Common.logger(log_type, crawler).info('切回NATIVE_APP')
  226. driver.switch_to.context('NATIVE_APP')
  227. # 点赞
  228. like_id = driver.find_element(By.ID, 'com.tencent.mm:id/k04')
  229. like_cnt = like_id.get_attribute('name')
  230. if like_cnt == "" or like_cnt == "喜欢" or like_cnt == "火" or cls.is_contain_chinese(like_cnt) is True:
  231. like_cnt = 0
  232. elif '万' in like_cnt:
  233. like_cnt = int(float(like_cnt.split('万')[0]) * 10000)
  234. elif '万+' in like_cnt:
  235. like_cnt = int(float(like_cnt.split('万+')[0]) * 10000)
  236. else:
  237. like_cnt = int(float(like_cnt))
  238. # 分享
  239. share_id = driver.find_element(By.ID, 'com.tencent.mm:id/jhv')
  240. share_cnt = share_id.get_attribute('name')
  241. if share_cnt == "" or share_cnt == "转发" or cls.is_contain_chinese(share_cnt) is True:
  242. share_cnt = 0
  243. elif '万' in share_cnt:
  244. share_cnt = int(float(share_cnt.split('万')[0]) * 10000)
  245. elif '万+' in share_cnt:
  246. share_cnt = int(float(share_cnt.split('万+')[0]) * 10000)
  247. else:
  248. share_cnt = int(float(share_cnt))
  249. # 收藏
  250. favorite_id = driver.find_element(By.ID, 'com.tencent.mm:id/fnp')
  251. favorite_cnt = favorite_id.get_attribute('name')
  252. if favorite_cnt == "" or favorite_cnt == "收藏" or favorite_cnt == "推荐" or favorite_cnt == "火" or cls.is_contain_chinese(favorite_cnt) is True:
  253. favorite_cnt = 0
  254. elif '万' in favorite_cnt:
  255. favorite_cnt = int(float(favorite_cnt.split('万')[0]) * 10000)
  256. elif '万+' in favorite_cnt:
  257. favorite_cnt = int(float(favorite_cnt.split('万+')[0]) * 10000)
  258. else:
  259. favorite_cnt = int(float(favorite_cnt))
  260. # 评论
  261. comment_id = driver.find_element(By.ID, 'com.tencent.mm:id/bje')
  262. comment_cnt = comment_id.get_attribute('name')
  263. if comment_cnt == "" or comment_cnt == "评论" or cls.is_contain_chinese(comment_cnt) is True:
  264. comment_cnt = 0
  265. elif '万' in comment_cnt:
  266. comment_cnt = int(float(comment_cnt.split('万')[0]) * 10000)
  267. elif '万+' in comment_cnt:
  268. comment_cnt = int(float(comment_cnt.split('万+')[0]) * 10000)
  269. else:
  270. comment_cnt = int(float(comment_cnt))
  271. # 发布时间
  272. comment_id.click()
  273. time.sleep(1)
  274. publish_time = driver.find_element(By.ID, "com.tencent.mm:id/bre").get_attribute("name")
  275. if "天前" in publish_time:
  276. days = int(publish_time.replace("天前", ""))
  277. publish_time_str = (date.today() + timedelta(days=-days)).strftime("%Y-%m-%d")
  278. elif "年" in publish_time:
  279. publish_time_str = publish_time.replace("年", "-").replace("月", "-").replace("日", "")
  280. else:
  281. publish_time_str = f'2023-{publish_time.replace("月", "-").replace("日", "")}'
  282. # publish_time_stamp = int(time.mktime(time.strptime(publish_time_str, "%Y-%m-%d")))
  283. # 收起评论
  284. # Common.logger(log_type, crawler).info("收起评论")
  285. driver.find_element(By.ID, "com.tencent.mm:id/be_").click()
  286. time.sleep(0.5)
  287. # 返回 webview
  288. # Common.logger(log_type, crawler).info(f"操作手机返回按键")
  289. driver.find_element(By.ID, "com.tencent.mm:id/a2z").click()
  290. time.sleep(0.5)
  291. # driver.press_keycode(AndroidKey.BACK)
  292. # cls.check_to_webview(log_type=log_type, crawler=crawler, driver=driver)
  293. webviews = driver.contexts
  294. driver.switch_to.context(webviews[1])
  295. video_dict = {
  296. "like_cnt": like_cnt,
  297. "share_cnt": share_cnt,
  298. "favorite_cnt": favorite_cnt,
  299. "comment_cnt": comment_cnt,
  300. "publish_time_str": publish_time_str,
  301. # "publish_time_stamp": publish_time_stamp,
  302. }
  303. return video_dict
  304. @classmethod
  305. def search_all_videos(cls, log_type, crawler, env):
  306. word_list = get_config_from_mysql(log_type, crawler, env, "search_word", action="")
  307. for word in word_list:
  308. cls.i = 0
  309. Common.logger(log_type, crawler).info(f"开始抓取搜索词:{word}")
  310. try:
  311. cls.start_wechat(log_type=log_type,
  312. crawler=crawler,
  313. word=word,
  314. env=env)
  315. except Exception as e:
  316. Common.logger(log_type, crawler).error(f"search_video:{e}\n")
  317. if __name__ == '__main__':
  318. ShipinhaoSearch.search_all_videos(log_type="search",
  319. crawler="shipinhao",
  320. env="dev")
  321. pass