#997: Added documentation for Rollback of Script-Languages-Container #31
Workflow file for this run
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: Check Rollback Script 7.1.30 | |
| on: | |
| push: | |
| branches: | |
| - develop | |
| pull_request: | |
| jobs: | |
| Check: | |
| runs-on: ubuntu-24.04 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| with: | |
| fetch-depth: 0 | |
| submodules: 'recursive' | |
| - name: Setup Python & Poetry Environment | |
| uses: exasol/python-toolbox/.github/actions/[email protected] | |
| with: | |
| python-version: "3.10" | |
| poetry-version: '1.8.2' | |
| - name: Start ITDE | |
| run: poetry run itde spawn-test-environment --environment-name exasol_test --database-port-forward 8888 --bucketfs-port-forward 6583 --docker-db-image-version=7.1.29; | |
| - name: Install dependencies | |
| run: sudo apt update && sudo apt install -y perl default-jre | |
| - name: Install EXAPlus | |
| run: | | |
| curl -o exaplus.tar.gz https://exasol-script-languages-dependencies.s3.eu-central-1.amazonaws.com/EXAplus-7.0.11.tar.gz && tar xf exaplus.tar.gz | |
| echo "/tmp/EXAplus-7.0.11" >> $GITHUB_PATH | |
| working-directory: /tmp | |
| - name: Check if get_original_script_languages_parameters.sql works | |
| run: | | |
| RESULT=`exaplus -x -q -c localhost:8888 -u sys -p exasol -f ./get_original_script_languages_parameter.sql` | |
| echo "$RESULT" | grep "ALTER SYSTEM SET SCRIPT_LANGUAGES='R=builtin_r JAVA=builtin_java PYTHON3=builtin_python3'" || (echo SCRIPT_LANGUAGES parameter not as expected && exit 1) | |
| working-directory: doc/user_guide/resources | |
| - name: Check if get_original_script_languages_parameters.sql works | |
| run: | | |
| RESULT=`exaplus -x -q -c localhost:8888 -u sys -p exasol -f ./get_original_script_languages_parameter.sql` | |
| echo "$RESULT" | grep "ALTER SYSTEM SET SCRIPT_LANGUAGES='R=builtin_r JAVA=builtin_java PYTHON3=builtin_python3'" || (echo SCRIPT_LANGUAGES parameter not as expected && exit 1) | |
| working-directory: doc/user_guide/resources | |
| - name: Install a simple R UDF | |
| run: | | |
| exaplus -x -q -c localhost:8888 -u sys -p exasol -f install_r_udf.sql | |
| exaplus -x -q -c localhost:8888 -u sys -p exasol -sql "SELECT TEST.R_DEMO();" | |
| working-directory: .github/workflows/scripts | |
| - name: Check if pre_update_check.sql works | |
| run: | | |
| RESULT=`exaplus -x -q -c localhost:8888 -u sys -p exasol -f ./pre_update_check.sql` | |
| echo "$RESULT" | grep "You have 1 UDFs using the pre-shipped R" | |
| working-directory: doc/user_guide/resources | |
| - name: Check if construct_alter_system_command_before_update.sql works | |
| run: | | |
| RESULT=`exaplus -c localhost:8888 -u sys -p exasol -f ./construct_alter_system_command_before_update.sql` | |
| echo "$RESULT" | tr -d '\n' | grep "ALTER SYSTEM SET SCRIPT_LANGUAGES='JAVA=builtin_java PYTHON3=builtin_python3 R=localzmq+protobuf:///bfsdefault/default/EXAClusterOS/ScriptLanguages-standard-EXASOL-7.1.0-slc-v6.0.0-VYP23K36/?lang=r#/buckets/bfsdefault/default/EXAClusterOS/ScriptLanguages-standard-EXASOL-7.1.0-slc-v6.0.0-VYP23K36/exaudf/exaudfclient_py3';" | |
| exaplus -x -q -c localhost:8888 -u sys -p exasol -sql "ALTER SYSTEM SET SCRIPT_LANGUAGES='JAVA=builtin_java PYTHON3=builtin_python3 R=localzmq+protobuf:///bfsdefault/default/EXAClusterOS/ScriptLanguages-standard-EXASOL-7.1.0-slc-v6.0.0-VYP23K36/?lang=r#/buckets/bfsdefault/default/EXAClusterOS/ScriptLanguages-standard-EXASOL-7.1.0-slc-v6.0.0-VYP23K36/exaudf/exaudfclient_py3';" | |
| exaplus -x -q -c localhost:8888 -u sys -p exasol -sql "SELECT TEST.R_DEMO();" | |
| working-directory: doc/user_guide/resources | |
| - name: Run Skript | |
| run: bash install_slc_v6.0.0_on_db.sh localhost 6583 write default HTTP | |
| working-directory: doc/user_guide/resources | |
| - name: Check if construct_alter_system_command_from_downloaded.sql works | |
| run: | | |
| sed -i 's/<bucketfs_name>/bfsdefault/g' construct_alter_system_command_from_downloaded_container.sql | |
| sed -i 's/<bucket_name>/default/g' construct_alter_system_command_from_downloaded_container.sql | |
| sed -i 's/<path_in_bucket>//g' construct_alter_system_command_from_downloaded_container.sql | |
| sed -i 's/<container_name>/standard-EXASOL-7.1.0_release\.tar\.gz/g' construct_alter_system_command_from_downloaded_container.sql | |
| echo babla1 | |
| RESULT=`exaplus -q -c localhost:8888 -u sys -p exasol -f ./construct_alter_system_command_from_downloaded_container.sql` | |
| echo babla2 | |
| echo "$RESULT" | |
| echo blabla2.1 | |
| echo "$RESULT" | tr -d '\n' | grep "ALTER SYSTEM SET SCRIPT_LANGUAGES='JAVA=builtin_java PYTHON3=builtin_python3 R=localzmq+protobuf:///bfsdefault/default//standard-EXASOL-7.1.0_release.tar.gz/?lang=r#/buckets/bfsdefault/default//standard-EXASOL-7.1.0_release.tar.gz/exaudf/exaudfclient_py3';" | |
| echo babla3 | |
| exaplus -x -q -c localhost:8888 -u sys -p exasol -sql "ALTER SYSTEM SET SCRIPT_LANGUAGES='JAVA=builtin_java PYTHON3=builtin_python3 R=localzmq+protobuf:///bfsdefault/default//standard-EXASOL-7.1.0_release.tar.gz/?lang=r#/buckets/bfsdefault/default//standard-EXASOL-7.1.0_release.tar.gz/exaudf/exaudfclient_py3';" | |
| echo babla4 | |
| exaplus -x -q -c localhost:8888 -u sys -p exasol -sql "SELECT TEST.R_DEMO();" | |
| echo babla5 | |
| working-directory: doc/user_guide/resources |