def test_mysql_to_dict(self):
mysql_instance = MySQLDiff(
apps.get_models(include_auto_created=True),
vars(self.options),
stdout=self.tmp_out,
stderr=self.tmp_err,
)
mysql_dict = mysql_instance.sql_to_dict("""select 1 as "foo", 1 + 1 as "BAR";""", [])
self.assertEqual(mysql_dict, [{'bar': 2, 'foo': 1}])
def test_format_field_names(self):
instance = MySQLDiff(
apps.get_models(include_auto_created=True),
vars(self.options),
stdout=self.tmp_out,
stderr=self.tmp_err,
)
expected_field_name = ['name', 'email', 'address']
self.assertEqual(instance.format_field_names(['Name', 'EMAIL', 'aDDress']), expected_field_name)
def test_invalid_mysql_to_dict(self, format_field_names):
format_field_names.side_effect = lambda x: x
mysql_instance = MySQLDiff(
apps.get_models(include_auto_created=True),
vars(self.options),
stdout=self.tmp_out,
stderr=self.tmp_err,
)
mysql_dict = mysql_instance.sql_to_dict("""select 1 as "foo", 1 + 1 as "BAR";""", [])
self.assertNotEquals(mysql_dict, [{'bar': 2, 'foo': 1}])