Subversion Repositories SmartDukaan

Rev

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

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