CSP Spot Check

[AnvayYadav]

CSP Spot Check

My scores were slightly reduced as I presented one day late.

Question 1 - 0.87 Question 2 - 0.86 Question 3 - 0.82

Best 2 = (0.87 + 0.86)/(1+1) = 1.73/1

[AnvayYadav]

Question 1: database, with database schema change

• Show db.Column changes you have made to model/python file in Visual Studio Code
  • Show initialization data code in VSCode

• Demo delete database and run ./migrate.sh

• Demo corresponding schema change in SQLite3 The added users gone

• Demo initialization data captured in Column in SQLite3

[AnvayYadav]

Question 2: postman with /authentication screen

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

[AnvayYadav]

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

• Show /api CRUD code in Visual Studio Code, expecting READ/GET code
  • Show and Demo /api READ/GET endpoint in Postman…
  • Demo calling to endpoint that requires Cookie
• Show Response/Data
• Demo Deleting cookie
  • Demo calling endpoint again
  • Show Response/Failure