Viewing the database in DB Browser for SQLite

RESTful APIs with Python 3 and Flask

What you should know

Using the exercise files

Demo project overview

Creating a new Flask project in PyCharm

Making a super-simple API example

Setting up a run configuration

Testing with Postman

Restarting your server

Returning JSON instead of text

HTTP status codes

URL parameters

URL variables and conversion filters

Adding an ORM (SQLAlchemy)

Setting up SQLAlchemy

Creating the ORM model classes

Seeding the database with the Flask CLI

Retrieving a list of planets from the database

Serializing SQLAlchemy results with Marshmallow

JSON Web Tokens

Registering new users

Authenticating users and passing the token

Setting up email

Emailing a lost password

Retrieving a single planet's details

Adding planets with a POST method

Securing the add planet endpoint

Updating a planet using a PUT method

Deleting a planet with DEL

Exporting your project’s requirements file

Conclusion