- name: mkdir /opt/sz-ds/flyway
  file:
    state: directory
    path: /opt/sz-ds/flyway
- name: /opt/sz-ds/bin/flyway
  template:
    src: opt/sz-ds/bin/flyway.j2
    dest: /opt/sz-ds/bin/flyway
- name: /etc/sz-ds/flyway.conf
  tags: update-password
  copy:
    dest: /etc/sz-ds/flyway.conf
    content: |
      flyway.url=jdbc:postgresql://localhost/sz-ds
      flyway.user=sz-ds-flyway
      flyway.password={{ sz_ds_secret.db_password_flyway }}

      flyway.locations=filesystem:/opt/sz-ds/src/SweetzpotCentral/data-server/migrations
      flyway.schemas=public
- name: Download and extract Flyway {{ flyway_version }}
  unarchive:
    src: "https://repo1.maven.org/maven2/org/flywaydb/flyway-commandline/{{ flyway_version }}/flyway-commandline-{{ flyway_version }}.zip"
    dest: /opt/sz-ds/flyway
    creates: "/opt/sz-ds/flyway/flyway-{{ flyway_version }}"
    remote_src: yes
- name: chmod +x flyway
  file:
    path: "/opt/sz-ds/flyway/flyway-{{ flyway_version }}/flyway"
    mode: a=rx