Skip to content

Merge Dev To Master 2023-09-15 #78

Merge Dev To Master 2023-09-15

Merge Dev To Master 2023-09-15 #78

name: Test Postgres and MySQL schemas
on:
schedule:
- cron: '0 0 * * *'
workflow_dispatch:
pull_request:
paths:
- packages/cli/src/databases/migrations/**
jobs:
test:
runs-on: ubuntu-latest
timeout-minutes: 60
env:
DB_MYSQLDB_PASSWORD: password
DB_POSTGRESDB_PASSWORD: password
steps:
- uses: actions/[email protected]
- uses: pnpm/[email protected]
- uses: actions/[email protected]
with:
node-version: 18.x
cache: 'pnpm'
- name: Install dependencies
run: pnpm install --frozen-lockfile
- name: Start MySQL & Postgres
uses: isbang/[email protected]
with:
compose-file: ./.github/docker-compose.yml
- name: Build Core, Workflow, and CLI
run: pnpm --filter @n8n/client-oauth2 --filter n8n-workflow --filter n8n-core --filter n8n build
- name: Test MySQL
working-directory: packages/cli
run: DB_TABLE_PREFIX=test_ pnpm test:mysql
- name: Test Postgres
working-directory: packages/cli
run: DB_POSTGRESDB_SCHEMA=alt_schema DB_TABLE_PREFIX=test_ pnpm test:postgres
- name: Notify Slack on failure
uses: act10ns/[email protected]
if: failure()
with:
status: ${{ job.status }}
channel: '#updates-build-alerts'
webhook-url: ${{ secrets.SLACK_WEBHOOK_URL }}
message: Postgres or MySQL tests failed (${{ github.server_url }}/${{ github.repository }}/actions/runs/${{ github.run_id }})