peterholdsworth/flyway-action

Migrate database in Github Action

Flyway Action

This action runs Flyway v9 to migrate database. It aims to migrate database for testing in workflows.

Usage

name: Main
on:
  - push
jobs:
  test:
    runs-on: ubuntu-latest
    services:
      postgres:
        image: postgres
        env:
          POSTGRES_DB: db
          POSTGRES_USER: user
          POSTGRES_PASSWORD: password
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
    steps:
      - uses: actions/checkout@v2
      - uses: joshuaavalon/flyway-action@v3.0.0
        with:
          url: jdbc:postgresql://postgres:5432/db
          user: user
          password: password
      - run: echo 'testing'

Currently, it supports url, user, password, initSql and locations. locations are default to filesystem:./sql.

For details, please check out Flyway documentation.