search

alaraipek / Issues

0 stars 0 forks source link

CSP Spot Check #10

Open alaraipek opened 5 months ago

alaraipek commented 5 months ago

Jan 31

Database, with database schema change Score:

Show db.Column changes you have made to model/python file in Visual Studio Code image Initialization data code in VSCode image Demo delete database and run ./migrate.sh image image

Postman with /authentication screen Score:

Backend image User sends post request authenticating if the uid and password match image Frontend, URL accesses POST request image Postman Calling to Endpoint and Authenticated image JWT Cookie Acquired image Payload on jwt.io image

Postman with /api screen to access data under authentication Score:

Show /api CRUD code in Visual Studio Code, expecting READ/GET code image image Reading data for authentication image

alaraipek commented 5 months ago

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
jm1021 commented 5 months ago

I don't see SQLite3 Viewer or Postman in any of the sessions above. All of the material does not follow instructions provided or reference code that I expect. You do have UI's and CRUD operations with the UI's that would be valuable for Monday checkpoint.

alaraipek commented 5 months ago

Hi, I'm confused what I am missing for postman. How exactly does it not show what you're asking for? Also, why does my code not demonstrate what you've listed on the checklist?

jm1021 commented 5 months ago

Please review solutions that I recommended in Slack. Then we could talk about this in person.