---
- name: Playbook to find the snowflakes having manage_server_db set
  hosts: all
  gather_facts: false
  tasks:
    - name: Get plesk info
      plesk_info:
      register: plsk
    - name: On plesk server get me the state
      when: plsk.plesk_found
      ansible.builtin.shell: |
        set -o pipefail
        plesk db -N -e "SELECT p.value FROM Permissions p LEFT JOIN clients c ON c.perm_id = p.id WHERE p.permission = 'manage_server_db' AND c.id IS NOT NULL"
      args:
        executable: /bin/bash
      register: snowflake
      changed_when: false
    - name: If snowflake make flag
      when: snowflake.stdout == 'true'
      block:
        - name: Show debug
          ansible.builtin.debug:
            msg: "We have found a flake"
          changed_when: snowflake.stdout == 'true'
        - name: Create snowflake flag file
          ansible.builtin.shell: |
            set -o pipefail
            mkdir -p /opt/layershift/snowflake/
            touch /opt/layershift/snowflake/manage_server_phpmyadmin.flag
          args:
            executable: /bin/bash
          changed_when: false