Working with Models, SQLAlchemy, and Hyperlinked APIs in Flask

In this chapter, we will expand the capabilities of the RESTful API that we started in the previous chapter. We will use SQLAlchemy as our ORM to work with a PostgreSQL database, and we will take advantage of advanced features included in Flask and Flask-RESTful that will allow us to easily organize code for complex APIs, such as models and blueprints.

We will go through the following topics in this chapter:

• Design a RESTful API to interact with a PostgreSQL 10.5 database
• Understand the tasks performed by each HTTP method
• Install packages with the requirements.txt file to simplify our common tasks
• Create the database
• Configure the database
• Write code for the models with their relationships
• Use schemas to validate, serialize, and deserialize models
• Combine blueprints with resourceful routing
• Understand and configure...