pytest-mrt/examples/ci-integration/github-actions.yml at main · croc100/pytest-mrt · 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
98
99
100
101
102
103
104
# .github/workflows/migration-safety.yml
#
# Run pytest-mrt on every PR that touches migration files.
# Blocks merge if any rollback-unsafe migration is detected.

name: Migration Safety

on:
  pull_request:
    paths:
      - "migrations/**"
      - "alembic/**"
      - "**/migrations/*.py"   # Django

jobs:
  static-check:
    name: Static analysis (no DB needed)
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4

      - uses: actions/setup-python@v5
        with:
          python-version: "3.12"

      - run: pip install pytest-mrt

      # Alembic
      - name: Check Alembic migrations
        run: mrt check alembic/versions/ --strict
        if: ${{ hashFiles('alembic/versions/*.py') != '' }}

      # Django (auto-detected)
      - name: Check Django migrations
        run: mrt check myapp/migrations/ --strict
        if: ${{ hashFiles('**/migrations/*.py') != '' }}

  dynamic-check:
    name: Dynamic verification (with DB)
    runs-on: ubuntu-latest
    needs: static-check

    services:
      postgres:
        image: postgres:16
        env:
          POSTGRES_USER: test
          POSTGRES_PASSWORD: test
          POSTGRES_DB: mrt_test
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
        ports:
          - 5432:5432

    steps:
      - uses: actions/checkout@v4

      - uses: actions/setup-python@v5
        with:
          python-version: "3.12"

      - run: pip install pytest-mrt[postgres]

      - name: Run rollback verification
        env:
          TEST_DATABASE_URL: postgresql://test:test@localhost/mrt_test
        run: pytest tests/test_migrations.py -v

  # Optional: run with MySQL too
  dynamic-check-mysql:
    name: Dynamic verification (MySQL)
    runs-on: ubuntu-latest
    needs: static-check

    services:
      mysql:
        image: mysql:8
        env:
          MYSQL_ROOT_PASSWORD: test
          MYSQL_DATABASE: mrt_test
        options: >-
          --health-cmd "mysqladmin ping -h localhost"
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
        ports:
          - 3306:3306

    steps:
      - uses: actions/checkout@v4

      - uses: actions/setup-python@v5
        with:
          python-version: "3.12"

      - run: pip install pytest-mrt[mysql]

      - name: Run rollback verification (MySQL)
        env:
          TEST_DATABASE_URL: mysql+pymysql://root:test@127.0.0.1/mrt_test
        run: pytest tests/test_migrations.py -v