class MysqlQueryChangeTest(unittest.TestCase): def setUp(self): self.f = Fixture() self.f.create_database() self.f.create_change_example() def tearDown(self): self.f.close() def testInsertRequired(self): args = dict( login_user=MYSQL_CONNECTION_PARAMS['user'], name=MYSQL_CONNECTION_PARAMS['db'], login_password=MYSQL_CONNECTION_PARAMS['passwd'], login_host=MYSQL_CONNECTION_PARAMS['host'], table='change_example', identifiers=dict( setting_name='do_backups', setting_group_id='4', ), values=dict(value1=8, value2='fifteen'), defaults=dict(default1=16, default3='thirty-two'), ) self.assertEquals(self.f.count_change_example(), 0, 'no row in table before running the module') result = utils.ansible_run(args) self.assertIn('changed', result) self.assertTrue(result['changed'], 'the database has been changed') self.assertEquals(self.f.count_change_example(), 1, 'a row has been inserted') row = self.f.query_change_example('do_backups', 4) self.assertItemsEqual((8, 'fifteen'), row[3:5], 'values were inserted') self.assertItemsEqual((16, 42, 'thirty-two'), row[5:8], 'row has been inserted with default values') def testUpdateRequired(self): self.f.insert_into_change_example(['do_syncs', '5'], [42, 'four'], [8, 16, 'bar']) args = dict(login_user=MYSQL_CONNECTION_PARAMS['user'], name=MYSQL_CONNECTION_PARAMS['db'], login_password=MYSQL_CONNECTION_PARAMS['passwd'], login_host=MYSQL_CONNECTION_PARAMS['host'], table='change_example', identifiers=dict(setting_name='do_syncs', setting_group_id='5'), values=dict(value1='43', value2='five'), defaults=dict(default1=9, default2='miow', bogus='foo')) result = utils.ansible_run(args) self.assertIn('changed', result) self.assertRegexpMatches(result['msg'], 'Successfully updated') self.assertEquals(self.f.count_change_example(), 1, 'no additional row has been inserted') row = self.f.query_change_example('do_syncs', '5') self.assertItemsEqual((43, 'five'), row[3:5], 'values have been updated') self.assertItemsEqual((8, 16, 'bar'), row[5:8], 'defaults have not been changed') def testNoChangeRequiredInNoCheckMode(self): """ this is the case if no change is required, but we're not in check mode. :return: """ self.f.insert_into_change_example(['no change required', 3], [1, 'one'], [1, 2, 'three']) args = dict(login_user=MYSQL_CONNECTION_PARAMS['user'], name=MYSQL_CONNECTION_PARAMS['db'], login_password=MYSQL_CONNECTION_PARAMS['passwd'], login_host=MYSQL_CONNECTION_PARAMS['host'], table='change_example', identifiers=dict(setting_name='no change required', setting_group_id=3), values=dict(value1=1, value2='one')) result = utils.ansible_run(args) self.assertIn('changed', result) self.assertFalse(result['changed'])
class MysqlQueryChangeTest(unittest.TestCase): def setUp(self): self.module = mysql_query self.mock_exit_fail = patch.multiple(basic.AnsibleModule, exit_json=exit_json, fail_json=fail_json) self.mock_exit_fail.start() self.addCleanup(self.mock_exit_fail.stop) self.f = Fixture() self.f.create_database() self.f.create_change_example() def tearDown(self): self.f.close() def test_insert_required(self): set_module_args( login_user=MYSQL_CONNECTION_PARAMS['user'], name=MYSQL_CONNECTION_PARAMS['db'], login_password=MYSQL_CONNECTION_PARAMS['passwd'], login_host=MYSQL_CONNECTION_PARAMS['host'], table='change_example', identifiers=dict(setting_name='do_backups', setting_group_id='4', ), values=dict(value1=8, value2='fifteen'), defaults=dict(default1=16, default3='thirty-two'), ) self.assertEquals(self.f.count_change_example(), 0, 'no row in table before running the module') with self.assertRaises(AnsibleExitJson) as e: self.module.main() result = e.exception.args[0] self.assertIn('changed', result) self.assertTrue(result['changed'], 'the database has been changed') self.assertEquals(self.f.count_change_example(), 1, 'a row has been inserted') row = self.f.query_change_example('do_backups', 4) six.assertCountEqual(self, (8, 'fifteen'), row[3:5], 'values were inserted') six.assertCountEqual(self, (16, 42, 'thirty-two'), row[5:8], 'row has been inserted with default values') def test_update_required(self): self.f.insert_into_change_example(['do_syncs', '5'], [42, 'four'], [8, 16, 'bar']) set_module_args( login_user=MYSQL_CONNECTION_PARAMS['user'], name=MYSQL_CONNECTION_PARAMS['db'], login_password=MYSQL_CONNECTION_PARAMS['passwd'], login_host=MYSQL_CONNECTION_PARAMS['host'], table='change_example', identifiers=dict(setting_name='do_syncs', setting_group_id='5'), values=dict(value1='43', value2='five'), defaults=dict(default1=9, default2='miow', bogus='foo') ) with self.assertRaises(AnsibleExitJson) as e: self.module.main() result = e.exception.args[0] self.assertIn('changed', result) self.assertRegexpMatches(result['msg'], 'Successfully updated') self.assertEquals(self.f.count_change_example(), 1, 'no additional row has been inserted') row = self.f.query_change_example('do_syncs', '5') six.assertCountEqual(self, (43, 'five'), row[3:5], 'values have been updated') six.assertCountEqual(self, (8, 16, 'bar'), row[5:8], 'defaults have not been changed') def test_delete_required(self): self.f.insert_into_change_example(['do_syncs', '5'], [42, 'four'], [8, 16, 'bar']) set_module_args( login_user=MYSQL_CONNECTION_PARAMS['user'], name=MYSQL_CONNECTION_PARAMS['db'], login_password=MYSQL_CONNECTION_PARAMS['passwd'], login_host=MYSQL_CONNECTION_PARAMS['host'], table='change_example', identifiers=dict(setting_name='do_syncs', setting_group_id='5'), state='absent' ) with self.assertRaises(AnsibleExitJson) as e: self.module.main() result = e.exception.args[0] self.assertIn('changed', result) self.assertRegexpMatches(result['msg'], 'Successfully deleted') self.assertEquals(self.f.count_change_example(), 0, 'all rows have been deleted') def test_no_change_required_in_no_check_mode(self): """ this is the case if no change is required, but we're not in check mode. :return: """ self.f.insert_into_change_example(['no change required', 3], [1, 'one'], [1, 2, 'three']) set_module_args( login_user=MYSQL_CONNECTION_PARAMS['user'], name=MYSQL_CONNECTION_PARAMS['db'], login_password=MYSQL_CONNECTION_PARAMS['passwd'], login_host=MYSQL_CONNECTION_PARAMS['host'], table='change_example', identifiers=dict(setting_name='no change required', setting_group_id=3), values=dict(value1=1, value2='one') ) with self.assertRaises(AnsibleExitJson) as e: self.module.main() result = e.exception.args[0] self.assertIn('changed', result) self.assertFalse(result['changed'])
class MysqlQueryChangeTest(unittest.TestCase): def setUp(self): self.f = Fixture() self.f.create_database() self.f.create_change_example() def tearDown(self): self.f.close() def testInsertRequired(self): args = dict( login_user=MYSQL_CONNECTION_PARAMS['user'], name=MYSQL_CONNECTION_PARAMS['db'], login_password=MYSQL_CONNECTION_PARAMS['passwd'], login_host=MYSQL_CONNECTION_PARAMS['host'], table='change_example', identifiers=dict(setting_name='do_backups', setting_group_id='4', ), values=dict(value1=8, value2='fifteen'), defaults=dict(default1=16, default3='thirty-two'), ) self.assertEquals(self.f.count_change_example(), 0, 'no row in table before running the module') result = utils.ansible_run(args) self.assertIn('changed', result) self.assertTrue(result['changed'], 'the database has been changed') self.assertEquals(self.f.count_change_example(), 1, 'a row has been inserted') row = self.f.query_change_example('do_backups', 4) self.assertItemsEqual((8, 'fifteen'), row[3:5], 'values were inserted') self.assertItemsEqual((16, 42, 'thirty-two'), row[5:8], 'row has been inserted with default values') def testUpdateRequired(self): self.f.insert_into_change_example(['do_syncs', '5'], [42, 'four'], [8, 16, 'bar']) args = dict( login_user=MYSQL_CONNECTION_PARAMS['user'], name=MYSQL_CONNECTION_PARAMS['db'], login_password=MYSQL_CONNECTION_PARAMS['passwd'], login_host=MYSQL_CONNECTION_PARAMS['host'], table='change_example', identifiers=dict(setting_name='do_syncs', setting_group_id='5'), values=dict(value1='43', value2='five'), defaults=dict(default1=9, default2='miow', bogus='foo') ) result = utils.ansible_run(args) self.assertIn('changed', result) self.assertRegexpMatches(result['msg'], 'Successfully updated') self.assertEquals(self.f.count_change_example(), 1, 'no additional row has been inserted') row = self.f.query_change_example('do_syncs', '5') self.assertItemsEqual((43, 'five'), row[3:5], 'values have been updated') self.assertItemsEqual((8, 16, 'bar'), row[5:8], 'defaults have not been changed') def testNoChangeRequiredInNoCheckMode(self): """ this is the case if no change is required, but we're not in check mode. :return: """ self.f.insert_into_change_example(['no change required', 3], [1, 'one'], [1, 2, 'three']) args = dict( login_user=MYSQL_CONNECTION_PARAMS['user'], name=MYSQL_CONNECTION_PARAMS['db'], login_password=MYSQL_CONNECTION_PARAMS['passwd'], login_host=MYSQL_CONNECTION_PARAMS['host'], table='change_example', identifiers=dict(setting_name='no change required', setting_group_id=3), values=dict(value1=1, value2='one') ) result = utils.ansible_run(args) self.assertIn('changed', result) self.assertFalse(result['changed'])