# -------------------------------------------------------------------------
# Copyright (c) 2025 Huawei Technologies Co., Ltd.
# This file is part of the MindStudio project.
#
# MindStudio is licensed under Mulan PSL v2.
# You can use this software according to the terms and conditions of the Mulan PSL v2.
# You may obtain a copy of Mulan PSL v2 at:
#
#    http://license.coscl.org.cn/MulanPSL2
#
# THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
# EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
# MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
# See the Mulan PSL v2 for more details.
# -------------------------------------------------------------------------

from common_func.db_manager import DBManager
from common_func.db_name_constant import DBNameConstant
from common_func.ms_constant.number_constant import NumberConstant
from msconfig.config_manager import ConfigManager
from msmodel.interface.parser_model import ParserModel
from profiling_bean.db_dto.acc_pmu_dto import AccPmuOriDto


class AccPmuModel(ParserModel):
    """
    task_based acc_pmu data model
    """

    READ = 1
    WRITE = 0
    TABLES_PATH = ConfigManager.TABLES

    def __init__(self: any, result_dir: str, db_name: str, table_list: list) -> None:
        super().__init__(result_dir, db_name, table_list)
        self.cur = None
        self.conn = None

    def insert_pmu_origin_data(self: any, datas: list) -> None:
        """
        insert acc_pmu data to db
        :return: None
        """
        result = [(data.acc_id, data.bandwidth[self.READ], data.bandwidth[self.WRITE],
                   data.ost[self.READ], data.ost[self.WRITE], data.timestamp) for data in datas]

        self.insert_data_to_db(DBNameConstant.TABLE_ACC_PMU_DATA, result)

    def flush(self: any, data: list) -> None:
        """
        insert data to database
        """
        self.insert_pmu_origin_data(data)

    def get_timeline_data(self: any) -> list:
        """
        get soc timeline data
        :return: list
        """
        if not DBManager.judge_table_exist(self.cur, DBNameConstant.TABLE_ACC_PMU_DATA):
            return []
        sql = "select acc_id, read_bandwidth, write_bandwidth ,read_ost, write_ost, " \
              "timestamp/{NS_TO_US} as timestamp from {} ORDER BY timestamp ASC, acc_id ASC".format(
            DBNameConstant.TABLE_ACC_PMU_DATA, NS_TO_US=NumberConstant.NS_TO_US)
        return DBManager.fetch_all_data(self.cur, sql, dto_class=AccPmuOriDto)

    def get_summary_data(self: any) -> list:
        """
        get soc timeline data
        :return: list
        """
        if not DBManager.judge_table_exist(self.cur, DBNameConstant.TABLE_ACC_PMU_DATA):
            return []
        sql = "select task_id, stream_id, acc_id, block_id," \
              " read_bandwidth, write_bandwidth ,read_ost, write_ost, " \
              "time_stamp, start_time, dur_time from {}".format(DBNameConstant.TABLE_ACC_PMU_DATA)
        return DBManager.fetch_all_data(self.cur, sql)