Build and Publish #582
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/setup@v0.11.0 | |
| with: | |
| versionSpec: '5.x' | |
| - name: Determine Version | |
| id: gitversion | |
| uses: gittools/actions/gitversion/execute@v0.11.0 | |
| 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 | |
| strategy: | |
| matrix: | |
| #os: [windows-latest, ubuntu-latest, macos-latest] | |
| # category: [ "CommandLine.SqlServer", "CommandLine.PostgreSQL", | |
| # "CommandLine.MariaDB", "CommandLine.Sqlite", "CommandLine.Oracle" ] | |
| category: | |
| - CommandLine.SqlServer | |
| - CommandLine.PostgreSQL | |
| - CommandLine.MariaDB | |
| - CommandLine.Sqlite | |
| - CommandLine.Oracle | |
| #include: | |
| os: | |
| # - os: windows-latest | |
| # executable: grate.exe | |
| # - name: windows-latest | |
| # arch: win-x64 | |
| # executable: grate.exe | |
| # - os: linux-latest | |
| # executable: grate | |
| - name: linux-latest | |
| arch: linux-x64 | |
| executable: grate | |
| # - os: macos-latest | |
| # executable: grate | |
| # - name: macos-latest | |
| # arch: osx-x64 | |
| # executable: grate | |
| # - name: macos-14 | |
| # arch: osx-x64 | |
| # executable: grate | |
| #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" | |
| # ] | |
| runs-on: ${{ matrix.os.name }} | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions/download-artifact@v3 | |
| with: | |
| name: grate-${{ matrix.os.arch }}-self-contained-${{ needs.set-version-number.outputs.nuGetVersion }} | |
| #name: grate-linux-musl-x64-self-contained-${{ needs.set-version-number.outputs.nuGetVersion }} | |
| path: executables/${{ matrix.os.arch }} | |
| - name: Setup .NET 8 | |
| uses: actions/setup-dotnet@v4 | |
| with: | |
| dotnet-version: 8.0.x | |
| - name: chmod u+x | |
| run: chmod u+x $GrateExecutablePath | |
| if: ${{ matrix.os.arch != 'win-x64' }} | |
| env: | |
| GrateExecutablePath: ${{ github.workspace }}/executables/${{ matrix.os.arch }}/${{ matrix.os.executable }} | |
| #GrateExecutablePath: ${{ github.workspace }}/executables/${{ matrix.arch }}/grate | |
| - name: Test | |
| run: > | |
| dotnet test | |
| unittests/CommandLine/${{ matrix.category }} | |
| --logger:"xunit;LogFilePath=/tmp/test-results/${{ matrix.os.arch }}/${{ matrix.category }}.xml" -- | |
| -MaxCpuCount 2 | |
| env: | |
| LogLevel: Warning | |
| GrateExecutablePath: ${{ github.workspace }}/executables/${{ matrix.os.arch }}/${{ matrix.os.executable }} | |
| #GrateExecutablePath: ${{ github.workspace }}/executables/${{ matrix.arch }}/grate | |
| TZ: UTC | |