Convert ALTER TABLE ... ADD CONSTRAINT ... CHECK SQL to pgroll operation
#2720
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: Build | |
| on: | |
| pull_request: | |
| push: | |
| branches: | |
| - main | |
| tags: | |
| - 'v*' | |
| permissions: | |
| contents: write | |
| packages: write | |
| jobs: | |
| cross-build: | |
| name: cross-platform build | |
| runs-on: ubuntu-24.04 | |
| container: | |
| image: surjection/goreleaser-cross:v1.23-v2.4.8 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Set up Go | |
| uses: actions/setup-go@v5 | |
| with: | |
| go-version-file: 'go.mod' | |
| # Mark the checkout as 'safe' despite being owned by `root` | |
| - run: git config --global --add safe.directory $GITHUB_WORKSPACE | |
| - name: Run GoReleaser | |
| uses: goreleaser/goreleaser-action@v6 | |
| with: | |
| distribution: goreleaser | |
| version: '~> v2' | |
| args: build --snapshot | |
| - uses: actions/upload-artifact@v4 | |
| with: | |
| name: platform-binaries | |
| path: dist/ | |
| if-no-files-found: error | |
| test: | |
| name: 'test (pg: ${{ matrix.pgVersion }}, schema: ${{ matrix.testSchema }})' | |
| runs-on: ubuntu-24.04 | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| pgVersion: ['14.8', '15.3', '16.4', '17.0' ,'latest'] | |
| testSchema: [ 'public', 'non_public' ] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Set up Go | |
| uses: actions/setup-go@v5 | |
| with: | |
| go-version-file: 'go.mod' | |
| - name: Run tests | |
| run: go test ./... | |
| env: | |
| POSTGRES_VERSION: ${{ matrix.pgVersion }} | |
| PGROLL_TEST_SCHEMA: ${{ matrix.testSchema }} | |
| lint: | |
| name: lint | |
| runs-on: ubuntu-24.04 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Set up Go | |
| uses: actions/setup-go@v5 | |
| with: | |
| go-version-file: 'go.mod' | |
| cache: false | |
| - name: golangci-lint | |
| uses: golangci/golangci-lint-action@v4 | |
| with: | |
| # Require: The version of golangci-lint to use. | |
| # When `install-mode` is `binary` (default) the value can be v1.2 or v1.2.3 or `latest` to use the latest version. | |
| # When `install-mode` is `goinstall` the value can be v1.2.3, `latest`, or the hash of a commit. | |
| version: v1.61.0 | |
| # Optional: golangci-lint command line arguments. | |
| # | |
| # Note: By default, the `.golangci.yml` file should be at the root of the repository. | |
| # The location of the configuration file can be changed by using `--config=` | |
| args: --timeout=30m --out-format=colored-line-number --config=.golangci.yml | |
| - name: Ensure JSON examples are formatted | |
| run: | | |
| for file in ./examples/*.json; do | |
| if ! diff <(cat $file | jq) <(cat $file); then | |
| echo "$file is not formatted: run 'cat $file | jq' to fix"; | |
| exit 1; | |
| fi | |
| done | |
| type-generation: | |
| name: type generation | |
| runs-on: ubuntu-24.04 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Generate types | |
| run: | | |
| chmod 666 pkg/state/init.sql | |
| make generate | |
| - name: Ensure generated types are up-to-date | |
| run: | | |
| if ! git diff --quiet; then | |
| echo "generated types are out of date!" | |
| echo "run 'make generate' to regenerate type definitions" | |
| exit 1 | |
| fi | |
| check-ledger: | |
| name: check ledger | |
| runs-on: ubuntu-24.04 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Generate ledger | |
| run: | | |
| make ledger | |
| - name: Ensure ledger is up to date | |
| run: | | |
| if ! git diff --quiet; then | |
| echo "generated ledger is out of date!" | |
| echo "run 'make ledger' to regenerate the ledger" | |
| exit 1 | |
| fi | |
| dead-code-check: | |
| name: dead code check | |
| runs-on: ubuntu-24.04 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Set up Go | |
| uses: actions/setup-go@v5 | |
| with: | |
| go-version-file: 'go.mod' | |
| - name: Install deadcode tool | |
| run: | | |
| go install golang.org/x/tools/cmd/deadcode@latest | |
| - name: Run deadcode analysis | |
| run: | | |
| deadcode --test ./... > deadcode.out | |
| if [ -s deadcode.out ]; then | |
| echo "Dead code analysis found the following dead code:" | |
| cat deadcode.out | |
| exit 1 | |
| fi | |
| license-check: | |
| name: license check | |
| runs-on: ubuntu-24.04 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Ensure .go files have a license reference | |
| run: | | |
| curl -s https://raw.githubusercontent.com/lluissm/license-header-checker/master/install.sh | bash | |
| ./bin/license-header-checker -a -r .github/license-header.txt . go && [[ -z `git status -s` ]] | |
| examples-schema-validation: | |
| name: validate examples JSON | |
| runs-on: ubuntu-24.04 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Validate example migrations against JSON schema | |
| run: | | |
| npx -y ajv-cli --spec=draft2020 validate --strict-schema=false -s schema.json -d "./examples/*.json" | |
| examples: | |
| name: 'examples (pg: ${{ matrix.pgVersion }}, schema: ${{ matrix.testSchema }})' | |
| runs-on: ubuntu-24.04 | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| pgVersion: ['14.8', '15.3', '16.4', '17.0' ,'latest'] | |
| testSchema: [ 'public', 'non_public' ] | |
| services: | |
| postgres: | |
| image: postgres:${{ matrix.pgVersion }} | |
| env: | |
| POSTGRES_PASSWORD: postgres | |
| options: >- | |
| --health-cmd pg_isready | |
| --health-interval 10s | |
| --health-timeout 5s | |
| --health-retries 5 | |
| ports: | |
| - 5432:5432 | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Set up Go | |
| uses: actions/setup-go@v5 | |
| with: | |
| go-version-file: 'go.mod' | |
| - name: Run example migrations | |
| run: | | |
| if [ "$PGROLL_SCHEMA" != "public" ]; then | |
| psql -h $POSTGRES_HOST -p $POSTGRES_PORT -U postgres -c "CREATE SCHEMA $PGROLL_SCHEMA;" | |
| fi | |
| make examples | |
| env: | |
| POSTGRES_PORT: 5432 | |
| POSTGRES_HOST: localhost | |
| PGPASSWORD: postgres | |
| PGROLL_SCHEMA: ${{ matrix.testSchema }} | |
| release: | |
| runs-on: ubuntu-24.04 | |
| container: | |
| image: surjection/goreleaser-cross:v1.23-v2.4.8 | |
| needs: [test, lint, examples-schema-validation, examples, license-check, type-generation, dead-code-check, check-ledger, cross-build] | |
| if: startsWith(github.ref, 'refs/tags/') | |
| env: | |
| DOCKER_CLI_EXPERIMENTAL: "enabled" | |
| steps: | |
| - uses: actions/checkout@v4 | |
| with: | |
| fetch-depth: 0 | |
| # Mark the checkout as 'safe' despite being owned by `root` | |
| - run: git config --global --add safe.directory $GITHUB_WORKSPACE | |
| - run: git fetch --force --tags | |
| - name: Set up Docker Buildx | |
| uses: docker/setup-buildx-action@v3 | |
| - name: Login to GitHub Container Registry | |
| uses: docker/login-action@v3 | |
| with: | |
| registry: ghcr.io | |
| username: ${{ github.repository_owner }} | |
| password: ${{ secrets.GITHUB_TOKEN }} | |
| - name: Set up Go | |
| uses: actions/setup-go@v5 | |
| with: | |
| go-version-file: 'go.mod' | |
| - name: Run GoReleaser | |
| uses: goreleaser/goreleaser-action@v6 | |
| with: | |
| distribution: goreleaser | |
| version: '~> v2' | |
| args: release --clean | |
| env: | |
| # We use two GitHub tokens here: | |
| # * The actions-bound `GITHUB_TOKEN` with permissions to write packages. | |
| # * The org level `GIT_TOKEN` to be able to publish the brew tap file. | |
| # See: https://goreleaser.com/errors/resource-not-accessible-by-integration/ | |
| GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} | |
| TAP_GITHUB_TOKEN: ${{ secrets.GIT_TOKEN }} | |
| GITHUB_USERNAME: ${{ github.repository_owner }} | |
| DOCKER_USERNAME: ghcr.io/${{ github.repository_owner }} |