def save_recover_info(results): """ save recover info :param results: :return: """ sqls = [] for item in results: if item['port'] is None or (str(item['port']) == ''): item['port'] = 0 sql = INSERT_WARNING_HISTORY % ( get_uuid_str(), item['sys_id'], item['sys_name'], item['description'], item['type'], item['ip'], str(item['port']), item['start_time'], item['check_result'], '', '异常恢复', str(item['interval'])) sqls.append(sql) DB_POOL.execute_sql_array(sqls)
def __insert_system_info(json_obj): """ insert monitor instance :param json_obj: :return: """ sql = INSERT_SYSTEM_INFO % ( get_uuid_str(), TypeChange.to_string(json_obj, 'name'), TypeChange.to_string(json_obj, 'manager'), TypeChange.to_string(json_obj, 'telephone'), TypeChange.to_string(json_obj, 'job_number'), ) DB_POOL.execute_sql_str(sql)
def __insert_monitor_instance(json_obj): """ insert monitor instance :param json_obj: `id`,`sys_id`,`sys_name`,`description`,`ip`,`port`,`type`,`interval`,`is_use` :return: """ sql = INSERT_MONITOR_INSTANCE % ( get_uuid_str(), TypeChange.to_string(json_obj, 'sys_id'), TypeChange.to_string(json_obj, 'sys_name'), TypeChange.to_string( json_obj, 'description'), TypeChange.to_string( json_obj, 'ip'), TypeChange.to_string(json_obj, 'port'), TypeChange.to_string( json_obj, 'type'), TypeChange.to_string(json_obj, 'interval'), TypeChange.to_string(json_obj, 'is_use')) DB_POOL.execute_sql_str(sql)
def save_check_result_to_detail(results): """ save check info to mysql :param results: :return: """ sqls = [] for result in results: if result.interval is None: result.interval = 0 if result.end_time is None: result.end_time = time.time() if result.port is None: result.port = 0 sql = INSERT_PING_TO_MONITOR_DETAIL. \ format(pymysql.escape_string(get_uuid_str()), pymysql.escape_string(result.ip), result.port, pymysql.escape_string(result.check_type), pymysql.escape_string(str(result.is_success)), pymysql.escape_string(TypeChange.date_stamp_to_datetime(result.start_time)), pymysql.escape_string(TypeChange.date_stamp_to_datetime(result.end_time)), pymysql.escape_string(str(result.interval))) sqls.append(sql) DB_POOL.execute_sql_array(sqls)
def save_items(items): """ save items :param items: :return: """ sqls = [] for item in items: if item.port is None: item.port = 0 sql = INSERT_WARNING_HISTORY % ( get_uuid_str(), item.sys_id, item.sys_name, item.description, item.check_type, item.ip, item.port, TypeChange.date_stamp_to_datetime(item.start_time), item.is_success, item.comment, item.warning_type, item.interval) sqls.append(sql) DB_POOL.execute_sql_array(sqls)
from common.utility.uuid_utility import get_uuid_str from db.mysql_relevant.connection_pool.db_pool import DB_POOL from db.mysql_relevant.sql_str.monitor_instance import INSERT_MONITOR_INSTANCE sys_id = 'f6f7aa8239a24499962ee7f45a763bc5' sys_name = '综合运营平台' with open('1.csv', 'r', encoding='utf8') as f: reader = csv.reader(f) print(type(reader)) for row in reader: description = str(row[0]).replace(' ', '') ip = row[1].replace(' ', '') ports = row[2].replace(' ', '') ports = str(ports).split('/') for port in ports: if len(port) < 2: continue sql = INSERT_MONITOR_INSTANCE % (get_uuid_str(), sys_id, sys_name, description, ip, str(port), '半连接', '60', '1') print(sql) DB_POOL.execute_sql_str(sql) print(row)