digdag-plugin-mysql

Digdag mysql> operator plugin to execute a query on MySQL server.

Caution: Update query still development.

configuration

Release list.

_export:
  plugin:
    repositories:
    repositories:
      #- file://${repos}
      #- file:///path/to/digdag-plugin-mysql/build/repo
      - https://jitpack.io
    dependencies:
      - com.github.hiroyuki-sato:digdag-plugin-mysql:0.1.1

  mysql:
    host: localhost
    user: root
    database: digdag_test
    ssl: true

+step1:
  mysql>: test.sql
  download_file: test.txt

Register mysql password into secrets.

local mode

digdag secrets --local --set mysql.password

server mode

digdag secrets --project <project> --set mysql.password

Development

1) build

./gradlew publish

Artifacts are build on local repos: ./build/repo.

2) run an example

digdag selfupdate

rm -rf sample/.digdag/plugin 
digdag run -a --project sample plugin.dig -p repos=`pwd`/build/repo