Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a new model and table, users, by running a migration that includes the following columns: UserId, FirstName, LastName, Email, Username, Password, Admin Tip! The

Create a new model and table, users, by running a migration that includes the following columns: UserId, FirstName, LastName, Email, Username, Password, Admin Tip! The Admin column should be a boolean with a default value of false. To update users to be an admin, update them within MySQL Workbench itself. You need at least one user in your users table that is an Admin. To check if a user is an admin in your express routes you can use user.admin. Don't forget to create the users model The createdAt and updatedAt columns will be created automatically Step 3 Add the routes of the following: User signup: /users/signup User login: /users/login Show user profile: /users/profile Show a list of users: /users Show a specific user: /users/:id Delete user: /users/:id Step 4 Use passport's local strategy so only the user sees their profile in the /users/profile route and can see other users profiles when they use the /users/:id route. Don't forget the installations needed when working with Passport Step 5 Allow the Admin users to be able to view a list of all users You will need to update your database to include at least one Admin user Use the route of / to see the list of users by their name Hint! Remember the / route in the users.js file will be localhost:3000/users as was set up in app.js If an unauthorized user tries to access this route, send them a message that they are not authorized to access the page. Use the Admin property on your logged in user to determine if they should be allowed access to all users. Step 6 Allow the Admin users to be able to click on and view a specific user. Use the route of /users/:id Step 7 Allow the Admin users to be able to delete users from the database. If a user is not an admin, they should not be able to delete users. Remember to only update the users to have a column of Deleted set to true when "deleted" You will need to run another migration to add the column of Deleted to the database.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Conceptual Database Design An Entity Relationship Approach

Authors: Carol Batini, Stefano Ceri, Shamkant B. Navathe

1st Edition

ISBN: 0805302441, 978-0805302448

More Books

Students also viewed these Databases questions