Changeset 40931 for branches/ipp-259_genericise_backups/tools/backups/backup_test.py

Timestamp:

Oct 9, 2019, 11:25:06 AM (7 years ago)

Author:

fairlamb

Message:

added mysqldump to the backup class + tests; tests are skipped as they require some mysql setup

File:

• branches/ipp-259_genericise_backups/tools/backups/backup_test.py (modified) (2 diffs)

branches/ipp-259_genericise_backups/tools/backups/backup_test.py

@@ -294 +294 @@
         assert not os.path.exists(expected_tar2)
         backy._run_tar()
-        print(expected_tar1)
-        print(expected_tar2)
         assert os.path.exists(expected_tar1)
         assert os.path.exists(expected_tar2)
@@ -309 +307 @@
 
 
-# class TestRunningMysqldump():
-
-#     def test_simply_mysqldump(self):
-#         assert True is False
-
-#     def test_mysqldump_with_additional_args(self):
-#         assert True is False
+@pytest.mark.skip(reason="Requires a fake database to be setup")
+class TestMysqlBackup(object):
+    """ The mySQL dump tests require the machine on which they are
+running to have a mysql database running with a user called
+'dumper' and a password set to 'not_a_real_password'.
+
+In production, a proper password should be set on the server and in the config
+file. DO NOT USE THE ABOVE IN PRODUCTION
+
+To change the password:
+UPDATE mysql.user SET authentication_string = PASSWORD('NEW_USER_PASSWORD')WHERE User = 'user-name' AND Host = 'localhost';FLUSH PRIVILEGES;
+"""
+
+    dumper_password = "not_a_real_password"
+
+    def test_mysql_dump_is_ok(self, tmpdir):
+        config = make_default_config(tmpdir, ['bck1', 'bck2'])
+        config['MYSQLDUMP'] = \
+        { 'user' : 'dumper'
+        , 'password' : 'not_a_real_password'
+        , 'db_name' : 'jiradb'
+        , 'target_filename' : "cool_dump.sql"
+        , 'prefix_date' : True
+        }
+
+        backy = Backup(config)
+
+        date = bckup.get_date()
+
+        expected_dump1 = os.path.join(tmpdir, 'bck1', f'{date}_cool_dump.sql')
+        expected_dump2 = os.path.join(tmpdir, 'bck2', f'{date}_cool_dump.sql')
+        assert not os.path.exists(expected_dump1)
+        assert not os.path.exists(expected_dump2)
+        backy._run_mysqldump()
+        assert os.path.exists(expected_dump1)
+        assert os.path.exists(expected_dump2)
+
+    def test_mysql_dump_fails_with_incorrect_password(self, tmpdir):
+        config = make_default_config(tmpdir, ['bck1', 'bck2'])
+        config['MYSQLDUMP'] = \
+        { 'user' : 'dumper'
+        , 'password' : 'incorrect_password'
+        , 'db_name' : 'jiradb'
+        , 'target_filename' : "cool_dump.sql"
+        , 'prefix_date' : True
+        }
+
+        backy = Backup(config)
+        with pytest.raises(errs.SubprocessError):
+            backy._run_mysqldump()