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])