tests #48
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: tests | |
| on: | |
| push: | |
| pull_request: | |
| types: [opened, reopened, review_requested, synchronize] | |
| workflow_dispatch: | |
| # Run tests 10:00 PM (JST) every day | |
| schedule: | |
| - cron: '0 13 * * *' | |
| env: | |
| COBOL4J_LIB_DIR: /usr/lib/opensourcecobol4j | |
| COBOL4J_LIBCOBJ_JAR_PATH: /usr/lib/opensourcecobol4j/libcobj.jar | |
| OCESQL4J_LIB_DIR: /usr/lib/Open-COBOL-ESQL-4j | |
| OCESQL4J_POSTGRESQL_JDBC_PATH: /usr/lib/Open-COBOL-ESQL-4j/postgresql.jar | |
| OCESQL4J_OCESQL4J_JAR_PATH: /usr/lib/Open-COBOL-ESQL-4j/ocesql4j.jar | |
| CLASSPATH: ":/usr/lib/opensourcecobol4j/sqlite.jar:/usr/lib/opensourcecobol4j/libcobj.jar:/usr/lib/Open-COBOL-ESQL-4j/postgresql.jar:/usr/lib/Open-COBOL-ESQL-4j/ocesql4j.jar" | |
| jobs: | |
| Open-COBOL-ESQL-4j-tests: | |
| strategy: | |
| matrix: | |
| os: ["ubuntu:22.04", "almalinux:9"] | |
| runs-on: ubuntu-latest | |
| container: | |
| image: ${{ matrix.os }} | |
| services: | |
| # Start PostgreSQL 9.6 server | |
| postgres9_6: | |
| image: postgres:9.6 | |
| ports: | |
| - 5432:5432 | |
| env: | |
| POSTGRES_PASSWORD: password | |
| POSTGRES_USER: main_user | |
| POSTGRES_DB: testdb | |
| POSTGRES_HOST_AUTH_METHOD: 'trust' | |
| options: >- | |
| --health-cmd pg_isready | |
| --health-interval 10s | |
| --health-timeout 5s | |
| --health-retries 5 | |
| # Start PostgreSQL 15 server | |
| postgres15: | |
| image: postgres:15 | |
| ports: | |
| - 5433:5432 | |
| env: | |
| POSTGRES_PASSWORD: password | |
| POSTGRES_USER: main_user | |
| POSTGRES_DB: testdb | |
| POSTGRES_HOST_AUTH_METHOD: 'trust' | |
| options: >- | |
| --health-cmd pg_isready | |
| --health-interval 10s | |
| --health-timeout 5s | |
| --health-retries 5 | |
| steps: | |
| # Install dependencies (Ubuntu 22.04) | |
| - name: Install dependencies on Ubuntu 22.04 | |
| if: matrix.os == 'ubuntu:22.04' | |
| run: | | |
| apt update -y | |
| apt install -y build-essential bison flex gettext texinfo automake autoconf curl | |
| # Install dependencies (Almalinux 9) | |
| - name: Install dependencies on AlmaLinux 9 | |
| if: matrix.os == 'almalinux:9' | |
| run: | | |
| dnf -y update | |
| dnf install -y gcc gcc-c++ make bison flex automake autoconf diffutils gettext | |
| # Setup JDK | |
| - name: Setup JDK | |
| uses: actions/setup-java@v3 | |
| with: | |
| distribution: zulu | |
| java-version: 11 | |
| # Setup sbt | |
| - name: Setup sbt | |
| uses: olafurpg/setup-scala@v11 | |
| with: | |
| java-version: zulu@1.11 | |
| # Checkout | |
| - name: Checkout Open-COBOL-ESQL-4j | |
| uses: actions/checkout@v3 | |
| # Install JDBC | |
| - name: Install JDBC | |
| run: | | |
| mkdir -p $COBOL4J_LIB_DIR $OCESQL4J_LIB_DIR | |
| curl -L -o $OCESQL4J_POSTGRESQL_JDBC_PATH https://jdbc.postgresql.org/download/postgresql-42.2.24.jre6.jar | |
| # Checkout opensource COBOL 4J | |
| - name: Checkout opensourcecobol 4J | |
| uses: actions/checkout@v3 | |
| with: | |
| repository: opensourcecobol/opensourcecobol4j | |
| path: opensourcecobol4j | |
| # Install opensource COBOL 4J | |
| - name: Install opensource COBOL 4J | |
| run: | | |
| cd opensourcecobol4j | |
| curl -L -k -o libcobj/sqlite-jdbc/sqlite.jar https://github.com/xerial/sqlite-jdbc/releases/download/3.36.0.3/sqlite-jdbc-3.36.0.3.jar | |
| ./configure --prefix=/usr/ | |
| make | |
| make install | |
| # Build and Install Open COBOL ESQL 4J | |
| - name: Install Open COBOL ESQL 4J | |
| run: | | |
| cp $OCESQL4J_POSTGRESQL_JDBC_PATH dblibj/lib | |
| cp $COBOL4J_LIBCOBJ_JAR_PATH dblibj/lib | |
| sh configure --prefix=/usr/ | |
| make | |
| make install | |
| # Run Autotest for PostgreSQL 9.6 | |
| - name: Run tests for PostgreSQL 9.6 | |
| run: | | |
| cd tests | |
| cp ../.github/workflows/db-settings/embed_db_info_postgresql_9.6.sh embed_db_info.sh | |
| make test | |
| # Run Autotest for PostgreSQL 15 | |
| - name: Run tests for PostgreSQL 15 | |
| run: | | |
| cd tests | |
| cp ../.github/workflows/db-settings/embed_db_info_postgresql_15.sh embed_db_info.sh | |
| make test | |
| # Create an issue if one or more tests fail in scheduled tests | |
| create-issue-on-failure: | |
| needs: Open-COBOL-ESQL-4j-tests | |
| if: failure() && github.event_name == 'schedule' && github.actor == 'opensourcecobol' | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Create an Issue | |
| uses: imjohnbo/issue-bot@v3 | |
| with: | |
| assignees: "yutaro-sakamoto" | |
| title: A scheduled build is failed | |
| body: | | |
| Scheduled build is failed. | |
| See ${{ github.server_url }}/${{ github.repository }}/actions/runs/${{ github.run_id }} |