e2e-pipeline.yml

#
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements.  See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License.  You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#

name: E2E - Pipeline

on:
  push:
    branches: [ master, dev ]
    paths:
      - '.github/workflows/e2e-pipeline.yml'
      - 'infra/**/src/main/**'
      - 'mode/**/src/main/**'
      - 'features/encrypt/src/main/**'
      - 'features/features/readwrite-splitting/src/main/**'
      - 'features/sharding/src/main/**'
      - 'proxy/**/src/main/**'
      - 'jdbc/core/src/main/**'
      - '**/*-distsql*/**/src/main/**'
      - 'kernel/data-pipeline/**/src/main/**'
      - 'kernel/data-pipeline/**/pom.xml'
      - '**/src/main/**/data/pipeline/**'
      - '**/src/main/resources/META-INF/services/*.data.pipeline.*'
      - '!test/**'
      - 'test/pom.xml'
      - 'test/e2e/fixture/**'
      - 'test/e2e/env/**'
      - 'test/e2e/operation/pipeline/**'
      - '!*.md'
  pull_request:
    branches: [ master ]
    paths:
      - '.github/workflows/e2e-pipeline.yml'
      - 'infra/**/src/main/**'
      - 'mode/**/src/main/**'
      - 'features/encrypt/src/main/**'
      - 'features/features/readwrite-splitting/src/main/**'
      - 'features/sharding/src/main/**'
      - 'proxy/**/src/main/**'
      - 'jdbc/core/src/main/**'
      - '**/*-distsql*/**/src/main/**'
      - 'kernel/data-pipeline/**/src/main/**'
      - 'kernel/data-pipeline/**/pom.xml'
      - '**/src/main/**/data/pipeline/**'
      - '**/src/main/resources/META-INF/services/*.data.pipeline.*'
      - '!test/**'
      - 'test/pom.xml'
      - 'test/e2e/fixture/**'
      - 'test/e2e/env/**'
      - 'test/e2e/operation/pipeline/**'
      - '!*.md'
  schedule:
    - cron: '0 22 */1 * *'  # once a day. UTC time
  workflow_dispatch:

concurrency:
  group: e2e-pipeline-${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

env:
  MAVEN_OPTS: -Dhttp.keepAlive=false -Dmaven.wagon.http.pool=false -Dmaven.wagon.http.retryHandler.class=standard -Dmaven.wagon.http.retryHandler.count=3 -Dmaven.javadoc.skip=true -Dcheckstyle.skip=true -Dspotless.apply.skip=true -Djacoco.skip=true -Dfailsafe.skipAfterFailureCount=1 -Dio.netty.leakDetectionLevel=advanced
  REPOSITORY_NAME: shardingsphere

jobs:
  pipeline:
    if: (github.event_name != 'schedule')
    name: E2E - Pipeline
    runs-on: ubuntu-latest
    env:
      postgresql_version: postgres:12-alpine
      mysql_version: mysql:5.7
      opengauss_version: enmotech/opengauss:2.1.0
    timeout-minutes: 40
    steps:
      - uses: actions/checkout@v3
      - name: Cache Maven Repos
        uses: actions/cache@v3
        with:
          path: ~/.m2/repository
          key: ${{ env.REPOSITORY_NAME }}-maven-third-party-e2e-cache-${{ github.sha }}
          restore-keys: |
            ${{ env.REPOSITORY_NAME }}-maven-third-party-e2e-cache-
            ${{ env.REPOSITORY_NAME }}-maven-third-party-
      - name: Set up JDK 11
        uses: actions/setup-java@v3
        with:
          distribution: 'temurin'
          java-version: 11
      - name: Build Pipeline E2E image
        run: ./mvnw -B clean install -am -pl test/e2e/operation/pipeline -Pit.env.docker -DskipTests
      - name: Setup JDK 8 for Test
        uses: actions/setup-java@v3
        with:
          distribution: 'temurin'
          java-version: 8
      - name: Run Pipeline MySQL E2E Test
        run: ./mvnw -nsu -B install -f test/e2e/operation/pipeline/pom.xml -Dpipeline.it.env.type=docker -Dpipeline.it.docker.mysql.version=${{ env.mysql_version }}
      - name: Run Pipeline PostgreSQL E2E Test
        run: ./mvnw -nsu -B install -f test/e2e/operation/pipeline/pom.xml -Dpipeline.it.env.type=docker -Dpipeline.it.docker.postgresql.version=${{ env.postgresql_version }}
      - name: Run Pipeline openGauss E2E Test
        run: ./mvnw -nsu -B install -f test/e2e/operation/pipeline/pom.xml -Dpipeline.it.env.type=docker -Dpipeline.it.docker.opengauss.version=${{ env.opengauss_version }}

  daily-pipeline:
    if: (github.event_name == 'schedule' && github.repository == 'apache/shardingsphere')
    name: Nightly - E2E - Pipeline
    runs-on: ubuntu-latest
    env:
      postgresql_version: postgres:10-alpine,postgres:11-alpine,postgres:12-alpine,postgres:13-alpine,postgres:14-alpine
      mysql_version: mysql:5.7,mysql:8.0
      opengauss_version: enmotech/opengauss:2.1.0,enmotech/opengauss:3.0.0
    timeout-minutes: 60
    steps:
      - uses: actions/checkout@v3
      - name: Cache Maven Repos
        uses: actions/cache@v3
        with:
          path: ~/.m2/repository
          key: ${{ env.REPOSITORY_NAME }}-maven-third-party-e2e-cache-${{ github.sha }}
          restore-keys: |
            ${{ env.REPOSITORY_NAME }}-maven-third-party-e2e-cache-
            ${{ env.REPOSITORY_NAME }}-maven-third-party-
      - name: Set up JDK 11
        uses: actions/setup-java@v3
        with:
          distribution: 'temurin'
          java-version: 11
      - name: Build Pipeline E2E image
        run: ./mvnw -B clean install -am -pl test/e2e/operation/pipeline -Pit.env.docker -DskipTests
      - name: Setup JDK 8 for Test
        uses: actions/setup-java@v3
        with:
          distribution: 'temurin'
          java-version: 8
      - name: Run Pipeline Daily MySQL E2E Test
        run: ./mvnw -nsu -B install -f test/e2e/operation/pipeline/pom.xml -Dpipeline.it.env.type=docker -Dpipeline.it.docker.mysql.version=${{ env.mysql_version }}
      - name: Run Pipeline Daily PostgreSQL E2E Test
        run: ./mvnw -nsu -B install -f test/e2e/operation/pipeline/pom.xml -Dpipeline.it.env.type=docker -Dpipeline.it.docker.postgresql.version=${{ env.postgresql_version }}
      - name: Run Pipeline Daily openGauss E2E Test
        run: ./mvnw -nsu -B install -f test/e2e/operation/pipeline/pom.xml -Dpipeline.it.env.type=docker -Dpipeline.it.docker.opengauss.version=${{ env.opengauss_version }}