Feb. 6 AP CSP Spot Check (ACTUAL/FINAL DRAFT)

[tuckergol]

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

• [x] Show HTML and JavaScript to support Login/Signup in VSCode…

  • [x] Show HTML that support Login/Signup

Login

Signup

• [x] Show Style that supports Login/Signup formatting

• [x] Show JavaScript code that performs Fetch

• [x] In Browser/Jupyter demo…
  • [x] Demo Login success

(Redirect to home page/current index.html)

• [x] Demo Login failure

(Invalid credentials when logging in; don't exist in database)

• 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

• [x] Show HTML and JavaScript to support Login/Signup failure VSCode…

  • [x] Show JavaScript that performs Fetch

• [x] Show code that redirects to page on success

• [x] Show code that shows implementation of roles

(Shows role of "admin")

• [x] Show code that captures error handling on 403

• [x] In Browser/Jupyter demo…
  • [x] Demo Login success redirecting to table/data page

(If user has Admin role, they can access table/database data)

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

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

(Accessing table/database data with Admin role)

• [x] Demo Login failure related in insufficient role

(What happens when user attempts to access table/database data without Admin role)

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

• [x] Show in VSCode HTML and JavaScript to support Post, Put or Delete method

  • [x] Show JavaScript that performs Fetch
  • [x] Show JavaScript code that handles Response and formats data
  • [x] Show code that supports HTML, HTML generation, and Style → View previous section(s)

• [x] In Browser/Jupyter demo…

  • [x] Demo Fetch Action for Create/Post

• [x] Demo Fetch Action for Update/Put

• [x] Demo Fetch Action for Delete

• [x] In SQLite demo…
  • [x] Demo Data Before each Fetch Action
  • [x] Demo Data After each Fetch Action → Demo editing/deleting user, demo database before and after.