---

- tags: mariadb
  block:

  - name: Package
    apt:
      state: present
      name:
        - mariadb-server
        - python3-pymysql
      update_cache: true

  - name: Service
    systemd:
      state: started
      name: mariadb
      enabled: true

  - name: Create new databases with names 'webapp' and 'webapp_backup'
    community.mysql.mysql_db:
      login_unix_socket: /var/run/mysqld/mysqld.sock
      name: "{{ item }}"
    loop: "{{ mariadb.databases }}"

  - name: DB User
    mysql_user:
      name: "{{ item.name }}"
      password: "{{ item.password }}"
      priv: "{{ item.priv }}"
      login_unix_socket: /var/run/mysqld/mysqld.sock
    loop: "{{ mariadb.users }}"
    loop_control:
      label: "{{ item.name }}"