Flask-RESTful: Integrating the API Server with a MySQL Database

Flask-RESTful 1.1.1
  • 17 Videos | 2h 13m
  • Includes Assessment
  • Earns a Badge
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 17s
    UP NEXT
  • Playable
    2. 
    Implementing API Servers to Respond to Requests
    9m 44s
  • Locked
    3. 
    Testing Create, Read, Update, and Delete Operations
    9m 16s
  • Locked
    4. 
    Installing MySQL and MySQL Workbench on macOS
    9m 48s
  • Locked
    5. 
    Installing MySQL and MySQL Workbench on Windows
    8m 13s
  • Locked
    6. 
    Creating Tables Using SQLAlchemy
    10m 42s
  • Locked
    7. 
    Installing the Advanced REST Client
    2m 37s
  • Locked
    8. 
    Serializing API Responses to JSON Format
    9m 3s
  • Locked
    9. 
    Adding and Retrieving Data from a MySQL Database
    11m 1s
  • Locked
    10. 
    Updating Data in a MySQL Database
    6m 38s
  • Locked
    11. 
    Deleting Data in a MySQL Database
    3m 18s
  • Locked
    12. 
    Using the Envelope Parameter to Wrap JSON Responses
    10m
  • Locked
    13. 
    Renaming and Formatting Response Fields in JSON
    5m 4s
  • Locked
    14. 
    Working with JSON Response Default Values and URLs
    9m 15s
  • Locked
    15. 
    Creating Custom Fields in JSON Responses
    6m 53s
  • Locked
    16. 
    Creating Custom Parsing and Mapping Errors
    9m 23s
  • Locked
    17. 
    Course Summary
    2m 20s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.