[release] fix release #41
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: Main | |
| 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: | |
| name: Release | |
| runs-on: ubuntu-latest | |
| needs: [build, end2end-tests] | |
| steps: | |
| - name: Check out Git repository | |
| uses: actions/checkout@v4 | |
| with: | |
| fetch-depth: 0 | |
| - uses: actions/download-artifact@v2 | |
| with: | |
| name: wasm-file | |
| - name: Bump version and create new tag | |
| id: bump_version | |
| run: | | |
| set -e | |
| echo "Extract the latest tag version" | |
| LATEST_TAG=$(git describe --tags $(git rev-list --tags --max-count=1)) | |
| echo "LATEST_TAG=$LATEST_TAG" >> $GITHUB_ENV | |
| echo "latest tag version: $LATEST_TAG" | |
| LATEST_COMMIT_MSG=$(git log -1 --pretty=%B) | |
| 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 | |
| # Bump the version based on the type | |
| 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 | |
| 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 | |
| - name: Calculate sha256 | |
| run: | | |
| SHA256_HASH=$(sha256sum plugin.wasm | awk '{ print $1 }') | |
| echo "SHA256_HASH=$SHA256_HASH" >> $GITHUB_ENV | |
| echo "The calculated sha256 is $SHA256_HASH" | |
| - name: Create release draft | |
| env: | |
| GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} | |
| run: | | |
| LATEST_TAG=${{ env.LATEST_TAG }} | |
| NEW_TAG=${{ env.NEW_TAG }} | |
| SHA256_HASH=${{ env.SHA256_HASH }} | |
| PREVIOUS_TAG=$(git rev-list -n 1 $LATEST_TAG) | |
| CHANGE_LOG=$(git --no-pager log $PREVIOUS_TAG..HEAD --pretty=format:'%h - %an, %ar : %s') | |
| # Define the release notes template | |
| RELEASE_NOTES=$(cat <<EOF | |
| ## Release version $NEW_TAG | |
| Release sha256 is \`$SHA256_HASH\` | |
| ## Configuration example | |
| \`\`\`yaml | |
| version: '2' | |
| plugins: | |
| - name: ruby | |
| wasm: | |
| url: https://github.com/DaredevilOSS/sqlc-gen-ruby/releases/download/$NEW_TAG/sqlc-gen-ruby.wasm | |
| sha256: $SHA256_HASH | |
| \`\`\` | |
| ## Changelog | |
| $CHANGE_LOG | |
| ## Contributors | |
| * @doron050 @SockworkOrange | |
| EOF | |
| ) | |
| # change file name to convention | |
| mv plugin.wasm sqlc-gen-ruby.wasm | |
| # Create a draft release | |
| gh release create $NEW_TAG sqlc-gen-ruby.wasm \ | |
| --draft \ | |
| --title "$NEW_TAG" \ | |
| --notes "$RELEASE_NOTES" |