Skip to content

fix: ports

fix: ports #14

Workflow file for this run

name: Validations
on:
push:
pull_request:
workflow_dispatch:
jobs:
build:
runs-on: ubuntu-latest
name: SQL Validations
services:
mysql:
image: mysql:5.7
env:
MYSQL_DATABASE: cideades_e_estados
MYSQL_USER: user
MYSQL_PASSWORD: password
MYSQL_ROOT_PASSWORD: rootpassword
ports:
- 3306:3306
options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3
env:
DB_DATABASE: cideades_e_estados
DB_USER: root
DB_PASSWORD: rootpassword
steps:
- uses: actions/checkout@v4
- name: run SQL with no errors
run: |
mysql -h 127.0.0.1 -e 'CREATE DATABASE IF NOT EXISTS cideades_e_estados;' -u${{ env.DB_USER }} -p${{ env.DB_PASSWORD }}
mysql -h 127.0.0.1 --default-character-set=utf8 cideades_e_estados < src/cidades-e-estados.sql -u${{ env.DB_USER }} -p${{ env.DB_PASSWORD }}
mysql -h 127.0.0.1 -e 'USE cideades_e_estados; DROP TABLE cidades; DROP TABLE estados;' -u${{ env.DB_USER }} -p${{ env.DB_PASSWORD }}
mysql -h 127.0.0.1 --default-character-set=utf8 cideades_e_estados < src/estados.sql -u${{ env.DB_USER }} -p${{ env.DB_PASSWORD }}
mysql -h 127.0.0.1 --default-character-set=utf8 cideades_e_estados < src/cidades.sql -u${{ env.DB_USER }} -p${{ env.DB_PASSWORD }}