Subversion Repositories SmartDukaan

#!/usr/bin/python
import optparse
import xlrd
import datetime

if __name__ == '__main__' and __package__ is None:
    import sys
    import os
    sys.path.insert(0, os.getcwd())

from shop2020.thriftpy.model.v1.catalog.ttypes import status
from shop2020.model.v1.catalog.impl import DataService
from shop2020.model.v1.catalog.impl.DataService import CheckItem
from elixir import *

def load_item_data(filename):
    DataService.initialize()

    workbook = xlrd.open_workbook(filename)
    sheet = workbook.sheet_by_index(0)
    num_rows = sheet.nrows
    updatedOn = datetime.datetime.now()
    for rownum in range(1, num_rows):
        print sheet.row_values(rownum)
        #hotspot_category, brand, model_number, color, model_name, mrp, mop, dp, xfer_price, weight, start_date, deal_text, deal_value, comments, catalog_item_id, category_id = sheet.row_values(rownum)[0:17]
        #brand, model_number, model_name, color, dp, mrp, unused_fbp, comments, hotspot_category, unused_feature, xfer_price, weight, start_date, deal_text, deal_value, catalog_item_id, category_id = sheet.row_values(rownum)[0:17]
        product_group, brand, model_number, item_number, color, xfer_price, mop, mrp = sheet.row_values(rownum)[0:9]
        if isinstance(model_number, float):
            model_number = str(int(model_number))

        item = CheckItem()
        item.product_group = product_group
        item.brand = brand
        item.model_number = model_number
        item.color = color
        item.item_number = item_number
        item.mop = mop
        item.mrp = mrp
        item.transfer_price = xfer_price
        session.add(item)
            

    session.commit()
    
    print "Successfully updated the item list information."

def main():
    parser = optparse.OptionParser()
    parser.add_option("-f", "--file", dest="filename",
                   default="ItemList.xls", type="string",
                   help="Read the item list from FILE",
                   metavar="FILE")
    (options, args) = parser.parse_args()
    if len(args) != 0:
        parser.error("You've supplied extra arguments. Are you sure you want to run this program?")
    filename = options.filename
    load_item_data(filename)

if __name__ == '__main__':
    main()