feat: SQLAlchemy and alembic integration #1157
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: CI | |
| on: [pull_request, workflow_dispatch] | |
| permissions: | |
| contents: read | |
| jobs: | |
| build-and-test-extension: | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| postgres-version: [ 16, 17 ] | |
| fail-fast: false | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: taiki-e/install-action@just | |
| - name: Set up Python | |
| uses: actions/setup-python@v5 | |
| with: | |
| python-version: "3.10" | |
| cache: "pip" # caching pip dependencies | |
| - name: Verify Docker installation | |
| run: | | |
| docker --version | |
| docker info | |
| - name: Build Docker image | |
| run: just ext docker-build | |
| env: | |
| PG_MAJOR: ${{ matrix.postgres-version }} | |
| - name: Run Docker container | |
| run: just ext docker-run | |
| - name: Build | |
| run: docker exec pgai-ext just build | |
| - name: Lint SQL and Python | |
| run: docker exec pgai-ext just lint | |
| - name: Check Python Formatting | |
| run: docker exec pgai-ext just format-py | |
| - name: Install extension | |
| run: docker exec pgai-ext just install | |
| - name: Run test server | |
| run: docker exec -d pgai-ext just test-server | |
| - name: Run tests | |
| run: docker exec pgai-ext just test | |
| - name: Stop and remove Docker container | |
| run: | | |
| just ext docker-stop | |
| just ext docker-rm | |
| build-and-test-pgai: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: taiki-e/install-action@just | |
| - name: Install uv | |
| uses: astral-sh/setup-uv@v3 | |
| with: | |
| version: "0.4.29" | |
| enable-cache: true | |
| cache-dependency-glob: "./projects/pgai/uv.lock" | |
| - name: "Set up Python" | |
| uses: actions/setup-python@v5 | |
| with: | |
| python-version-file: "./projects/pgai/.python-version" | |
| - name: Install dependencies | |
| working-directory: ./projects/pgai | |
| run: uv sync | |
| - name: Lint | |
| run: just pgai lint | |
| - name: Check Typing | |
| run: just pgai type-check | |
| - name: Check Formatting | |
| run: just pgai format | |
| - name: Run Tests | |
| run: just pgai test | |
| - name: Build the pgai distributable and check artifacts | |
| run: just pgai build |