Build and Publish #565
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
| # Heavyweight build and test | |
| name: Build and Publish | |
| on: | |
| push: | |
| branches: | |
| - main | |
| paths-ignore: | |
| - docs/ | |
| workflow_dispatch: | |
| jobs: | |
| set-version-number: | |
| name: Set version number | |
| runs-on: ubuntu-latest | |
| outputs: | |
| nuGetVersion: ${{ steps.gitversion.outputs.nuGetVersionV2 }} | |
| semVer: ${{ steps.gitversion.outputs.fullSemVer }} | |
| is-release: ${{ steps.gitversion.outputs.CommitsSinceVersionSource == 0 }} | |
| #is-release: 'true' | |
| steps: | |
| - name: Setup .NET 8 | |
| uses: actions/setup-dotnet@v4 | |
| with: | |
| dotnet-version: 8.0.x | |
| - name: Checkout | |
| uses: actions/checkout@v4 | |
| with: | |
| fetch-depth: 0 | |
| - name: Install GitVersion | |
| uses: gittools/actions/gitversion/[email protected] | |
| with: | |
| versionSpec: '5.x' | |
| - name: Determine Version | |
| id: gitversion | |
| uses: gittools/actions/gitversion/[email protected] | |
| build-netcore-tool: | |
| needs: set-version-number | |
| name: Build .NET Core (global) tool | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Setup .NET 8 | |
| uses: actions/setup-dotnet@v4 | |
| with: | |
| dotnet-version: 8.0.x | |
| - name: Restore dependencies | |
| run: dotnet restore | |
| - name: Build | |
| #run: dotnet pack ./grate/grate.csproj -c release -p:PackAsTool=true -p:PackageOutputPath=/tmp/grate/nupkg | |
| run: dotnet pack ./src/grate/grate.csproj -p:SelfContained=false -p:PackAsTool=true -p:PackageOutputPath=/tmp/grate/nupkg | |
| env: | |
| VERSION: ${{ needs.set-version-number.outputs.nuGetVersion }} | |
| - name: Upload published tool artifact | |
| uses: actions/upload-artifact@v3 | |
| if: ${{ needs.set-version-number.outputs.is-release == 'true' }} | |
| with: | |
| name: grate-dotnet-tool-${{ needs.set-version-number.outputs.nuGetVersion }} | |
| path: /tmp/grate/nupkg/* | |
| - name: Push to Nuget.org | |
| if: ${{ needs.set-version-number.outputs.is-release == 'true' }} | |
| run: dotnet nuget push /tmp/grate/nupkg/*.nupkg --source https://api.nuget.org/v3/index.json --api-key ${{secrets.NUGET_ORG_KEY}} --skip-duplicate | |
| build-nuget-package: | |
| needs: set-version-number | |
| name: Build Nuget | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| package: [ | |
| "grate.core", | |
| "grate.mariadb", | |
| "grate.oracle", | |
| "grate.postgresql", | |
| "grate.sqlite", | |
| "grate.sqlserver" | |
| ] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Setup .NET 8 | |
| uses: actions/setup-dotnet@v4 | |
| with: | |
| dotnet-version: 8.0.x | |
| - name: Restore dependencies | |
| run: dotnet restore | |
| - name: Pack Nuget package ${{ matrix.package }} | |
| run: dotnet pack ./src/${{ matrix.package }} -c Release --include-symbols -o /tmp/grate/nupkg /p:Version=${{ env.VERSION }} | |
| env: | |
| VERSION: ${{ needs.set-version-number.outputs.nuGetVersion }} | |
| - name: Push to Nuget.org | |
| if: ${{ needs.set-version-number.outputs.is-release == 'true' }} | |
| run: dotnet nuget push /tmp/grate/nupkg/*.nupkg --source https://api.nuget.org/v3/index.json --api-key ${{secrets.NUGET_ORG_KEY}} --skip-duplicate | |
| build-standalone: | |
| name: Build cli | |
| needs: set-version-number | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| arch: [ "win-x64", "win-x86", "win-arm64", | |
| "linux-musl-x64", "linux-musl-arm64", "linux-x64", "linux-arm64", | |
| "osx-x64", "osx-arm64" | |
| ] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Setup .NET 8 | |
| uses: actions/setup-dotnet@v4 | |
| with: | |
| dotnet-version: 8.0.x | |
| - name: Publish self-contained ${{ matrix.arch }} | |
| run: dotnet publish ./src/grate/grate.csproj -f net8.0 -r ${{ matrix.arch }} -c release --self-contained -p:SelfContained=true -o ./publish/${{ matrix.arch }}/self-contained | |
| env: | |
| VERSION: ${{ needs.set-version-number.outputs.nuGetVersion }} | |
| - name: Publish .NET 6/7/8 dependent ${{ matrix.arch }} | |
| run: dotnet publish ./src/grate/grate.csproj -r ${{ matrix.arch }} -c release --no-self-contained -o ./publish/${{ matrix.arch }}/dependent | |
| env: | |
| VERSION: ${{ needs.set-version-number.outputs.nuGetVersion }} | |
| - name: Upload self-contained ${{ matrix.arch }} | |
| #if: ${{ needs.set-version-number.outputs.is-release == 'true' }} | |
| uses: actions/upload-artifact@v3 | |
| with: | |
| name: grate-${{ matrix.arch }}-self-contained-${{ needs.set-version-number.outputs.nuGetVersion }} | |
| path: ./publish/${{ matrix.arch }}/self-contained/* | |
| - name: Upload .net dependent ${{ matrix.arch }} | |
| if: ${{ needs.set-version-number.outputs.is-release == 'true' }} | |
| uses: actions/upload-artifact@v3 | |
| with: | |
| name: grate-${{ matrix.arch }}-framework-dependent-${{ needs.set-version-number.outputs.nuGetVersion }} | |
| path: ./publish/${{ matrix.arch }}/dependent/* | |
| build-msi: | |
| name: Build MSI | |
| needs: | |
| - set-version-number | |
| - build-standalone | |
| runs-on: windows-latest | |
| if: ${{ needs.set-version-number.outputs.is-release == 'true' }} | |
| strategy: | |
| matrix: | |
| arch: [ "win-x64", "win-arm64" ] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions/download-artifact@v3 | |
| with: | |
| name: grate-${{ matrix.arch }}-self-contained-${{ needs.set-version-number.outputs.nuGetVersion }} | |
| path: ${{ matrix.arch }}/ | |
| - name: Create msi | |
| if: ${{ needs.set-version-number.outputs.is-release == 'true' }} | |
| run: ./installers/msi/Create-Installer.ps1 -grateExe ./${{ matrix.arch }}/grate.exe -Version "${{ needs.set-version-number.outputs.nuGetVersion }}" | |
| env: | |
| VERSION: ${{ needs.set-version-number.outputs.nuGetVersion }} | |
| - name: Upload MSI ${{ matrix.arch }} | |
| uses: actions/upload-artifact@v3 | |
| with: | |
| name: grate-msi-${{ matrix.arch }}-${{ needs.set-version-number.outputs.nuGetVersion }} | |
| path: ./installers/msi/tmp/*.msi | |
| build-docker-image: | |
| name: Build and push docker image | |
| needs: | |
| - set-version-number | |
| #- build-standalone ## no need, we build directly from source | |
| runs-on: ubuntu-latest | |
| if: ${{ needs.set-version-number.outputs.is-release == 'true' }} | |
| env: | |
| #REGISTRY: ghcr.io | |
| IMAGE_NAME: ${{ github.repository }} | |
| FULL_IMAGE_NAME: ${{ github.repository }} | |
| steps: | |
| - uses: actions/checkout@v4 | |
| # - uses: actions/download-artifact@v3 # download from another artifact is not a good idea, we need to build directly from source | |
| # with: | |
| # name: grate-linux-musl-x64-self-contained-${{ needs.set-version-number.outputs.nuGetVersion }} | |
| # path: installers/docker/ | |
| - name: Log in to the Container registry | |
| uses: docker/login-action@343f7c4344506bcbf9b4de18042ae17996df046d | |
| with: | |
| #registry: ${{ env.REGISTRY }} | |
| username: ${{ github.repository_owner}} | |
| password: ${{ secrets.DOCKER_HUB_TOKEN }} | |
| - name: Extract metadata (tags, labels) for Docker | |
| id: meta | |
| uses: docker/metadata-action@8e5442c4ef9f78752691e2d8f8d19755c6f78e81 | |
| with: | |
| tags: | | |
| type=semver,pattern={{version}} | |
| type=semver,pattern={{version}},value=${{ needs.set-version-number.outputs.semVer }} | |
| type=ref,event=tag | |
| #images: ${{ env.REGISTRY }}/${{ env.IMAGE_NAME }} | |
| images: ${{ env.IMAGE_NAME }} | |
| - name: Build and push Docker image | |
| uses: docker/build-push-action@4a13e500e55cf31b7a5d59a38ab2040ab0f42f56 | |
| with: | |
| file: ./installers/docker/Dockerfile | |
| context: . | |
| push: true | |
| tags: ${{ steps.meta.outputs.tags }} | |
| labels: ${{ steps.meta.outputs.labels }} | |
| build-deb: | |
| name: Build Debian package | |
| needs: | |
| - set-version-number | |
| - build-standalone | |
| runs-on: ubuntu-latest | |
| if: ${{ needs.set-version-number.outputs.is-release == 'true' }} | |
| strategy: | |
| matrix: | |
| arch: [ "linux-arm64", "linux-x64" ] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions/download-artifact@v3 | |
| with: | |
| name: grate-${{ matrix.arch }}-self-contained-${{ needs.set-version-number.outputs.nuGetVersion }} | |
| path: ${{ matrix.arch }}/ | |
| - id: get-arch | |
| name: Get architecture | |
| run: | | |
| arch=$(echo ${{ matrix.arch }} | cut -d- -f2 | sed 's/x64/amd64/') | |
| echo "::set-output name=arch::$arch" | |
| - name: Create dpkg # Linux with powershell script? really? | |
| if: ${{ needs.set-version-number.outputs.is-release == 'true' }} | |
| run: ./installers/deb/Create-Package.ps1 -grateExe ./${{ matrix.arch }}/grate -Version "${{ needs.set-version-number.outputs.nuGetVersion }}" -arch ${{ steps.get-arch.outputs.arch}} | |
| env: | |
| VERSION: ${{ needs.set-version-number.outputs.nuGetVersion }} | |
| - name: Upload .dpkg ${{ steps.get-arch.outputs.arch }} | |
| uses: actions/upload-artifact@v3 | |
| with: | |
| name: grate_${{ needs.set-version-number.outputs.nuGetVersion }}-1_${{ steps.get-arch.outputs.arch}}.deb | |
| path: ./installers/deb/grate_${{ needs.set-version-number.outputs.nuGetVersion }}-1_${{ steps.get-arch.outputs.arch }}.deb | |
| # build-winget: | |
| # name: Winget - Update package manifest in the OWC | |
| # needs: | |
| # - set-version-number | |
| # - build-msi | |
| # runs-on: windows-latest | |
| # if: ${{ needs.set-version-number.outputs.is-release == 'true' }} | |
| # steps: | |
| # - name: Winget-Create | |
| # run: | | |
| # $version = "$($env:version)" | |
| # # Download wingetcreate | |
| # iwr https://aka.ms/wingetcreate/latest -OutFile wingetcreate.exe | |
| # $packageUrl="https://github.com/erikbra/grate/releases/download/$version/grate-$version.msi" | |
| # echo "Running ./wingetcreate.exe update erikbra.grate -u $packageUrl -v $version -t `"$env:WINGET_GH_PAT`" --submit" | |
| # ./wingetcreate.exe update erikbra.grate -u $packageUrl -v $version -t "$env:WINGET_GH_PAT" --submit | |
| # env: | |
| # WINGET_GH_PAT: ${{ secrets.WINGET_GH_PAT }} | |
| # #version: "1.4.0" | |
| # version: "${{ needs.set-version-number.outputs.nuGetVersion }}" | |
| test: | |
| name: Run tests | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| category: [ "Basic_tests", "SqlServer", "PostgreSQL", "MariaDB", "Sqlite", "Oracle" ] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Setup .NET 8 | |
| uses: actions/setup-dotnet@v4 | |
| with: | |
| dotnet-version: 8.0.x | |
| - name: Test | |
| run: | | |
| dotnet test \ | |
| unittests/${{ matrix.category }} \ | |
| --logger:"xunit;LogFilePath=/tmp/test-results/${{ matrix.category }}.xml" -- \ | |
| -MaxCpuCount 2 | |
| env: | |
| LogLevel: Warning | |
| TZ: UTC | |
| integration-test: | |
| name: Tests cli | |
| needs: | |
| - set-version-number | |
| - build-standalone | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| category: [ "CommandLine.SqlServer", "CommandLine.PostgreSQL", | |
| "CommandLine.MariaDB", "CommandLine.Sqlite", "CommandLine.Oracle" ] | |
| arch: [ "linux", "win" ] | |
| #arch: [ "linux", "win", "macos" ] | |
| # arch: [ "win-x64", "win-x86", "win-arm64", | |
| # "linux-musl-x64", "linux-musl-arm64", "linux-x64", "linux-arm64", | |
| # "osx-x64", "osx-arm64" | |
| # ] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions/download-artifact@v3 | |
| with: | |
| name: grate-${{ matrix.arch }}-x64-self-contained-${{ needs.set-version-number.outputs.nuGetVersion }} | |
| #name: grate-linux-musl-x64-self-contained-${{ needs.set-version-number.outputs.nuGetVersion }} | |
| path: executables/${{ matrix.arch }}-x64 | |
| - name: Setup .NET 8 | |
| uses: actions/setup-dotnet@v4 | |
| with: | |
| dotnet-version: 8.0.x | |
| - name: Test | |
| run: | | |
| chmod u+x $GrateExecutablePath | |
| dotnet test \ | |
| unittests/CommandLine/${{ matrix.category }} \ | |
| --logger:"xunit;LogFilePath=/tmp/test-results/${{ matrix.category }}.xml" -- \ | |
| -MaxCpuCount 2 | |
| env: | |
| LogLevel: Warning | |
| GrateExecutablePath: ${{ github.workspace }}/executables/${{ matrix.arch }}-x64/grate | |
| TZ: UTC | |