Subversion Repositories SmartDukaan

'''

Created on 25-May-2010

@author: gaurav

'''

from datastore.DataAccessor import DataHelper

from StdFormatConv.SplitBrandandModel import *

from StdFormatConv.RefineModel import *

import sys

import os

phones = DataHelper()

phones = phones.get_all_indiaplaza_phones()

sup_name = "indiaplaza"

if not phones:

    print "Error while getting phones"

    sys.exit(-1)

ds = os.sep

file_to_write = ds+"tmp"+ds+"gsinfo.csv"

data_file = open(file_to_write,"w")

csv_data =  "%s, %s, %s, %s, %s, %s, %s" %("brand", "model", "shown_price", "final_price","guaranteeinfo","shipinfo","extra_info")

data_file.write(csv_data)

data_file.write("\n")

da = DataHelper()

for phone in phones:

    #phone = infibeam_data()

    unparsed_name = getunformatted(phone.p_name)

    vendor_name, phone_name,e_info = getbrandandmodel(unparsed_name)

    if vendor_name == "":

        vendor_name = "unknown"

    model_name,extra_info = getrefinedmodel(phone_name)

    extra_info = e_info + extra_info

    if extra_info.endswith(','):

        extra_info = extra_info[0:len(extra_info)-1]

    da.add_models(vendor_name, model_name)

    csv_data =  "%s, %s, %d, %d, %s, %s, %s" %(vendor_name, model_name, phone.p_shown_price, phone.p_final_price, phone.p_guaranteeinfo, phone.p_shipinfo,extra_info)

    modId = da.get_modId(vendor_name,model_name)

    supId = da.get_suppId(sup_name)

    da.add_prices(modId, supId, phone.p_shown_price, phone.p_final_price,extra_info)

    data_file.write(csv_data)

    data_file.write("\n")

data_file.close()