def del_product(id):
product = db.session.query(Product).get(id)
db.session.delete(product)
db.session.commit()
products = db.session.query(Product).all() # SQLAlchemy request => 'SELECT * FROM products'
db.session.commit()
return products_schema.jsonify(products)
def read_products():
from tasks import very_slow_add
very_slow_add.delay(1,
2) # This pushes a task to Celery and does not block.
products = db.session.query(Product).all()
return (products_schema.jsonify(products), 200)
def products():
from tasks import very_slow_add
very_slow_add.delay(1,
2) # This pushes a task to Celery and does not block.
products = db.session.query(
Product).all() # SQLAlchemy request => 'SELECT * FROM products'
return products_schema.jsonify(products)
def create_products():
req = request.get_json("name")
name = req['name']
product = Product()
product.name = name
db.session.add(product)
db.session.commit()
return products_schema.jsonify([product])
def update_products(product_id):
req = request.get_json("name")
name = req['name']
product = db.session.query(Product).get(product_id)
product.name = name
db.session.add(product)
db.session.commit()
return products_schema.jsonify([product])
def upd_product(id):
new_product_dict = request.get_json()
new_product_name = new_product_dict.get('name')
product = db.session.query(Product).get(id)
product.name = new_product_name
db.session.commit()
products = db.session.query(Product).all() # SQLAlchemy request => 'SELECT * FROM products'
db.session.commit()
return products_schema.jsonify(products)
def products():
if request.method == 'GET':
products = db.session.query(
Product).all() # SQLAlchemy request => 'SELECT * FROM products'
return products_schema.jsonify(products)
elif request.method == 'POST':
product = Product()
product.name = request.get_json()['name']
db.session.add(product)
db.session.commit()
return f'{product.name} successfully added to database', 201
def products():
if request.method == 'GET':
products = db.session.query(
Product).all() # SQLAlchemy request => 'SELECT * FROM products'
return products_schema.jsonify(products)
elif request.method == 'POST':
product_json = request.get_json()
ed_product = Product(name=product_json['name'],
description=product_json['description'])
db.session.add(ed_product)
db.session.commit()
return '', 201
def products():
if request.method == "GET":
products = db.session.query(Product).all() # SQLAlchemy request => 'SELECT * FROM products'
result = products_schema.jsonify(products)
else:
product_name = request.json['name']
product_desc = request.json['description']
new_product = Product(product_name, product_desc)
db.session.add(new_product)
db.session.commit()
result = product_schema.jsonify(new_product)
return result
def products():
if request.method == 'GET':
products = db.session.query(
Product).all() # SQLAlchemy request => 'SELECT * FROM products'
return products_schema.jsonify(products)
product = Product()
newprod = request.get_json()
product.name = newprod['name']
db.session.add(product)
db.session.commit()
return product_schema.jsonify(product), 201
def products():
if request.method=="GET":
products = db.session.query(Product).all() # SQLAlchemy request => 'SELECT * FROM products'
return products_schema.jsonify(products)
if request.method=="POST":
json=request.json
prod = Product()
prod.name = json["name"]
prod.description = json["description"]
db.session.add(prod)
db.session.commit()
#insert product
return product_schema.jsonify(prod)
def products():
if request.method == 'GET':
products = db.session.query(Product).all() # SQLAlchemy request => 'SELECT * FROM products'
return products_schema.jsonify(products), 200
if request.method == 'POST':
if 'name' in request.get_json():
product = Product()
product.name = request.get_json()['name']
if 'description' in request.get_json():
product.description = request.get_json()['description']
db.session.add(product)
db.session.commit()
return "Product created", 201
return "Invalid product name", 400
def create_product():
#get json body
json = request.get_json()
#validate parameters in json
if type(json) is dict:
new_product = process_create_poduct(json)
return product_schema.jsonify(new_product), 201
elif type(json) is list:
#bulk create
created_products = []
for item in json:
created_products.append(process_create_poduct(item))
return products_schema.jsonify(created_products), 201
else:
abort(422)
def products():
if request.method == 'GET':
products = db.session.query(
Product).all() # SQLAlchemy request => 'SELECT * FROM products'
return products_schema.jsonify(products)
elif request.method == 'POST':
content = request.get_json()
new_product = Product()
new_product.name = content['name']
new_product.description = content['description']
db.session.add(new_product)
db.session.commit()
return Response(
f"added {content['name']} with desription {content['description']}",
status=201,
mimetype='application/json')
def products():
products = db.session.query(
Product).all() # SQLAlchemy request => 'SELECT * FROM products'
#return render_template('base.html', products=products)
return products_schema.jsonify(products)
def list_products():
all_products = Product.query.all()
return products_schema.jsonify(all_products)
def add_product():
newproduct = Product(name = "newProducts")
db.session.add(newproduct) # SQLAlchemy request => 'SELECT * FROM products'
db.session.commit()
products = db.session.query(Product).all()
return products_schema.jsonify(products)
def update_product(prd_id):
updateprd=db.session.query(Product).filter(Product.id == prd_id).update({'name' : 'newnae'})
db.session.commit()
products = db.session.query(Product).all()
return products_schema.jsonify(products)
def read_product(id):
#query db
to_return = db.session.query(Product).get(id)
#serialize and return
products_schema.jsonify(to_return)
def products():
products = db.session.query(
Product).all() # SQLAlchemy request => 'SELECT * FROM products'
return products_schema.jsonify(products)
def products():
products = db.session.query(Product).all()
return products_schema.jsonify(products)
def products_list():
products = db.session.query(Product).all()
response = make_response(products_schema.jsonify(products), 200)
return response
def list_products():
products = db.session.query(
Product).all() # SQLAlchemy request => 'SELECT * FROM products'
# products = db.session.query(Product).order_by(Product.name).all() # SQLAlchemy request => 'SELECT * FROM products'
return products_schema.jsonify(products)
def get_products(product_id):
product = db.session.query(Product).get(
product_id) # SQLAlchemy request => 'SELECT * FROM products'
return products_schema.jsonify([product])
