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"}}
