github-actions-demo.yml

name: PostgreSQL service to run the Tests
on:
  push:
    branches: [main]
  pull_request:
    branches: [main]

jobs:
  # Label of the container job
  container-job:
    # Containers must run in Linux based operating systems
    runs-on: ubuntu-latest
    # Docker Hub image that `container-job` executes in
    strategy:
      matrix:
        node: [16]

    name: Node ${{ matrix.node }} sample

  # Service containers to run with `container-job`
    services:
      # Label used to access the service container
      postgres:
        # Docker Hub image
        image: postgres:13-alpine
        # Provide the password for postgres
        env:
          POSTGRES_PASSWORD: root123
          POSTGRES_USER: menumingle_test_user
          POSTGRES_DB: menumingle_test

        # Set health checks to wait until postgres has started
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
        ports:
          - 5432:5432
    steps:

      # Downloads a copy of the code in your repository before running CI tests

      - name: Check out repository code

        uses: actions/checkout@v3


      - name: Use Node.js

        uses: actions/setup-node@v3

        with:

          node-version: ${{ matrix.node }}

      # Performs a clean installation of all dependencies in the `package.json` file

      # For more information, see https://docs.npmjs.com/cli/ci.html

      - name: Install dependencies

        run: npm i

      - name: Connect to PostgreSQL

        # Runs a script that creates a PostgreSQL table, populates

        # the table with data, and then retrieves the data.

        run: npm run test

        # Environments variables.

        env:

          DEV_DB_URL: ${{ secrets.DEV_DB_URL }}
          TEST_DB_URL: ${{ secrets.TEST_DB_URL }}
          PRODUCTION_DB_URL: ${{ secrets.PRODUCTION_DB_URL }}
          JWT_SECRET: ${{ secrets.JWT_SECRET }}