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
