---
- 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: Save the name into a file
          ansible.builtin.lineinfile:
            path: "/home/ssh-gateway/ansible/kuly/RM10090_snowflakes.txt"
            create: true
            mode: '0644'
            line: "{{ inventory_hostname }}"
          delegate_to: 127.0.0.1
        - 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