def createUser(login_session):
newUser = User(name=login_session['username'],
email=login_session['email'],
picture=login_session['picture'])
session.add(newUser)
session.commit()
user = session.query(User).filter_by(email=login_session['email']).one()
return user.id
def shopItemJSON(shop_id):
items = session.query(Item).filter_by(shop_id=shop_id).all()
return jsonify(Items=[i.serialize for i in items])
def categoryJSON():
items = session.query(Category).all()
return jsonify(Category=[r.serialize for r in items])
def itemJSON():
items = session.query(Item).all()
return jsonify(Items=[r.serialize for r in items])
def shopsJSON():
shops = session.query(Shop).all()
return jsonify(shops=[r.serialize for r in shops])
def getUserID(email):
try:
user = session.query(User).filter_by(email=email).one()
return user.id
except:
return None
def getUserInfo(user_id):
user = session.query(User).filter_by(id=user_id).one()
return user