crawler_xigua/main/xigua_follow_old.py

# -*- 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.xigua_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