Skip to content

Nom Nom. An app to leave reviews on our favourite restaurants in London!

Notifications You must be signed in to change notification settings

fac-23/week2-database-team2

Repository files navigation

🔗 Visit the live site

How to install

Local Database Setup

  • In your terminal

    • run chmod +x ./scripts/create_db
    • run chmod +x ./scripts/populate_db
    • run ./scripts/create_db <name of your local database>
    • run ./scripts/populate_db
    • run psql
    • run \connect <name of your local database>
    • run \dt to check the tables are there. There should be only one table named "reviews"
  • To start sever run command npm run dev

  • For cypress testing run command npm run test

  • Access locally on localhost:3000

User stories

  • As a user, I want to: submit information to your site for anyone to see
  • As a user, I want to: come back to your site later and see what I posted is still there

Since this project is open-ended you’ll need to write your own more specific user stories once you know what you want to build.

Acceptance Criteria

  • A form for users to submit data
  • A page showing all the data
  • Semantic form elements with correctly associated labels
  • A Postgres database hosted on Heroku
  • A schema describing your database in your README
  • Tests for server routes and database access
  • Not process user input as SQL commands
  • Hidden environment variables (i.e. not on GitHub)

Stretch criteria

  • A way to view filtered/sorted data, instead of just all of it
  • GitHub Actions CI setup to run your tests when you push

Roles:

  • Scrum Facilitator and UX Design - Paolo
  • DevOps - Juliette
  • Quality Assurance - Orian

Project Set up:

  • Connect local and remote repos
  • Create project set up branch
  • Actualize npm directory and install express and cypress
  • Set up database, deploy on Heroku and connect to directory

About

Nom Nom. An app to leave reviews on our favourite restaurants in London!

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published