github-mysql-migration-action

GitHub MariaDB/MySQL migration action

🎲 :octocat: A GitHub action to manage MariaDB/MySQL versioned migrations.

Usage

Parameters

• OPERATION (required) The operation to be executed (one of: dry-run, migrate, check, or integrity)
• MYSQL_HOST (required) The MariaDB/MySQL host address (domain or IPv4 address).
• MYSQL_USER (required) The username to connect in the MySQL/MariaDB host.
• MYSQL_DATABASE (required) The database name.
• INTEGRITY_COMMANDS_FILE (optional) When the OPERATION is integrity, this parameter receives the file with a list (one per line) of commands to run and validate the presence of data in the database.

Environment variables

• MYSQL_PWD (optional) The password to connect to the MySQL/MariaDB host. This needs to be set as an environment variable to keep it safe.

Outputs

None.

Example

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

  jobs:
    test:
      runs-on: ubuntu-latest
      steps:
      
      - uses: actions/checkout@v4
  
      - name: Run the action
        uses: guibranco/github-mysql-migration-action@latest
        env:
          MYSQL_PWD: $ # Pass the password as an environment variable to keep it secret.
        with:
          OPERATION: migrate
          MYSQL_HOST: 127.0.0.1
          MYSQL_USER: test
          MYSQL_DATAABSE: test          

This site is open source. Improve this page.