david125tran/Flask_REST_API_MySQL

Flask_REST_API_MySQL

This project is a Flask REST Web API attached to a MySQL relational database that can perform CRUD operations to the database.

URLs:

Index URL: http://localhost:5000/
Create / Post: http://localhost:5000/create/name
Read / Get: http://localhost:5000/read/id
Update / Put: http://localhost:5000//update/id/name
Delete: http://localhost:5000/delete/id

MySQL:

I start by creating a database (database.sql file) and table within MySQL. This will house my data from the API.

Index:

Create Functionality:

Add an entry named Layla which is automatically appended to the end of the list of entries with the correct ascending id.

Read Functionality:

Read "id" 2.

Update Functionality:

Update "id" 2 to Shelby.

Delete Functionality:

Delete "id" 2. Once an entry is removed, all of the remaining entries become updated with the correct ascending id.