Subversion Repositories SmartDukaan

Rev

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

Rev 17736 Rev 17741
Line 128... Line 128...
128 
                        cashback_amount = subOrder.get("cashBackAmount")
 128 
                        cashback_amount = subOrder.get("cashBackAmount")
129 
                        city = result[10]
 129 
                        city = result[10]
130 
                        state = result[11]
 130 
                        state = result[11]
131 
                        pincode = result[12]
 131 
                        pincode = result[12]
132
132
133 
                        print user_id, user_name, product_title
 - 
 
134 
                        user_name = re.sub(r'[^\x00-\x7F]+',' ', user_name)
 133 
                        user_name = re.sub(r'[^\x00-\x7F]+',' ', user_name)
135 
                        product_title = re.sub(r'[^\x00-\x7F]+',' ', product_title)
 134 
                        product_title = re.sub(r'[^\x00-\x7F]+',' ', product_title)
- 
 
 135 
                        print user_id, user_name, product_title
136
136
137 
                        values = (str(user_id), str(user_name), str(order_id), str(created_on), str(store_id), str(merchant_order_id), str(status), str(detailed_status), str(product_title), str(referrer), str(amount_paid), str(catalog_id), str(brand), str(model),str(category), str(deal_rank), str(max_nlc), str(min_nlc), str(dp), str(item_status), str(city), str(state), str(pincode),str(merchant_suborder_id),str(cashback_status),str(cashback_amount), str(quantity), str(reconciled), str(affStatus))
 137 
                        values = (str(user_id), str(user_name), str(order_id), str(created_on), str(store_id), str(merchant_order_id), str(status), str(detailed_status), str(product_title), str(referrer), str(amount_paid), str(catalog_id), str(brand), str(model),str(category), str(deal_rank), str(max_nlc), str(min_nlc), str(dp), str(item_status), str(city), str(state), str(pincode),str(merchant_suborder_id),str(cashback_status),str(cashback_amount), str(quantity), str(reconciled), str(affStatus))
138 
                        cur.execute(query,values)
138 
                        cur.execute(query,values)
139 
                        con.commit()
 139 
                        con.commit()
140 
    except _mysql.Error, e:
 140 
    except _mysql.Error, e: