Week6_project_login

full stack project with user authentication

General purpose

Create a login App using a database and express. Our week project employs the use of cookies and jwts (using the npm module jsonwebtoken) to maintain a logged in state through different pages. Via a database, the username and password are stored and verified as correct using the bcryptjs npm module upon login. Coding will be assign to 2 different teams: front-end and back-end. Development will be TDD on both client and server side.

User stories

As a user I want to:

• login to my profile(see user example).
• add a new post on the timeline.

Wireframe

Setup 💻

• clone Repo
• create a postrgres DB importing our db_schema.sql & db_data.sql
• "npm i" or "npm install"
• run with "npm run dev" for local testing

Try it on Heroku!

• user example: [email protected]
• password example: iannis

Stretch goals

• edit posts.
• delete the posts.
• like posts.

Repository structure

• server.js
• public -front end team
• src
  • router.js
  • handler.js (could several files)
  • database
    • db_connection.js
    • db_populate.js
    • db_schema.sql
    • db_data.sql
  • queries
• test

Database schema

2 tables:

• users
  • id (auto incremental)
  • username
  • email
  • PASSWORD
• posts
  • id (auto incremental)
  • title
  • content
  • like BOOLEAN
  • FOREIGN KEY (user_id) REFERENCES users (id)