reservations-component

PostgreSQL Installation Instructions

1. Install PostgreSQL through brew:

$ brew install postgresql

2. Initialize the database

$ initdb /usr/local/var/postgres

3. In order to start the PostgreSQL server, run:

$ pg_ctl -D /usr/local/var/postgres start

Later, if you want to stop the PostgreSQL server, run:

$ pg_ctl -D /usr/local/var/postgres stop

4. Create a user:

$ createuser mark_pg

Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) n
Shall the new role be allowed to create more new roles? (y/n) n

5. Create a database named "silverspoon", owned by the new user

$ createdb -Omark_pg -Eutf8 silverspoon

psql console

Login to the psql administrative console:

$ psql -U mark_pg silverspoon

The psql prompt looks like this.

silverspoon->

List of useful psql commands

\?   // help
\q   // quit
\l   // list databases
\dt  // show tables
\dt <name>
\i <filename> // run filename with commands
select * from restaurants;
select * from reservations;

Reservations Component Setup

6. git clone the repository from Github.

7. Download and install dependencies:

$ cd reservations-component
$ npm install

8. Update the included example.env file with relevant settings & rename to .env

9. Seed the database with data:

$ npm run seed

> node ./server/db/seed.js

migration complete, loading restaurant data
restaurant data complete, loading reservations
Generated 3866 reservations for 2018-03-02
Generated 3840 reservations for 2018-03-03
Generated 3763 reservations for 2018-03-04
Generated 3794 reservations for 2018-03-05
Generated 3749 reservations for 2018-03-06
Generated 3778 reservations for 2018-03-07
Generated 3836 reservations for 2018-03-08
reservations complete
closing connections
pg client end

10. Run the development server:

$ npm run server-dev

11. The component should now be available from:

http://localhost:3001/

Other npm commands:

npm test                  // run jest test suite
npm run test:watch        // run jest in watch mode
npm run test:coverage     // generate test coverage report
npm run build             // run webpack build
npm run build:prod        // create a production bundle.js
npm run build:watch       // run webpack in watch mode
npm run lint              // run ESLint