From 256ae2ad1511d4be25a880ec3ef350689ee98af4 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 30 Oct 2011 15:31:03 -0400 Subject: [PATCH] fix this for PG, other on update cascade DBs --- test/orm/test_hasparent.py | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/test/orm/test_hasparent.py b/test/orm/test_hasparent.py index 2b1e914abc..3940c03dab 100644 --- a/test/orm/test_hasparent.py +++ b/test/orm/test_hasparent.py @@ -27,12 +27,19 @@ class ParentRemovalTest(fixtures.MappedTest): @classmethod def define_tables(cls, metadata): + if testing.against('oracle'): + fk_args = dict(deferrable=True, initially='deferred') + elif testing.against('mysql'): + fk_args = {} + else: + fk_args = dict(onupdate='cascade') + Table('users', metadata, Column('id', Integer, primary_key=True, test_needs_autoincrement=True), ) Table('addresses', metadata, Column('id', Integer, primary_key=True, test_needs_autoincrement=True), - Column('user_id', Integer, ForeignKey('users.id')), + Column('user_id', Integer, ForeignKey('users.id', **fk_args)), ) @classmethod -- 2.47.2