def add_one_product(): name = request.get_json().get('name') products = Product(id=3, name=name, description=name) print(products) products = db.session.add(products) # SQLAlchemy request => 'SELECT * FROM products' db.session.commit() return one_product_schema.jsonify(products), 200
def read_one_product(id): content = request.get_json() if content is None: abort(400) product = db.session.query(Product).get(id) if product is None: abort(404) return one_product_schema.jsonify(product), 200
def post_one_product(): content = request.get_json() if content is None: abort(400) product = Product() product.name = content['name'] db.session.add(product) db.session.commit() return one_product_schema.jsonify(product), 201
def create_one_product(): content = request.json name = content.get('name', None) description = content.get('description', '') if name is None: return {}, 404 new_product = Product(name=name, description=description) db.session.add(new_product) db.session.commit() return one_product_schema.jsonify(new_product), 201
def update_one_product(id): product = db.session.query(Product).get(id) if product is None: return {}, 404 content = request.json name = content.get('name', None) description = content.get('description', None) if name is not None and name != '': product.name = name if description is not None and description != '': product.description = description db.session.add(product) db.session.commit() return one_product_schema.jsonify(product), 201
def get_one_product(id): products = db.session.query(Product).get(id) # SQLAlchemy request => 'SELECT * FROM products' return one_product_schema.jsonify(products), 200
def get_one_product(id): product = db.session.query(Product).get(id) return one_product_schema.jsonify(product), 200
def get_one_product(product_id): product = db.session.query(Product).get( product_id ) # SQLAlchemy request => 'SELECT * FROM products where id = {product_id}' return one_product_schema.jsonify(product), 200