Exemple #1
0
 def __init__(self):
     self.elementConstant = ElementConstant()
     self.getIpProxy = GetIpProxy()
     self.url = "https://bj.lianjia.com/ershoufang/pg{}/"
     self.infos = {}
     self.proxyServer = ()
     # 传参使用进行excle生成
     self.generate_excle = generate_excle()
     self.elementConstant = ElementConstant()
 def __init__(self, city, url=None):
     self.city = city
     self.elementConstant = ElementConstant()
     self.getIpProxy = GetIpProxy()
     if url == None:
         self.url = "https://%s.ke.com/chengjiao/pg{}/" % cityMap[self.city]
     else:
         self.url = url
     self.infos = {}
     self.proxyServer = ()
     # 传参使用进行excle生成
     self.generate_excle = generate_excle()
     self.elementConstant = ElementConstant()
class chengJiaoInfo:
    # 初始化构造函数
    def __init__(self, city, url=None):
        self.city = city
        self.elementConstant = ElementConstant()
        self.getIpProxy = GetIpProxy()
        #        self.url = "https://bj.lianjia.com/ershoufang/pg{}/"
        if url == None:
            self.url = "https://%s.lianjia.com/chengjiao/pg{}/" % cityMap[
                self.city]
        else:
            self.url = url
        self.infos = {}
        self.proxyServer = ()
        # 传参使用进行excle生成
        self.generate_excle = generate_excle()
        self.elementConstant = ElementConstant()

    # 生成需要生成页数的链接
    def generate_allurl(self, user_in_nub):
        for url_next in range(1, int(user_in_nub) + 1):
            self.page = url_next
            yield self.url.format(url_next)

    # 开始函数
    def start(self):
        self.generate_excle.addSheetExcle(u'在售列表')
        user_in_nub = 100  #input('输入生成页数:')
        for i in self.generate_allurl(user_in_nub):
            try:
                print('page', i)
                url_count = self.get_allurl(i)
                while url_count == 0:
                    print("error get item url.", i)
                    time.sleep(3600)
                    self.proxyServer = self.getIpProxy.get_random_ip()
                    url_count = self.get_allurl(i)
                if self.page % 5 == 0:
                    self.saveResult()
            except Exception as e:
                print(i, e, 'failed')
        self.saveResult()

    def saveResult(self):
        date = str(datetime.datetime.now().date())
        dirName = 'data/chengjiao-%s' % self.city
        if not os.path.exists(dirName):
            os.makedirs(dirName)
        self.generate_excle.saveExcle(
            '%s/%s-%s.xls' % (dirName, date, self.city.split('/')[-1]))

    def get_allurl(self, generate_allurl):
        geturl = self.requestUrlForRe(generate_allurl)
        url_count = 0
        if geturl.status_code == 200:
            # 提取title跳转地址 对应每个商品
            re_set = re.compile('<li.*?<a.*?class="img.*?".*?href="(.*?)"')
            re_get = re.findall(re_set, geturl.text)
            url_count = len(re_get)
            for index in range(len(re_get)):
                print re_get[index]
                url_status = self.open_url(re_get[index], index)
                while url_status == False:
                    self.proxyServer = self.getIpProxy.get_random_ip()
                    url_status = self.open_url(re_get[index], index)
                print(re_get[index])
        elif geturl.status_code == 404:
            url_count = -1
        return url_count

    def open_url(self, re_get, index):
        print(re_get, index)
        res = self.requestUrlForRe(re_get)
        if res.status_code == 200:
            if '*****@*****.**' in res.text:
                return False
            soup = BeautifulSoup(res.text, 'lxml')
            self.infos['网址'] = re_get
            self.infos['标题'] = soup.title.text.split('_')[0]
            self.infos['售价(万)'] = soup.find(class_='dealTotalPrice').text
            self.infos['每平方售价'] = soup.find(
                class_='record_detail').text.split('元')[0][2:]
            partent = re.compile(
                '<li><span class="label">(.*?)</span>(.*?)</li>')
            result = re.findall(partent, res.text)
            for item in result:
                if item[0] == '建成年代':
                    self.infos['建成时间:年'] = item[1].strip()
                else:
                    self.infos[item[0]] = item[1].strip()

            partent = re.compile('<i>></i>(.*?)</a>')
            result = re.findall(partent, res.text)
            self.infos['所属下辖区'] = result[1].split('>')[1].split('二手房')[0]
            self.infos['所属商圈'] = result[2].split('>')[1].split('二手房')[0]
            self.infos['所属小区'] = result[3].split('>')[1].split('二手房')[0]
            msg = soup.find(class_='msg').contents
            result = [(
                a.contents[1],
                a.contents[0].text,
            ) for a in msg]
            for item in result:
                if item[0] == '建成年代':
                    self.infos['建成时间:年'] = item[1].strip()
                else:
                    self.infos[item[0]] = item[1].strip()
            self.infos['成交时间'] = '-'.join(
                soup.find(
                    class_='wrapper').contents[1].text.split()[0].split('.'))
            row = index + (self.page - 1) * 30
            #self.infos['序号'] = row + 1
            self.infos['城市'] = self.city
            print('row:' + str(row))
            if row == 0:
                for index_item in self.elementConstant.data_constant.keys():
                    self.generate_excle.writeExclePositon(
                        0, self.elementConstant.data_constant.get(index_item),
                        index_item)

                self.wirte_source_data(1)

            else:
                row = row + 1
                self.wirte_source_data(row)
        return True

    # 封装统一request请求,采取动态代理和动态修改User-Agent方式进行访问设置,减少服务端手动暂停的问题
    def requestUrlForRe(self, url):

        try:
            if len(self.proxyServer) == 0:
                tempProxyServer = self.getIpProxy.get_random_ip()
            else:
                tempProxyServer = self.proxyServer
            proxy_dict = {tempProxyServer[0]: tempProxyServer[1]}
            tempUrl = requests.get(url,
                                   headers=hds[random.randint(0,
                                                              len(hds) - 1)],
                                   proxies=proxy_dict)
            code = tempUrl.status_code
            #print tempUrl.text.decode('gbk')
            if code >= 200 or code < 300:
                self.proxyServer = tempProxyServer
                return tempUrl
            else:
                self.proxyServer = self.getIpProxy.get_random_ip()
                return self.requestUrlForRe(url)
        except Exception as e:
            self.proxyServer = self.getIpProxy.get_random_ip()
            s = requests.session()
            s.keep_alive = False
            return self.requestUrlForRe(url)

    # 源数据生成,写入excle中,从infos字典中读取数据,放置到list列表中进行写入操作,其中可修改规定写入格式
    def wirte_source_data(self, row):
        for itemKey in self.infos.keys():
            #print(itemKey + ':' + str(self.infos.get(itemKey)))

            item_valus = self.infos.get(itemKey)
            tempItemKey = self.elementConstant.unit_check_name(
                itemKey.encode('utf-8'))
            count = self.elementConstant.data_constant.get(tempItemKey)
            print tempItemKey, self.elementConstant.data_constant.get(
                tempItemKey), item_valus
            if tempItemKey != None and count != None:

                self.generate_excle.writeExclePositon(
                    row, self.elementConstant.data_constant.get(tempItemKey),
                    item_valus)
class salingInfo:
    # 初始化构造函数
    def __init__(self):
        self.elementConstant = ElementConstant()
        self.getIpProxy = GetIpProxy()
        self.url = "https://bj.lianjia.com/ershoufang/pg{}/"
        #        self.url = "https://bj.lianjia.com/chengjiao/pg{}/"
        self.infos = {}
        self.proxyServer = ()
        # 传参使用进行excle生成
        self.generate_excle = generate_excle()
        self.elementConstant = ElementConstant()

    # 生成需要生成页数的链接
    def generate_allurl(self, user_in_nub):
        for url_next in range(1, int(user_in_nub) + 1):
            self.page = url_next
            yield self.url.format(url_next)

    # 开始函数
    def start(self):
        self.generate_excle.addSheetExcle(u'在售列表')
        user_in_nub = input('输入生成页数:')

        for i in self.generate_allurl(user_in_nub):
            self.get_allurl(i)
            print(i)
        self.generate_excle.saveExcle('LianJiaSpider.xls')

    def get_allurl(self, generate_allurl):
        geturl = self.requestUrlForRe(generate_allurl)
        if geturl.status_code == 200:
            # 提取title跳转地址 对应每个商品
            re_set = re.compile('<li.*?<a.*?class="img.*?".*?href="(.*?)"')
            re_get = re.findall(re_set, geturl.text)
            for index in range(len(re_get)):
                self.open_url(re_get[index], index)
                print re_get[index]

    def open_url(self, re_get, index):
        res = self.requestUrlForRe(re_get)
        if res.status_code == 200:
            soup = BeautifulSoup(res.text, 'lxml')
            self.infos['网址'] = re_get
            self.infos['标题'] = soup.select('.main')[0].text
            self.infos['总价'] = soup.select('.total')[0].text + u'万'
            self.infos['每平方售价'] = soup.select('.unitPriceValue')[0].text

            self.infos['户型'] = soup.select('.mainInfo')[0].text
            self.infos['朝向'] = soup.select('.mainInfo')[1].text
            self.infos['大小'] = soup.select('.mainInfo')[2].text
            self.infos['楼层'] = soup.select('.subInfo')[0].text
            self.infos['装修'] = soup.select('.subInfo')[1].text
            self.infos['房子类型'] = soup.select('.subInfo')[2].text

            self.infos['小区名称'] = soup.select('.info')[0].text
            self.infos['区域'] = soup.select('.info > a')[0].text
            # infos['地区'] = soup.select('.info > a')[1].text
            self.infos['详细区域'] = soup.select('.info')[1].text
            self.infos['链家编号'] = soup.select('.info')[3].text
            self.infos['关注房源'] = soup.select('#favCount')[0].text + u"人关注"
            self.infos['看过房源'] = soup.select('#cartCount')[0].text + u"人看过"

            partent = re.compile(
                '<li><span class="label">(.*?)</span>(.*?)</li>')
            result = re.findall(partent, res.text)

            for item in result:
                if item[0] != u"抵押信息" and item[0] != u"房本备件":
                    self.infos[item[0]] = item[1]
            row = index + (self.page - 1) * 30
            self.infos['序号'] = row + 1
            self.infos['状态'] = u'在售'
            self.infos['城市'] = u'北京'
            print 'row:' + str(row)
            if row == 0:
                for index_item in self.elementConstant.data_constant.keys():
                    self.generate_excle.writeExclePositon(
                        0, self.elementConstant.data_constant.get(index_item),
                        index_item)

                self.wirte_source_data(1)

            else:
                row = row + 1
                self.wirte_source_data(row)
        return self.infos

    # 封装统一request请求,采取动态代理和动态修改User-Agent方式进行访问设置,减少服务端手动暂停的问题
    def requestUrlForRe(self, url):

        try:
            if len(self.proxyServer) == 0:
                tempProxyServer = self.getIpProxy.get_random_ip()
            else:
                tempProxyServer = self.proxyServer

            proxy_dict = {tempProxyServer[0]: tempProxyServer[1]}
            tempUrl = requests.get(url,
                                   headers=hds[random.randint(0,
                                                              len(hds) - 1)],
                                   proxies=proxy_dict)

            code = tempUrl.status_code
            if code >= 200 or code < 300:
                self.proxyServer = tempProxyServer
                return tempUrl
            else:
                self.proxyServer = self.getIpProxy.get_random_ip()
                return self.requestUrlForRe(url)
        except Exception as e:
            self.proxyServer = self.getIpProxy.get_random_ip()
            s = requests.session()
            s.keep_alive = False
            return self.requestUrlForRe(url)

    # 源数据生成,写入excle中,从infos字典中读取数据,放置到list列表中进行写入操作,其中可修改规定写入格式
    def wirte_source_data(self, row):
        for itemKey in self.infos.keys():
            print itemKey + ':' + str(self.infos.get(itemKey))

            item_valus = self.infos.get(itemKey)
            if itemKey == '详细区域':
                temps_item_valus = item_valus.split()
                print temps_item_valus[0], temps_item_valus[
                    1], temps_item_valus[2]
                self.generate_excle.writeExclePositon(
                    row, self.elementConstant.data_constant.get('所属下辖区'),
                    temps_item_valus[0])
                self.generate_excle.writeExclePositon(
                    row, self.elementConstant.data_constant.get('所属商圈'),
                    temps_item_valus[1])
                self.generate_excle.writeExclePositon(
                    row, self.elementConstant.data_constant.get('所属环线'),
                    temps_item_valus[2])
            else:

                tempItemKey = self.elementConstant.unit_check_name(
                    itemKey.encode('utf-8'))
                count = self.elementConstant.data_constant.get(tempItemKey)
                print tempItemKey, self.elementConstant.data_constant.get(
                    tempItemKey), item_valus
                if tempItemKey != None and count != None:
                    # todo 检查使用标准,修改使用逻辑
                    if tempItemKey == '链家编号':
                        item_valus = item_valus[0:len(item_valus) - 2]
                    elif tempItemKey == '单价(元/平米)':
                        item_valus = item_valus[0:len(item_valus) - 4]
                    elif tempItemKey == '建筑面积:平米':
                        item_valus = item_valus[0:len(item_valus) - 1]
                    elif tempItemKey == '建成时间:年':
                        item_valus = item_valus[0:item_valus.index('年')]
                    elif tempItemKey == '关注(人)' or tempItemKey == '看过房源:人':
                        item_valus = item_valus[0:len(item_valus) - 3]
                    elif tempItemKey == '挂牌时间':
                        item_valus = item_valus.replace('-', '/')
                    elif tempItemKey == '上次交易时间':
                        item_valus = item_valus.replace('-', '/')

                    self.generate_excle.writeExclePositon(
                        row,
                        self.elementConstant.data_constant.get(tempItemKey),
                        item_valus)