Unit tests #539
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: Unit tests | |
| permissions: read-all | |
| on: | |
| push: | |
| branches: | |
| - master | |
| tags: | |
| - "**" | |
| schedule: | |
| - cron: "0 0 * * SUN" | |
| pull_request: | |
| jobs: | |
| lint: | |
| runs-on: ubuntu-20.04 | |
| strategy: | |
| matrix: | |
| # only use one version for the lint step | |
| # pylint is broken with 3.11, see | |
| # https://github.com/PyCQA/pylint/issues/6535 | |
| python-version: ["3.10"] | |
| env: | |
| MYSQL_VERSION: mysql-8.0 | |
| steps: | |
| - id: checkout-code | |
| uses: actions/checkout@v4 | |
| with: | |
| persist-credentials: false | |
| - name: Cache APT Packages | |
| uses: awalsh128/[email protected] | |
| with: | |
| version: 1.0 | |
| packages: sudo lsb-release wget tzdata libsnappy-dev libpq5 libpq-dev software-properties-common build-essential rsync curl | |
| - id: prepare-python | |
| uses: actions/setup-python@v5 | |
| with: | |
| python-version: ${{ matrix.python-version }} | |
| - id: mysql-repos | |
| run: | | |
| wget -c 'https://repo.mysql.com/mysql-apt-config_0.8.22-1_all.deb' | |
| echo "mysql-apt-config mysql-apt-config/select-server select $MYSQL_VERSION" | sudo debconf-set-selections | |
| echo "mysql-apt-config mysql-apt-config/select-tools select Enabled" | sudo debconf-set-selections | |
| echo "mysql-apt-config mysql-apt-config/select-product select Ok" | sudo debconf-set-selections | |
| echo "mysql-apt-config mysql-apt-config/tools-component string mysql-tools" | sudo debconf-set-selections | |
| sudo dpkg -i mysql-apt-config_0.8.22-1_all.deb | |
| - id: percona-tools | |
| run: | | |
| wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb | |
| sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb | |
| sudo percona-release enable-only tools | |
| sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys B7B3B788A8D3785C | |
| sudo apt update | |
| - id: build-deps | |
| run: | | |
| sudo apt-get update | |
| sudo apt install -y libsnappy-dev | |
| sudo apt-get install -q -y --allow-unauthenticated -o Dpkg::Options::=--force-confnew mysql-server percona-xtrabackup-80 | |
| mysqld --version | |
| - id: python-deps | |
| run: | | |
| pip install -e . | |
| pip install -e '.[dev]' | |
| - id: pre-commit | |
| run: pre-commit run --all | |
| - id: copyright | |
| run: make copyright | |
| unittest: | |
| runs-on: ubuntu-${{ matrix.ubuntu-version }} | |
| strategy: | |
| fail-fast: false | |
| # this isn't a standard matrix because some version testing doesn't make sense | |
| # e.g. you cannot use mysql .28 with percona .27, and there's no clean way of | |
| # skipping matrix items that aren't meaningful | |
| matrix: | |
| include: | |
| - mysql-version: "8.0.32" | |
| percona-version: "8.0.32-26-1.focal" | |
| python-version: "3.9" | |
| ubuntu-version: "20.04" | |
| - mysql-version: "8.0.32" | |
| percona-version: "8.0.32-26-1.focal" | |
| python-version: "3.10" | |
| ubuntu-version: "20.04" | |
| - mysql-version: "8.0.32" | |
| percona-version: "8.0.32-26-1.focal" | |
| python-version: "3.11" | |
| ubuntu-version: "20.04" | |
| - mysql-version: "8.0.35" | |
| percona-version: "8.0.35-30-1.focal" | |
| python-version: "3.11" | |
| ubuntu-version: "20.04" | |
| steps: | |
| - id: checkout-code | |
| uses: actions/checkout@v4 | |
| - name: Cache APT Packages | |
| uses: awalsh128/[email protected] | |
| with: | |
| version: 1.0 | |
| packages: sudo lsb-release wget tzdata libsnappy-dev libpq5 libpq-dev software-properties-common build-essential rsync curl git libaio1 libmecab2 psmisc | |
| - id: prepare-python | |
| uses: actions/setup-python@v5 | |
| with: | |
| python-version: ${{ matrix.python-version }} | |
| cache: pip | |
| cache-dependency-path: | | |
| **/requirements.txt | |
| **/requirements.dev.txt | |
| - run: make clean | |
| - run: sudo scripts/remove-default-mysql | |
| - run: sudo scripts/install-mysql-packages ${{matrix.mysql-version}} | |
| - run: sudo scripts/setup-percona-repo | |
| - run: sudo scripts/install-percona-package ${{matrix.percona-version}} | |
| - run: scripts/install-python-deps | |
| - run: python -m pip install -e . | |
| - id: unittest | |
| run: | | |
| make coverage | |
| - id: upload-codecov | |
| uses: codecov/codecov-action@v3 | |
| with: | |
| verbose: true |