Readme: Replace MySQL with MariaDB #409
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: Build | |
on: [push,pull_request] | |
env: | |
FLYWAY_VERSION: 7.15.0 | |
jobs: | |
build: | |
runs-on: ubuntu-latest | |
services: | |
faf-db: | |
image: mariadb:10.6 | |
ports: | |
- 3306:3306 | |
options: >- | |
--health-cmd "mysqladmin ping --silent" | |
--health-interval 10s | |
--health-timeout 5s | |
--health-retries 5 | |
env: | |
MYSQL_ROOT_PASSWORD: banana | |
MYSQL_DATABASE: faf | |
MYSQL_USER: faf-java-api | |
MYSQL_PASSWORD: banana | |
steps: | |
- name: Checkout code | |
# Upgrading to v2 will break the submodule checkout as long as ubuntu-latest ships with Git 2.17 | |
uses: actions/checkout@v1 | |
with: | |
submodules: true | |
- name: Install tools | |
run: sudo apt update && sudo apt install -y wget | |
- name: Install flyway | |
run: wget -qO- https://repo1.maven.org/maven2/org/flywaydb/flyway-commandline/${FLYWAY_VERSION}/flyway-commandline-${FLYWAY_VERSION}-linux-x64.tar.gz | tar xvz && sudo ln -s `pwd`/flyway-${FLYWAY_VERSION}/flyway /usr/local/bin | |
- name: Run flyway db migrations | |
env: | |
FLYWAY_URL: jdbc:mysql://localhost/faf?useSSL=false | |
FLYWAY_USER: root | |
FLYWAY_PASSWORD: banana | |
FLYWAY_LOCATIONS: filesystem:migrations | |
FLYWAY_VALIDATE_MIGRATION_NAMING: "true" | |
run: flyway migrate | |
- name: Run test-data.sql | |
env: | |
MYSQL_HOST: 127.0.0.1 | |
MYSQL_DATABASE: faf | |
MYSQL_ROOT_PASSWORD: banana | |
run: ./ci/test-data.sh | |
- name: Run migration on anonymized db extract | |
env: | |
MYSQL_HOST: 127.0.0.1 | |
MYSQL_DATABASE: faf | |
MYSQL_ROOT_PASSWORD: banana | |
FLYWAY_URL: jdbc:mysql://127.0.0.1/faf?useSSL=false | |
FLYWAY_USER: root | |
FLYWAY_PASSWORD: banana | |
FLYWAY_LOCATIONS: filesystem:migrations | |
FLYWAY_TABLE: schema_version | |
run: ./ci/test-migrations.sh | |
- name: Generate schemaspy docs | |
if: github.ref == 'refs/heads/develop' | |
run: ./ci/schemaspy.sh | |
- name: Publish to Github Pages | |
if: github.ref == 'refs/heads/develop' | |
uses: peaceiris/actions-gh-pages@v3 | |
with: | |
github_token: ${{ secrets.GITHUB_TOKEN }} | |
publish_dir: ./public | |
- name: Build and push Docker images | |
if: github.ref == 'refs/heads/develop' || startsWith(github.ref, 'refs/tags') | |
uses: docker/[email protected] | |
with: | |
username: ${{ secrets.DOCKER_USERNAME }} | |
password: ${{ secrets.DOCKER_PASSWORD }} | |
repository: faforever/faf-db-migrations | |
tag_with_ref: true |