diff options
Diffstat (limited to 'lib/sqlalchemy/testing')
| -rw-r--r-- | lib/sqlalchemy/testing/requirements.py | 12 | ||||
| -rw-r--r-- | lib/sqlalchemy/testing/suite/test_reflection.py | 24 |
2 files changed, 34 insertions, 2 deletions
diff --git a/lib/sqlalchemy/testing/requirements.py b/lib/sqlalchemy/testing/requirements.py index 3a2161740..04537905b 100644 --- a/lib/sqlalchemy/testing/requirements.py +++ b/lib/sqlalchemy/testing/requirements.py @@ -427,10 +427,22 @@ class SuiteRequirements(Requirements): return exclusions.closed() @property + def fk_constraint_option_reflection_ondelete_restrict(self): + return exclusions.closed() + + @property + def fk_constraint_option_reflection_ondelete_noaction(self): + return exclusions.closed() + + @property def foreign_key_constraint_option_reflection_onupdate(self): return exclusions.closed() @property + def fk_constraint_option_reflection_onupdate_restrict(self): + return exclusions.closed() + + @property def temp_table_reflection(self): return exclusions.open() diff --git a/lib/sqlalchemy/testing/suite/test_reflection.py b/lib/sqlalchemy/testing/suite/test_reflection.py index e529a0753..53e1599b3 100644 --- a/lib/sqlalchemy/testing/suite/test_reflection.py +++ b/lib/sqlalchemy/testing/suite/test_reflection.py @@ -671,10 +671,29 @@ class ComponentReflectionTest(fixtures.TablesTest): def test_get_foreign_key_options_onupdate(self): self._test_get_foreign_key_options(onupdate="SET NULL") + @testing.requires.foreign_key_constraint_option_reflection_onupdate + def test_get_foreign_key_options_onupdate_noaction(self): + self._test_get_foreign_key_options(onupdate="NO ACTION", expected={}) + + @testing.requires.fk_constraint_option_reflection_ondelete_noaction + def test_get_foreign_key_options_ondelete_noaction(self): + self._test_get_foreign_key_options(ondelete="NO ACTION", expected={}) + + @testing.requires.fk_constraint_option_reflection_onupdate_restrict + def test_get_foreign_key_options_onupdate_restrict(self): + self._test_get_foreign_key_options(onupdate="RESTRICT") + + @testing.requires.fk_constraint_option_reflection_ondelete_restrict + def test_get_foreign_key_options_ondelete_restrict(self): + self._test_get_foreign_key_options(ondelete="RESTRICT") + @testing.provide_metadata - def _test_get_foreign_key_options(self, **options): + def _test_get_foreign_key_options(self, expected=None, **options): meta = self.metadata + if expected is None: + expected = options + Table( "x", meta, @@ -714,7 +733,8 @@ class ComponentReflectionTest(fixtures.TablesTest): eq_(dict((k, opts[k]) for k in opts if opts[k]), {}) opts = insp.get_foreign_keys("user")[0]["options"] - eq_(dict((k, opts[k]) for k in opts if opts[k]), options) + eq_(opts, expected) + # eq_(dict((k, opts[k]) for k in opts if opts[k]), expected) def _assert_insp_indexes(self, indexes, expected_indexes): index_names = [d["name"] for d in indexes] |