Another great video thank you. If anyone gets the error "AttributeError: 'list' object has no attribute 'data'", it's because since Marshmallow v3 you don't need the .data attribute as dump returns the data directly ... def get_products(): all_products = Product.query.all() result = products_schema.dump(all_products) return jsonify(result)
If when running "db.create_all()" from the Python interpreter you experience "RuntimeError: Working outside of application context.", instead run the following three lines: >>> from app import app, db >>> app.app_context().push() >>> db.create_all()
Thank you for presenting an example by using my favorite two tools - pipenv and vscode. They save so much time and effort. I also ALWAYS create a git repository for projects, even if they are the throwaway kind. As of this date, marshmallow is version 3.0 and the "strict" key is no longer needed or allowed.
Thanks for the video Brad. kudos. I was getting this error when sending a GET to return all the Products, To fix it I returned jsonify(result) instead of jsonify(result.data) I hope it will save someone else time =)
Thank you so much for this. As a part of an interview assignment, I was given a task to create a CRUD system and expose APIs for a table. Starting from absolutely 0 knowledge about Flask, I was able to fully develop it thanks to you. Thank you so much! Do let me know if there is some way I can buy you a couple of beers (your Paypal?)
Just a note: jsonify does more than the simple conversion (if I'm not mistaken), it actually does some other prep steps to make it ready to be used as a response. For a simple conversion, you can use the built in module `json` ... json_string = json.dumps(som_python_dict)
Good Tutorial Thanks Brad Might be something new with Marshmellow but I think that this is the correct synatax - # Init Schema product_schema = ProductSchema() products_schema = ProductSchema(many=True) I tried it with strict and it was dropping an error .. above worked.
Hi Brad, I've been following your channel for the past few months. I have learnt HTML and CSS as well as Python from your channel. I was forced to learn Java in my college as part our curriculum (which I find hard as a first time coder) and currently, we are going to make an Android app Although I find React Native to be really efficient, my professors, insist that I should make an app through Java. Can you include a crash course on Java and Android Studio. sorry if I'm asking too much. Your work is awesome as always
At 26:40, would it be all right to replace the two statements: result = products_schema.dump(all_products) return jsonify(result.data) with: products_schema.jsonify(all_products) ? I'm too much of a noob to understand the difference 🙈
Thanks a lot for this, nicly explained but during delete part when I delete any product from the middle let say product number 3 in list of 5 products Is there a way to update its Product id?
I typed in python3 --version into the terminal and it said "Python was not found". How do I resolve this? Edit: Python 3 is already installed on my computer but I still get this message Edit: Nevermind. Everything's working fine.
Wow that is great. What if I want to make it bigger? Would you make a video tutorial of these Flask Restful and seperate the models, views(with blueprints), and the main app with application factory (create_app() function)? and also add an authentication method. It would be better right?
0:27 - Intro to tutorial 1:00 - Intro to the other packages used in this tutorial (SQLAlchemy, Marshmallow, PostMan) 2:01 - Creating virtual environment (Pipenv) 3:09 - Installing dependencies 4:10 - Create main file (app.py) 5:43 - Initialize flask and run server 7:02 - Creating a basic route 7:58 - Making POST request in Postman 8:18 - Setting up database URI 9:04 - Setting up database 10:46 - Initialize database 11:00 - Initialize Marshmallow 11:23 - Creating a class for your resource(s) 16:13 - Creating a product schema (This is where we use Marshmallow) 17:13 - Initialize schema 17:56 - Another schema initialization 18:50 - Creating the database 20:04 - Creating our routes 20:15 - "Create a product" route ('/product') 23:30 - Making a POST request in Postman 24:50 - Creating "fetch all products" route 25:40 - SQLAlchemy .all() method 26:46 - Testing get all products in Postman 27:28 - Creating "get single product" route 29:29 - Creating "update a product" route 31:35 - Making a PUT request to product in Postman 32:21 - Create a delete route 33:49 - Making a DELETE request in Postman
For people coming across this video in June 2021. I had a few issues using the latest versions of everything. 1. At 18 minutes the schema no longer requires strict = True. 2. At 16.30, result.data should be result.
Quite old, some methods are not the same right now. But it's definitely a good tutorial. The strict param is not accepted right now for marshmallow (product(s)_schema) For the get_all the following lines are the new ones: all_products = Product.query.all() return products_schema.jsonify(all_products)
File "C:\Users\Engr\Documents\flask-api\traversy\app.py", line 47, in add_product name = request.json['name'] TypeError: 'NoneType' object is not subscriptable after I try to make the same post request with postman. And I got the same error with the code from github so I wrote all the code correctly. Can anyone help with this?
Just for someone who gets stuck when they get all products, the "result" variable will be default be an array/list so you don't need the `data` you can just jsonify(result)
For anyone using this now, and update to Marshmallow (from documentation): Setting the strict option on class Meta has no effect on Schema behavior. Passing strict=True or strict=False to the Schema constructor will raise a TypeError.
For anyone following this tutorial in 2021 The strict parameter was removed. Schemas are always strict. So product_schema = ProductSchema() products_schema = ProductSchema(many=True)
Dont know why Traversy decided to create the database in the terminal makes no sense to me, instead import create_engine from sqlalchemy, then engine=create_engine(use the url Traversy uses) then db.Model.metadata.create_all(engine) and thats it ! You can add ‘if not database_exists(engine.url): db.Model.metadata etc.’ to only create database if it does not exist, that will make your program portable. There are many ways to check if a database exists but installing the sqlalchemy_utils and importing database_exists is easier
Is this some sort of magic? I swear I was reading flask documentation and now you post a video. Thank you so MUCH BTWBrad, what magic classes do you take,?
Breaking Marshmallow changes since the version used to record this tutorial. 3.0.0b7 (2018-02-03) Features: Backwards-incompatible: Schemas are always strict (#377). The strict parameter is removed. Backwards-incompatible: Schema().load and Schema().dump return data instead of a (data, errors) tuple (#598).
name = request.json['name'] TypeError: 'NoneType' object is not subscriptable - keep getting this error and looking all over for it, but I have no idea what it means. Can anyone help?
On the get all products route I had to remove .data from result in order to see my products. I was getting the error, " 'list' object has no attribute 'data' ".
For anyone confused about how the table name is generated, I just realized that on executing the db.create_all() command, a table with same name as the lower cased Class name gets created in SQLite database, so in this case a table named 'product' is created with the defined schema. Also, if Class name has a name like MyProduct then table would be named as my_product.
You will probably get the same error when you try 'GET' for all products. Here is the solution stackoverflow.com/questions/60529230/flask-marshmallow-attributeerror-list-object-has-no-attribute-data
# Get All Products @app.route('/product', methods=['GET']) def get_products(): all_products = Product.query.all() result = products_schema.dump(all_products) return jsonify(result.data) < ------------ there is not attribute called data so just return the result and it works
UPDATES IN MARSHMALLOW: 1) all schemas are strict by default now - so (strict=True) is giving errors 2) result will give you the data by default now - so (result.data) is trowing an error
Thank you for providing such great content. However, I believe many of us would like to see this project expanded further. Right now, as great this tutorial might be, it's not suitable to use for any real-world application. Some things I would like to see are: breaking the app.py into multiple files to separate out the models and routes, using token authentication, implementing model relationships, etc. I hope you please consider. Thank you.
Hi Traversy, Thanks so much for this video. I had been reading a lot and trying to get the concept of such an API but it was confusing to me mostly because many tutorials start off by putting different things in different files and then they import different modules into each other-it's just too confusing for a beginner. So thanks to God you put everything in a single file and gave us an overview. You have no idea how that is important to me.
Attribute data on Get All Products is not required. Should be removed so the function should read - @app.route('/product', methods=['GET']) def get_products(): all_products = Product.query.all() result = products_schema.dump(all_products) return jsonify(result) Hope this helps someone!
I disliked it because even though you explained the content pretty well and your video breakdown was very neat, however, you are showing an example of doing CRUD and has nothing to do with RESTFUL API. To be more specific, it is violating the Statelessness as well as Client-Service architecture type. (en.wikipedia.org/wiki/Representational_state_transfer)
For a REST API I think it would be better to showcase the PATCH method for updating a product. There is a whole debate to be had about idempotence, but most of the time you do not want to supply the entire product in order to update a single field. Especially if the API is not consumed by a frontend, but utilized directly by an end-user to fetch and modify data.
Awesome video. could you make a small video that integrates a flask backend and a react frontend. I would like to know how the data flows between both ends. More so how to send data from the frontend and receive it in the flask backend. Please if you do get a chance make a video on it. Thank you.
Can someone please tell what was the purpose of the below commands running on python shell. Does it create objects as well or just created the db. From app import db Db.create_all()
Awesome tutorial, it clearly shows why Flask is the best framework for python API development. You can also use Flask-Restful to define your endpoints. It give you all the HTTP verbs ready, your endpoints will be called resources rather than routes. Thanks Brad for your hard work and dedication.
I was introduced to FastAPI and never want to look back! It feels like a sucessor to flask: inspired by it, but adding a lot of structure and validation with parameters and type hints.
I'm love your tutorials, except for one thing .. You seem to assume that the viewer is familiar with similar libraries, extensions, etc to the one that is the subject of the video. That's not the case for me, and I wonder how many of your viewers are in a similar position. For example, you are constantly making references to django in this video. Unless you state at the beginning of the video that certain skills are prerequisites for taking your tutorial, I wish you wouldn't make frequent references to other packages. I don't find that helpfu.
Hello! while passing the first product by postman this console throws me this error TypeError: 'Product' object is not iterable did that happen to anyone else? you can help me?
Thank you! I’m coming from node web backends and just tryna switch it up and start using python instead. Most tutorials were just brushing over the basics without explaining and getting straight to the point. Thank you brad, you’re THE best!
Press "Ctrl + Shift + P" : Show all commands Type: "Configure Language Specific …", then pick "Python" "settings.json" will open. Check in this json file if there is a line like this: {"python.jediEnabled": false} If yes, then comment it out, then reload VSCode, the problem should be solved
Marshmallow can on the fly update db models. That means instead of product.name = request.json.get("name") product.description = ... You can use (but you should update your schema with option sqla_session github.com/marshmallow-code/marshmallow-sqlalchemy#generate-marshmallow-schemas) product_schema = ProductSchema() response = product_schema.load(request.json, session=db.session) if response.errors: return jsonify(response.errors), 400 else: db.session.commit() # optional db.session.refresh(response.data) return jsonify({"product": response.data}), 201 Or extend ModelSchema like this (and db.session will be passed to subclasses of BaseSchema automaticly marshmallow-sqlalchemy.readthedocs.io/en/latest/recipes.html#base-schema-ii): class BaseOpts(ModelSchemaOpts): def __init__(self, meta): if not hasattr(meta, 'sql_session'): meta.sqla_session = db.session super(BaseOpts, self).__init__(meta) class BaseSchema(ModelSchema): OPTIONS_CLASS = BaseOpts
I really love Flask coz it's is similar to express when it comes to build apis but I would love to watch a video with authentication added to this via Rest. Anyways your contents are making our lives in this competitive world easier. Thanks teacher
If you are trying to receive data from frontend along with API as data, use name = request.form.get('name') ==> instead of ==> name = request.json['name']
In the get all products function what is the importance of the keyword "dump"?? I tried return products_schema.jsonify(all_items) and it works fine. Can anyone help me understand?
I love this; that you make real projects now days that are more "complete" and not just 'frontend', but I would like to see more front-end, please. E.g. you could explain how 'content: ""' works when people use it "before" and "after" when they do these seemingly magic stuff. How does it work? Looks like magic to me, and would like to know more about it.
Doenst FLash has some framework for API just like DJango Rest Framework for Django?? We can use this jsonify in DJnago too I guess. But I need the framework for Flask.
great video, I have a question. If I give an example, I have a user table and a vehicle table user and my vehicle table are one-to-many linked. When I get my user table, the vehicle's id comes. How do I get all the values of the vehicle to be listed, not just the id?
what happens exactly if i put method=[Delete] but within the handler i just updated a record instead of deleting...?? or generally the handler performing a task without considering the method. Beacuse to me it seems that the http-method is just a convention im confused.
I can't get this to work. I've installed all the necessary dependencies and pulled the code from Github in my attempts to troubleshoot the problem. The interpreter keeps on complaining about the strict in the ProductSchema(strict=True). Anyone who has an idea of what I have to do to sort this out please help 😣
For "return jsonify(result.data)", I'm getting error: "AttributeError: 'dict' object has no attribute 'data' // Werkzeug Debugger". Can you advise on how to overcome it?
Hi Brad! first, another great and informative tutorial, thank you so much for your effort!. Second, I think that you have a small mistake - at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PTZiDnuC86g.html you ran the project with the command "python app.py" meaning you ran it using the global packages installed on your computer, I think you should have run it with "pipenv run app.py", which means that the project runs using the locally installed packages.
Thanks for a quick introduction to Flask REST API. I am working on a React/Flask application for IT Inventory system. I was looking for something quick on Flask REST API development.
Great video as always! Anyone else having this issue when posting the products? 400 Bad Request Bad Request Failed to decode JSON object: Expecting value: line 1 column 1 (char 0) I believe the issue may lie with the request object when we are decode those values. I have reduced the /product endpoint to just evaluate the json body into variables and still getting this response. Note that I have made sure my header is properly Content-Type : application/json in postman.
Edit: tried with curl: curl -i -H "Content-Type: application/json" -X POST -d '{"name":"Product 2", "description":"This is product two", "price":230.50, "qty":31}' 127.0.0.1:9000/product/ . and it worked as expected. I guess originally i had taken out some of the auto generated postman headers, and upon putting those headers back it worked with postman. So anyone having this issue make sure you leave the autogenerated postman headers