Subversion Repositories SmartDukaan

Rev

Rev 224 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 224 Rev 254
Line 6... Line 6...
6 
 
 6 
 
7 
from datastore.DataAccessor import DataHelper
 7 
from datastore.DataAccessor import DataHelper
8 
import sys
 8 
import sys
9 
from StdFormatConv.SplitBrandandModel import *
 9 
from StdFormatConv.SplitBrandandModel import *
10 
from StdFormatConv.RefineModel import *
 10 
from StdFormatConv.RefineModel import *
- 
 
 11 
import os
11 
 
 12 
 
12 
'''
 13 
'''
13 
Get all the themobilestore phones first.
 14 
Get all the themobilestore phones first.
14 
Postprocess the phones and brake the phone name column into
15 
Postprocess the phones and brake the phone name column into
15 
brand and model name respectively
 16 
brand and model name respectively
16 
'''
 17 
'''
17 
da = DataHelper()
 18 
da = DataHelper()
18 
da.initxy()
 19 
da.initxy()
19 
 
 20 
ds = os.sep
20 
sup_name = "mobilestore"
 21 
sup_name = "mobilestore"
21 
phones = DataHelper()
 22 
phones = DataHelper()
22 
 
 23 
 
23 
phones = phones.get_allmobstorephones_new()
 24 
phones = phones.get_allmobstorephones_new()
24 
 
 25 
 
25 
if not phones:
 26 
if not phones:
26 
    print "Error while getting phones"
 27 
    print "Error while getting phones"
27 
    sys.exit(-1)
 28 
    sys.exit(-1)
28 
 
 29 
 
29 
file_to_write = "/home/gaurav/themobstore_new.csv"
 30 
file_to_write = ds+"tmp"+ds+"themobstore_new.csv"
30 
 
 31 
 
31 
data_file = open(file_to_write,"w")
 32 
data_file = open(file_to_write,"w")
32 
csv_data =  "%s, %s, %s, %s, %s" %("brand", "model", "shown_price", "final_price", "extra_info")
 33 
csv_data =  "%s, %s, %s, %s, %s" %("brand", "model", "shown_price", "final_price", "extra_info")
33 
data_file.write(csv_data)
 34 
data_file.write(csv_data)
34 
data_file.write("\n")
 35 
data_file.write("\n")
35 
 
 36 
 
36 
da.initxy()
 37 
da.initxy()
37 
for phone in phones:
 38 
for phone in phones:
38 
    #phone = infibeam_data()
 - 
 
39 
    unparsed_name = getunformatted(phone.name)
 39 
    unparsed_name = getunformatted(phone.name)
40
- 
 
41 
    vendor_name, phone_name,e_info = getbrandandmodel(unparsed_name)
 40 
    vendor_name, phone_name,e_info = getbrandandmodel(unparsed_name)
42 
    if vendor_name == "":
 41 
    if vendor_name == "":
43 
        vendor_name = "unknown"
 42 
        vendor_name = "unknown"
44 
    model_name,extra_info = getrefinedmodel(phone_name)
43 
    model_name,extra_info = getrefinedmodel(phone_name)
45 
    extra_info = e_info + extra_info
 44 
    extra_info = e_info + extra_info
46 
    if extra_info.endswith(','):
 45 
    if extra_info.endswith(','):
47 
        extra_info = extra_info[0:len(extra_info)-1]
 46 
        extra_info = extra_info[0:len(extra_info)-1]
48 
 
 47 
 
49 
    da.add_models(vendor_name, model_name)
48 
    da.add_models(vendor_name, model_name)
50 
    #print "unparsed_name : " + unparsed_name
 - 
 
51 
    #print "vendor_name : " + vendor_name
 - 
 
52 
    #print "phone_name : " + phone_name
 - 
 
53 
    #print unparsed_name
 - 
 
54 
    extra_info = phone.extra_info + extra_info
 49 
    extra_info = phone.extra_info + extra_info
55 
    csv_data =  "%s, %s, %d, %d, %s" %(vendor_name, model_name, phone.shown_price, phone.final_price,extra_info)
 50 
    csv_data =  "%s, %s, %d, %d, %s" %(vendor_name, model_name, phone.shown_price, phone.final_price,extra_info)
56 
    modId = da.get_modId(vendor_name,model_name)
 51 
    modId = da.get_modId(vendor_name,model_name)
57 
    supId = da.get_suppId(sup_name)
 52 
    supId = da.get_suppId(sup_name)
58 
    da.add_prices(modId, supId, phone.shown_price, phone.final_price,extra_info)
 53 
    da.add_prices(modId, supId, phone.shown_price, phone.final_price,extra_info)