From 76681751cd0234d147194e30f49ba3a9a77f7066 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Thu, 16 Feb 2006 06:38:49 +0000
Subject: [PATCH] ok now they worked...

---
 test/inheritance.py | 73 +++++++++++++++++++++++++--------------------
 1 file changed, 40 insertions(+), 33 deletions(-)

diff --git a/test/inheritance.py b/test/inheritance.py
index b7465548e6..f972306cf0 100644
--- a/test/inheritance.py
+++ b/test/inheritance.py
@@ -4,39 +4,6 @@ import string
 import sqlalchemy.attributes as attr
 
 
-principals = Table(
-    'principals',
-    testbase.db,
-    Column('principal_id', Integer, Sequence('principal_id_seq', optional=False), primary_key=True),
-    Column('name', String(50), nullable=False),    
-    )
-
-users = Table(
-    'prin_users',
-    testbase.db,
-    Column('principal_id', Integer, ForeignKey('principals.principal_id'), primary_key=True),
-    Column('password', String(50), nullable=False),
-    Column('email', String(50), nullable=False),
-    Column('login_id', String(50), nullable=False),
-    
-    )
-
-groups = Table(
-    'prin_groups',
-    testbase.db,
-    Column( 'principal_id', Integer, ForeignKey('principals.principal_id'), primary_key=True),
-    
-    )
-
-user_group_map = Table(
-    'prin_user_group_map',
-    testbase.db,
-    Column('user_id', Integer, ForeignKey( "prin_users.principal_id"), primary_key=True ),
-    Column('group_id', Integer, ForeignKey( "prin_groups.principal_id"), primary_key=True ),
-    #Column('user_id', Integer, ForeignKey( "prin_users.principal_id"),  ),
-    #Column('group_id', Integer, ForeignKey( "prin_groups.principal_id"),  ),    
-    
-    )
 
 class Principal( object ):
     pass
@@ -49,6 +16,46 @@ class Group( Principal ):
 
 class InheritTest(testbase.AssertMixin):
         def setUpAll(self):
+            global principals
+            global users
+            global groups
+            global user_group_map
+            principals = Table(
+                'principals',
+                testbase.db,
+                Column('principal_id', Integer, Sequence('principal_id_seq', optional=False), primary_key=True),
+                Column('name', String(50), nullable=False),    
+                )
+
+            users = Table(
+                'prin_users',
+                testbase.db,
+                Column('principal_id', Integer, ForeignKey('principals.principal_id'), primary_key=True),
+                Column('password', String(50), nullable=False),
+                Column('email', String(50), nullable=False),
+                Column('login_id', String(50), nullable=False),
+
+                )
+
+            groups = Table(
+                'prin_groups',
+                testbase.db,
+                Column( 'principal_id', Integer, ForeignKey('principals.principal_id'), primary_key=True),
+
+                )
+
+            user_group_map = Table(
+                'prin_user_group_map',
+                testbase.db,
+                Column('user_id', Integer, ForeignKey( "prin_users.principal_id"), primary_key=True ),
+                Column('group_id', Integer, ForeignKey( "prin_groups.principal_id"), primary_key=True ),
+                #Column('user_id', Integer, ForeignKey( "prin_users.principal_id"),  ),
+                #Column('group_id', Integer, ForeignKey( "prin_groups.principal_id"),  ),    
+
+                )
+
+
+
             principals.create()
             users.create()
             groups.create()
-- 
2.47.2