-
Notifications
You must be signed in to change notification settings - Fork 6
45 lines (38 loc) · 1015 Bytes
/
database.yml
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
name: Test Database
on:
push:
branches:
- main
pull_request:
paths:
- 'db/**'
branches:
- main
jobs:
test-database:
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v2
- uses: actions/setup-python@v2
with:
python-version: 3.9
- uses: mirromutth/[email protected]
with:
mysql version: '8.0.22'
mysql database: 'esprr_data'
mysql root password: 'testpassword'
- name: Install Dependencies
run: |
cd db
python -m pip install --upgrade pip
pip install -r test-requirements.txt
pip list
- name: Migrate database
env:
DATABASE_URL: "mysql://root:[email protected]:3306/esprr_data"
run: |
curl -fsSL -o ./dbmate https://github.com/amacneil/dbmate/releases/latest/download/dbmate-linux-amd64
chmod +x ./dbmate
./dbmate --wait up
- name: Test
run: pytest db