gvankeerberghen/ht_backend_node_pg_express

A basic REST api for the ht app, containing routes for users, technologies, votes and links.

HT backend using node, express, sequelize and postgres

A simple REST api for the ht app, containing routes for users, technologies votes and links.

Scaffolded following scotch.io tutorial with correction for sequelize v4.

How to

Start the server for dev

Assumes a postgres db is running according to config, otherwise see how to start a dev db

npm run start:dev

Migrate db if needed (assumes sequelize cli globally installed)

sequelize db:migrate

Seed data if needed (assumes sequelize cli globally installed)

sequelize db:seed:all

Start a dev db using docker

Start a postgres container

docker run -p5432:5432 --name ht_postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres

Connect to the db

docker run -it --link ht_postgres:postgres postgres psql -h postgres -U postgres

Create user and db

CREATE USER ht_backend;
ALTER USER ht_backend WITH PASSWORD 'devpassword';

CREATE DATABASE ht_db;
GRANT ALL PRIVILEGES ON DATABASE ht_db TO ht_backend;

You should now be able to connect to ht_db as ht_backend,

docker run -it --link ht_postgres:postgres postgres psql -h postgres -U ht_backend -d ht_db

Todos

• secure: ensure only the 'right users' are acknowledged and that all routes require the user to be logged in
• define and add permissions, which users shall be able to edit / delete votes, links and reviews?
• address different error types and return correct response codes
• add tests, unit and / or e2e at least