/etc/ansible/roles/os_murano/tasks/db_setup.yml
---
# Copyright 2019, VEXXHOST, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

# WARNING:
# This file is maintained in the openstack-ansible-tests repository.
# https://git.openstack.org/cgit/openstack/openstack-ansible-tests/tree/sync/tasks/db_setup.yml
# If you need to modify this file, update the one in the openstack-ansible-tests
# repository. Once it merges there, the changes will automatically be proposed to
# all the repositories which use it.

- name: Setup Database Service (MariaDB)
  delegate_to: "{{ _oslodb_setup_host }}"
  tags:
    - common-mariadb
  block:
    - name: Create database for service
      mysql_db:
        name: "{{ item.name }}"
      loop: "{{ _oslodb_databases }}"
      no_log: true

    - name: Grant access to the database for the service
      mysql_user:
        name: "{{ item.1.username }}"
        password: "{{ item.1.password }}"
        host: "{{ item.1.host | default('%') }}"
        priv: "{{ item.0.name }}.*:{{ item.1.priv | default('ALL') }}"
        append_privs: yes
      loop: "{{ _oslodb_databases | subelements('users') }}"
      no_log: true