def publisher_update():
try:
name = request.json['name']
uuid = request.json['uuid']
query = '''UPDATE `publishers` SET `name` = %s WHERE `uuid` = %s'''
arguments = [name, uuid]
result = edit_helper(query, arguments)
return jsonify(result)
except Exception:
return jsonify({'result': 'failure'})
def update_desc():
try:
desc = request.json['desc']
tasklists_id = request.json['tasklist_id']
token = request.headers.get('Authorization').split(' ')[1]
decoded = jwt.decode(token, 'secret', algorithms=['HS256'])
# decoded successfully
query = '''UPDATE `tasklists` SET `desc` = %s WHERE `tasklist_id` = %s'''
result = edit_helper(query, [desc, tasklists_id])
return jsonify(result)
except Exception:
return jsonify({'result':'failure' })
def edit(blog_id):
try:
heading = request.json['heading']
body = request.json['body']
token = request.headers.get('Authorization').split()[1]
# decode the token
try:
decoded = jwt.decode(token, 'secret', algorithms=['HS256'])
user_id = decoded['user_id']
except Exception:
return jsonify({'result': 'failure', 'user': '******'})
query = '''UPDATE `blog` SET
`heading` = %s,
`body` = %s
WHERE `blog_id` = %s
'''
result = edit_helper(query, [heading, body, blog_id])
return jsonify(result)
except Exception as ex:
return jsonify({'result': 'failure', 'error': ex})
def edit(blog_id):
try:
heading = request.json['heading']
body = request.json['body']
token = request.json['token']
user_id = request.json['user_id']
# decode the token
decoded = jwt.decode(token, 'secret', algorithms=['HS256'])
if int(decoded['user_id']) != int(user_id):
return jsonify({
'result': 'failure',
'error': 'authentication failed'
})
query = '''UPDATE `blog` SET
`heading` = %s,
`body` = %s
WHERE `blog_id` = %s
'''
result = edit_helper(query, [heading, body, blog_id])
return jsonify(result)
except Exception as ex:
return jsonify({'result': 'failure', 'error': ex})