Subversion Repositories SmartDukaan

Rev

Rev 175 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 175 Rev 224
Line 13... Line 13...
13 
Get all the naaptol phones first.
 13 
Get all the naaptol phones first.
14 
Postprocess the phones and brake the phone name column into
14 
Postprocess the phones and brake the phone name column into
15 
brand and model name respectively
 15 
brand and model name respectively
16 
'''
 16 
'''
17 
 
 17 
 
18 
site = "www.naaptol.com"
 - 
 
19 
da = DataHelper()
 18 
da = DataHelper()
- 
 
 19 
da.initxy()
20 
 
 20 
 
- 
 
 21 
site = "www.naaptol.com"
21 
 
 22 
 
22 
onsp = da.get_allntonlinesp()
 23 
onsp = da.get_allntonlinesp()
23 
if not onsp:
 24 
if not onsp:
24 
    print "Error while getting onlinesuppliers"
 25 
    print "Error while getting onlinesuppliers"
25 
    sys.exit(-1)
 26 
    sys.exit(-1)
Line 40... Line 41...
40 
 
 41 
 
41 
if not phones:
 42 
if not phones:
42 
    print "Error while getting phones"
 43 
    print "Error while getting phones"
43 
    sys.exit(-1)
 44 
    sys.exit(-1)
44 
 
 45 
 
45 
file_to_write = "/tmp/filterednaaptol.csv"
 46 
file_to_write = "/home/gaurav/filterednaaptol.csv"
46 
 
 47 
 
47 
data_file = open(file_to_write,"w")
 48 
data_file = open(file_to_write,"w")
- 
 
 49 
csv_data =  "%s, %s, %s, %s, %s, %s, %s" %("brand", "model", "shown_price", "final_price", "extra_info", "supplier_name", "mode of selling")
- 
 
 50 
data_file.write(csv_data)
- 
 
 51 
data_file.write("\n")
48 
 
 52 
 
49 
 
 53 
 
50 
for phone in phones:
 54 
for phone in phones:
- 
 
 55 
    unparsed_name = phone.name
51 
    unparsed_name = getunformatted(phone.name)
 56 
    unparsed_name = getunformatted(unparsed_name)
52 
    vendor_name, phone_name,e_info = getbrandandmodel(unparsed_name)
 57 
    vendor_name, phone_name,e_info = getbrandandmodel(unparsed_name)
53 
    if vendor_name == "":
 58 
    if vendor_name == "":
54 
        vendor_name = "unknown"
 59 
        vendor_name = "unknown"
55 
    model_name,extra_info = getrefinedmodel(phone_name)
60 
    model_name,extra_info = getrefinedmodel(phone_name)
56 
    extra_info = e_info + extra_info
 61 
    extra_info = e_info + extra_info
57 
    if extra_info.endswith(','):
 62 
    if extra_info.endswith(','):
58 
        extra_info = extra_info[0:len(extra_info)-1]
 63 
        extra_info = extra_info[0:len(extra_info)-1]
59 
 
 64 
 
60 
    da.add_models(vendor_name, model_name)
65 
    da.add_models(vendor_name, model_name)
61 
    #print "unparsed_name : " + unparsed_name
 - 
 
62 
    #print "vendor_name : " + vendor_name
 - 
 
63 
    #print "phone_name : " + phone_name
 - 
 
64 
    #print unparsed_name
 - 
 
65
66
66 
    modId = da.get_modId(vendor_name,model_name)
 67 
    modId = da.get_modId(vendor_name,model_name)
67 
    sups = da.get_ntofflinespbynid(phone.id)
 68 
    sups = da.get_ntofflinespbynid(phone.id)
68 
    for sup in sups:
69 
    for sup in sups:
69 
        sup_name = sup.name
 70 
        sup_name = sup.name
70 
        final_price = quoted_price = sup.price
71 
        final_price = quoted_price = sup.price
- 
 
 72
71 
        supId = da.get_suppId(sup_name)
 73 
        supId = da.get_suppId(sup_name)
72 
        da.add_prices(modId, supId,quoted_price,final_price,extra_info)
 74 
        da.add_prices(modId, supId,quoted_price,final_price,extra_info)
- 
 
 75 
        csv_data =  "%s, %s, %d, %d, %s, %s, %s" %(vendor_name, model_name, quoted_price, final_price,extra_info,sup_name, "offline")
73 
        csv_data =  "%s, %s, %d, %d, %s" %(vendor_name, model_name, quoted_price, final_price,extra_info)
 76 
        print "%s, %s, %d, %d, %s %s" %(vendor_name, model_name, quoted_price, final_price,extra_info, sup_name)
74 
        data_file.write(csv_data)
 77 
        data_file.write(csv_data)
75 
        data_file.write("\n")
 78 
        data_file.write("\n")
76
79
77 
    sups = da.get_ntofflinespbynid(phone.id)
 80 
    sups = da.get_ntonlinespbynid(phone.id)
78 
    for sup in sups:
81 
    for sup in sups:
79 
        sup_name = sup.name
 82 
        sup_name = sup.name
80 
        final_price = quoted_price = sup.price
83 
        final_price = quoted_price = sup.price
81 
        supId = da.get_suppId(sup_name)
 84 
        supId = da.get_suppId(sup_name)
82 
        da.add_prices(modId, supId,quoted_price,final_price,extra_info)
 85 
        da.add_prices(modId, supId,quoted_price,final_price,extra_info)
- 
 
 86 
        csv_data =  "%s, %s, %d, %d, %s, %s, %s" %(vendor_name, model_name, quoted_price, final_price,extra_info,sup_name, "online")
83 
        csv_data =  "%s, %s, %d, %d, %s" %(vendor_name, model_name, quoted_price, final_price,extra_info)
 87 
        print "%s, %s, %d, %d, %s %s" %(vendor_name, model_name, quoted_price, final_price,extra_info, sup_name)
84 
        data_file.write(csv_data)
 88 
        data_file.write(csv_data)
85 
        data_file.write("\n")
 89 
        data_file.write("\n")
86 
 
 90 
 
87 
data_file.close()
 91 
data_file.close()
88 
 
 92