Skip to content

Update db.sql

Update db.sql #44

name: SQL Syntax Check
on:
pull_request:
paths:
- 'db.sql'
jobs:
syntax_check:
name: Check SQL Syntax
runs-on: ubuntu-latest
services:
mariadb:
image: mariadb:latest
env:
MYSQL_RANDOM_ROOT_PASSWORD: "yes" # Generate a random root password
MYSQL_DATABASE: test # optional, create a test database if needed
options: >-
--health-cmd="mysqladmin ping"
--health-interval=10s
--health-timeout=5s
--health-retries=3
--mount type=bind,source=${{ github.workspace }}/.github/workflows/init.sql,target=/docker-entrypoint-initdb.d/init.sql,readonly
ports:
- 3306:3306
steps:
- name: Checkout Repository
uses: actions/checkout@v2
- name: Generate init.sql
run: |
echo "DELETE FROM mysql.proxies_priv WHERE Host != 'localhost';" > init.sql
- name: Wait for MariaDB to Start
run: dockerize -wait tcp://127.0.0.1:3306 -timeout 1m
- name: Run SQL Linting
run: |
password="${{ job.services.mariadb.env.MYSQL_ROOT_PASSWORD }}"
docker exec -i mariadb mysql -uroot -p"$password" < db.sql
- name: Stop MariaDB
run: docker stop mariadb