From e3fc9af4abd65262f2d3bdced96b687b65be618a Mon Sep 17 00:00:00 2001 From: Hasan Ramezani Date: Tue, 30 Jul 2019 16:21:05 +0200 Subject: Refs #30593 -- Fixed introspection of check constraints columns on MariaDB. --- tests/backends/mysql/test_introspection.py | 17 ++++++++++++----- 1 file changed, 12 insertions(+), 5 deletions(-) (limited to 'tests') diff --git a/tests/backends/mysql/test_introspection.py b/tests/backends/mysql/test_introspection.py index 1b8fb94ed9..37fbcb1513 100644 --- a/tests/backends/mysql/test_introspection.py +++ b/tests/backends/mysql/test_introspection.py @@ -7,16 +7,23 @@ from django.test import TestCase @skipUnless(connection.vendor == 'mysql', 'MySQL tests') class ParsingTests(TestCase): def test_parse_constraint_columns(self): + _parse_constraint_columns = connection.introspection._parse_constraint_columns tests = ( - ('`height` >= 0', ['height']), - ('`cost` BETWEEN 1 AND 10', ['cost']), - ('`ref1` > `ref2`', ['ref1', 'ref2']), + ('`height` >= 0', ['height'], ['height']), + ('`cost` BETWEEN 1 AND 10', ['cost'], ['cost']), + ('`ref1` > `ref2`', ['id', 'ref1', 'ref2'], ['ref1', 'ref2']), ( '`start` IS NULL OR `end` IS NULL OR `start` < `end`', + ['id', 'start', 'end'], ['start', 'end'], ), + ('JSON_VALID(`json_field`)', ['json_field'], ['json_field']), + ('CHAR_LENGTH(`name`) > 2', ['name'], ['name']), + ("lower(`ref1`) != 'test'", ['id', 'owe', 'ref1'], ['ref1']), + ("lower(`ref1`) != 'test'", ['id', 'lower', 'ref1'], ['ref1']), + ("`name` LIKE 'test%'", ['name'], ['name']), ) - for check_clause, expected_columns in tests: + for check_clause, table_columns, expected_columns in tests: with self.subTest(check_clause): - check_columns = connection.introspection._parse_constraint_columns(check_clause) + check_columns = _parse_constraint_columns(check_clause, table_columns) self.assertEqual(list(check_columns), expected_columns) -- cgit v1.3