Subversion Repositories SmartDukaan

Rev

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

Rev 12357 Rev 12392
Line 47... Line 47...
47 
            except:
 47 
            except:
48 
                # Rollback in case there is any error
 48 
                # Rollback in case there is any error
49 
                db.rollback()
 49 
                db.rollback()
50 
            print rec
 50 
            print rec
51 
        except Exception as e:
 51 
        except Exception as e:
52 
            item = Item.get_by(id==rec[0])
 52 
            item = Item.get_by(id =rec[0])
53 
            if item is not None and item.category == 0:
 53 
            if item is not None and item.category == 0:
54 
                exceptionList.append(e + "For ItemId :" + rec[0] + " StateId :" + rec[7]+ " Category:"+ item.category)
 54 
                exceptionList.append(str(e) + "For ItemId :" + str(rec[0]) + " StateId :" + str(rec[7])+ " Category:"+ str(item.category))
55 
            else:
55 
            else:
56 
                exceptionList.append(e + "For ItemId :" + rec[0] + " StateId :" + rec[7])
 56 
                exceptionList.append(str(e) + "For ItemId :" + str(rec[0]) + " StateId :" + str(rec[7]))
57 
            continue
 57 
            continue
58 
        '''
 58 
        '''
59 
        sql_update ="update lineitem set nlcP = nlc, vatDiff = 0.0 where itemId = %d and purchaseOrder_id = %d"%(rec[0],rec[3])
 59 
        sql_update ="update lineitem set nlcP = nlc, vatDiff = 0.0 where itemId = %d and purchaseOrder_id = %d"%(rec[0],rec[3])
60 
        print sql_update
 60 
        print sql_update
61 
        try:
 61 
        try: