diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2019-06-26 11:45:50 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2019-06-26 15:10:53 -0400 |
| commit | 5cf8e14d58c89fdb94c60bf5e94d8b13d296da25 (patch) | |
| tree | 9819e92b6dcce02ad453bac70841446843e0c05e /test/dialect/postgresql/test_reflection.py | |
| parent | 1ed2f1621510b48a6c46bedf3dd579c56bd89ccb (diff) | |
| download | sqlalchemy-5cf8e14d58c89fdb94c60bf5e94d8b13d296da25.tar.gz | |
Reflect "NO ACTION" as None; support "RESTRICT"
The "NO ACTION" keyword for foreign key "ON UPDATE" is now considered to be
the default cascade for a foreign key on all supporting backends (SQlite,
MySQL, PostgreSQL) and when detected is not included in the reflection
dictionary; this is already the behavior for PostgreSQL and MySQL for all
previous SQLAlchemy versions in any case. The "RESTRICT" keyword is
positively stored when detected; PostgreSQL does report on this keyword,
and MySQL as of version 8.0 does as well. On earlier MySQL versions, it is
not reported by the database.
Fixes: #4741
Change-Id: I6becf1f2450605c1991158bb8a04d954dcc7396c
Diffstat (limited to 'test/dialect/postgresql/test_reflection.py')
| -rw-r--r-- | test/dialect/postgresql/test_reflection.py | 8 |
1 files changed, 1 insertions, 7 deletions
diff --git a/test/dialect/postgresql/test_reflection.py b/test/dialect/postgresql/test_reflection.py index 7e7a82d46..ea72d5710 100644 --- a/test/dialect/postgresql/test_reflection.py +++ b/test/dialect/postgresql/test_reflection.py @@ -1147,13 +1147,7 @@ class ReflectionTest(fixtures.TestBase): "referred_columns": ["id"], "referred_table": "industry", "referred_schema": None, - "options": { - "onupdate": "CASCADE", - "deferrable": None, - "ondelete": "CASCADE", - "initially": None, - "match": None, - }, + "options": {"onupdate": "CASCADE", "ondelete": "CASCADE"}, }, } metadata.create_all() |