Files @ 3dd7f39302f8
Branch filter:

Location: majic-ansible-roles/roles/database/tests/test_backup.py

branko
MAR-29: Implemented tests for php_website role:

- Install some additional tools for testing everything.
- Updated test playbook to change allowed extensions for running PHP scripts on
parameters-optional.
- Updated error page to use correct extension for parameters-optional test
instance.
- Expanded rewrite configuration slightly for parameters-optional.
- Install libmariadb-client-lgpl-dev-compat to test mysql_config symlink
creation.
- Deploy a number of PHP pages used for testing if pages are served correctly.
- Set file permissions on deployed PHP FPM pool configuraiton files.
- Use expanded syntax when deploying TLS keys/certificates in order to avoid
issues with TAB mangling.
- Fixed set-up of Strict-Transport-Security header when HTTPS enforcement is
disabled.
- Added a number of PHP and static test pages.
- Wrote tests covering full functionality of the role.
import testinfra.utils.ansible_runner

testinfra_hosts = testinfra.utils.ansible_runner.AnsibleRunner(
    '.molecule/ansible_inventory').get_hosts('backup')


def test_backup_directories(File, Sudo):
    """
    Tests if backup directories have been set-up correctly.
    """

    with Sudo():
        directories = ["/srv/backup", "/srv/backup/mariadb"]

        for path in directories:

            directory = File(path)

            assert directory.is_directory
            assert directory.user == 'root'
            assert directory.group == 'root'
            assert directory.mode == 0o700


def test_backup_script_file(File, Sudo):
    """
    Tests if backup script file for dumping database has been set-up correctly.
    """

    with Sudo():
        script = File('/etc/duply/main/pre.d/dump_testdb.sh')

        assert script.is_file
        assert script.user == 'root'
        assert script.group == 'root'
        assert script.mode == 0o700
        assert "/usr/bin/mysqldump \"testdb\" > \"/srv/backup/mariadb/testdb.sql\"" in script.content


def test_backup_run(Command, File, Sudo):
    """
    Tests if backup runs correctly, and if restore will included the backed-up
    database.
    """

    with Sudo():

        # Remove restore directory in order to make sure restore has worked
        # correctly.
        Command("rm -rf /root/restore")

        backup_run = Command('duply main backup')
        assert backup_run.rc == 0

        database_dump = File('/srv/backup/mariadb/testdb.sql')
        assert database_dump.is_file
        assert 'Database: testdb' in database_dump.content

        restore_run = Command('duply main restore /root/restore')
        assert restore_run.rc == 0

        restored_database_dump = File('/root/restore/srv/backup/mariadb/testdb.sql')
        assert restored_database_dump.is_file
        assert restored_database_dump.content == database_dump.content