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

IN THIS COURSE

• 1.  Course Overview
  2m 17s
  This course will teach you how to set up APIs to perform create, read, update, and delete (CRUD) operations. You will learn to implement APIs using an In-Memory dictionary, and install and set up the MySQL database.  You will work with the MySQL Workbench and install the FLASK library. You will install and use the advanced REST client to test and validate APIs and wire up your CRUD operations with the MySQL database backend.  FREE ACCESS
• 2.  Implementing API Servers to Respond to Requests
  9m 44s
  In this course, you will learn to write code for your API server to handle CRUD requests. You will learn how to implement a complete API server using Flask-RESTful. The instructor walks you through the process, step-by-step, as you watch the demo.    FREE ACCESS
• 3.  Testing Create, Read, Update, and Delete Operations
  9m 16s
  In this video, you will make sure your requests and responses work as expected. You'll make sure your FLASK server is up and running. The instructor will walk you through each step, providing a demo.  You'll learn how to view and read response headers, as well.  FREE ACCESS
• 4.  Installing MySQL and MySQL Workbench on macOS
  9m 48s
  In this video, you will follow a demo for users on macOS. In this demo, you've installed the MySQL server and the MySQL workbench graphical user interface on the local machine. The demo will show you how to use this database to write out your data.  FREE ACCESS
• 5.  Installing MySQL and MySQL Workbench on Windows
  8m 13s
  In this video, you will follow a demo for users on Windows. In this demo, you've installed the MySQL server and the MySQL workbench graphical user interface on the local machine. The demo will show you how to use this database to write out your data.  FREE ACCESS
• 6.  Creating Tables Using SQLAlchemy
  10m 42s
  In this video, you will watch a demo showing you how to set up your environment so your API server can connect to the MySQL database. First, you'll learn to install the MySQL connector Python.  The Python library you will use is SQLAlchemy. You'll also learn to install FLASK-SQLAlchemy.  Next, you'll learn to run a script to create the table you'll be working with. You'll learn more about SQLAlchemy. FREE ACCESS
• 7.  Installing the Advanced REST Client
  2m 37s
  In this video, you will install the Advanced REST Client, an API testing tool to test APIs and validate responses. First, you'll follow the demo to learn how to download and install the Advanced REST Client. Then, you'll learn more about the Advanced REST Client. FREE ACCESS
• 8.  Serializing API Responses to JSON Format
  9m 3s
  In this video, you will learn to wire up your code. You'll learn to check for multiple errors at one time. The demo will show you how to serialize API responses to JSON format and use the marshal() function, marshal_with, and data_class decorators to serialize an object to JSON format. You will also learn how to perform queries and run Python code.  FREE ACCESS
• 9.  Adding and Retrieving Data from a MySQL Database
  11m 1s
  In this video, you will learn how to wire up the methods to add and retrieve data from a MySQL database. In this demo, you will use the marshal technique in Flask-RESTful.  FREE ACCESS
• 10.  Updating Data in a MySQL Database
  6m 38s
  In this video, you will wire up another API without a database backend. You'll update a book with an update book operation. Following the demo, you will learn to use the PUT method with JSON.  FREE ACCESS
• 11.  Deleting Data in a MySQL Database
  3m 18s
  In this video, you will learn one last API. This is the delete operation. Following the demo, you will learn the delete method to remove a record from the database.  FREE ACCESS
• 12.  Using the Envelope Parameter to Wrap JSON Responses
  10m
  In this video, you will see how to use output fields in Flask-RESTful to customize fields. It is important to customize fields for your customer. You will use the envelope parameters to structure the JSON response to the user. FREE ACCESS
• 13.  Renaming and Formatting Response Fields in JSON
  5m 4s
  In this video, you will learn to change field names. The demo will show you how to configure JSON responses with special display names. You will use the Advanced Rest Client to return JSON responses.  FREE ACCESS
• 14.  Working with JSON Response Default Values and URLs
  9m 15s
  In this video, you will learn to specify nested fields and URL paths within JSON responses. Next, you will learn how to make tweaks to your existing code. Finally, you will learn to customize fields to update your URL. FREE ACCESS
• 15.  Creating Custom Fields in JSON Responses
  6m 53s
  In this video, you will learn to create customs in JSON responses. You'll discover that these custom fields have values derived from other fields. FREE ACCESS
• 16.  Creating Custom Parsing and Mapping Errors
  9m 23s
  In this video, you will learn to create custom error messages for specific error handling using MySQL Database and Flask-RESTful. You'll learn to use the request parser to perform custom parsing as specified by the user. FREE ACCESS
• 17.  Course Summary
  2m 20s
  This video summarizes what you've learned in the course. You've explored the creation of APIs to perform CRUD operations. You installed MySQL, the MySQL Workbench, Python SQLAlchemy, and created a Python table. You learned to create tables, use the REST client to test APIs, and learned to query. You also integrated the API server with the MySQL database. Finally, you discovered how to configure and format output fields and configure custom error codes.  FREE ACCESS