def update_db(): """ 更新数据库 """ svr_num = sum_all_list() db = MySQL(DESTINATION_CONFIG) db.truncate('TRUNCATE TABLE top_sec_svr') sql = 'INSERT INTO top_sec_svr(top_svr, sec_svr, whois_sum) VALUES("%s", "%s", "%s")' for top,sec,num in svr_num: db.insert_no_commit(sql % (top,sec,num)) db.commit() db.close()
def update_db(): """更新数据库""" tld_num = sum_all_domains() db = MySQL(DESTINATION_CONFIG) db.truncate('TRUNCATE TABLE domain_summary') update_sql = 'INSERT INTO domain_update(tld_name, domain_num) VALUES("%s", "%s")' summary_sql = 'INSERT INTO domain_summary(tld_name, domain_num) VALUES("%s", "%s")' for tld,num in tld_num: db.insert_no_commit(update_sql % (tld,num)) db.insert_no_commit(summary_sql % (tld,num)) db.commit() db.close()
def update_destination(tb_name, results): """ 更新数据库 :param results: :return: """ destination_db = MySQL(DESTINATION_CONFIG) destination_db.truncate('TRUNCATE TABLE domain_whois_%s' % tb_name) for item in results: destination_db.insert_no_commit('INSERT INTO domain_whois_%s (tld,flag,whois_sum) VALUES ("%s","%s","%s")' % ( tb_name, item[0], item[1], item[2])) destination_db.commit() destination_db.close()
def update_db(): """更新数据库""" db = MySQL(DESTINATION_CONFIG) truncate_sql = 'TRUNCATE TABLE tld_whois_flag' db.truncate(truncate_sql) sql = 'INSERT INTO tld_whois_flag(tld, flag,flag_detail, whois_sum) VALUES("%s", "%s", "%s", "%s")' tld_flag_num = sum_all_flags() for tld, flag_detail, num in tld_flag_num: try: if int(flag_detail) < 0: flag = '0' elif int(flag_detail) >= 120: flag = '1' elif flag_detail == '102' or flag_detail == '110' or flag_detail == '112': flag = '2' else: flag = '3' db.insert_no_commit(sql % (tld,flag,flag_detail,num)) except: continue db.commit() db.close()