def get_domain(): try: db = Database() exsited_sql = 'SELECT domain FROM domain_white_list_whois_copy' exsited_domain = db.select_domain(exsited_sql) existed_domain_list = [i[0] for i in exsited_domain] check_sql = 'SELECT domain FROM domain_white_list' check_domain = db.select_domain(check_sql) check_domain_list = [i[0] for i in check_domain] # return list(set(existed_domain_list).difference(set(check_domain_list))) return list(set(check_domain_list).difference(set(existed_domain_list))) except: print '获得查询域名异常' sys.exit(1) finally: db.close_db()
def get_domain(): try: db = Database() exsited_sql = 'SELECT domain FROM domain_white_list_whois_copy' exsited_domain = db.select_domain(exsited_sql) existed_domain_list = [i[0] for i in exsited_domain] check_sql = 'SELECT domain FROM domain_white_list' check_domain = db.select_domain(check_sql) check_domain_list = [i[0] for i in check_domain] # return list(set(existed_domain_list).difference(set(check_domain_list))) return list( set(check_domain_list).difference(set(existed_domain_list))) except: print '获得查询域名异常' sys.exit(1) finally: db.close_db()
def get_domain(): try: db = Database() sql = "SELECT domain FROM domain_white_list_whois_copy WHERE (reg_email = '' AND reg_phone ='' AND reg_name = '' AND details = '')" domain = db.select_domain(sql) domain_list = [i[0] for i in domain] return domain_list except: print '获得查询域名异常' sys.exit(1) finally: db.close_db()