Placed all ddl in sql files #70
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
| name: PG Tier Extension | |
| defaults: | |
| run: | |
| shell: bash | |
| working-directory: ./ | |
| on: | |
| pull_request: | |
| branches: | |
| - main | |
| paths-ignore: | |
| - 'README.md' | |
| - docs/** | |
| push: | |
| branches: | |
| - main | |
| paths-ignore: | |
| - 'README.md' | |
| - docs/** | |
| release: | |
| types: | |
| - created | |
| jobs: | |
| dependencies: | |
| name: Install dependencies | |
| runs-on: ubuntu-22.04 | |
| steps: | |
| - uses: actions/checkout@v2 | |
| # rust needed to install trunk | |
| - name: Install Rust stable toolchain | |
| uses: actions-rs/toolchain@v1 | |
| with: | |
| toolchain: stable | |
| cache-directories: /home/runner/.pgrx | |
| - name: Install stoml and pg-trunk | |
| shell: bash | |
| run: | | |
| set -xe | |
| wget https://github.com/freshautomations/stoml/releases/download/v0.7.1/stoml_linux_amd64 &> /dev/null | |
| mv stoml_linux_amd64 stoml | |
| chmod +x stoml | |
| sudo mv stoml /usr/local/bin/ | |
| cargo install pg-trunk | |
| - name: Cache binaries | |
| uses: actions/cache@v2 | |
| with: | |
| path: | | |
| /usr/local/bin/stoml | |
| ~/.cargo/bin/trunk | |
| key: ${{ runner.os }}-bins-${{ github.sha }} | |
| restore-keys: | | |
| ${{ runner.os }}-bins- | |
| lint: | |
| name: Run linters | |
| runs-on: ubuntu-22.04 | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Install Rust minimal nightly with clippy and rustfmt | |
| uses: actions-rs/toolchain@v1 | |
| with: | |
| profile: minimal | |
| toolchain: nightly | |
| components: rustfmt, clippy | |
| - uses: Swatinem/rust-cache@v2 | |
| with: | |
| prefix-key: "pg-tier-extension-lint" | |
| workspaces: pg-tier/ | |
| # Additional directories to cache | |
| cache-directories: /home/runner/.pgrx | |
| - uses: ./.github/actions/pgx-init | |
| with: | |
| working-directory: ./ | |
| - name: Cargo format | |
| run: cargo fmt --all --check | |
| - name: Clippy | |
| run: cargo clippy | |
| publish: | |
| if: github.event_name == 'release' | |
| name: trunk publish | |
| runs-on: ubuntu-22.04 | |
| strategy: | |
| matrix: | |
| pg-version: [14, 15, 16] | |
| steps: | |
| - uses: actions/checkout@v2 | |
| - name: Install Rust stable toolchain | |
| uses: actions-rs/toolchain@v1 | |
| with: | |
| toolchain: stable | |
| - uses: Swatinem/rust-cache@v2 | |
| with: | |
| prefix-key: "pg-tier-extension-test" | |
| workspaces: pg-tier | |
| # Additional directories to cache | |
| cache-directories: /home/runner/.pgrx | |
| - name: Install stoml and pg-trunk | |
| shell: bash | |
| run: | | |
| set -xe | |
| wget https://github.com/freshautomations/stoml/releases/download/v0.7.1/stoml_linux_amd64 &> /dev/null | |
| mv stoml_linux_amd64 stoml | |
| chmod +x stoml | |
| sudo mv stoml /usr/local/bin/ | |
| cargo install pg-trunk | |
| - name: trunk build | |
| working-directory: ./ | |
| run: ~/.cargo/bin/trunk build --pg-version ${{ matrix.pg-version }} | |
| - name: trunk publish | |
| working-directory: ./ | |
| env: | |
| TRUNK_API_TOKEN: ${{ secrets.TRUNK_AUTH_TOKEN }} | |
| run: ~/.cargo/bin/trunk publish | |
| build_and_push: | |
| name: Build and push images | |
| env: | |
| TARGET_PLATFORMS: linux/amd64,linux/arm64 | |
| runs-on: | |
| - self-hosted | |
| - dind | |
| - large-8x8 | |
| outputs: | |
| short_sha: ${{ steps.versions.outputs.SHORT_SHA }} | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v4 | |
| - name: Install stoml | |
| shell: bash | |
| run: | | |
| set -xe | |
| wget https://github.com/freshautomations/stoml/releases/download/v0.7.1/stoml_linux_amd64 &> /dev/null | |
| mv stoml_linux_amd64 stoml | |
| chmod +x stoml | |
| sudo mv stoml /usr/local/bin/ | |
| - name: Set version strings | |
| id: versions | |
| run: | | |
| echo "SHORT_SHA=$(git rev-parse --short HEAD)" >> $GITHUB_OUTPUT | |
| echo "TAG_VER=$(/usr/local/bin/stoml Cargo.toml package.version)" >> $GITHUB_OUTPUT | |
| - name: Set up QEMU | |
| uses: docker/setup-qemu-action@v3 | |
| - name: Set up Docker Buildx | |
| uses: docker/setup-buildx-action@v3 | |
| - name: Login to Quay | |
| uses: docker/login-action@v2 | |
| with: | |
| registry: quay.io/tembo | |
| username: ${{ secrets.QUAY_USER_TEMBO }} | |
| password: ${{ secrets.QUAY_PASSWORD_TEMBO }} | |
| - name: Build and push -- Commit | |
| if: github.event_name != 'release' | |
| uses: docker/build-push-action@v5 | |
| with: | |
| file: ./images/tier-pg/Dockerfile | |
| context: . | |
| platforms: linux/amd64 | |
| push: true | |
| tags: | | |
| quay.io/tembo/tier-pg:v${{ steps.versions.outputs.SHORT_SHA }} | |
| - name: Build and push | |
| if: github.event_name == 'release' | |
| uses: docker/build-push-action@v5 | |
| with: | |
| file: ./images/tier-pg/Dockerfile | |
| context: . | |
| platforms: linux/amd64 | |
| push: true | |
| tags: | | |
| quay.io/tembo/tier-pg:v${{ steps.versions.outputs.TAG_VER }} | |
| quay.io/tembo/tier-pg:latest |