language: node_js
dist: bionic

before_script: |
  yarn build
  node packages/pg/script/create-test-tables.js postgresql:///

env:
  - CC=clang CXX=clang++ npm_config_clang=1 PGUSER=postgres PGDATABASE=postgres

node_js:
  - lts/dubnium
  - lts/erbium
  # node 13.7 seems to have changed behavior of async iterators exiting early on streams
  # if 13.8 still has this problem when it comes down I'll talk to the node team about the change
  # in the mean time...peg to 13.6
  - 13.6
  - 14

addons:
  postgresql: '10'

matrix:
  include:
    # Run tests/paths that require password authentication
    - node_js: lts/erbium
      env:
        - CC=clang CXX=clang++ npm_config_clang=1 PGUSER=postgres PGDATABASE=postgres PGPASSWORD=test-password SCRAM_TEST_PGUSER=scram_test SCRAM_TEST_PGPASSWORD=test4scram
      before_script: |
        sudo -u postgres sed -i \
          -e '/^local/ s/trust$/peer/' \
          -e '/^host/ s/trust$/md5/' \
          /etc/postgresql/10/main/pg_hba.conf
        sudo -u postgres psql -c "ALTER ROLE postgres PASSWORD 'test-password'; SELECT pg_reload_conf()"
        yarn build
        node packages/pg/script/create-test-tables.js postgresql:///
        sudo -u postgres -- psql \
          -c "SET password_encryption = 'scram-sha-256'" \
          -c "CREATE ROLE scram_test login password 'test4scram'"

    - node_js: lts/carbon
      addons:
        postgresql: '9.5'
      dist: precise

    # different PostgreSQL versions on Node LTS
    - node_js: lts/erbium
      addons:
        postgresql: '9.3'
    - node_js: lts/erbium
      addons:
        postgresql: '9.4'
    - node_js: lts/erbium
      addons:
        postgresql: '9.5'
    - node_js: lts/erbium
      addons:
        postgresql: '9.6'

    # PostgreSQL 9.2 only works on precise
    - node_js: lts/carbon
      addons:
        postgresql: '9.2'
      dist: precise