Refactor MySQLConnection to use connection pooling and update connect… #3224
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: Test Application | |
| on: [push, pull_request] | |
| jobs: | |
| build: | |
| runs-on: ubuntu-20.04 | |
| services: | |
| postgres: | |
| image: postgres:10.8 | |
| env: | |
| POSTGRES_USER: postgres | |
| POSTGRES_PASSWORD: postgres | |
| POSTGRES_DB: postgres | |
| ports: | |
| # will assign a random free host port | |
| - 5432/tcp | |
| # needed because the postgres container does not provide a healthcheck | |
| options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5 | |
| mysql: | |
| image: mysql:5.7 | |
| env: | |
| MYSQL_ALLOW_EMPTY_PASSWORD: yes | |
| MYSQL_DATABASE: orm | |
| ports: | |
| - 3306 | |
| options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3 | |
| strategy: | |
| matrix: | |
| python-version: ["3.6", "3.7", "3.8", "3.9"] | |
| name: Python ${{ matrix.python-version }} | |
| steps: | |
| - uses: actions/checkout@v1 | |
| - name: Set up Python ${{ matrix.python-version }} | |
| uses: actions/setup-python@v4 | |
| with: | |
| python-version: ${{ matrix.python-version }} | |
| - name: Install dependencies | |
| run: | | |
| make init | |
| - name: Test with pytest | |
| env: | |
| POSTGRES_DATABASE_HOST: localhost | |
| POSTGRES_DATABASE_DATABASE: postgres | |
| POSTGRES_DATABASE_USER: postgres | |
| POSTGRES_DATABASE_PASSWORD: postgres | |
| POSTGRES_DATABASE_PORT: ${{ job.services.postgres.ports[5432] }} | |
| MYSQL_DATABASE_HOST: localhost | |
| MYSQL_DATABASE_DATABASE: orm | |
| MYSQL_DATABASE_USER: root | |
| MYSQL_DATABASE_PORT: ${{ job.services.mysql.ports[3306] }} | |
| DB_CONFIG_PATH: tests/integrations/config/database.py | |
| run: | | |
| python orm migrate --connection postgres | |
| python orm migrate --connection mysql | |
| make test | |
| lint: | |
| runs-on: ubuntu-20.04 | |
| name: Lint | |
| steps: | |
| - uses: actions/checkout@v1 | |
| - name: Set up Python 3.6 | |
| uses: actions/setup-python@v4 | |
| with: | |
| python-version: 3.6 | |
| - name: Install Flake8 | |
| run: | | |
| pip install flake8==3.7.9 | |
| - name: Lint | |
| run: make lint |