frompot_libs.mysql_util.mysql_utilimportMysqlUtilasyncdefget_sum_by_interval(table_name,time_format,start,end,sql_mid,cid_list,point_id):sql=f"""SELECT SUM(p) p,sum(charge) charge,sum(kwh) kwh, DATE_FORMAT(create_time, '{time_format}') time_interval FROM {table_name} where {sql_mid} and create_time >="{start}" and
else:data=awaitconn.fetchall(sql,args=(point_id,))returndataasyncdefget_power_charge_dao(table_name,start,end,sql_mid):sql=f'SELECT * from {table_name} where {sql_mid} and ' \f'create_time >="{start}" and create_time<="{end}"'asyncwithMysqlUtil()asconn:data=awaitconn.fetchall(sql)returndata