#
# Task: import
#
# @author Björn Hase, <herrhase@node001.net>
#

- name: name of database for Import
  pause:
    prompt: "Dbname?"
  register: mariadb_dbname

- name: locale-Path for SQL-file
  pause:
    prompt: "Locale Path for SQL-File?"
  register: mariadb_sql_path

- name: copy SQL-file to Db-Server
  copy:
    src: "{{ item }}"
    dest: "/tmp/{{ mariadb_dbname.user_input }}.sql"
  with_items: "{{ mariadb_sql_path.user_input }}"
  when: mariadb_sql_path.user_input

- name: import SQL-file
  community.mysql.mysql_db:
    state: import
    name: "{{ mariadb_dbname.user_input }}"
    login_user: "{{ mariadb_admin_user }}"
    login_unix_socket: "{{ mariadb_socket }}"
    target: "/tmp/{{ mariadb_dbname.user_input }}.sql"

- name: delete SQL-file from Db-Server
  file:
    path: "/tmp/{{ mariadb_dbname.user_input }}.sql"
    state: absent