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()
