diff options
author | Matt Clay <matt@mystile.com> | 2016-10-13 09:09:25 -0700 |
---|---|---|
committer | GitHub <noreply@github.com> | 2016-10-13 09:09:25 -0700 |
commit | 75e4645ee70434e2706845ca9fe96d5823616eea (patch) | |
tree | 360f27f11eeb33ba993ae3f30764589b3981e99c /test/integration/targets/mysql_db | |
parent | 374e4348e4d76cff7c0e6e41cb2368799c0ae443 (diff) | |
download | ansible-75e4645ee70434e2706845ca9fe96d5823616eea.tar.gz |
Migrate Linux CI roles to test targets. (#17997)
Diffstat (limited to 'test/integration/targets/mysql_db')
4 files changed, 283 insertions, 0 deletions
diff --git a/test/integration/targets/mysql_db/defaults/main.yml b/test/integration/targets/mysql_db/defaults/main.yml new file mode 100644 index 0000000000..456ba0eb4c --- /dev/null +++ b/test/integration/targets/mysql_db/defaults/main.yml @@ -0,0 +1,8 @@ +--- +# defaults file for test_mysql_db +db_name: 'data' +db_user1: 'datauser1' +db_user2: 'datauser2' + +tmp_dir: '/tmp' + diff --git a/test/integration/targets/mysql_db/meta/main.yml b/test/integration/targets/mysql_db/meta/main.yml new file mode 100644 index 0000000000..4aa170dc06 --- /dev/null +++ b/test/integration/targets/mysql_db/meta/main.yml @@ -0,0 +1,2 @@ +dependencies: + - setup_mysql_db diff --git a/test/integration/targets/mysql_db/tasks/main.yml b/test/integration/targets/mysql_db/tasks/main.yml new file mode 100644 index 0000000000..1c2adcce8e --- /dev/null +++ b/test/integration/targets/mysql_db/tasks/main.yml @@ -0,0 +1,198 @@ +# test code for the mysql_db module +# (c) 2014, Wayne Rosario <wrosario@ansible.com> + +# This file is part of Ansible +# +# Ansible is free software: you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation, either version 3 of the License, or +# (at your option) any later version. +# +# Ansible is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with Ansible. If not, see <http://www.gnu.org/licenses/>. + +# ============================================================ + +- name: make sure the test database is not there + command: mysql {{db_name}} + register: mysql_db_check + failed_when: "'1049' not in mysql_db_check.stderr" + +- name: test state=present for a database name (expect changed=true) + mysql_db: name={{ db_name }} state=present + register: result + +- name: assert output message that database exist + assert: + that: + - "result.changed == true" + - "result.db =='{{ db_name }}'" + +- name: run command to test state=present for a database name (expect db_name in stdout) + command: mysql "-e show databases like '{{ db_name }}';" + register: result + +- name: assert database exist + assert: { that: "'{{ db_name }}' in result.stdout" } + +# ============================================================ +- name: test state=absent for a database name (expect changed=true) + mysql_db: name={{ db_name }} state=absent + register: result + +- name: assert output message that database does not exist + assert: + that: + - "result.changed == true" + - "result.db =='{{ db_name }}'" + +- name: run command to test state=absent for a database name (expect db_name not in stdout) + command: mysql "-e show databases like '{{ db_name }}';" + register: result + +- name: assert database does not exist + assert: { that: "'{{ db_name }}' not in result.stdout" } + +# ============================================================ +- name: test mysql_db encoding param not valid - issue 8075 + mysql_db: name=datanotvalid state=present encoding=notvalid + register: result + ignore_errors: true + +- name: assert test mysql_db encoding param not valid - issue 8075 (failed=true) + assert: + that: + - "result.failed == true" + - "'Traceback' not in result.msg" + - "'Unknown character set' in result.msg" + +# ============================================================ +- name: test mysql_db using a valid encoding utf8 (expect changed=true) + mysql_db: name=en{{ db_name }} state=present encoding=utf8 + register: result + +- name: assert output message created a database + assert: { that: "result.changed == true" } + +- name: test database was created + command: mysql "-e SHOW CREATE DATABASE en{{ db_name }};" + register: result + +- name: assert created database is of encoding utf8 + assert: { that: "'utf8' in result.stdout" } + +- name: remove database + mysql_db: name=en{{ db_name }} state=absent + +# ============================================================ +- name: test mysql_db using valid encoding binary (expect changed=true) + mysql_db: name=en{{ db_name }} state=present encoding=binary + register: result + +- name: assert output message that database was created + assert: { that: "result.changed == true" } + +- name: run command to test database was created + command: mysql "-e SHOW CREATE DATABASE en{{ db_name }};" + register: result + +- name: assert created database is of encoding binary + assert: { that: "'binary' in result.stdout" } + +- name: remove database + mysql_db: name=en{{ db_name }} state=absent + +# ============================================================ +- name: create user1 to access database dbuser1 + mysql_user: name=user1 password=password1 priv=*.*:ALL state=present + +- name: create database dbuser1 using user1 + mysql_db: name={{ db_user1 }} state=present login_user=user1 login_password=password1 + register: result + +- name: assert output message that database was created + assert: { that: "result.changed == true" } + +- name: run command to test database was created using user1 + command: mysql "-e show databases like '{{ db_user1 }}';" + register: result + +- name: assert database exist + assert: { that: "'{{ db_user1 }}' in result.stdout" } + +# ============================================================ +- name: create user2 to access database with privilege select only + mysql_user: name=user2 password=password2 priv=*.*:SELECT state=present + +- name: create database dbuser2 using user2 with no privilege to create (expect failed=true) + mysql_db: name={{ db_user2 }} state=present login_user=user2 login_password=password2 + register: result + ignore_errors: true + +- name: assert output message that database was not created using dbuser2 + assert: + that: + - "result.failed == true" + - "'Access denied' in result.msg" + +- name: run command to test that database was not created + command: mysql "-e show databases like '{{ db_user2 }}';" + register: result + +- name: assert database does not exist + assert: { that: "'{{ db_user2 }}' not in result.stdout" } + +# ============================================================ +- name: delete database using user2 with no privilege to delete (expect failed=true) + mysql_db: name={{ db_user1 }} state=absent login_user=user2 login_password=password2 + register: result + ignore_errors: true + +- name: assert output message that database was not deleted using dbuser2 + assert: + that: + - "result.failed == true" + - "'Access denied' in result.msg" + +- name: run command to test database was not deleted + command: mysql "-e show databases like '{{ db_user1 }}';" + register: result + +- name: assert database still exist + assert: { that: "'{{ db_user1 }}' in result.stdout" } + +# ============================================================ +- name: delete database using user1 with all privilege to delete a database (expect changed=true) + mysql_db: name={{ db_user1 }} state=absent login_user=user1 login_password=password1 + register: result + ignore_errors: true + +- name: assert output message that database was deleted using user1 + assert: { that: "result.changed == true" } + +- name: run command to test database was deleted using user1 + command: mysql "-e show databases like '{{ db_name }}';" + register: result + +- name: assert database does not exist + assert: { that: "'{{ db_user1 }}' not in result.stdout" } + +# ============================================================ +- include: state_dump_import.yml format_type=sql file=dbdata.sql format_msg_type=ASCII + +- include: state_dump_import.yml format_type=gz file=dbdata.gz format_msg_type=gzip + +- include: state_dump_import.yml format_type=bz2 file=dbdata.bz2 format_msg_type=bzip2 + + + + + + + + diff --git a/test/integration/targets/mysql_db/tasks/state_dump_import.yml b/test/integration/targets/mysql_db/tasks/state_dump_import.yml new file mode 100644 index 0000000000..44267e1edb --- /dev/null +++ b/test/integration/targets/mysql_db/tasks/state_dump_import.yml @@ -0,0 +1,75 @@ +# test code for state dump and import for mysql_db module +# (c) 2014, Wayne Rosario <wrosario@ansible.com> + +# This file is part of Ansible +# +# Ansible is free software: you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation, either version 3 of the License, or +# (at your option) any later version. +# +# Ansible is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with Ansible. If not, see <http://www.gnu.org/licenses/>. + +# ============================================================ +- set_fact: db_file_name="{{tmp_dir}}/{{file}}" + +- name: state dump/import - create database + mysql_db: name={{ db_name }} state=present + +- name: state dump/import - create table employee + command: mysql {{ db_name }} '-e create table employee(id int, name varchar(100));' + +- name: state dump/import - insert data into table employee + command: mysql {{ db_name }} "-e insert into employee value(47,'Joe Smith');" + +- name: state dump/import - file name should not exist + file: name={{ db_file_name }} state=absent + +- name: test state=dump to backup the database of type {{ format_type }} (expect changed=true) + mysql_db: name={{ db_name }} state=dump target={{ db_file_name }} + register: result + +- name: assert output message backup the database + assert: + that: + - "result.changed == true" + - "result.db =='{{ db_name }}'" + +- name: assert database was backup successfully + command: file {{ db_file_name }} + register: result + +- name: assert file format type + assert: { that: "'{{format_msg_type}}' in result.stdout" } + +- name: update database table employee + command: mysql {{ db_name }} "-e update employee set name='John Doe' where id=47;" + +- name: test state=import to restore the database of type {{ format_type }} (expect changed=true) + mysql_db: name={{ db_name }} state=import target={{ db_file_name }} + register: result + +- name: assert output message restore the database + assert: { that: "result.changed == true" } + +- name: select data from table employee + command: mysql {{ db_name }} "-e select * from employee;" + register: result + +- name: assert data in database is from the restore database + assert: + that: + - "'47' in result.stdout" + - "'Joe Smith' in result.stdout" + +- name: remove database name + mysql_db: name={{ db_name }} state=absent + +- name: remove file name + file: name={{ db_file_name }} state=absent |