Flask-RESTful: Integrating the API Server with a MySQL Database
Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
Learn more about Flask-RESTful, which connects to the ORM libraries you use to connect to your database.
You'll set up APIs to perform create, read, update, and delete (CRUD) operations. You'll then implement APIs using an in-memory dictionary before integrating them with a MySQL database back end. You’ll set up a MySQL database and work with MySQL Workbench. You'll install and use the Advanced REST Client.
Expected Duration (hours)
2.1
Lesson Objectives Flask-RESTful: Integrating the API Server with a MySQL Database
discover the key concepts covered in this course
implement a complete API server using Flask-RESTful, which responds to GET, POST, PUT, and DELETE requests
test create, read, update, and delete (CRUD) operations using Flask-RESTful
install and set up MySQL and MySQL Workbench on macOS
install and set up MySQL and MySQL Workbench on Windows
install the SQLAlchemy library, connect to a database, and insert records in the database
install the Advanced REST Client, an API testing tool to test APIs and validate responses
use the marshal() function, marshal_with, and data_class decorators to serialize an object to JSON format
wire up the methods to add and retrieve data with the MySQL database
wire up the method to update data with the MySQL database
wire up the method to delete data with the MySQL database
use the envelope parameters to structure the JSON response to the user
configure JSON responses with special display names
specify nested fields and URL paths within JSON responses
create custom fields in JSON responses
create custom error messages for specific error handling using MySQL Database and Flask-RESTful
summarize the key concepts covered in this course
Course Number: it_pywsfrdj_03_enus
Expertise Level
Expert