split main workflow to ci & release #5
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: CI | |
| defaults: | |
| run: | |
| shell: bash | |
| permissions: | |
| contents: write | |
| pull-requests: write | |
| on: | |
| push: | |
| branches: [ "main" ] | |
| paths: | |
| - "**" | |
| - "!**.md" | |
| - "!ruby-wasm-poc/**" | |
| pull_request: | |
| branches: [ "*" ] | |
| paths: | |
| - "**" | |
| - "!**.md" | |
| - "!ruby-wasm-poc/**" | |
| jobs: | |
| lint: | |
| name: Lint | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Check out Git repository | |
| uses: actions/checkout@v4 | |
| - name: Set up .NET | |
| uses: actions/setup-dotnet@v4 | |
| with: | |
| dotnet-version: "8.0.x" | |
| - name: .NET Lint | |
| uses: zyactions/dotnet-lint@v1 | |
| with: | |
| implicit-restore: true | |
| workspace: sqlc-gen-ruby.sln | |
| exclude: GeneratedProtobuf | |
| build: | |
| name: Build | |
| runs-on: ${{ matrix.os }} | |
| needs: [lint] | |
| strategy: | |
| matrix: | |
| os: [ 'ubuntu-latest' ] | |
| architecture: [ 'x64', 'arm64' ] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Load .env file | |
| uses: xom9ikk/dotenv@v2.3.0 | |
| with: | |
| load-mode: strict | |
| - name: Setup Dotnet | |
| uses: actions/setup-dotnet@v4 | |
| with: | |
| dotnet-version: '8.0.x' | |
| - name: Install Wasi workload | |
| run: dotnet workload install wasi-experimental | |
| - name: Download Wasi SDK on Ubuntu | |
| if: runner.os == 'Linux' | |
| run: | | |
| wget https://github.com/WebAssembly/wasi-sdk/releases/download/wasi-sdk-22/wasi-sdk-22.0-linux.tar.gz | |
| tar xf wasi-sdk-22.0-linux.tar.gz | |
| chmod -R 755 wasi-sdk-22.0 | |
| - name: Dotnet Wasm Publish | |
| run: | | |
| WASI_SDK_PATH="$(pwd)/wasi-sdk-22.0" dotnet publish WasmRunner -c release | |
| ./scripts/wasm/copy_plugin_to.sh dist | |
| - name: upload wasm plugin as artifact | |
| if: matrix.architecture == 'arm64' # this needs to happen once across matrix | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: wasm-file | |
| path: dist/plugin.wasm | |
| end2end-tests: | |
| name: End-to-End Tests | |
| runs-on: ubuntu-latest | |
| needs: [build] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions/download-artifact@v4 | |
| with: | |
| name: wasm-file | |
| path: dist | |
| - uses: sqlc-dev/setup-sqlc@v4 | |
| with: | |
| sqlc-version: '1.25.0' | |
| - name: Load .env file | |
| uses: xom9ikk/dotenv@v2.3.0 | |
| with: | |
| load-mode: strict | |
| - name: Verify pushed generated code is synced | |
| run: | | |
| ./scripts/wasm/update_sha.sh ${SQLC_CI_FILE} | |
| sqlc -f ${SQLC_CI_FILE} diff | |
| - name: Docker compose | |
| uses: hoverkraft-tech/compose-action@v1.5.1 | |
| with: | |
| services: | | |
| mysqldb | |
| postgresdb | |
| plugin-tests | |
| - name: End-to-End Tests | |
| run: ./scripts/tests/run_end2end.sh | |
| release-tag: | |
| name: Release Tag | |
| runs-on: ubuntu-latest | |
| if: "contains(github.event.head_commit.message, '[release]')" | |
| needs: [ build, end2end-tests ] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions/download-artifact@v4 | |
| with: | |
| name: wasm-file | |
| - name: Bump version and create new tag | |
| id: bump_version | |
| run: | | |
| bump_version() { | |
| latest_tag=$1 | |
| latest_commit_msg=$2 | |
| BUMP_TYPE="patch" # Initialize the default version bump type to patch | |
| if [[ $latest_commit_msg == *"[major]"* ]]; then | |
| BUMP_TYPE="major" | |
| elif [[ $latest_commit_msg == *"[minor]"* ]]; then | |
| BUMP_TYPE="minor" | |
| fi | |
| case $BUMP_TYPE in | |
| "major") | |
| NEW_TAG=$(echo $latest_tag | awk -F. '{OFS="."; $1="v" substr($1,2)+1; $2="0"; $3="0"; print}') | |
| ;; | |
| "minor") | |
| NEW_TAG=$(echo $latest_tag | awk -F. '{OFS="."; $2=$2+1; $3="0"; print}') | |
| ;; | |
| "patch") | |
| NEW_TAG=$(echo $latest_tag | awk -F. '{OFS="."; $3=$3+1; print}') | |
| ;; | |
| esac | |
| return NEW_TAG | |
| } | |
| set -e | |
| echo "Extract the latest tag version" | |
| LATEST_TAG_COMMIT=$(git rev-list --tags --max-count=1) | |
| LATEST_COMMIT_MSG=$(git log -1 --pretty=%B) | |
| if [ -z $LATEST_TAG_COMMIT ]; then | |
| NEW_TAG="0.10.0" # default 1st release version | |
| else | |
| LATEST_TAG=$(git describe --tags $LATEST_TAG_COMMIT) | |
| echo "latest tag version: $LATEST_TAG" | |
| NEW_TAG=$(bump_version $LATEST_TAG $LATEST_COMMIT_MSG) | |
| fi | |
| echo "New tag version: $NEW_TAG" | |
| echo "NEW_TAG=$NEW_TAG" >> $GITHUB_ENV | |
| # Create a new tag | |
| git tag $NEW_TAG | |
| git push origin $NEW_TAG |