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)