def get_all_Categories():
c = Categories(connection_data)
result = c.get_all_Categories()
return jsonify({'data': result})
def get_one_categorie(id):
categories = CategoriesEntity(CategoryID=id)
c = Categories(connection_data)
result = c.get_one_Categories(categories)
return jsonify({'data': result})
def add_categories():
data = request.json
categories = CategoriesEntity(category_name=data['category_name'],
description=data['description']
)
c = Categories(connection_data)
message = c.insert(categories)
if message is None:
return jsonify({
'message': 'Cannot insert data'
}), 500
return jsonify({
'message': message
})
def add_Categories():
data = request.json
cate = CategoriesEntity(CategoryName=data['CategoryName'],
Description=data['Description'])
c = Categories(connection_data)
message = c.insert_Categories(cate)
if message is None:
return jsonify({'message': 'Cannot insert data'}), 500
return jsonify({'message': message})
def delete_category_by_id(id):
if request.method == 'DELETE':
# Delete user by id
cate = CategoriesEntity(CategoryID=id)
c = Categories(connection_data)
result = c.delete_Categories(cate)
return jsonify({'message': result[0]}), result[1]
else:
# Update user by id
data = request.json
cate = CategoriesEntity(CategoryID=id,
CategoryName=data['CategoryName'],
Description=data['Description'])
c = Categories(connection_data)
result = c.update_Categories(cate)
return jsonify({'message': result[0]}), result[1]
def delete_categories_by_id(id):
if request.method == 'DELETE':
# Delete user by id
categories = CategoriesEntity(category_id=id)
c = Categories(connection_data)
result = c.delete(categories)
return jsonify({
'message': result[0]
}), result[1]
else:
# Update user by id
data = request.json
categories = CategoriesEntity(category_id=id,
category_name=data['category_name'],
description=data['description'])
c = Categories(connection_data)
result = c.update(categories)
return jsonify({
'message': result[0]
}), result[1]