From VSCode using SQLite3 Editor, show your unique collection/table in database, display rows and columns in the table of the SQLite database.
This is our data table for our user data.
From VSCode model, show your unique code that was created to initialize table and create test data.
This is the model used to generate user test data and the admin account into an sql file.
In VSCode using Debugger, show a list as extracted from database as Python objects.
Data is separated from body into variables.
In VSCode use Debugger and list, show two distinct example examples of dictionaries, show Keys/Values using debugger.
Returning data in dictionary, and setting up data with dictionaries and multiple key value pairs.
In VSCode, show Python API code definition for request and response using GET, POST, UPDATE methods. Discuss algorithmic condition used to direct request to appropriate Python method based on request method.
On webpage, multiple different actions lead to different outcomes. For example, updating data and submitting images uses put, while logging in uses post.
In VSCode, show algorithmic conditions used to validate data on a POST condition.
Data is checked to be long enough and exists so the post request can go through.
In Postman, show URL request and Body requirements for GET, POST, and UPDATE methods.
Body needed in login/signup system
In Postman, show the JSON response data for 200 success conditions on GET, POST, and UPDATE methods.
JSON response shows success message, from 200 status
In Postman, show the JSON response for error for 400 when missing body on a POST request.
When the body is either not there, or too short, the api returns a 400 error.
In Postman, show the JSON response for error for 404 when providing an unknown user ID to a UPDATE request.
When logging in, message user not found is returned if the user isn’t in the database.
In Chrome inspect, show response of JSON objects from fetch of GET, POST, and UPDATE methods.
After login, api returns responses and data into console.
In the Chrome browser, show a demo (GET) of obtaining an Array of JSON objects that are formatted into the browsers screen.
Data page shows all user data in a formatted table.
In JavaScript code, describe fetch and method that obtained the Array of JSON objects.
Code below gets all user data from backend, and formats it into a table
In JavaScript code, show code that performs iteration and formatting of data into HTML.
In the Chrome browser, show a demo (POST or UPDATE) gathering and sending input and receiving a response that show update. Repeat this demo showing both success and failure.
In JavaScript code, show and describe code that handles success. Describe how code shows success to the user in the Chrome Browser screen. The code takes the user’s data and send its to the api to confirm whether the user has access. If the user is authorized in the database, it sends a positive response back to the frontend, which is interpreted as a goahead to chance the data, sending another request to the backend to update the data.
In JavaScript code, show and describe code that handles failure. Describe how the code shows failure to the user in the Chrome Browser screen. The code takes the user’s data and send its to the api to confirm whether the user has access. If the user is not authorized in the database, it sends a negative response back to the frontend, which is interpreted, and the frontend does not send a request to the backend to change the data.