def createOwner(request): try: DB_STR = request.registry.settings['sqlalchemy.url'] dbCon = DBCon(DB_STR) request_params = request.params phone = request_params.get('phone') password = request_params.get('password') if not (password and phone): return { 'status': 'error', 'data': { 'msg': "empty phone/password not allowed" } } qry = "select * from restaurant_owners where phone = '%s'" % (phone) owner = dbCon.fetch_one(qry) if owner and str(owner['password']) == str(password): return {'status': 'success', 'data': {'owner_id': owner['id']}} elif owner: return {'status': 'error', 'data': {'msg': "wrong password"}} else: qry = "insert into restaurant_owners values (null, '%s', '%s')" % ( password, phone) owner_id = dbCon.insert(qry) return {'status': 'success', 'data': {'owner_id': owner['id']}} except: return {'status': 'error', 'data': {'msg': "server side error"}}
def create(request): try: DB_STR = request.registry.settings['sqlalchemy.url'] dbCon = DBCon(DB_STR) request_params = request.params text = request_params.get('text') start_time = request_params.get('start_time') end_time = request_params.get('end_time') date = request_params.get('date') reservations_allowed = request_params.get('count') restaurant_id = request_params.get('restaurant_id') deal_type = request_params.get('deal_type') deal_msg = request_params.get('deal_msg') qry = "insert into deals values (null, '%s', %s, %s, '%s','published', %s, %s ,'%s', '%s')" %(text, start_time, end_time, date, reservations_allowed, restaurant_id, deal_type, deal_msg) print qry deal_id = dbCon.insert(qry) return { 'status': 'success', 'data': { 'deal_id': deal_id } } except: import traceback traceback.print_exc() return { 'status': 'error', 'data': { 'msg': "server side error" } }
def create(request): try: DB_STR = request.registry.settings['sqlalchemy.url'] dbCon = DBCon(DB_STR) request_params = request.params name = request_params['name'] phone = request_params['phone'] token = request_params['token'] if not (phone and token): return { 'status': 'error', 'data': { 'msg': "empty phone/token not allowed" } } device_token = request_params.get('device_token') if not device_token: device_token = '' phone = phone.replace('-','').replace('+','') if len(phone) == 10: phone = '91' + phone qry = "select * from users where phone = '%s'" %(phone) user = dbCon.fetch_one(qry) if user: return { 'status': 'success', 'data': { 'user_id': user['id'] } } stripe.api_key = request.registry.settings['stripe.api_key'] customer_id, card_id = createStripeCustomer(token) if not (phone and token): return { 'status': 'error', 'data': { 'msg': "empty phone not allowed" } } qry = "insert into users values (null, '%s', '%s', '%s', '%s', '%s')" %(name, device_token, phone, card_id, customer_id) print qry user_id = dbCon.insert(qry) print user_id return { 'status': 'success', 'data': { 'user_id': user_id } } except: traceback.print_exc() return { 'status': 'error', 'data': { 'msg': "server side error" } }
def createDeal(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 = "insert into user_deals values (null, %s, %s, '%s')" % ( user_id, deal_id, 'claimed') user_deal_id = dbCon.insert(qry) return {'status': 'success', 'data': {'user_deal_id': user_deal_id}} except: return {'status': 'error', 'data': {'msg': "server side error"}}
def createOwner(request): try: DB_STR = request.registry.settings['sqlalchemy.url'] dbCon = DBCon(DB_STR) request_params = request.params phone = request_params.get('phone') password = request_params.get('password') if not (password and phone): return { 'status': 'error', 'data': { 'msg': "empty phone/password not allowed" } } qry = "select * from restaurant_owners where phone = '%s'" %(phone) owner = dbCon.fetch_one(qry) if owner and str(owner['password']) == str(password): return { 'status': 'success', 'data': { 'owner_id': owner['id'] } } elif owner: return { 'status': 'error', 'data': { 'msg': "wrong password" } } else: qry = "insert into restaurant_owners values (null, '%s', '%s')" %(password, phone) owner_id = dbCon.insert(qry) return { 'status': 'success', 'data': { 'owner_id': owner['id'] } } except: return { 'status': 'error', 'data': { 'msg': "server side error" } }
def create(request): try: DB_STR = request.registry.settings['sqlalchemy.url'] dbCon = DBCon(DB_STR) request_params = request.params name = request_params['name'] phone = request_params['phone'] token = request_params['token'] if not (phone and token): return { 'status': 'error', 'data': { 'msg': "empty phone/token not allowed" } } device_token = request_params.get('device_token') if not device_token: device_token = '' phone = phone.replace('-', '').replace('+', '') if len(phone) == 10: phone = '91' + phone qry = "select * from users where phone = '%s'" % (phone) user = dbCon.fetch_one(qry) if user: return {'status': 'success', 'data': {'user_id': user['id']}} stripe.api_key = request.registry.settings['stripe.api_key'] customer_id, card_id = createStripeCustomer(token) if not (phone and token): return { 'status': 'error', 'data': { 'msg': "empty phone not allowed" } } qry = "insert into users values (null, '%s', '%s', '%s', '%s', '%s')" % ( name, device_token, phone, card_id, customer_id) print qry user_id = dbCon.insert(qry) print user_id return {'status': 'success', 'data': {'user_id': user_id}} except: traceback.print_exc() return {'status': 'error', 'data': {'msg': "server side error"}}
def createDeal(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 = "insert into user_deals values (null, %s, %s, '%s')" %(user_id, deal_id, 'claimed') user_deal_id = dbCon.insert(qry) return { 'status': 'success', 'data': { 'user_deal_id': user_deal_id } } except: return { 'status': 'error', 'data': { 'msg': "server side error" } }
def create(request): try: DB_STR = request.registry.settings['sqlalchemy.url'] dbCon = DBCon(DB_STR) request_params = request.params text = request_params.get('text') start_time = request_params.get('start_time') end_time = request_params.get('end_time') date = request_params.get('date') reservations_allowed = request_params.get('count') restaurant_id = request_params.get('restaurant_id') deal_type = request_params.get('deal_type') deal_msg = request_params.get('deal_msg') qry = "insert into deals values (null, '%s', %s, %s, '%s','published', %s, %s ,'%s', '%s')" % ( text, start_time, end_time, date, reservations_allowed, restaurant_id, deal_type, deal_msg) print qry deal_id = dbCon.insert(qry) return {'status': 'success', 'data': {'deal_id': deal_id}} except: import traceback traceback.print_exc() return {'status': 'error', 'data': {'msg': "server side error"}}