Subversion Repositories SmartDukaan

Rev

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

Rev 12654 Rev 13040
Line 43... Line 43...
43 
            categoryMap[tcategory.label] = tcategory.id
 43 
            categoryMap[tcategory.label] = tcategory.id
44 
    prodClient = CatalogClient("catalog_service_server_host_prod").get_client()
 44 
    prodClient = CatalogClient("catalog_service_server_host_prod").get_client()
45 
    iclient = InventoryClient().get_client()
 45 
    iclient = InventoryClient().get_client()
46
46
47 
    for rownum in range(1, num_rows):
 47 
    for rownum in range(1, num_rows):
48 
        print sheet.row_values(rownum)
 48 
        #print sheet.row_values(rownum)
49 
        message = ""
 49 
        message = ""
50 
        try:
 50 
        try:
51 
            product_group, category_name, brand, model_number, model_name, color, mrp, sp, mop, dp, tp, nlc, start_date, preferred_vendor, risky, weight, item_type = sheet.row_values(rownum)[0:17]
 51 
            product_group, category_name, brand, model_number, model_name, color, mrp, sp, mop, dp, tp, nlc, start_date, preferred_vendor, risky, weight, item_type = sheet.row_values(rownum)[0:17]
52
52 
            print "preferred_vendor", preferred_vendor
53 
            if isinstance(model_number, float):
 53 
            if isinstance(model_number, float):
54 
                model_number = str(int(model_number))
 54 
                model_number = str(int(model_number))
55
55
56
56
57 
            item = Item()
 57 
            item = Item()
Line 73... Line 73...
73 
            item.updatedOn = updatedOn
 73 
            item.updatedOn = updatedOn
74 
            item.type = int(item_type)
 74 
            item.type = int(item_type)
75 
            for c in (1,2,3,4,5):
 75 
            for c in (1,2,3,4,5):
76 
                try:
 76 
                try:
77 
                    item_id = cclient.addItem(item)
 77 
                    item_id = cclient.addItem(item)
- 
 
 78 
                    print "item added\t{0}".format(item.id)
78 
                    item.id = item_id
 79 
                    item.id = item_id
79 
                    for c1 in (5,5,5,5,5):
 80 
                    for c1 in (5,5,5,5,5):
80 
                        try:
 81 
                        try:
81 
                            prodClient.addItem(item)
 82 
                            prodClient.addItem(item)
82 
                            break
 83 
                            break
Line 102... Line 103...
102
103
103 
        except Exception as e:
 104 
        except Exception as e:
104 
            message = message + "\t" + str(brand) + "\t" + str(model_name) + "\t" + str(model_number) + "\t" + str(e.message) + "\n"
 105 
            message = message + "\t" + str(brand) + "\t" + str(model_name) + "\t" + str(model_number) + "\t" + str(e.message) + "\n"
105 
    print message
 106 
    print message
106 
    mail("build@shop2020.in", "cafe@nes", ["amit.gupta@shop2020.in", "chandan.kumar@shop2020.in"], "Problem while adding items", message, [], [], [])
107 
    mail("build@shop2020.in", "cafe@nes", ["amit.gupta@shop2020.in", "chandan.kumar@shop2020.in"], "Problem while adding items", message, [], [], [])
107 
    print "Successfully updated the item list information."
 - 
 
108 
 
 108 
 
109 
 
 109 
 
110 
def main():
 110 
def main():
111 
    parser = optparse.OptionParser()
 111 
    parser = optparse.OptionParser()
112 
    parser.add_option("-f", "--file", dest="filename",
 112 
    parser.add_option("-f", "--file", dest="filename",