Spot Check #2 Q1, Q2, & Q3

[alaraipek]

Live reviews will be focussed on discussing the Show elements and demonstrating the Demo elements. It is expected that ISSUE is prepared in advance, but is linked at the end of Live review day.

jupyter notebook or web page that shows signup and login, focus on login

Show HTML and JavaScript to support Login/Signup in VSCode … Show HTML that supports Login/Signup Show Style that supports Login/Signup formatting Show JavaScript Code that performs fetch Login Signup Show JavaScript code that performs Fetch

• [ ] In Browser/Jupyter demo …
• [ ] Demo Login success
  • User should be redirected to CRUD operations page if using admin credentials
  • User should be redirected to 403 Unauthorization Page if credentials exist in database but aren't admin
• [ ] Demo Login failure
  • User should be redirected to signup page if credentials don't exist in database in order to enter them into the database

[alaraipek]

• 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

  Show HTML and JavaScript to support Login/Signup failure VSCode…

  Show JavaScript that performs Fetch Show code that redirects to page on success Show code that shows implementation of roles Show code that captures error handling on 403

• [ ] In Browser/Jupyter demo…

• [ ] Demo Login success redirecting to table/data page

• Use Admin credentials (role): Tucker, Gol, 2007

• [ ] Show in split screen, login success with cookie on redirected page

• Show "Application" area in Inspect Element and token when logging in

• [ ] Demo Login success to a page that requires advanced role

• Successfully login with h an Admin role. Credentials used are the only user in the database redirected to CRUD operations page

• [ ] Demo Login failure related in insufficient role

• User attempting to login with credentials in the database but aren't Admin are redirected to 403. User attempting to login with credentials not already in the database are redirected to Signup.

[alaraipek]

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

  Show in VSCode HTML and JavaScript to support Post, Put or Delete method

  Show JavaScript that performs Fetch Fetch users from DB to display in table Fetch code for Update/Put Fetch code for Create/Post Fetch code to Delte users from database Show JavaScript code that handles Response and formats data Show code that supports HTML, HTML generation, and Style HTML generated by javascript

• [ ] In Browser/Jupyter demo…

  • [ ] Demo Fetch Action for Create/Post
  • Show new user through CRUD page and updated database in VSCode
  • Demo creating new user through CRUD web page, show updated DB in VSCode

• [ ] Demo Fetch Action for Update/Put

  • Demo editing user in DB through CRUD web page by ID, show updated DB in VSCode

• [ ] Demo Fetch Action for Delete

  • Demo deleting user in DB through CRUD web page by ID, show updated DB in VSCode In SQLite demo…

• [ ] Demo Data Before each Fetch Action

  • Open users.db before and after changes made through CRUD web page

• [ ] Demo Data After each Fetch Action

  • Open users.db before and after changes made through CRUD web page