# vendor/bin/wp option delete _site_transient_update_themes
# vendor/bin/wp option delete _site_transient_theme_roots

- hosts: remote
  vars:
    src_dir: "{{playbook_dir}}/build/tmp/rc/src/"
  tasks:

    - name: create temporary file
      tempfile:
        state: file
        suffix: sql
      register: sql_tmp_path

    - name: dump and fetch
      block:
        - name: dump database
          command:
            argv:
              - "{{remote_path}}/vendor/bin/wp"
              - db
              - export
              - "{{sql_tmp_path.path}}"
          args:
            chdir: "{{remote_path}}"

        - name: transfer sql file
          fetch:
            src: "{{sql_tmp_path.path}}"
            dest: "{{db_file_path}}"
            flat: yes
      always:
        - name: delete temporary file
          file:
            path: "{{sql_tmp_path.path}}"
            state: absent