Skip to content

Latest commit

 

History

History
85 lines (64 loc) · 2.56 KB

README.md

File metadata and controls

85 lines (64 loc) · 2.56 KB

database-project

To View Our Site

  • Clone our repo
  • Do npm install in your terminal
  • Do run devStart, once the server is running...
  • Go to localhost:8000 on your browser

To login try using: email: [email protected] || [email protected] || [email protected] || [email protected] password: name123 (the name of the user)

Objective

Build a platform for writing and sharing reviews of coding resources.

User stories:

  • I can log in.
  • I can see a list of recent reviews.
  • I can see a list of reviewed resources.
  • I can create, edit and view my own reviews.
  • I can see a list of reviews of a particular resource.
  • I can click on a listed review to read it.
  • (optional extra) I can see a list of reviews by a particular user.

Focus on getting this functionality rather than making the frontend look good. Build your endpoints first.

Endpoints

  • I can log in. (/login)
  • I can see a list of recent reviews. (/reviews/recent on the landing page)
  • I can see a list of reviewed resources. (/resources?reviewed=true)
  • I can create, (edit) and view my own reviews. (/reviews)
  • I can see a list of reviews of a particular resource. (resources/{resource_id})
  • I can click on a listed review to read it. (/resources/{resource_id})

Database

Table 1: Users

name value type
user_id 1 PRIMARY KEY
first_name Jo string
last_name Bloggs string
email [email protected] string
password h3Llo string

Table 2: Resources

name type
resource_id PRIMARY KEY
url string
title string
img string
intro string varchar(100)

Table 3: Reviews

name type
review_id PRIMARY KEY
title string
rating integer
content string
created_at time stamp
modified_at time stamp

Table 4 User Reviews:

name type
ur_id PRIMARY KEY
review_id FOREIGN KEY
user_id FOREIGN KEY
resource_id FOREIGN KEY

Stretch Goals

  • Create new users
  • Add nice styling to the frontend
  • Nightwatch testing