import os
import sys
import datetime



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


class sqlHelp():
    @classmethod
    def get_count_list(cls, name_list):
        count_list = []
        current_time = datetime.now()
        formatted_time = current_time.strftime("%Y-%m-%d")
        for name in name_list:

            count = f"""SELECT COUNT(*) AS agc_video_deposit FROM ( SELECT audio, account_id FROM agc_video_deposit WHERE time = '{formatted_time}' AND mark = '{name["mark"]}' GROUP BY audio, account_id) AS subquery;"""
            count = MysqlHelper.get_values(count, "prod")
            if count == None:
                count = 0
            count = str(count).replace('(', '').replace(')', '').replace(',', '')
            count_list.append(f"{name['mark_name']}生成条数为:{count}条 \n")
        return count_list