try to reconcile the input database file #14
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: Functional Test | |
on: | |
pull_request: | |
branches: [ main ] | |
push: | |
branches: [ provider-model ] | |
jobs: | |
setup-mysql: | |
runs-on: ubuntu-latest | |
steps: | |
- uses: actions/checkout@v2 | |
- uses: actions/setup-go@v3 | |
with: | |
go-version: '1.21' | |
- name: Start MySQL | |
run: sudo /etc/init.d/mysql start | |
- name: Create Database | |
run: mysql -e 'CREATE DATABASE test_db;' -uroot -proot | |
- name: Import database | |
run: mysql -uroot -proot test_db < .github/workflows/functional-test.sql | |
- name: Build MTK | |
run: make build | |
- name: Dump database | |
run: bin/mtk-linux-amd64 dump test_db --port=3306 --user=root --password=root --host=127.0.0.1 > mtk-dump.sql | |
- name: Drop Database | |
run: mysql -e 'DROP DATABASE test_db;' -uroot -proot | |
- name: Clean database file | |
run: | | |
sed '$d' mtk-dump.sql > mtk-dump-clean.sql | |
- name: Create Database | |
run: mysql -e 'CREATE DATABASE test_db;' -uroot -proot | |
- name: Import database | |
run: mysql -uroot -proot test_db < mtk-dump-clean.sql | |
- name: Upload diff as artifact | |
uses: actions/upload-artifact@v2 | |
with: | |
name: file-diff | |
path: | | |
.github/workflows/functional-test.sql | |
mtk-dump-clean.sql | |
- name: Generate diff | |
run: diff -q .github/workflows/functional-test.sql mtk-dump-clean.sql |