video_editor/main.py

import os
import sys
import datetime


sys.path.append(os.getcwd())
from datetime import datetime
from common import MysqlHelper

from video_stitching.video_stitching import VideoStitching



def get_account_id():
    current_time = datetime.now()
    formatted_time = current_time.strftime("%Y-%m-%d")
    count = f"""SELECT COUNT(*) AS total_count
                        FROM (
                          SELECT audio, account_id
                          FROM video_audio
                          WHERE time = "{formatted_time}" 
                          GROUP BY audio, account_id
                        ) AS subquery;"""
    count = MysqlHelper.get_values(count, "prod")
    return count
if __name__ == '__main__':
    count = get_account_id()
    count = str(count).replace('(', '').replace(')', '').replace(',', '')
    if int(count) < 20:
        VideoStitching.video_stitching()