demo.py 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204
  1. # -*- coding: utf-8 -*-
  2. # @Author: wangkun
  3. # @Time: 2022/11/23
  4. import time
  5. import requests
  6. from selenium.webdriver import DesiredCapabilities
  7. from main.common import Common
  8. from main.feishu_lib import Feishu
  9. class Demo:
  10. @classmethod
  11. def get_sheet(cls, log_type, crawler, sheetid):
  12. sheet = Feishu.get_values_batch(log_type, crawler, sheetid)
  13. print(sheet)
  14. @classmethod
  15. def publish_time(cls):
  16. time1 = '发布时间:2022年11月20日'
  17. time2 = time1.replace('发布时间:', '').replace('年', '/').replace('月', '/').replace('日', '')
  18. print(time2)
  19. time3 = int(time.mktime(time.strptime(time2, "%Y/%m/%d")))
  20. print(time3)
  21. @classmethod
  22. def get_video_url(cls, log_type, video_id):
  23. url = 'https://haokan.hao123.com/v?'
  24. params = {
  25. 'vid': video_id,
  26. '_format': 'json',
  27. }
  28. headers = {
  29. 'Accept': '*/*',
  30. 'Accept-Encoding': 'gzip, deflate, br',
  31. 'Accept-Language': 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6',
  32. 'Cache-Control': 'no-cache',
  33. 'Connection': 'keep-alive',
  34. 'Content-Type': 'application/x-www-form-urlencoded',
  35. 'Cookie': 'PC_TAB_LOG=video_details_page; COMMON_LID=b0be69dd9fcae328d06935bd40f615cd; Hm_lvt_4aadd610dfd2f5972f1efee2653a2bc5=1669029953; hkpcvideolandquery=%u82CF%u5DDE%u6700%u5927%u7684%u4E8C%u624B%u8F66%u8D85%u5E02%uFF0C%u8F6C%u4E00%u8F6C%u91CC%u8FB9%u8C6A%u8F66%u592A%u591A%u4E86%uFF0C%u4EF7%u683C%u66F4%u8BA9%u6211%u5403%u60CA%uFF01; Hm_lpvt_4aadd610dfd2f5972f1efee2653a2bc5=1669875695; ariaDefaultTheme=undefined; reptileData=%7B%22data%22%3A%22636c55e0319da5169a60acec4a264a35c10862f8abfe2f2cc32c55eb6b0ab4de0efdfa115ea522d6d4d361dea07feae2831d3e2c16ed6b051c611ffe5aded6c9f852501759497b9fbd2132a2160e1e40e5845b41f78121ddcc3288bd077ae4e8%22%2C%22key_id%22%3A%2230%22%2C%22sign%22%3A%22f6752aac%22%7D; RT="z=1&dm=hao123.com&si=uc0q7wnm4w&ss=lb4otu71&sl=j&tt=av0&bcn=https%3A%2F%2Ffclog.baidu.com%2Flog%2Fweirwood%3Ftype%3Dperf&ld=1rdw&cl=7v6c"',
  36. 'Pragma': 'no-cache',
  37. 'Referer': 'https://haokan.hao123.com/v?vid=10623278258033022286&pd=pc&context=',
  38. 'sec-ch-ua': '"Microsoft Edge";v="107", "Chromium";v="107", "Not=A?Brand";v="24"',
  39. 'sec-ch-ua-mobile': '?0',
  40. 'sec-ch-ua-platform': '"macOS"',
  41. 'Sec-Fetch-Dest': 'empty',
  42. 'Sec-Fetch-Mode': 'cors',
  43. 'Sec-Fetch-Site': 'same-origin',
  44. 'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36 Edg/107.0.1418.62',
  45. }
  46. r = requests.get(url=url, headers=headers, params=params)
  47. if r.status_code != 200:
  48. Common.logger(log_type).info(f'get_video_url_response:{r.text}')
  49. elif r.json()['errno'] != 0 or len(r.json()['data']) == 0:
  50. Common.logger(log_type).info(f'get_video_url_response:{r.json()}')
  51. else:
  52. clarityUrl = r.json()['data']['apiData']['curVideoMeta']['clarityUrl']
  53. video_url = r.json()['data']['apiData']['curVideoMeta']['clarityUrl'][len(clarityUrl) - 1]['url']
  54. return video_url
  55. user_pcursor = ''
  56. user_cnt = []
  57. @classmethod
  58. def get_follow_users(cls, log_type):
  59. while True:
  60. url = "https://www.kuaishou.com/graphql"
  61. payload = {
  62. "operationName": "visionProfileUserList",
  63. "variables": {"ftype": 1, "pcursor": str(cls.user_pcursor)},
  64. "query": "query visionProfileUserList($pcursor: String, $ftype: Int) "
  65. "{\n visionProfileUserList(pcursor: $pcursor, ftype: $ftype) "
  66. "{\n result\n fols {\n user_name\n headurl\n "
  67. "user_text\n isFollowing\n user_id\n __typename\n }\n"
  68. " hostName\n pcursor\n __typename\n }\n}\n"
  69. }
  70. headers = {
  71. 'accept': '*/*',
  72. 'Accept-Encoding': 'gzip, deflate, br',
  73. 'Accept-Language': 'zh-CN,zh;q=0.9,en;q=0.8',
  74. 'Cache-Control': 'no-cache',
  75. 'Connection': 'keep-alive',
  76. 'Content-Length': '382',
  77. 'content-type': 'application/json',
  78. 'Cookie': 'kpf=PC_WEB; '
  79. 'kpn=KUAISHOU_VISION; '
  80. 'clientid=3; '
  81. 'did=web_260fc6cc87668951b745d0aa536b6c45; '
  82. 'client_key=65890b29; '
  83. 'userId=1921947321; '
  84. 'kuaishou.server.web_st=ChZrdWFpc2hvdS5zZXJ2ZXIud2ViLnN0EqABeKWnZv84JvnYIdwhX6o5jaBjDblgvsn'
  85. '7o8XEAvihFCj1P-69BK0qcjnCMbpUUmfT7pqlsn0KVsuK5789LXjySbqdee8yKhNhM-kttccnRokJM7BbSl7VzViTd'
  86. 'afHKDM3UEh1oJKy5s_iMUHbXo6wHSbMjdFYP6QsSRf7xU9KA4IC-uNX9ZcBj39OuCUCjlQFOXLjJV8mYAcBt1BqrIT'
  87. 'VhhoS6uws2LN-siMyPVYdMaXTUH7FIiCEI0MRi2vzOYp7_RSnHX_7--xNCDYQVUo05gjITkWaGCgFMAE; '
  88. 'kuaishou.server.web_ph=f2b6b9531d9ade009d5dccf1351ae7d4c7d2',
  89. 'Pragma': 'no-cache',
  90. 'Referer': 'https://www.kuaishou.com/profile/3xbp7922t5sgcpq',
  91. 'sec-ch-ua': '"Not?A_Brand";v="8", "Chromium";v="108", "Google Chrome";v="108"',
  92. 'sec-ch-ua-mobile': '?0',
  93. 'sec-ch-ua-platform': '"macOS"',
  94. 'Sec-Fetch-Dest': 'empty',
  95. 'Sec-Fetch-Mode': 'cors',
  96. 'Sec-Fetch-Site': 'same-origin',
  97. 'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 '
  98. '(KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36'
  99. }
  100. r = requests.post(url=url, headers=headers, json=payload)
  101. fols = r.json()['data']['visionProfileUserList']['fols']
  102. cls.user_pcursor = r.json()['data']['visionProfileUserList']['pcursor']
  103. if len(fols) == 0:
  104. print(f'到底啦~\n共关注 {len(cls.user_cnt)} 人\n')
  105. cls.user_pcursor = 0
  106. cls.user_cnt = []
  107. return
  108. for i in range(len(fols)):
  109. user_name = fols[i]['user_name']
  110. user_id = fols[i]['user_id']
  111. cls.user_cnt.append(user_id)
  112. print(f'user_name:{user_name}')
  113. print(f'user_id:{user_id}')
  114. print('\n')
  115. @classmethod
  116. def get_video_feeds(cls, log_type, out_id):
  117. url = 'https://www.kuaishou.com/graphql'
  118. headers = {
  119. 'accept': '*/*',
  120. 'Accept-Encoding': 'gzip, deflate, br',
  121. 'Accept-Language': 'zh-CN,zh;q=0.9,en;q=0.8',
  122. 'Cache-Control': 'no-cache',
  123. 'content-type': 'application/json',
  124. 'Cookie': 'kpf=PC_WEB; kpn=KUAISHOU_VISION; clientid=3; did=web_260fc6cc87668951b745d0aa536b6c45; client_key=65890b29; userId=1921947321; kuaishou.server.web_st=ChZrdWFpc2hvdS5zZXJ2ZXIud2ViLnN0EqABwCuiLLMSOvJtdcmO-XD0RHf-lRaR--1o0MNMhnsdl1xRZOfkHgEnFM1GNwk-pNxGwIXupJiGfL6JC-dsw6pNVRfW9eiCMUiFfVSS8bbVuBhSnh4wlJc6e2wy6FeYXC4V2WUQ7CKlUc_1sESmPlYq1D2JV7eKyNJP9VVnZ1i_y31SnTnAx2DpncW8UNV2qv_bjTxokg4rZRPnBBRCfAAhShoStEyT9S95saEmiR8Dg-bb1DKRIiDJ8NOu7QSy1FkD3GwzpAURUTTYYTuENNqldrStQMfWxygFMAE; kuaishou.server.web_ph=f80aff104d1749fbb5b6760aee76d5b640e2',
  125. 'Pragma': 'no-cache',
  126. 'Referer': 'https://www.kuaishou.com/profile/'+str(out_id),
  127. 'sec-ch-ua': '"Not?A_Brand";v="8", "Chromium";v="108", "Google Chrome";v="108"',
  128. 'sec-ch-ua-mobile': '?0',
  129. 'sec-ch-ua-platform': '"macOS"',
  130. 'Sec-Fetch-Dest': 'empty',
  131. 'Sec-Fetch-Mode': 'cors',
  132. 'Sec-Fetch-Site': 'same-origin',
  133. 'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36',
  134. }
  135. payload = {
  136. "operationName": "visionProfilePhotoList",
  137. "variables": {
  138. "userId": str(out_id),
  139. "pcursor": "",
  140. "page": "profile"
  141. },
  142. "query": "fragment photoContent on PhotoEntity {\n id\n duration\n caption\n originCaption\n likeCount\n viewCount\n realLikeCount\n coverUrl\n photoUrl\n photoH265Url\n manifest\n manifestH265\n videoResource\n coverUrls {\n url\n __typename\n }\n timestamp\n expTag\n animatedCoverUrl\n distance\n videoRatio\n liked\n stereoType\n profileUserTopPhoto\n musicBlocked\n __typename\n}\n\nfragment feedContent on Feed {\n type\n author {\n id\n name\n headerUrl\n following\n headerUrls {\n url\n __typename\n }\n __typename\n }\n photo {\n ...photoContent\n __typename\n }\n canAddComment\n llsid\n status\n currentPcursor\n tags {\n type\n name\n __typename\n }\n __typename\n}\n\nquery visionProfilePhotoList($pcursor: String, $userId: String, $page: String, $webPageArea: String) {\n visionProfilePhotoList(pcursor: $pcursor, userId: $userId, page: $page, webPageArea: $webPageArea) {\n result\n llsid\n webPageArea\n feeds {\n ...feedContent\n __typename\n }\n hostName\n pcursor\n __typename\n }\n}\n"
  143. }
  144. r = requests.post(url=url, headers=headers, json=payload)
  145. feeds = r.json()['data']['visionProfilePhotoList']['feeds']
  146. if len(feeds) == 0:
  147. Common.logger(log_type).info('到底啦~\n')
  148. return
  149. for i in range(len(feeds)):
  150. # 视频标题过滤话题及处理特殊字符
  151. kuaishou_title = feeds[i]['photo']["caption"]
  152. title_split1 = kuaishou_title.split(" #")
  153. if title_split1[0] != "":
  154. title1 = title_split1[0]
  155. else:
  156. title1 = title_split1[-1]
  157. title_split2 = title1.split(" #")
  158. if title_split2[0] != "":
  159. title2 = title_split2[0]
  160. else:
  161. title2 = title_split2[-1]
  162. title_split3 = title2.split("@")
  163. if title_split3[0] != "":
  164. title3 = title_split3[0]
  165. else:
  166. title3 = title_split3[-1]
  167. video_title = title3.strip()\
  168. .replace("\n", "").replace("/", "").replace("快手", "").replace(" ", "").replace(" ", "")\
  169. .replace("&NBSP", "").replace("\r", "").replace("#", "").replace(".", "。").replace("\\", "")\
  170. .replace(":", "").replace("*", "").replace("?", "").replace("?", "").replace('"', "")\
  171. .replace("<", "").replace(">", "").replace("|", "").replace("@", "")[:40]
  172. hevc = feeds[i]['photo']['videoResource']['hevc']
  173. if hevc == '':
  174. video_url = feeds[i]['photo']['videoResource']['h264']['adaptationSet'][0]['representation'][0]['url']
  175. else:
  176. video_url = feeds[i]['photo']['videoResource']['hevc']['adaptationSet'][0]['representation'][0]['url']
  177. print(f'video_title:{video_title}')
  178. print(f'video_url:{video_url}')
  179. print('\n')
  180. if __name__ == '__main__':
  181. # Demo.get_sheet('demo', 'haokan', '7f05d8')
  182. # Demo.publish_time()
  183. # Demo.get_video_url('demo', '10377041690614321392')
  184. # Demo.get_follow_users('demo')
  185. # Demo.get_video_feeds('demo', '3xfr3gqnxmk92y2')
  186. # print(Feishu.get_values_batch('log_type', 'haokan', '5LksMx')[0][0])
  187. # print(type(Feishu.get_values_batch('log_type', 'haokan', '5LksMx')[0][0]))
  188. pass