Skip to content

Commit fbd4d0b

Browse files
delcroipdelcroip
committed
execute test all db
1 parent 706991b commit fbd4d0b

1 file changed

Lines changed: 53 additions & 13 deletions

File tree

‎.github/workflows/openmis-module-test.yml‎

Lines changed: 53 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -46,10 +46,10 @@ jobs:
4646
python -m pip install --upgrade pip
4747
- name: DB migration 1.42
4848
run: |
49-
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -Q 'DROP DATABASE IF EXISTS imis'
50-
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -Q 'CREATE DATABASE imis'
51-
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -d imis -i 1.42/openIMIS_ONLINE.sql | grep . | uniq -c
52-
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -d imis -i "new/Migration script/openIMIS migration latest.sql" | grep . | uniq -c
49+
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -Q 'DROP DATABASE IF EXISTS imis.1.4.2'
50+
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -Q 'CREATE DATABASE imis.1.4.2'
51+
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -d imis.1.4.2 -i 1.42/openIMIS_ONLINE.sql | grep . | uniq -c
52+
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -d imis.1.4.2 -i "new/Migration script/openIMIS migration latest.sql" | grep . | uniq -c
5353
env:
5454
SA_PASSWORD: GitHub999
5555
ACCEPT_EULA: Y
@@ -64,11 +64,11 @@ jobs:
6464
ACCEPT_EULA: Y
6565
- name: DB migration prev main
6666
run: |
67-
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -Q 'DROP DATABASE IF EXISTS imis'
68-
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -Q 'CREATE DATABASE imis'
69-
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -d imis -i oldMain/openIMIS_ONLINE.sql | grep . | uniq -c
70-
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -d imis -i oldMain/openIMIS_demo_ONLINE.sql | grep . | uniq -c
71-
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -d imis -i "new/Migration script/openIMIS migration latest.sql" | grep . | uniq -c
67+
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -Q 'DROP DATABASE IF EXISTS imis_main'
68+
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -Q 'CREATE DATABASE imis_main'
69+
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -d imis_main -i oldMain/openIMIS_ONLINE.sql | grep . | uniq -c
70+
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -d imis_main -i oldMain/openIMIS_demo_ONLINE.sql | grep . | uniq -c
71+
/opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -d imis_main -i "new/Migration script/openIMIS migration latest.sql" | grep . | uniq -c
7272
env:
7373
SA_PASSWORD: GitHub999
7474
ACCEPT_EULA: Y
@@ -84,11 +84,52 @@ jobs:
8484
python modules-requirements.py openimis.json > modules-requirements.txt
8585
cat modules-requirements.txt
8686
pip install -r modules-requirements.txt
87-
- name: Django tests
87+
- name: Django tests latest
88+
working-directory: ./openimis
89+
run: |
90+
python -V
91+
ls -l
92+
cd openIMIS
93+
python manage.py migrate
94+
python init_test_db.py | grep . | uniq -c
95+
python manage.py test --keepdb $(jq -r '(.modules[]|.name)' ../openimis.json)
96+
env:
97+
SECRET_KEY: secret
98+
DEBUG: true
99+
#DJANGO_SETTINGS_MODULE: hat.settings
100+
DB_HOST: localhost
101+
DB_PORT: 1433
102+
DB_NAME: imis
103+
DB_USER: sa
104+
DB_PASSWORD: GitHub999
105+
#DEV_SERVER: true
106+
SITE_ROOT: api
107+
REMOTE_USER_AUTHENTICATION: True
108+
- name: Django tests 1.4.2
109+
working-directory: ./openimis
110+
run: |
111+
python -V
112+
ls -l
113+
cd openIMIS
114+
python manage.py migrate
115+
python init_test_db.py | grep . | uniq -c
116+
python manage.py test --keepdb $(jq -r '(.modules[]|.name)' ../openimis.json)
117+
env:
118+
SECRET_KEY: secret
119+
DEBUG: true
120+
#DJANGO_SETTINGS_MODULE: hat.settings
121+
DB_HOST: localhost
122+
DB_PORT: 1433
123+
DB_NAME: imis.1.4.2
124+
DB_USER: sa
125+
DB_PASSWORD: GitHub999
126+
#DEV_SERVER: true
127+
SITE_ROOT: api
128+
REMOTE_USER_AUTHENTICATION: True
129+
- name: Django tests last main
88130
working-directory: ./openimis
89131
run: |
90132
python -V
91-
92133
ls -l
93134
cd openIMIS
94135
python manage.py migrate
@@ -100,10 +141,9 @@ jobs:
100141
#DJANGO_SETTINGS_MODULE: hat.settings
101142
DB_HOST: localhost
102143
DB_PORT: 1433
103-
DB_NAME: imis
144+
DB_NAME: imis_main
104145
DB_USER: sa
105146
DB_PASSWORD: GitHub999
106147
#DEV_SERVER: true
107148
SITE_ROOT: api
108149
REMOTE_USER_AUTHENTICATION: True
109-

0 commit comments

Comments
 (0)