Using docker-compose for Postgres

db.js

const Sequelize = require("sequelize");

const sequelize = new Sequelize("postgres://user:pass@localhost:5432/codeworks");

sequelize.authenticate().then(() => {
  console.log("connected to database");
}).catch(() => {
  console.error("failed to connect to database");
})

docker-compose.yml

# run this with `docker-compose up -d`
db:
  image: postgres
  ports:
    - "5432:5432"
  environment:
    - POSTGRES_USER=user
    - POSTGRES_PASSWORD=pass
    - POSTGRES_DB=codeworks

push.yml

# put this filein the Github Workflows dir: `.github/workflows/push.yml`
name: Node.js CI

on: [push]

jobs:
  build:

    runs-on: ubuntu-latest

    strategy:
      matrix:
        node-version: [10.x]

    steps:
      - uses: actions/checkout@v2
      - name: Use Node.js ${{ matrix.node-version }}
        uses: actions/setup-node@v1
        with:
          node-version: ${{ matrix.node-version }}
      - name: Build the docker-compose stack
        run: docker-compose up -d
      - run: npm ci
      - run: npm run build --if-present
      - run: npm run lint
      - run: npm test