You use note_id in the query’s .get() method to get the note with the primary key of the note_id integer. Although you’re working with SQLAlchemyAutoSchema, you have to explicitly create the notes field in PersonSchema. Otherwise Marshmallow doesn’t receive all the information it needs to work with the Notes data. For example, it won’t know that you’re expecting a list of objects using the many argument.
The modifications that you’ll make to the program will move all the data to a database table. This means that the data will be saved to your disk and will exist between runs of the app.py program. Marshmallow converts Python class instances to objects that can be converted to JSON. If you downloaded the source code from the link above, then make sure to follow the installation instructions within the provided README.md file.
Why Python?
You use db from your config module so Python knows how to handle data and commit it to the corresponding database tables and cells. In the next section, you’ll create the models that represent the database table relationships you came up with. Working through part two, you connected your REST API to a database. That way, your Flask application can make changes to existing data and create new data that persists even when you restart your app server.
In this tutorial, you adjusted your SQLite database to implement relationships. First, you look for the owner of the note by using person_id, which you provide with the notes argument for create(). If this person exists in the database, then you go ahead to append the new note to person.notes. When you compare update() with delete(), they share a similar structure.
Read next
This displays the structure of the expected response, the content-type of that response, and the description text that you entered about the endpoint in the swagger.yml file. Any time the configuration file changes, the Swagger UI changes as well. Connexion will use “people.read_all” to find a Python function named read_all() in a people module of your project. You’ll create the corresponding Python code later in this tutorial. The Swagger configuration file is a YAML or JSON file containing your OpenAPI definitions. This file contains all of the information necessary to configure your server to provide input parameter validation, output response data validation, and URL endpoint definition.
- This isn’t such a big deal for your person data, as there aren’t that many columns.
- You’ll create a foundation with a basic Flask project then add endpoints and connect them to a SQLite database.
- You’ve created a foundation with a basic Flask project and added endpoints, which you’ll connect to a SQLite database.
- While it’s not important to understand how Decorators work for this tutorial, I strongly recommend you check out some material about Decorators after this lesson.
- Finally, you can use Swagger UI to create, update, and delete people and see the changes reflected on the home page.
You’ve created a foundation with a basic Flask project and added endpoints, which you connected to a SQLite database. Most modern web applications are powered by a REST API under the hood. That way, developers can separate the front-end code from the back-end logic, and users can interact with the interface dynamically. In this three-part tutorial series, you’re building a REST API with the Flask web framework.
