redis识别归属地

##############号段入库标记###########
# -*- coding: utf-8 -*-
import re
import redis
r_conn = redis.Redis(host='192.168',port='6666',password='')
import csv
def get_data(t1):
    f2 = open('合肥_手机号段查询.txt', 'r')
    data1 = f2.read()
    pat = '1\d{6}'
    phones = re.compile(pat).findall(data1)
    print(len(phones))
    for phone in phones:
        print(phone)
        phone=str(phone)
        p_test = r_conn.hget('190801_hf', phone)
        print(p_test)
        if p_test == None:
            r_conn.hset('190801_hf', phone,'13')
            t1 = t1+1
            if t1 == 100000000000000:
                break
            else:
                pass
        else:
            print('the keys always exist!')

if __name__=='__main__':
    t1 = 0
    get_data(t1)

##################redis识别归属地#####################

# -*- coding: utf-8 -*-
from selenium import webdriver
import threading
import time
import redis
import re
import csv
import pymysql
import datetime
from selenium.webdriver.common.desired_capabilities import DesiredCapabilities
r_conn = redis.Redis(host='192.168.1.110', port='6666', password='cxys3204')
# db = pymysql.connect(host='192.168.1.',port=3306,user='root',db='cxys_public_data',passwd='',charset='utf8')
filename = '1004北京企业联系人.csv'
def get_mysqldata1():
    for name in range(0,1):
        p_data = open('0615hd_main_city_hf.txt', 'r')
        data1 = p_data.read()
        pat = '1\d{10}'
        phones = re.compile(pat).findall(data1)
        for real_phone in phones:
            real_phone = str(real_phone)
            filename = '1017济南企业联系人'
            f = open(str(filename) + '.txt', "a+")
            p = str(real_phone) + '\n'
            f.write(p)
    # db.close()
if __name__=='__main__':
    get_mysqldata1()