def edit_shop():
body = json.loads(request.data)
key = body.get('_key', None)
if key is None:
return jsonify({'error': 'key cannot be null'})
shop = db.query(Shops).by_key(key)
# TODO this but programmatically if things change
name = body.get('name', None)
if name is not None:
shop.name = name
slogan = body.get('slogan', None)
if slogan is not None:
shop.slogan = slogan
description = body.get('description', None)
if description is not None:
shop.description = description
logoLocation = body.get('logoLocation', None)
if logoLocation is not None:
shop.logoLocation = logoLocation
geolocation = body.get('geolocation', None)
if geolocation is not None:
shop.geolocation = geolocation
foundingDate = body.get('foundingDate', None)
if foundingDate is not None:
shop.foundingDate = foundingDate
db.update(shop)
return jsonify({'result': shop._dump()})
def edit_task():
body = json.loads(request.data)
task_key = body.get('_key', None)
task = db.query(Tasks).by_key(task_key)
if task is None:
return jsonify({'message':'task not found'})
name = body.get('name',None)
description = body.get('description', None)
task.name = name
task.description = description
db.update(task)
category_key = body.get('category_key', None)
category = db.query(Categories).by_key(category_key)
if category is not None:
# find old category relation and delete it
old_category_relation = db.query(Category_Relation).filter('_to==@_to',_to=task._id).first()
db.delete(old_category_relation)
# add new category relation
db.add(task_graph.relation(relation_from=category, relation=Category_Relation(), relation_to=task))
assignee_key = body.get('assignee_key', None)
assignee = db.query(People).by_key(assignee_key)
if assignee is not None:
# find old assignee relation and delete it
old_assignee_relation = db.query(Assignee_Relation).filter('_from==@_from',_from=task._id).first()
db.delete(old_assignee_relation)
# add new assignee relation
db.add(task_graph.relation(relation_from=task, relation=Assignee_Relation(), relation_to=assignee))
return jsonify({'result':task._dump()}), 200
def edit_product():
body = json.loads(request.data)
key = body.get('_key', None)
if key is None:
return jsonify({'error': 'key cannot be null'})
product = db.query(Products).by_key(key)
if product is None:
return jsonify({'error': 'product not found'})
# TODO this but programmatically if things change
name = body.get('name', None)
if name is not None:
product.name = name
description = body.get('description', None)
if description is not None:
product.description = description
imageLocation = body.get('imageLocation', None)
if imageLocation is not None:
product.imageLocation = imageLocation
price = body.get('price', None)
if price is not None:
product.price = price
discount = body.get('discount', None)
if discount is not None:
product.discount = discount
db.update(product)
#relations
category_key = body.get('category_key', None)
category = db.query(Categories).by_key(category_key)
if category is not None:
# find old category relation and delete it
old_category_relation = db.query(Category_Relation).filter(
'_to==@_to', _to=product._id).first()
db.delete(old_category_relation)
# add new category relation
db.add(
product_graph.relation(relation_from=category,
relation=Category_Relation(),
relation_to=product))
shop_key = body.get('shop_key', None)
shop = db.query(Shops).by_key(shop_key)
if shop is not None:
# find old assignee relation and delete it
old_shop_relation = db.query(Shop_Relation).filter(
'_from==@_from', _from=product._id).first()
db.delete(old_shop_relation)
# add new assignee relation
db.add(
product_graph.relation(relation_from=product,
relation=Shop_Relation(),
relation_to=shop))
return jsonify({'result': product._dump()})
def edit_categories():
body = json.loads(request.data)
category_name = body.get('name', None)
category_key = body.get('_key',None)
category = db.query(Categories).by_key(category_key)
if category is not None:
category.name = category_name
db.update(category)
else:
return jsonify({'error':'Category not found'}), 200
return jsonify({'result': category._dump()}), 200
def edit_person():
body = json.loads(request.data)
key = body.get('_key',None)
if key is None:
return jsonify({'error':'key cannot be null'})
name = body.get('name',None)
if name is None:
return jsonify({'error':'name cannot be null'})
person = db.query(People).by_key(key)
person.name = name
db.update(person)
return jsonify({'result':person._dump()})
def edit_category():
body = json.loads(request.data)
key = body.get('_key', None)
if key is None:
return jsonify({'error': 'key cannot be null'})
category = db.query(Categories).by_key(key)
# TODO this but programmatically if things change
name = body.get('name', None)
if name is not None:
category.name = name
description = body.get('description', None)
if description is not None:
category.description = description
db.update(category)
return jsonify({'result': category._dump()})
def emptychat():
print db.update('delete from chat where id = ?', (238,))