5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Aspire     Pythonista to Python Master     Python Master Track 4: Building Restful Web Services with Python

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.



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