Users Database Spot Check

[iwu78]

Ian Wu Period 5 Score: 1.85/2 (If 3 scores above 0.9 = 2 applies then 2/2) Q1: 0.92 Q2: 0.91 Q3: 0.93

[iwu78]

Q1: database with database change SCORE: 0.92

• [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 (result after running migrate.sh is below)

  

• [x] Demo initialization data captured in Column in SQLite3 (see above image)

[iwu78]

Q2: postman with /authentication screen SCORE; 0.91/1

• [x] Show /authenticate endpoint code in Visual Studio Code

  

• [x] Show and Demo /authenticate in Postman…

  

• [x] Demo calling to endpoint (see above)

• [x] Show JSON data passed in call (see payload with uid and password in the center above)

• [x] Show Response window (see body part on the bottom above)

• [x] Show Cookie acquired window

  

• [x] Cut/Copy/Paste Cookie into jwt.io and show decrypting payload

  

[iwu78]

Q3: postman with /api screen to access data under authentication SCORE: 0.93/1

• [ ] 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 (see above)

• [ ] Show Response/Data (see above)

• [ ] Demo Deleting cookie

  

• [ ] Demo calling endpoint again

  

• [ ] Show Response/Failure (see above)