Write Up

From VSCode using SQLite3 Editor, show your unique collection/table in database, display rows and columns in the table of the SQLite database. image

This screenshots demonstrates the data being stored in a table within an SQLite database. It demonstrates the rows and columns in the table of the SQLite database and how there is data being stored within the table. The table is called “users” and it has columns for “id”, “username”, and “password”.

In VSCode using Debugger, show a list as extracted from database as Python objects. image

This screenshot demonstrates a list that comes from the VSCode debugger. It shows the list as extracted from the database as Python objects. The list is a list of dictionaries that contain the data from the database.

From VSCode model, show your unique code that was created to initialize table and create test data. image

This screenshot demonstrates the code that initializes the table and creates test data. It shows the code that was created to initialize the table and create test data. The code is written in Python and uses the SQLite3 library to interact with the database.

In VSCode use Debugger and list, show two distinct example examples of dictionaries, show Keys/Values using debugger. image

This screenshot demonstrates two distinct examples of dictionaries. It shows the keys and values using the debugger. The dictionaries are used to store data from the database and are used to interact with the database.

In VSCode, show algorithmic conditions used to validate data on a POST condition. image

This screenshot demonstrates the algorithmic conditions used to validate data on a POST condition. It shows the algorithmic conditions used to validate data on a POST condition. The conditions are used to check if the data is valid before it is inserted into the database.

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. image

This screenshot demonstrates the Python API code definition for request and response using GET, POST, UPDATE methods. It discusses the algorithmic condition used to direct request to appropriate Python method based on request method. The code is used to handle requests from the client and send responses back to the client.

In Postman, show URL request and Body requirements for GET, POST, and UPDATE methods. image

This screenshot demonstrates the URL request and Body requirements for GET, POST, and UPDATE methods. It shows the URL request and Body requirements for GET, POST, and UPDATE methods. The URL request is used to specify the endpoint that the request is being sent to, and the Body requirements are used to specify the data that is being sent with the request.

In Postman, show the JSON response data for 200 success conditions on GET, POST, and UPDATE methods. image

This screenshot demonstrates the JSON response data for 200 success conditions on GET, POST, and UPDATE methods. It shows the JSON response data for 200 success conditions on GET, POST, and UPDATE methods. The JSON response data is used to send data back to the client in response to a request.

In Postman, show the JSON response for error for 404 when providing an unknown user ID to a UPDATE request. image

This screenshot demonstrates the JSON response for error for 404 when providing an unknown user ID to a UPDATE request. It shows the JSON response for error for 404 when providing an unknown user ID to a UPDATE request. The response is used to indicate that the user ID provided in the request does not exist in the database.

In Chrome inspect, show response of JSON objects from fetch of GET, POST, and UPDATE methods. image

This screenshot demonstrates the response of JSON objects from fetch of GET, POST, and UPDATE methods. It shows the response of JSON objects from fetch of GET, POST, and UPDATE methods. The response is displayed in the Chrome inspect tool and shows the data that was received from the server.

In the Chrome browser, show a demo (GET) of obtaining an Array of JSON objects that are formatted into the browsers screen. image

This screenshot demonstrates a demo (GET) of obtaining an Array of JSON objects that are formatted into the browsers screen. It shows the Array of JSON objects that are formatted into the browsers screen. The data is displayed in a table format in the browser.

In JavaScript code, show code that performs iteration and formatting of data into HTML. image

This screenshot demonstrates the JavaScript code that performs iteration and formatting of data into HTML. It shows the code that performs iteration and formatting of data into HTML. The code is used to take the data received from the server and display it in a table format in the browser.

In JavaScript code, describe fetch and method that obtained the Array of JSON objects. image

This screenshot shows the fetch and method that obtained the Array of JSON objects. It describes the fetch and method that obtained the Array of JSON objects. The fetch method is used to send a request to the server and receive a response containing the data.

In the Chrome browser, show a demo (POST or UPDATE) gathering and sending input and receiving a response that show update. Demo Success: image image

This code demonstrates a successfull login attempt. It shows the input being gathered and sent and the response that shows the update. The code is used to send a request to the server to update the data in the database.

Demo Failure:

image image

This code demonstrates a failed login attempt. It shows the input being gathered and sent and the response that shows the update. The code is used to send a request to the server to update the data in the database.

Code responsible for success: image

This is the code responsbile for the successfull login attempt. It includes the code that is being used to store that password and username and fetch them from the database. The code is used to send a request to the server to update the data in the database.

Code responsible for failure: image

This is the code responsible for the failed login attempt. It shows the redirection if the incorrect password or username is entered. The code is used to send a request to the server to update the data in the database.