Torin Wolff || CSP Spot Check || P2

[TDWolff]

Torin Wolff || Jan 31

• [x] Show db.Column changes you have made to model/python file in Visual Studio Code

  • [x] Show initialization data code in VSCode
  • [x] Demo delete database and run ./migrate.sh
  • [x] Demo corresponding schema change in SQLite3
  • [x] Demo initialization data captured in Column in SQLite3

• [x] postman with /authentication screen

  • [x] Show /authenticate endpoint code in Visual Studio Code
  • [x] Show and Demo /authenticate in Postman…
  • [x] Demo calling to endpoint
  • [x] Show JSON data passed in call
  • [x] Show Response window
  • [x] Show Cookie acquired window
  • [x] Cut/Copy/Paste Cookie into jwt.io and show decrypting payload

• [x] postman with /api screen to access data under authentication

  • [x] Show /api CRUD code in Visual Studio Code, expecting READ/GET code
  • [x] Show and Demo /api READ/GET endpoint in Postman…
  • [x] Demo calling to endpoint that requires Cookie

• [x] Show Response/Data

• [x] Demo Deleting cookie

• [x] Demo calling endpoint again

• [x] Show Response/Failure Individuals will be asked to demonstrate the following ... Feb 5 (Delayed)

• [x] jupyter notebook or web page that shows signup and login, focus on login

• [x] jupyter notebook or web page that shows redirect or 403 error as result of signup and login page, focus on redirect to - [ ] - [ ] data/table display or failure

• [x] jupyter notebook that shows CRUD operation on page that requires authentication, or this can include signup without - [ ] - [ ] authentication

Quiz instructions Each student will present in live review the following information on screen Use Issue to verbally capture progress for Instruction provided by Teacher Prepare an on Screen answer of questions. For instance...

• [x] Visual Studio Code List
• [x] Browser interaction
• [x] Postman interaction
• [x] SQLite3 visual
• [x] Terminal commands etc Talking during Spot Check with Teacher should be minimal, just Show or Demo as requested Be sure to prepare Issue in the process of preparing and answering questions as you will submit Issue with final score. Issue instructions Screen capture and record results of each question in a personal ISSUE. Teacher will be reviewing time stamps on each question.

Questions New Comment in Issue Questions Score: 1.9/2 (Check Comments for each score)

Question 1: database, with database schema change

• [x] Record Check Marks
• [x] Provide Screen Capture(s)
• [x] New Comment in Issue

Question 2: postman with /authentication screen

• [x] Record Check Marks
  • [x] Provide Screen Capture(s)
• [x] New Comment in Issue

Question 3: postman with /api screen to access data under authentication

• [x] Record Check Marks
• [x] Provide Screen Capture(s)
  • [x] Comment/Post Issue to this Page

After 5th period TODAY, link your Personal ISSUE to this CSP Spot Check issue. Comment/Post contains…


[TDWolff]

Question 1: (Score: 0.95/1) Schema Change in the sqlite.db file

And on the website:

[TDWolff]

Question 2: (Score: 0.95/1) Authentication Screen for sqlite.db in postman

[TDWolff]

Question 3: (Score: 0.95/1) Postman /api/users/ endpoint after authentication:

Additionally Cookie is here too:

With JWT Authenticated

cation