Subversion Repositories SmartDukaan

'''
Created on 28-May-2010

@author: gaurav
'''

from scrapy.spider import BaseSpider
from scrapy.selector import HtmlXPathSelector
from scrapy.http import Request

from demo.items import DemoItem
from scrapy.contrib.spidermiddleware import referer
from scrapy.http.headers import Headers
from scrapy.http.request.form import FormRequest
from scrapy.log import msg
from scrapy.http.response import Response
from time import *
from datastore.DataCodeAccessor import *
from datastore.DataAccessor import *

import urllib
from html2text.unescaping import *

class naaptol_price2(BaseSpider):
    
    def __init__(self):
       
       initialize_table()
       #NAAPTOL_DOMAINNAME2 = "naaptol2"   
       NAAPTOL_DOMAINNAME2 = get_code_word("NAAPTOL_DOMAINNAME2")
       self.domain_name = NAAPTOL_DOMAINNAME2 
       
       # get urls from the database and append them in the list for crawling
       da = DataHelper()
       for pitem in da.get_allmorenaaptolurls():
            self.start_urls.append(pitem.url.strip())
    
    def start_requests(self):
        #for each request a referer has to be set
        listreq = []
        #NAAPTOL_REFERER = "http://www.google.com"
        NAAPTOL_REFERER = get_code_word("NAAPTOL_REFERER")
        for url1 in self.start_urls:
            request = Request(url = str(url1), callback=self.parse)
            request.headers.setdefault("Referer", NAAPTOL_REFERER)
            listreq.append(request)
        return listreq
    
       
    def parse(self, response): 
        da = DataHelper()
        #NAAPTOL_REMOVELIST = ["Rs.",","]
        #list separated by ';'
        NAAPTOL_REMOVELIST = get_code_word("NAAPTOL_REMOVELIST")
        NAAPTOL_REMOVELIST = NAAPTOL_REMOVELIST.split(';')
        #retreiving name from the the url
        name = str(response.url)
        name = unescape(name)
        name_pos = name.rfind("/")
        name = name[name_pos+1:len(name)-5]
        name_pos = name.find("-")
        name = name[name_pos+1:len(name)]
            
        hxs = HtmlXPathSelector(response)
       
        #price and price2 determine range
        #NAAPTOL_XPATH2 = '//table[@class ="ProductDetails"]//td[@class="Price"]/span/text()'
        NAAPTOL_XPATH2 = get_code_word("NAAPTOL_XPATH2")
        prices = hxs.select(NAAPTOL_XPATH2)
        try:
            price1 = prices.extract()[0]
            #price1 = price1.decode("utf-8")
            price1 = price1.strip()
        except:
            price1 = ""
        
        try:
            price2 = prices.extract()[1]
            #price2 = price2.decode("utf-8")
            price2 = price2.strip()
        except:
            price2 = ""
        
        try:
            if price1 == "" and price2 == "":
                #NAAPTOL_XPATH3 = '//table[@class ="ProductDetails"]//td[@class="Price"]/span/script/text()'
                NAAPTOL_XPATH3 = get_code_word("NAAPTOL_XPATH3")
                prices = hxs.select(NAAPTOL_XPATH3)
                price = str(prices.extract()[0])
                pos1 = price.find("'")
                pos2 = price.find("'",pos1+1,len(price))
                price1 = price[pos1+1:pos2] + "(approx)" 
                price2 = ""
        except:
            price1 = price2 = ""
        #removelist is used for converting price to decimal format containing only numbers and '.'    
            
        if price1 != '':
            for r in NAAPTOL_REMOVELIST: 
                while price1.find(r) != -1:
                    price1 = price1.replace(r, "")
            price1 = price1.strip()
        if price2 != '':        
            for r in NAAPTOL_REMOVELIST: 
                while price2.find(r) != -1:
                    price2 = price2.replace(r, "")
            price2 = price2.strip()
        
        if price1 == "Rates Not Available":
            price1 = price2 = ""
        
        #range = price1 to price2
        range = price1
        if price2 != "":
            range = str(range) + " to " 
            range = range + str(price2) 
        da.add_new_naaptolphone(name, range)
        
        
        OnlineSellers_pricelist = []
        OnlineSellers_namelist = []
        try:
            #ct1 holds the count of online sellers
            #NAAPTOL_XPATH4 = '//div[@id="OnlineSellers"]//div[@class="ProductResultHead"]//div[@class="headingstyle"]/text()'
            NAAPTOL_XPATH4 = get_code_word("NAAPTOL_XPATH4")
            ct1 = hxs.select(NAAPTOL_XPATH4)
            ct1 = str(ct1.extract()[0])
            ct1 = ct1.decode("utf-8")
            ct1 = ct1.strip()
            ps1 = ct1.find(" ")
            ct1 = ct1[0:ps1]
            ct1 = int(ct1)
        except:
            ct1 = 0
        ct = ct1
        i = 0
        #NAAPTOL_XPATH5 = '//div[@id="onSellerContents"]//td[@class="price"]'
        NAAPTOL_XPATH5 = get_code_word("NAAPTOL_XPATH5")
        os_info = hxs.select(NAAPTOL_XPATH5)
        while ct > 0:
            os = os_info[i].extract()
            ps1 = os.find(">")
            ps2 = os.find("<",ps1)
            os = os[ps1+1:ps2]
            
            if os != '':        
                for r in NAAPTOL_REMOVELIST: 
                    while os.find(r) != -1:
                        os = os.replace(r, "")
            os = urllib.unquote(os)
            try:
                os = int(os)
            except:
                #stored in format different than previous one
                os = os_info[i].extract()
                ps1 = os.find(">",ps2)
                ps2 = os.find("<",ps1)
                os = os[ps1+1:ps2]
                if os != '':        
                    for r in NAAPTOL_REMOVELIST: 
                        while os.find(r) != -1:
                            os = os.replace(r, "")
                os = urllib.unquote(os)
                os = int(os) 
            
            OnlineSellers_pricelist.append(os)
            
            #NAAPTOL_XPATH6 = '//div[@id="onSellerContents"]//tr[@class="DottedBorder"]/td/a[@id="storeInfoPop'  
            NAAPTOL_XPATH6 = get_code_word("NAAPTOL_XPATH6")
            #NAAPTOL_XPATH7 = '"]/span/text()'
            NAAPTOL_XPATH7 = get_code_word("NAAPTOL_XPATH7")
            NAAPTOL_XPATH6 = NAAPTOL_XPATH6 + str(i) 
            NAAPTOL_XPATH6 = NAAPTOL_XPATH6 + NAAPTOL_XPATH7 
            path = NAAPTOL_XPATH6
            osname = hxs.select(path)
            osname = osname.extract()[0]
            osname = unescape(osname)
            osname = urllib.unquote(osname)
            OnlineSellers_namelist.append(osname)
            i = i+1
            ct = ct-1
            
        l = len(OnlineSellers_pricelist)
        i = 0 
        nid = da.get_naaptolphone(name,range).id
        while l > 0:
            da.add_new_ntonlinesp(nid, OnlineSellers_namelist[i], OnlineSellers_pricelist[i])
            i = i+1
            l = l-1
        
        LocalSellers_pricelist = []   
        LocalSellers_namelist = []
        try:
            #ct1 holds the count of online sellers
            #NAAPTOL_XPATH8 = '//div[@id="LocalStores"]//div[@class="ProductResultHead"]//div[@class="headingstyle"]/text()'
            NAAPTOL_XPATH8 = get_code_word("NAAPTOL_XPATH8")
            ct1 = hxs.select(NAAPTOL_XPATH8)
            ct1 = str(ct1.extract()[0])
            ct1 = ct1.decode("utf-8")
            ct1 = ct1.strip()
            ps1 = ct1.find(" ")
            ct1 = ct1[0:ps1]
            ct1 = int(ct1)
        except:
            ct1 = 0
        ct = ct1
        i = 0
        #NAAPTOL_XPATH9 = '//div[@id="offSellerContents"]//td[@class="price"]'
        NAAPTOL_XPATH9 = get_code_word("NAAPTOL_XPATH9")
        #NAAPTOL_XPATH10 = '//div[@id="offSellerContents"]//span[@class="LocalStoreHeading"]/text()'
        NAAPTOL_XPATH10 = get_code_word("NAAPTOL_XPATH10")
        os_info = hxs.select(NAAPTOL_XPATH9)
        os_names = hxs.select(NAAPTOL_XPATH10)
        
        while ct > 0:
            os = os_info[i].extract()
            osname = os_names[i].extract() 
            ps1 = os.find(">")
            ps2 = os.find("<",ps1)
            os = os[ps1+1:ps2]
            if os != '':        
                for r in NAAPTOL_REMOVELIST: 
                    while os.find(r) != -1:
                        os = os.replace(r, "")
            os = urllib.unquote(os)
            osname = urllib.unquote(osname)
            osname = unescape(osname)
            try:
                os = int(os)
            except:
                #stored in format different than previous one
                os = os_info[i].extract()
                ps1 = os.find(">",ps2)
                ps2 = os.find("<",ps1)
                os = os[ps1+1:ps2]
                if os != '':        
                    for r in NAAPTOL_REMOVELIST: 
                        while os.find(r) != -1:
                            os = os.replace(r, "")
                os = urllib.unquote(os)
                os = int(os)        
            LocalSellers_pricelist.append(os)
            LocalSellers_namelist.append(osname)
            i = i+1
            ct = ct-1
            
        l = len(LocalSellers_pricelist)
        i = 0
        nid = da.get_naaptolphone(name,range).id
        while l > 0:
            da.add_new_ntofflinesp(nid, LocalSellers_namelist[i], LocalSellers_pricelist[i])
            i = i+1
            l = l-1

SPIDER = naaptol_price2()