mysql-schema-check.yml

# ---
# name: MySQL Schema Check
# on:
#   workflow_dispatch:
#   pull_request:
#     types: [opened, synchronize, reopened, ready_for_review]
#     paths:
#       - "schema.sql"
#   merge_group:
#   push:
#     paths:
#       - "schema.sql"
#     branches:
#       - main

# jobs:
#   mysql-schema-check:
#     runs-on: ubuntu-latest
#     services:
#       mysql:
#         image: mysql:8.0
#         env:
#           MYSQL_ROOT_PASSWORD: root
#           MYSQL_DATABASE: canary
#           MYSQL_USER: canary
#           MYSQL_PASSWORD: canary
#         ports:
#           - 3306/tcp
#         options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3
#     strategy:
#       fail-fast: false
#     name: Check
#     steps:
#       - name: Checkout repository
#         uses: actions/checkout@main
#       - name: 📌 MySQL Start & init & show db
#         run: |
#           sudo /etc/init.d/mysql start
#           mysql -e 'CREATE DATABASE canary;' -uroot -proot
#           mysql -e "SHOW DATABASES" -uroot -proot
#       - name: Import Canary Schema
#         run: |
#           mysql -uroot -proot canary < schema.sql