def get_domains(self):
global domains
domains = []
results = []
try:
db = MySQLdb.connect(host='172.26.253.3',
user='root',
passwd='platform',
charset = "utf8",
db='malicious_domain_sys')
cur = db.cursor()
sql = 'SELECT locate.id, domain_index.domain FROM locate,domain_index WHERE locate.id = domain_index.id AND locate.flag > 0 AND locate.flag mod 10 = 0'
count = cur.execute(sql)
# results = cur.fetchall()
domains = cur.fetchall()
# for result in results:
# if result[0].split('.')[-1] == 'cn':
# domains.append(result[0])
db.close()
except MySQLdb.Error,e:
raise e
评论列表
文章目录