Subversion Repositories SmartDukaan

Rev

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

Rev 17558 Rev 17736
Line 12... Line 12...
12 
from pymongo import MongoClient
 12 
from pymongo import MongoClient
13 
import MySQLdb as mdb
 13 
import MySQLdb as mdb
14 
import _mysql
 14 
import _mysql
15 
import smtplib
 15 
import smtplib
16 
import sys
 16 
import sys
- 
 
 17 
import re
17 
 
 18 
 
18 
 
 19 
 
19 
 
 20 
 
20 
# DataService.initialize()
 21 
# DataService.initialize()
21 
# client = MongoClient('mongodb://localhost:27017/')
 22 
# client = MongoClient('mongodb://localhost:27017/')
Line 127... Line 128...
127 
                        cashback_amount = subOrder.get("cashBackAmount")
 128 
                        cashback_amount = subOrder.get("cashBackAmount")
128 
                        city = result[10]
 129 
                        city = result[10]
129 
                        state = result[11]
 130 
                        state = result[11]
130 
                        pincode = result[12]
 131 
                        pincode = result[12]
131
132
- 
 
 133 
                        print user_id, user_name, product_title
- 
 
 134 
                        user_name = re.sub(r'[^\x00-\x7F]+',' ', user_name)
- 
 
 135 
                        product_title = re.sub(r'[^\x00-\x7F]+',' ', product_title)
132 
                        print user_id
 136
133 
                        values = (user_id, user_name, order_id, created_on, store_id, merchant_order_id, status, detailed_status, product_title, referrer, amount_paid, catalog_id, brand, model,category, deal_rank, max_nlc, min_nlc, dp, item_status, city, state, pincode,merchant_suborder_id,cashback_status,cashback_amount, quantity, reconciled, 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))
134 
                        cur.execute(query,values)
138 
                        cur.execute(query,values)
135 
                        con.commit()
 139 
                        con.commit()
136 
    except _mysql.Error, e:
 140 
    except _mysql.Error, e:
137 
        print "Error %d: %s" % (e.args[0], e.args[1])
 141 
        print "Error %d: %s" % (e.args[0], e.args[1])
138 
        sys.exit(1)
 142 
        sys.exit(1)