def get_all(order_type=None):
if order_type == 'order':
orders = session.query(Order).filter('is_order=1').all()
elif order_type == 'reservation':
orders = session.query(Order).filter('is_order=0').all()
else:
orders = session.query(Order).all()
return orders
def get_all(order_type=None):
if order_type == 'order':
orders = session.query(Order).filter('is_order=1').all()
elif order_type == 'reservation':
orders = session.query(Order).filter('is_order=0').all()
else:
orders = session.query(Order).all()
return orders
def get_mul(users_id, active=None):
nodes = ['user.id=%s' % i for i in users_id]
q = ' or '.join(nodes)
q = '(%s)' % q
if active == None:
users = session.query(User).filter(q).all()
else:
users = session.query(User).filter(q).filter_by(is_active=active).all()
return users
def authenticate(username, password):
user = session.query(User).filter_by(username=username, password=password).first()
if user:
s = request.environ.get('beaker.session')
s['user'] = user.id
return user
return None
def authenticate(username, password):
user = session.query(User).filter_by(username=username,
password=password).first()
if user:
s = request.environ.get('beaker.session')
s['user'] = user.id
return user
return None
def register(**argv):
user = session.query(User).filter_by(username=argv["username"]).first()
if user:
return False, "username exist"
user = User(username=argv["username"], password=argv["password"])
session.add(user)
session.commit()
s = request.environ.get('beaker.session')
s['user'] = user.id
return True, "success"
def register(**argv):
user = session.query(User).filter_by(username=argv["username"]).first()
if user:
return False, "username exist"
user = User(username=argv["username"], password=argv["password"])
session.add(user)
session.commit()
s = request.environ.get('beaker.session')
s['user'] = user.id
return True, "success"
def get_mul(types_id):
nodes = ['dtype.id=%s' % i for i in types_id]
q = ' or '.join(nodes)
q = '(%s)' % q
dtype = session.query(DessertType).filter(q).all()
return dtype
def get_by_name(username):
user = session.query(User).filter_by(username=username).first()
return user
def get_mul(ids):
nodes = ['"decision".id=%s' % i for i in ids]
q = " or ".join(nodes)
q = "(%s)" % q
decision = session.query(Decision).filter(q).all()
return decision
def get(id):
decision = session.query(Decision).filter_by(id=id).first()
return decision
def get_mul(perms_id):
nodes = ['perm.id=%s' % i for i in perms_id]
q = ' or '.join(nodes)
q = '(%s)' % q
perms = session.query(Permission).filter(q).all()
return perms
def get_mul(ids):
nodes = ['"order".id=%s' % i for i in ids]
q = ' or '.join(nodes)
q = '(%s)' % q
orders = session.query(Order).filter(q).all()
return orders
def get_all():
order_items = session.query(OrderItem).all()
return order_items
def get(d_id):
dessert = session.query(Dessert).filter_by(id=d_id).first()
return dessert
def get_mul(types_id):
nodes = ['dtype.id=%s' % i for i in types_id]
q = ' or '.join(nodes)
q = '(%s)' % q
dtype = session.query(DessertType).filter(q).all()
return dtype
def get_all():
types = session.query(DessertType).all()
return types
def get(type_id):
type = session.query(DessertType).filter_by(id=type_id).first()
return type
def get_mul(ids):
nodes = ['dessert.id=%s' % i for i in ids]
q = ' or '.join(nodes)
q = '(%s)' % q
desserts = session.query(Dessert).filter(q).all()
return desserts
def get_all():
desserts = session.query(Dessert).all()
return desserts
def get(o_id):
order = session.query(Order).filter_by(id=o_id).first()
return order
def get_mul(ids):
nodes = ['"order".id=%s' % i for i in ids]
q = ' or '.join(nodes)
q = '(%s)' % q
orders = session.query(Order).filter(q).all()
return orders
def get(id):
decision = session.query(Decision).filter_by(id=id).first()
return decision
def get(o_id):
order = session.query(Order).filter_by(id=o_id).first()
return order
def get_all():
decisions = session.query(Order).all()
return decisions
def get_mul(roles_id):
nodes = ['role.id=%s' % i for i in roles_id]
q = ' or '.join(nodes)
q = '(%s)' % q
roles = session.query(Role).filter(q).all()
return roles
def get_mul(ids):
nodes = ['"decision".id=%s' % i for i in ids]
q = ' or '.join(nodes)
q = '(%s)' % q
decision = session.query(Decision).filter(q).all()
return decision
def count(ft=None):
if not ft:
return session.query(Permission).count()
else:
return session.query(Permission).filter(ft).count()
def get(role_id):
role = session.query(Role).filter_by(id=role_id).first()
return role
def get_all():
decisions = session.query(Order).all()
return decisions
def get(type_id):
usertype = session.query(UserType).filter_by(id=type_id).first()
return usertype
def get(user_id):
user = session.query(User).filter_by(id=user_id).first()
return user
def get_all():
types = session.query(UserType).all()
return types
def get_all(active=None):
if active == None:
users = session.query(User).all()
else:
users = session.query(User).filter_by(is_active=active).all()
return users
def get_mul(types_id):
nodes = ['usertype.id=%s' % i for i in types_id]
q = ' or '.join(nodes)
q = '(%s)' % q
types = session.query(UserType).filter(q).all()
return types
def get_all():
order_items = session.query(OrderItem).all()
return order_items
def count(ft=None):
if not ft:
return session.query(UserType).count()
else:
return session.query(UserType).filter(ft).count()
def get_all():
types = session.query(DessertType).all()
return types
def get_all():
perms = session.query(Permission).all()
return perms
def count(ft=None):
if not ft:
return session.query(Order).count()
else:
return session.query(Order).filter(ft).count()
def get(role_id):
role = session.query(Role).filter_by(id=role_id).first()
return role
def count(ft=None):
if not ft:
return session.query(OrderItem).count()
else:
return session.query(OrderItem).filter(ft).count()
def get_mul(roles_id):
nodes = ['role.id=%s' % i for i in roles_id]
q = ' or '.join(nodes)
q = '(%s)' % q
roles = session.query(Role).filter(q).all()
return roles
def get(type_id):
type = session.query(DessertType).filter_by(id=type_id).first()
return type
def get_mul(ids):
nodes = ['dessert.id=%s' % i for i in ids]
q = ' or '.join(nodes)
q = '(%s)' % q
desserts = session.query(Dessert).filter(q).all()
return desserts
def get(perm_id):
perm = session.query(Permission).filter_by(id=perm_id).first()
return perm
def get_all():
roles = session.query(Role).all()
return roles
def get_mul(perms_id):
nodes = ['perm.id=%s' % i for i in perms_id]
q = ' or '.join(nodes)
q = '(%s)' % q
perms = session.query(Permission).filter(q).all()
return perms
def get(perm_id):
perm = session.query(Permission).filter_by(id=perm_id).first()
return perm
def get_all(): roles = session.query(Role).all() return roles
def get_all():
perms = session.query(Permission).all()
return perms
def count(ft=None):
if not ft:
return session.query(Role).count()
else:
return session.query(Role).filter(ft).count()
def get_all():
desserts = session.query(Dessert).all()
return desserts
