def update_table(tb_name): """ 更新表 :param tb_name: :return: """ sql = 'SELECT flag,sum(whois_sum) FROM domain_whois_%s GROUP BY flag' % tb_name.lower() flag_undetected = flag_no_svr = flag_no_connect = 0 flag_reg_info = flag_reg_date = flag_part_info = 0 db = MySQL(DESTINATION_CONFIG) db.query(sql) results = db.fetch_all_rows() for item in results: flag = item[0] whois_sum = item[1] if flag == '-6': flag_undetected += whois_sum if flag == '-5': flag_no_svr += whois_sum elif flag == '-1' or flag == '-2' or flag == '-3' or flag == '-4': flag_no_connect += whois_sum elif flag == '120' or flag == '121' or flag == '122': flag_reg_info += whois_sum elif flag == '110' or flag == '102' or flag == '112': flag_reg_date += whois_sum elif flag == '100' or flag == '101' or flag == '111': flag_part_info += whois_sum sql = 'INSERT INTO table_overall_history (table_name,flag_undetected,\ flag_no_svr,flag_no_connect,flag_reg_info,flag_reg_date,flag_part_info) \ VALUES ("%s","%s","%s","%s","%s","%s","%s")' % ('domain_whois_'+tb_name,flag_undetected,flag_no_svr,flag_no_connect,flag_reg_info,flag_reg_date,flag_part_info) db.insert(sql) db.close()
def update_day(): """更新表whois_sum_by_day,即统计数据库中最新的域名whois总量 """ print str(datetime.now()), '开始更新当天数据库中最新的WHOIS总量(whois_sum_by_day)' db = MySQL(DESTINATION_CONFIG) sql = 'INSERT INTO whois_sum_by_day(sum) SELECT MAX(tld_sum) FROM whois_sum \ WHERE to_days(insert_time) = to_days(now())' db.insert(sql) db.close() print str(datetime.now()), '结束更新当天数据库中最新的WHOIS总量(whois_sum_by_day)'
def update_db(): """更新数据库""" tld_whois = sum_all_whois() total = 0 db = MySQL(DESTINATION_CONFIG) sql = 'INSERT INTO tld_whois_sum_history(tld,whois_sum) VALUES("%s", "%s")' # 插入数据 for tld, whois in tld_whois: db.insert_no_commit(sql % (tld, whois)) total += whois db.commit() sql = 'INSERT INTO whois_sum(tld_sum) VALUES("%s")' db.insert(sql % total) db.close()
def update_db(): """更新数据库""" tld_whois = sum_all_whois() total = 0 db = MySQL(DESTINATION_CONFIG) sql = 'INSERT INTO tld_whois_sum_history(tld,whois_sum) VALUES("%s", "%s")' # 插入数据 for tld,whois in tld_whois: db.insert_no_commit(sql % (tld,whois)) total += whois db.commit() sql = 'INSERT INTO whois_sum(tld_sum) VALUES("%s")' db.insert(sql % total) db.close()
def insert_host_error(error,process_ids): """更新主机错误""" db = MySQL(SOURCE_CONFIG) error_info = '主机异常:'+ str(error) status = '异常' sql = 'insert into process_status (process_id,cpu,mem,vsz,rss,status,error_info,log_size) values("%s","%s","%s","%s","%s","%s","%s","%s")' for _,process_id,_,_ in process_ids: db.insert(sql % (process_id, 0, 0, 0, 0, status, error_info,'-3')) # -3表示日志的主机错误 email, host, pid, code_route, code_name,warning_times = process_id_to_user(process_id) if warning_times > 0: content = (pid, host, status, error_info, code_route, code_name) if send_process_exception([email], content): print "邮件预警成功:" + email reduce_warning_times(process_id) else: print "邮件预警失败:" + email db.close()
def update_table(tb_name): """ 更新表 :param tb_name: :return: """ sql = 'SELECT flag,sum(whois_sum) FROM domain_whois_%s GROUP BY flag' % tb_name.lower( ) flag_undetected = flag_no_svr = flag_no_connect = 0 flag_reg_info = flag_reg_date = flag_part_info = 0 db = MySQL(DESTINATION_CONFIG) db.query(sql) results = db.fetch_all_rows() for item in results: flag = item[0] whois_sum = item[1] if flag == '-6': flag_undetected += whois_sum if flag == '-5': flag_no_svr += whois_sum elif flag == '-1' or flag == '-2' or flag == '-3' or flag == '-4': flag_no_connect += whois_sum elif flag == '120' or flag == '121' or flag == '122': flag_reg_info += whois_sum elif flag == '110' or flag == '102' or flag == '112': flag_reg_date += whois_sum elif flag == '100' or flag == '101' or flag == '111': flag_part_info += whois_sum sql = 'INSERT INTO table_overall_history (table_name,flag_undetected,\ flag_no_svr,flag_no_connect,flag_reg_info,flag_reg_date,flag_part_info) \ VALUES ("%s","%s","%s","%s","%s","%s","%s")' % ( 'domain_whois_' + tb_name, flag_undetected, flag_no_svr, flag_no_connect, flag_reg_info, flag_reg_date, flag_part_info) db.insert(sql) db.close()