def charge(request): try: DB_STR = request.registry.settings['sqlalchemy.url'] dbCon = DBCon(DB_STR) request_params = request.params amount = int(float(request_params.get('amount'))*100) user_id = request_params.get('user_id') deal_id = request_params.get('deal_id') qry = "select * from users u join user_deals ud on u.id = ud.user_id where ud.status = 'claimed' and u.id = %s and ud.deal_id = %s" %(user_id, deal_id) user = dbCon.fetch_one(qry) stripe.api_key = request.registry.settings['stripe.api_key'] charge_id = chargeStripeCustomer(user['customer_id'], user['card_id'], amount) qry = "update user_deals set status = 'close' where user_id = %s and deal_id = %s" %(user_id, deal_id) dbCon.update(qry) return { 'status': 'success', 'data': { 'charge_id': charge_id } } except: traceback.print_exc() return { 'status': 'error', 'data': { 'msg': "server side error" } }
def unclaim(request): try: DB_STR = request.registry.settings['sqlalchemy.url'] dbCon = DBCon(DB_STR) request_params = request.params deal_id = request_params.get('deal_id') user_id = request_params.get('user_id') qry = "update user_deals set status = 'close' where user_id = %s and deal_id = '%s" %(user_id, deal_id) user_deal = dbCon.update(qry) return { 'status': 'success', 'data': { 'user_deal_id': user_deal['id'] } } except: traceback.print_exc() return { 'status': 'error', 'data': { 'msg': "server side error" } } #unclaim a coupon #dispute #expire deal
def charge(request): try: DB_STR = request.registry.settings['sqlalchemy.url'] dbCon = DBCon(DB_STR) request_params = request.params amount = int(float(request_params.get('amount')) * 100) user_id = request_params.get('user_id') deal_id = request_params.get('deal_id') qry = "select * from users u join user_deals ud on u.id = ud.user_id where ud.status = 'claimed' and u.id = %s and ud.deal_id = %s" % ( user_id, deal_id) user = dbCon.fetch_one(qry) stripe.api_key = request.registry.settings['stripe.api_key'] charge_id = chargeStripeCustomer(user['customer_id'], user['card_id'], amount) qry = "update user_deals set status = 'close' where user_id = %s and deal_id = %s" % ( user_id, deal_id) dbCon.update(qry) return {'status': 'success', 'data': {'charge_id': charge_id}} except: traceback.print_exc() return {'status': 'error', 'data': {'msg': "server side error"}}
def unclaim(request): try: DB_STR = request.registry.settings['sqlalchemy.url'] dbCon = DBCon(DB_STR) request_params = request.params deal_id = request_params.get('deal_id') user_id = request_params.get('user_id') qry = "update user_deals set status = 'close' where user_id = %s and deal_id = '%s" % ( user_id, deal_id) user_deal = dbCon.update(qry) return {'status': 'success', 'data': {'user_deal_id': user_deal['id']}} except: traceback.print_exc() return {'status': 'error', 'data': {'msg': "server side error"}} #unclaim a coupon #dispute #expire deal