ICPspider.py 文件源码

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