trevorhuang1 / csp_blog

Other
0 stars 0 forks source link

csp spot check - Trevor Huang P2 #3

Open trevorhuang1 opened 8 months ago

trevorhuang1 commented 8 months ago

My score: 0.90 + 0.90 + 0.90 = 2.70/3.00

Individuals will be asked to demonstrate the following ...

Jan 31

  • database, with database schema change

    • [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
  • 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

  • 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)

  • jupyter notebook or web page that shows signup and login, focus on login
  • 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
  • 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...

    • Visual Studio Code List
    • Browser interaction
    • Postman interaction
    • SQLite3 visual
    • 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.

Issue Heading

  • [ ] Name, Period, Score. (John Mortensen, P2, 1..75)
  • [ ] All Scores (e.g. Q1: 8.5, Q2: 9, Q3: 5.5)
  • [ ] Top 4 Score Total (e.g. Q1: 8.5 + Q2: 9 = 1.75 of 2.0 )

New Comment in Issue

  • [ ] Question 1: database, with database schema change
  • [ ] Record Check Marks
  • [ ] Provide Screen Capture(s)

New Comment in Issue

  • [ ] Question 2: postman with /authentication screen
  • [ ] Record Check Marks
  • [ ] Provide Screen Capture(s)

New Comment in Issue

  • [ ] Question 3: postman with /api screen to access data under authentication
  • [ ] Record Check Marks
  • [ ] Provide Screen Capture(s)

Comment/Post Issue to this Page

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


  • [ ] Name (e.g. John Mortensen)
  • [ ] Period (e.g. Period 2)
  • [ ] Sum of Score (e.g. 1.75 of 2.0), three scores .9 or above gets a 2.0 of 2.0
  • [ ] Link to Issue
trevorhuang1 commented 8 months ago

database, with database schema change: Score 0.90

db.Column change image

Initialization data code image

Main.py is where the the function is called image

Other checkpoints that required a demo were demoed to Mr. Mortensen

trevorhuang1 commented 8 months ago

Postman with /authentication screen Score 0.90

backend image when the user sends a post request to authenticate it checks whether or not the uid/password match image

frontend where the url is accessed with POST request image

postman calling to endpoint and authenticated image

jwt cookie acquired image

payload on jwt.io image

trevorhuang1 commented 8 months ago

postman with /api screen to access data under authentication Score: 0.90

CRUD on /api image image

Reading the data for authentication image

jm1021 commented 8 months ago

Very well done, I remember our conversations. Only request would be to show or capture SQLite screen in the above.