def get_url():
    """
    获取要查询的恶意域名url
    """

    sql = 'SELECT url FROM virustotal_info WHERE total is NULL or total =" " '
    result_list = []
    sql_query = MysqlConnection(host="172.26.253.3", user="******", passwd="platform", db="cyn_malicious_domain")

    result_list = sql_query.execute_query(sql)

    if result_list:
        return result_list
    else:
        return
 def update_db(self):
     """
     更新查询结果到数据库中
     """
     sql = (
         'UPDATE virustotal_info set date="%s",total = "%s",positives="%s",ip="%s",resolution_country="%s",category="%s",verify_result="%s" WHERE url = "%s"'
         % (
             self.date,
             self.total,
             self.positives,
             self.ip,
             self.resolution_country,
             self.category,
             str(self.verify_result),
             self.url,
         )
     )
     sql_query = MysqlConnection(host="172.26.253.3", user="******", passwd="platform", db="cyn_malicious_domain")
     sql_query.execute_update(sql)