name: test mysql8
on: 
  push:
    branches:
      - main
  pull_request:

jobs:
  test:
    name: test mysql8
    runs-on: ubuntu-latest
    steps:
      - run: apt-get update && apt-get install -y lsb-release inetutils-tools
      - run: wget https://dev.mysql.com/get/mysql-apt-config_0.8.24-1_all.deb
      - run: DEBIAN_FRONTEND=noninteractive dpkg -i mysql-apt-config_0.8.24-1_all.deb
      - run: apt-key adv --keyserver keyserver.ubuntu.com --recv-keys B7B3B788A8D3785C 
      - run: apt-get update
      - run: apt install -y default-mysql-client 
      - run: mysql -h mysql8 -u root -e '\q'

    services:
      mysql8:
        image: mysql:8.0
        env:
          MYSQL_ALLOW_EMPTY_PASSWORD: yes
          MYSQL_DATABASE: test_db
        ports:
          - 3306:3306