---
- 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:
        - plsk.plesk_found
        - snowflake is defined
        - "'true' in snowflake.stdout"
      block:
        - name: Show debug
          ansible.builtin.debug:
            msg: "We have found a flake"
          changed_when: true
        - name: Create snowflake flag file
          ansible.builtin.shell: |
            set -o pipefail
            echo "test"
            #mkdir -p /opt/layershift/snowflake/
            #touch /opt/layershift/snowflake/manage_server_phpmyadmin.flag
          args:
            executable: /bin/bash
          changed_when: false