Data Structure Write Up

Blog Python Model code and SQLite Database.

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

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

Lists and Dictionary

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

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

Blog Python API code and use of Postman to request and respond with JSON.

  • 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

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

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

    -> Message, likes, and cookies required for POST request image

  • Cookies required for GET request image

    • Message required for update method so the original message can be found

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

    -> New message is returned

image

  • In Postman, show the JSON response for error for 400 when missing body on a POST request. image

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

Blog JavaScript API fetch code and formatting code to display JSON.

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

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

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

  • In JavaScript code, show and describe code that handles failure. Describe how the code shows failure to the user in the Chrome Browser screen. image