-
Notifications
You must be signed in to change notification settings - Fork 8
79 lines (76 loc) · 2.15 KB
/
migrations-workflow.yaml
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
name: migrations-wf
on:
push:
tags:
- 'v*.*.*'
branches:
- "main"
paths:
- "api/alembic/**"
- ".github/workflows/migrations-**"
pull_request:
branches:
- "*"
paths:
- "api/alembic/**"
- ".github/workflows/migrations-**"
env:
POETRY_VERSION: "1.8.3"
PYTHON_VERSION: "3.11"
jobs:
test:
runs-on: ubuntu-22.04
defaults:
run:
working-directory: ./api
services:
# Setup postgres as service to run test migrations
postgres:
image: postgres:latest
env:
POSTGRES_PASSWORD: postgres
POSTGRES_DB: postgres
POSTGRES_USER: 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 Python
uses: actions/setup-python@v5
with:
python-version: ${{ env.PYTHON_VERSION }}
- name: Setup poetry
run: |
curl -sSL https://install.python-poetry.org | POETRY_VERSION=${{ env.POETRY_VERSION }} python -
poetry lock
- name: Install dependencies
run: |
poetry install
- name: Run migrations
run: |
poetry run alembic upgrade head
env:
DB_URL: localhost:5432
DB_USER: postgres
DB_PWD: postgres
build-migrations:
needs: [test]
if: github.event_name != 'pull_request'
uses: radicalbit/radicalbit-github-workflows/.github/workflows/docker.yaml@v1
with:
push: ${{ github.event_name != 'pull_request' }}
context: ./api
dockerfile: migrations.Dockerfile
image: radicalbit-ai-monitoring-migrations
tag: ${{ startsWith(github.ref, 'refs/tags/v') && github.ref_name || 'develop' }}
dockerhub_shortdesc: "Radicalbit AI Monitoring - database migrations"
dockerhub_push_latest: ${{ startsWith(github.ref, 'refs/tags/v') }}
secrets:
USERNAME: ${{ secrets.DOCKER_HUB_USER }}
PASSWORD: ${{ secrets.DOCKER_HUB_PAT }}
ORGANIZATION: ${{ secrets.DOCKER_HUB_ORG }}