# -*- coding: utf-8 -*- # @Author: wangkun # @Time: 2022/8/23 import base64 import os import random import subprocess import sys import time import requests import urllib3 sys.path.append(os.getcwd()) from main.common import Common from main.feishu import Feishu from main.publish import Publish from main.get_signature import GetSignature proxies = {"http": None, "https": None} class Follow: # 个人主页视频翻页参数 offset = 0 # 获取用户信息（字典格式）. 注意：部分 user_id 字符类型是 int / str @classmethod def get_user_info_from_feishu(cls, log_type): try: user_sheet = Feishu.get_values_batch(log_type, 'xigua', '5tlTYB') user_dict = {} for i in range(1, len(user_sheet)): user_name = user_sheet[i][0] user_id = user_sheet[i][1] our_id = user_sheet[i][3] if user_name is None or user_id is None or our_id is None: pass else: user_dict[user_name] = str(user_id)+','+str(our_id) return user_dict except Exception as e: Common.logger(log_type).error('get_user_id_from_feishu异常:{}\n', e) # 下载规则 @staticmethod def download_rule(duration, width, height): if int(duration) >= 60: if int(width) >= 720 or int(height) >= 720: return True else: return False else: return False # 过滤词库 @classmethod def filter_words(cls, log_type): try: filter_words_sheet = Feishu.get_values_batch(log_type, 'xigua', 'KGB4Hc') filter_words_list = [] for x in filter_words_sheet: for y in x: if y is None: pass else: filter_words_list.append(y) return filter_words_list except Exception as e: Common.logger(log_type).error('filter_words异常:{}\n', e) # PC端：西瓜用户主页视频列表. 注意:参数_signature有效期时长只有一小时 @classmethod def get_follow_feeds_by_pc(cls, log_type, userid, env, uid): try: url = "https://www.ixigua.com/api/videov2/author/new_video_list?" headers = { 'sec-ch-ua': '".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103"', 'accept': 'application/json, text/plain, */*', 'sec-ch-ua-mobile': '?0', 'user-agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko)' ' Chrome/103.0.0.0 Safari/537.36', 'sec-ch-ua-platform': '"macOS"', 'sec-fetch-site': 'same-origin', 'sec-fetch-mode': 'cors', 'sec-fetch-dest': 'document', 'referer': 'https://www.ixigua.com/home/' + str(userid), 'accept-encoding': 'gzip, deflate, br', 'accept-language': 'zh-CN,zh;q=0.9,en;q=0.8', } params = { 'to_user_id': str(userid), 'offset': str(cls.offset), 'limit': '30', 'maxBehotTime': '0', 'order': 'new', 'isHome': '0', 'msToken': '2ZHINOMBPK-qlCKApv37xVCBKkXyPli8mTYNlTSXvr17eZ0Ea8B__Otimkx6q_' 'enDc9m8Kgzi3Re7wpLIMSSE9dofTYdqQgvB7mHQbx_AMnVnf5lsByU', 'X-Bogus': 'DFSzswVuVvTANe2BSBBMCR/F6qyc', '_signature': Feishu.get_values_batch(log_type, 'xigua', '6tZHhs')[1][1], } cookies = { '__ac_signature': '_02B4Z6wo00f017vzS8QAAIDCwz2gwwDpX9-7009AAI4Bc4', 'MONITOR_WEB_ID': 'fd4244aa-2003-4e19-a2a4-715c19310a56', 'ixigua-a-s': '1', 'support_webp': 'true', 'support_avif': 'true', '_tea_utm_cache_1300': 'undefined', 'ttcid': '16a3b6b9b80b4a87ae258f5f3f101e6310', 'msToken': 'G8pL2oH-9Zl1hrLZPyOMSceMaII3ejKda2o-tgO1heYrj7b_fgm9vGlvwyLOA2H8oUShZgAYfxEvIuktT' '7OuxBuy85N-ousFfqxuAIrfruMEFZUTYp2z', 'tt_scid': 'a0zhISPImN-dVMMdbeb1Kzhl1x4oJS5Yr81FzH6qYk3jDtj1d2E5gsywN4rwna8ib398', 'ttwid': '1%7CvorN1HQjbSgBViRkEoZYEbqP_sQVoQqaUqGcFA-bzpA%7C1661324763%7Ce040213e1107973ebb0d' 'b64f0e77cfb027375f1fb5854bb40588d692d025af1f', } # Common.logger(log_type).info('offset:{}', cls.offset) urllib3.disable_warnings() response = requests.get(url=url, headers=headers, params=params, cookies=cookies, proxies=proxies, verify=False) # Common.logger(log_type).info('response:{}', response.text) cls.offset += 30 if 'data' not in response.text or response.json()['data'] == '' or response.json()['code'] != 200: Common.logger(log_type).info('get_follow_feeds: response:{}', response.text) else: feeds = response.json()['data']['videoList'] # print(len(feeds)) for i in range(len(feeds)): # video_title if 'title' not in feeds[i]: video_title = 0 else: video_title = feeds[i]['title'].strip().replace('手游', '')\ .replace('/', '').replace('\/', '').replace('\n', '') # video_id if 'video_id' not in feeds[i]: video_id = 0 else: video_id = feeds[i]['video_id'] # gid if 'gid' not in feeds[i]: gid = 0 else: gid = feeds[i]['gid'] # play_cnt if 'video_detail_info' not in feeds[i]: play_cnt = 0 elif 'video_watch_count' not in feeds[i]['video_detail_info']: play_cnt = 0 else: play_cnt = feeds[i]['video_detail_info']['video_watch_count'] # comment_cnt if 'comment_count' not in feeds[i]: comment_cnt = 0 else: comment_cnt = feeds[i]['comment_count'] # like_cnt if 'digg_count' not in feeds[i]: like_cnt = 0 else: like_cnt = feeds[i]['digg_count'] # share_cnt share_cnt = 0 # video_duration if 'video_duration' not in feeds[i]: video_duration = 0 else: video_duration = feeds[i]['video_duration'] # send_time if 'publish_time' not in feeds[i]: send_time = 0 else: send_time = feeds[i]['publish_time'] # is_top if 'is_top' not in feeds[i]: is_top = 0 else: is_top = feeds[i]['is_top'] # user_name if 'user_info' not in feeds[i]: user_name = 0 elif 'name' not in feeds[i]['user_info']: user_name = 0 else: user_name = feeds[i]['user_info']['name'] # user_id if 'user_info' not in feeds[i]: user_id = 0 elif 'user_id' not in feeds[i]['user_info']: user_id = 0 else: user_id = feeds[i]['user_info']['user_id'] # head_url if 'user_info' not in feeds[i]: head_url = 0 elif 'avatar_url' not in feeds[i]['user_info']: head_url = 0 else: head_url = feeds[i]['user_info']['avatar_url'] # cover_url if 'video_detail_info' not in feeds[i]: cover_url = 0 elif 'detail_video_large_image' not in feeds[i]['video_detail_info']: cover_url = 0 elif 'url' in feeds[i]['video_detail_info']['detail_video_large_image']: cover_url = feeds[i]['video_detail_info']['detail_video_large_image']['url'] else: cover_url = feeds[i]['video_detail_info']['detail_video_large_image']['url_list'][0]['url'] Common.logger(log_type).info(f'video_title:{video_title}') Common.logger(log_type).info(f'video_id:{video_id}') Common.logger(log_type).info(f'play_cnt:{play_cnt}') Common.logger(log_type).info('send_time:{}', time.strftime('%Y/%m/%d %H:%M:%S', time.localtime(send_time))) video_url_info = cls.get_video_info(log_type, gid) video_url = video_url_info[0] audio_url = video_url_info[1] video_width = video_url_info[2] video_height = video_url_info[-1] if gid == 0 or video_id == 0: Common.logger(log_type).info('无效视频\n') elif is_top is True and int(time.time()) - int(send_time) > 3600 * 24 * 10: Common.logger(log_type).info('置顶视频，且发布时间超过10天:{}\n', time.strftime('%Y/%m/%d %H:%M:%S', time.localtime(send_time))) elif int(time.time()) - int(send_time) > 3600 * 24 * 10: Common.logger(log_type).info('发布时间超过10天:{}\n', time.strftime('%Y/%m/%d %H:%M:%S', time.localtime(send_time))) cls.offset = 0 return elif cls.download_rule(video_duration, video_width, video_height) is False: Common.logger(log_type).info('不满足抓取规则\n') elif any(word if word in video_title else False for word in cls.filter_words(log_type)) is True: Common.logger(log_type).info('标题已中过滤词:{}\n', video_title) elif str(video_id) in [x for y in Feishu.get_values_batch(log_type, 'xigua', 'e075e9') for x in y]: Common.logger(log_type).info('视频已下载\n') elif str(video_id) in [x for y in Feishu.get_values_batch(log_type, 'xigua', '3Ul6wZ') for x in y]: Common.logger(log_type).info('视频已下载\n') elif str(video_id) in [x for y in Feishu.get_values_batch(log_type, 'xigua', 'wjhpDs') for x in y]: Common.logger(log_type).info('视频已存在\n') else: Feishu.insert_columns(log_type, 'xigua', 'wjhpDs', 'ROWS', 1, 2) get_feeds_time = time.time() values = [[time.strftime('%Y/%m/%d %H:%M:%S', time.localtime(get_feeds_time)), '关注榜', video_title, str(video_id), gid, play_cnt, comment_cnt, like_cnt, share_cnt, video_duration, str(video_width) + '*' + str(video_height), time.strftime('%Y/%m/%d %H:%M:%S', time.localtime(send_time)), user_name, user_id, head_url, cover_url, video_url, audio_url]] time.sleep(1) Feishu.update_values(log_type, 'xigua', 'wjhpDs', 'A2:Z2', values) Common.logger(log_type).info('视频信息写入飞书成功\n') time.sleep(random.randint(1, 3)) cls.download_publish(log_type, env, uid) except Exception as e: Common.logger(log_type).error('get_follow_feeds_by_pc异常:{}\n', e) # 获取视频详情 @classmethod def get_video_info(cls, log_type, gid): try: url = 'https://www.ixigua.com/api/mixVideo/information?' headers = { "accept-encoding": "gzip, deflate, br", "accept-language": "zh-CN,zh-Hans;q=0.9", "user-agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) " "AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.5 Safari/605.1.15", "referer": "https://www.ixigua.com/7102614741050196520?logTag=0531c88ac04f38ab2c62", } params = { 'mixId': gid, 'msToken': 'IlG0wd0Pylyw9ghcYiB2YseUmTwrsrqqhXrbIcsSaTcLTJyVlbYJzk20zw3UO-CfrfC' 'NVVIOBNjIl7vfBoxnVUwO9ZyzAI3umSKsT5-pef_RRfQCJwmA', 'X-Bogus': 'DFSzswVupYTANCJOSBk0P53WxM-r', '_signature': '_02B4Z6wo0000119LvEwAAIDCuktNZ0y5wkdfS7jAALThuOR8D9yWNZ.EmWHKV0WSn6Px' 'fPsH9-BldyxVje0f49ryXgmn7Tzk-swEHNb15TiGqa6YF.cX0jW8Eds1TtJOIZyfc9s5emH7gdWN94', } cookies = { 'ixigua-a-s': '1', 'msToken': 'IlG0wd0Pylyw9ghcYiB2YseUmTwrsrqqhXrbIcsSaTcLTJyVlbYJzk20zw3UO-CfrfCNVVIOB' 'NjIl7vfBoxnVUwO9ZyzAI3umSKsT5-pef_RRfQCJwmA', 'ttwid': '1%7C_yXQeHWwLZgCsgHClOwTCdYSOt_MjdOkgnPIkpi-Sr8%7C1661241238%7Cf57d0c5ef3f1d7' '6e049fccdca1ac54887c34d1f8731c8e51a49780ff0ceab9f8', 'tt_scid': 'QZ4l8KXDG0YAEaMCSbADdcybdKbUfG4BC6S4OBv9lpRS5VyqYLX2bIR8CTeZeGHR9ee3', 'MONITOR_WEB_ID': '0a49204a-7af5-4e96-95f0-f4bafb7450ad', '__ac_nonce': '06304878000964fdad287', '__ac_signature': '_02B4Z6wo00f017Rcr3AAAIDCUVxeW1tOKEu0fKvAAI4cvoYzV-wBhq7B6D8k0no7lb' 'FlvYoinmtK6UXjRIYPXnahUlFTvmWVtb77jsMkKAXzAEsLE56m36RlvL7ky.M3Xn52r9t1IEb7IR3ke8', 'ttcid': 'e56fabf6e85d4adf9e4d91902496a0e882', '_tea_utm_cache_1300': 'undefined', 'support_avif': 'false', 'support_webp': 'false', 'xiguavideopcwebid': '7134967546256016900', 'xiguavideopcwebid.sig': 'xxRww5R1VEMJN_dQepHorEu_eAc', } urllib3.disable_warnings() response = requests.get(url=url, headers=headers, params=params, cookies=cookies, proxies=proxies, verify=False) if 'data' not in response.json() or response.json()['data'] == '': Common.logger(log_type).warning('get_video_info: response: {}', response) else: video_info = response.json()['data']['gidInformation']['packerData']['video'] video_url = '' audio_url = '' video_width = '' video_height = '' # video_url if 'videoResource' not in video_info: video_url = 0 audio_url = 0 video_width = 0 video_height = 0 elif 'dash' in video_info['videoResource'] \ and 'dynamic_video' in video_info['videoResource']['dash']\ and 'dynamic_video_list' in video_info['videoResource']['dash']['dynamic_video']: video_url = video_info['videoResource']['dash']['dynamic_video']['dynamic_video_list'][-1][ 'main_url'] audio_url = video_info['videoResource']['dash']['dynamic_video']['dynamic_audio_list'][-1][ 'main_url'] Common.logger(log_type).info(f'main_video_url:{video_url}') Common.logger(log_type).info(f'main_audio_url:{audio_url}\n') if len(video_url) % 3 == 1: video_url += '==' elif len(video_url) % 3 == 2: video_url += '=' elif len(audio_url) % 3 == 1: audio_url += '==' elif len(audio_url) % 3 == 2: audio_url += '=' Common.logger(log_type).info(f'%_video_url:{video_url}') Common.logger(log_type).info(f'%_audio_url:{audio_url}\n') video_url = base64.b64decode(video_url).decode('utf8') audio_url = base64.b64decode(audio_url).decode('utf8') Common.logger(log_type).info(f'base64_video_url:{video_url}') Common.logger(log_type).info(f'base64_audio_url:{audio_url}\n') video_width = video_info['videoResource']['dash']['dynamic_video']['dynamic_video_list'][-1][ 'vwidth'] video_height = video_info['videoResource']['dash']['dynamic_video']['dynamic_video_list'][-1][ 'vheight'] elif 'dash_120fps' in video_info['videoResource']\ and 'dynamic_video' in video_info['videoResource']['dash_120fps']\ and 'dynamic_video_list' in video_info['videoResource']['dash_120fps']['dynamic_video']: video_url = video_info['videoResource']['dash_120fps']['dynamic_video']['dynamic_video_list'][-1][ 'main_url'] audio_url = video_info['videoResource']['dash_120fps']['dynamic_video']['dynamic_audio_list'][-1][ 'main_url'] if len(video_url) % 3 == 1: video_url += '==' elif len(video_url) % 3 == 2: video_url += '=' elif len(audio_url) % 3 == 1: audio_url += '==' elif len(audio_url) % 3 == 2: audio_url += '=' video_url = base64.b64decode(video_url).decode('utf8') audio_url = base64.b64decode(audio_url).decode('utf8') video_width = video_info['videoResource']['dash_120fps']['dynamic_video'][ 'dynamic_video_list'][-1]['vwidth'] video_height = video_info['videoResource']['dash_120fps']['dynamic_video'][ 'dynamic_video_list'][-1]['vheight'] elif 'normal' in video_info['videoResource']: video_list = video_info['videoResource']['normal']['video_list'] if 'video_4' in video_list.keys(): # Common.logger(log_type).info('{}', video_list['video_4']) video_url = video_list['video_4']['main_url'] audio_url = video_list['video_4']['main_url'] if len(video_url) % 3 == 1: video_url += '==' elif len(video_url) % 3 == 2: video_url += '=' elif len(audio_url) % 3 == 1: audio_url += '==' elif len(audio_url) % 3 == 2: audio_url += '=' video_url = base64.b64decode(video_url).decode('utf8') audio_url = base64.b64decode(audio_url).decode('utf8') video_width = video_list['video_4']['vwidth'] video_height = video_list['video_4']['vheight'] elif 'video_3' in video_list.keys(): # Common.logger(log_type).info('{}', video_list['video_3']) video_url = video_list['video_3']['main_url'] audio_url = video_list['video_3']['main_url'] if len(video_url) % 3 == 1: video_url += '==' elif len(video_url) % 3 == 2: video_url += '=' elif len(audio_url) % 3 == 1: audio_url += '==' elif len(audio_url) % 3 == 2: audio_url += '=' video_url = base64.b64decode(video_url).decode('utf8') audio_url = base64.b64decode(audio_url).decode('utf8') video_width = video_list['video_3']['vwidth'] video_height = video_list['video_3']['vheight'] elif 'video_2' in video_list.keys(): # Common.logger(log_type).info('{}', video_list['video_2']) video_url = video_list['video_2']['main_url'] audio_url = video_list['video_2']['main_url'] if len(video_url) % 3 == 1: video_url += '==' elif len(video_url) % 3 == 2: video_url += '=' elif len(audio_url) % 3 == 1: audio_url += '==' elif len(audio_url) % 3 == 2: audio_url += '=' video_url = base64.b64decode(video_url).decode('utf8') audio_url = base64.b64decode(audio_url).decode('utf8') video_width = video_list['video_2']['vwidth'] video_height = video_list['video_2']['vheight'] elif 'video_1' in video_list.keys(): # Common.logger(log_type).info('{}', video_list['video_1']) video_url = video_list['video_1']['main_url'] audio_url = video_list['video_1']['main_url'] if len(video_url) % 3 == 1: video_url += '==' elif len(video_url) % 3 == 2: video_url += '=' elif len(audio_url) % 3 == 1: audio_url += '==' elif len(audio_url) % 3 == 2: audio_url += '=' video_url = base64.b64decode(video_url).decode('utf8') audio_url = base64.b64decode(audio_url).decode('utf8') video_width = video_list['video_1']['vwidth'] video_height = video_list['video_1']['vheight'] else: video_url = 0 audio_url = 0 video_width = 0 video_height = 0 return video_url, audio_url, video_width, video_height except Exception as e: Common.logger(log_type).error(f'get_video_info异常:{e}\n') # 获取所有用户主页视频 @classmethod def get_all_person_videos(cls, log_type, env): try: user_list = cls.get_user_info_from_feishu(log_type) if len(user_list) == 0: Common.logger(log_type).warning('用户ID列表为空\n') else: for k, v in user_list.items(): Common.logger(log_type).info('正在获取 {} 主页视频\n', k) GetSignature.get_signature('follow') cls.get_follow_feeds_by_pc(log_type, v.split(',')[0], env, v.split(',')[1]) time.sleep(10) cls.offset = 0 except Exception as e: Common.logger(log_type).error('get_all_person_videos异常:{}\n', e) # 合并音视频 @classmethod def video_compose(cls, log_type, video_title): try: video_path = './videos/' + str(video_title) + '/video1.mp4' audio_path = './videos/' + str(video_title) + '/audio1.mp4' out_path = './videos/' + str(video_title) + '/video.mp4' cmd = 'ffmpeg -i ' + video_path + ' -i ' + audio_path + \ ' -c:v copy -c:a aac -strict experimental -map 0:v:0 -map 1:a:0 ' + out_path # print(cmd) subprocess.call(cmd, shell=True) for file in os.listdir('./videos/' + str(video_title)): if file.split('.mp4')[0] == 'video1' or file.split('.mp4')[0] == 'audio1': os.remove('./videos/' + str(video_title) + '/' + file) Common.logger(log_type).info('合成成功\n') except Exception as e: Common.logger(log_type).error(f'video_compose异常:{e}\n') # 下载 / 上传 @classmethod def download_publish(cls, log_type, env, uid): try: feeds_sheet = Feishu.get_values_batch(log_type, 'xigua', 'wjhpDs') for i in range(1, len(feeds_sheet)): download_video_title = feeds_sheet[i][2] download_video_id = feeds_sheet[i][3] download_video_gid = feeds_sheet[i][4] download_play_cnt = feeds_sheet[i][5] download_comment_cnt = feeds_sheet[i][6] download_like_cnt = feeds_sheet[i][7] download_share_cnt = feeds_sheet[i][8] download_video_duration = feeds_sheet[i][9] download_video_width_height = feeds_sheet[i][10] download_send_time = feeds_sheet[i][11] download_user_name = feeds_sheet[i][12] download_user_id = feeds_sheet[i][13] download_head_url = feeds_sheet[i][14] download_cover_url = feeds_sheet[i][15] download_video_url = feeds_sheet[i][16] download_audio_url = feeds_sheet[i][17] Common.logger(log_type).info('正在判断第{}行:{}', i + 1, download_video_title) Common.logger(log_type).info('download_video_id:{}', download_video_id) Common.logger(log_type).info('download_video_duration:{}', download_video_duration) Common.logger(log_type).info('download_send_time:{}', download_send_time) # 过滤空行 if download_video_title is None or download_video_id is None: Feishu.dimension_range(log_type, 'xigua', 'wjhpDs', 'ROWS', i + 1, i + 1) Common.logger(log_type).info('空行，删除成功\n') return elif str(download_video_id) in [x for y in Feishu.get_values_batch(log_type, 'xigua', 'e075e9') for x in y]: Feishu.dimension_range(log_type, 'xigua', 'wjhpDs', 'ROWS', i + 1, i + 1) Common.logger(log_type).info('视频已下载，删除成功\n') return elif str(download_video_id) in [x for y in Feishu.get_values_batch(log_type, 'xigua', '3Ul6wZ') for x in y]: Feishu.dimension_range(log_type, 'xigua', 'wjhpDs', 'ROWS', i + 1, i + 1) Common.logger(log_type).info('视频已下载，删除成功\n') return else: # 下载封面 Common.download_method(log_type=log_type, text='cover', d_name=download_video_title, d_url=download_cover_url) # 下载视频 Common.download_method(log_type=log_type, text='video', d_name=download_video_title, d_url=download_video_url) # 下载音频 Common.download_method(log_type=log_type, text='audio', d_name=download_video_title, d_url=download_audio_url) # 保存视频信息至 "./videos/{download_video_title}/info.txt" with open("./videos/" + download_video_title + "/" + "info.txt", "a", encoding="UTF-8") as f_a: f_a.write(str(download_video_id) + "\n" + str(download_video_title) + "\n" + str(download_video_duration) + "\n" + str(download_play_cnt) + "\n" + str(download_comment_cnt) + "\n" + str(download_like_cnt) + "\n" + str(download_share_cnt) + "\n" + str(download_video_width_height) + "\n" + str(int(time.mktime( time.strptime(download_send_time, "%Y/%m/%d %H:%M:%S")))) + "\n" + str(download_user_name) + "\n" + str(download_head_url) + "\n" + str(download_video_url) + "\n" + str(download_cover_url) + "\n" + "xigua"+str(int(time.time()))) Common.logger("follow").info("==========视频信息已保存至info.txt==========") # 合成音视频 cls.video_compose(log_type, download_video_title) # 上传视频 Common.logger(log_type).info("开始上传视频:{}".format(download_video_title)) our_video_id = Publish.upload_and_publish(log_type, env, uid) if env == 'dev': our_video_link = "https://testadmin.piaoquantv.com/cms/post-detail/" + str(our_video_id) + "/info" else: our_video_link = "https://admin.piaoquantv.com/cms/post-detail/" + str(our_video_id) + "/info" Common.logger(log_type).info("视频上传完成:{}\n", download_video_title) # 视频ID工作表，插入首行 Feishu.insert_columns(log_type, 'xigua', "e075e9", "ROWS", 1, 2) # 视频ID工作表，首行写入数据 upload_time = int(time.time()) values = [[time.strftime("%Y/%m/%d %H:%M:%S", time.localtime(upload_time)), "关注榜", download_video_title, str(download_video_id), our_video_link, download_video_gid, download_play_cnt, download_comment_cnt, download_like_cnt, download_share_cnt, download_video_duration, download_video_width_height, download_send_time, download_user_name, download_user_id, download_head_url, download_cover_url, download_video_url, download_audio_url]] Common.logger(log_type).info('values:{}\n', values) time.sleep(1) Feishu.update_values(log_type, 'xigua', "e075e9", "F2:Z2", values) Common.logger(log_type).info("视频已保存至云文档:{}", download_video_title) # 删除行或列，可选 ROWS、COLUMNS Feishu.dimension_range(log_type, 'xigua', "wjhpDs", "ROWS", i + 1, i + 1) Common.logger(log_type).info(f"视频:{download_video_title}，下载/上传成功\n") return except Exception as e: Common.logger(log_type).error('download_publish异常:{}\n', e) if __name__ == '__main__': pass