def add_product():
name = request.json["name"]
description = request.json["description"]
price = request.json["price"]
qty = request.json["qty"]
new_product = Product(name, description, price, qty)
db.session.add(new_product)
db.session.commit()
return product_schema.jsonify(new_product)
def change_product():
if request.method == 'PUT':
product = Product.query.get_or_404(id)
manufacturer = request.json['manufacturer']
name = request.json['name']
description = request.json['description']
price = request.json['price']
category_id = request.json['category_id']
try:
product.manufacturer = manufacturer
product.name = name
product.description = description
product.price = price
product.category_id = category_id
db.session.commit()
return product_schema.jsonify(product)
except:
db.session.rollback()
return {'msg': 'Ошибка добавления в Базу данных'}
elif request.method == 'DELETE':
product = Product.query.get_or_404(id)
try:
db.session.delete(product)
db.session.flush()
db.session.commit()
return product_schema.jsonify(product)
except:
db.session.rollback()
return {'msg': 'Ошибка удаления'}
def update_product(id):
product = Product.query.get(id)
name = request.json["name"]
description = request.json["description"]
price = request.json["price"]
qty = request.json["qty"]
product.name = name
product.description = description
product.price = price
product.qty = qty
db.session.commit()
return product_schema.jsonify(product)
def create_product():
manufacturer = request.json['manufacturer']
name = request.json['name']
description = request.json['description']
price = request.json['price']
category_id = request.json['category_id']
try:
new_product = Product(manufacturer, name, description, price, category_id)
db.session.add(new_product)
db.session.flush()
db.session.commit()
return product_schema.jsonify(new_product)
except:
db.session.rollback()
return {'msg': 'Ошибка добавления в Базу данных'}
def delete_product(id):
product = Product.query.get(id)
db.session.delete(product)
db.session.commit()
return product_schema.jsonify(product)
def get_product(id):
product = Product.query.get(id)
return product_schema.jsonify(product)
def get_product(id):
if Product.query.get_or_404(id):
product = Product.query.get_or_404(id)
return product_schema.jsonify(product)
else:
return 404