Feb. 6 AP CSP Spot Check (SCRAPPED DRAFT - DO NOT GRADE)

[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
  • [x] Show Style that supports Login/Signup formatting
  • [x] Show JavaScript code that performs Fetch

(Login)

(Signup)

(CRUD operations (Admin) Page): Fetch DB Users for Table

• [ ] In Browser/Jupyter demo…
  • [ ] Demo Login success
  • If user credentials are defined Admin credentials, redirect to CRUD operations Page
  • If user credentials exist in DB but aren't Admin, redirect to 403 Unauthorized Page
  • [ ] Demo Login failure
  • If user credentials don't exist in DB, redirect to Signup Page (so you can create user in DB)

Score:

• 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 (Admin/CRUD operations Page is named "crud.html")
  • [x] Show code that shows implementation of roles
  • [x] Show code that captures error handling on 403

• [ ] In Browser/Jupyter demo…

  • [ ] Demo Login success redirecting to table/data page
  • Use defined (role) Admin credentials: Tucker, Gol, 2007
  • [ ] Show in split screen, login success with cookie on redirected page
  • Show "Application" area in Inspect Element
    • Token when logging in
  • [ ] Demo Login success to a page that requires advanced role
  • This is same as Login success: the user with an Admin role (credentials Tucker, Gol, 2007) is the only user in the database redirected to CRUD operations page
  • [ ] Demo Login failure related in insufficient role
  • Contrasts to Login success: users attempting to login with credentials that are already in the database but aren't Admin are redirected to 403, but users attempting to login with credentials not already in the database are redirected to SIgnup

Score:

• 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

Fetch users from DB to display in table

Fetch to delete users from DB by user ID (DELETE)

Fetch to edit users by user ID (PUT)

Fetch to create/add users to DB from CRUD page like Signup (POST)

• [x] Show JavaScript code that handles Response and formats data

Fetches user DB data to display and format DB data into table

• [x] Show code that supports HTML, HTML generation, and Style
  • HTML supported by content structuring forms
  • HTML generated by JavaScript, interactions
    • Ex:
  • [ ] In Browser/Jupyter demo…
• [ ] Demo Fetch Action for Create/Post
  • 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

Score: