CircleCI config for Testing with Sequelize

config.yml

version: 2

jobs:
  test:
    docker:
      - image: circleci/node:10.15.3
      - image: circleci/postgres:10.1

    steps:
      # Init
      - checkout

      - restore_cache:
          keys:
            - v1-cache-{{ checksum "package.json" }}
            - v1-cache-

      - run: npm install

      - save_cache:
          paths:
            - node_modules
          key: v1-cache-{{ checksum "package.json" }}

      # Test
      - run: sudo apt-get update
      - run: sudo apt install postgresql-client

      - run: psql -U postgres -h localhost -p 5432 -c "CREATE USER my_user;"
      - run: psql -U postgres -h localhost -p 5432 -c "ALTER USER my_user WITH SUPERUSER;"

      - run: npm run db:create
      - run: npm run db:migrate

      - run:
          name: Run unit tests
          command: npm run test

    environment:
      NODE_ENV: test

workflows:
  version: 2

  test:
    jobs:
      test