Test Installs #153
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: Test Installs | |
| on: | |
| workflow_dispatch: | |
| schedule: | |
| - cron: "0 0 * * *" | |
| permissions: | |
| contents: read | |
| id-token: write | |
| jobs: | |
| test-cli: | |
| runs-on: ${{ matrix.os }} | |
| strategy: | |
| matrix: | |
| os: [ubuntu-latest, macos-latest, windows-latest] | |
| steps: | |
| - name: Install DuckDB on Mac | |
| if: matrix.os == 'macos-latest' | |
| run: | | |
| brew install unzip | |
| wget -O duckdb.zip https://github.com/duckdb/duckdb/releases/download/v0.8.1/duckdb_cli-osx-universal.zip | |
| unzip duckdb.zip -d duckdb | |
| sudo mv duckdb/duckdb /usr/local/bin | |
| - name: Install DuckDB on Linux | |
| if: matrix.os == 'ubuntu-latest' | |
| run: | | |
| sudo apt-get install wget unzip | |
| wget -O duckdb.zip https://github.com/duckdb/duckdb/releases/download/v0.8.1/duckdb_cli-linux-amd64.zip | |
| unzip duckdb.zip -d duckdb | |
| sudo mv duckdb/duckdb /usr/local/bin | |
| - name: Install DuckDB on Windows | |
| if: matrix.os == 'windows-latest' | |
| run: | | |
| choco install wget unzip | |
| wget -O duckdb.zip https://github.com/duckdb/duckdb/releases/download/v0.8.1/duckdb_cli-windows-amd64.zip | |
| unzip duckdb.zip | |
| - name: Create Script | |
| shell: bash | |
| run: | | |
| echo "SET custom_extension_repository='dbe.wheretrue.com/exon/latest';" > test.sql | |
| echo "INSTALL exon;" >> test.sql | |
| echo "LOAD exon;" >> test.sql | |
| echo "SELECT gc_content('ATCG');" >> test.sql | |
| cat test.sql | |
| - name: Run DuckDB (Unix) | |
| shell: bash | |
| if: matrix.os == 'macos-latest' || matrix.os == 'ubuntu-latest' | |
| run: | | |
| duckdb -unsigned < test.sql | |
| - name: Run DuckDB (Windows) | |
| shell: bash | |
| if: matrix.os == 'windows-latest' | |
| run: | | |
| ./duckdb.exe -unsigned < test.sql |