sqlmesh/.github/workflows/private-repo-test.yaml at d2c09e3db2baae94bfbd24d03e236d8a8e8cb357 · SQLMesh/sqlmesh · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
name: Private Repo Testing

on:
  pull_request_target:
    branches:
      - main

concurrency:
  group: 'private-test-${{ github.event.pull_request.number }}'
  cancel-in-progress: true

permissions:
  contents: read

jobs:
  trigger-private-test:
    runs-on: ubuntu-latest
    steps:
      - name: Checkout code
        uses: actions/checkout@v5
        with:
          fetch-depth: 0
          ref: ${{ github.event.pull_request.head.sha || github.ref }}
      - name: Set up Python
        uses: actions/setup-python@v5
        with:
          python-version: '3.12'
      - name: Install uv
        uses: astral-sh/setup-uv@v6
      - name: Set up Node.js for UI build
        uses: actions/setup-node@v4
        with:
          node-version: '20'
      - name: Install pnpm
        uses: pnpm/action-setup@v4
        with:
          version: latest
      - name: Install UI dependencies
        run: pnpm install
      - name: Build UI
        run: pnpm --prefix web/client run build
      - name: Install Python dependencies
        run: |
          python -m venv .venv
          source .venv/bin/activate
          pip install build twine setuptools_scm
      - name: Generate development version
        id: version
        run: |
          source .venv/bin/activate
          # Generate a PEP 440 compliant unique version including run attempt
          BASE_VERSION=$(python .github/scripts/get_scm_version.py)
          COMMIT_SHA=$(git rev-parse --short HEAD)
          # Use PEP 440 compliant format: base.devN+pr.sha.attempt
          UNIQUE_VERSION="${BASE_VERSION}+pr${{ github.event.pull_request.number }}.${COMMIT_SHA}.run${{ github.run_attempt }}"
          echo "version=$UNIQUE_VERSION" >> $GITHUB_OUTPUT
          echo "Generated unique version with run attempt: $UNIQUE_VERSION"
      - name: Build package
        env:
          SETUPTOOLS_SCM_PRETEND_VERSION: ${{ steps.version.outputs.version }}
        run: |
          source .venv/bin/activate
          python -m build
      - name: Configure PyPI for private repository
        env:
          TOBIKO_PRIVATE_PYPI_URL: ${{ secrets.TOBIKO_PRIVATE_PYPI_URL }}
          TOBIKO_PRIVATE_PYPI_KEY: ${{ secrets.TOBIKO_PRIVATE_PYPI_KEY }}
        run: ./.circleci/update-pypirc.sh
      - name: Publish to private PyPI
        run: |
          source .venv/bin/activate
          python -m twine upload -r tobiko-private dist/*
      - name: Publish Python Tests package
        env:
          SETUPTOOLS_SCM_PRETEND_VERSION: ${{ steps.version.outputs.version }}
        run: |
          source .venv/bin/activate
          unset TWINE_USERNAME TWINE_PASSWORD && make publish-tests
      - name: Get GitHub App token
        id: get_token
        uses: actions/create-github-app-token@v2
        with:
          private-key: ${{ secrets.TOBIKO_RENOVATE_BOT_PRIVATE_KEY }}
          app-id: ${{ secrets.TOBIKO_RENOVATE_BOT_APP_ID }}
          owner: ${{ secrets.PRIVATE_REPO_OWNER }}
      - name: Trigger private repository workflow
        uses: convictional/trigger-workflow-and-wait@v1.6.5
        with:
          owner: ${{ secrets.PRIVATE_REPO_OWNER }}
          repo: ${{ secrets.PRIVATE_REPO_NAME }}
          github_token: ${{ steps.get_token.outputs.token }}
          workflow_file_name: ${{ secrets.PRIVATE_WORKFLOW_FILE }}
          client_payload: |
            {
              "package_version": "${{ steps.version.outputs.version }}",
              "pr_number": "${{ github.event.pull_request.number }}"
            }