added oracle8 test target, sets use_ansi to false

got mapper, objectstore, inheritance unittest working with oracle8, tweaks to join syntax

2 files changed, 7 insertions, 4 deletions

diff --git a/test/inheritance.py b/test/inheritance.py
index 657af8a27..3202c3417 100644
--- a/test/inheritance.py
+++ b/test/inheritance.py
@@ -95,7 +95,7 @@ class InheritTest2(testbase.AssertMixin):
         engine = testbase.db
         global foo, bar, foo_bar
         foo = Table('foo', engine,
-            Column('id', Integer, primary_key=True),
+            Column('id', Integer, Sequence('foo_id_seq'), primary_key=True),
             Column('data', String(20)),
             ).create()
 
diff --git a/test/testbase.py b/test/testbase.py
index f10cce681..f3dfac15b 100644
--- a/test/testbase.py
+++ b/test/testbase.py
@@ -25,7 +25,7 @@ def parse_argv():
         elif sys.argv[1] == '--db':
             (param, DBTYPE) = (sys.argv.pop(1), sys.argv.pop(1))
 
-    
+    opts = {} 
     if (None == db_uri):
         p = DBTYPE.split('.')
         if len(p) > 1:
@@ -43,15 +43,18 @@ def parse_argv():
             db_uri = 'mysql://database=test&host=127.0.0.1&user=scott&password=tiger'
         elif DBTYPE == 'oracle':
             db_uri = 'oracle://user=scott&password=tiger'
+        elif DBTYPE == 'oracle8':
+            db_uri = 'oracle://user=scott&password=tiger'
+            opts = {'use_ansi':False}
 
     if not db_uri:
         raise "Could not create engine.  specify --db <sqlite|sqlite_file|postgres|mysql|oracle> to test runner."
 
     if PROXY:
-        db = proxy.ProxyEngine(echo=echo, default_ordering=True)
+        db = proxy.ProxyEngine(echo=echo, default_ordering=True, **opts)
         db.connect(db_uri)
     else:
-        db = engine.create_engine(db_uri, echo=echo, default_ordering=True)
+        db = engine.create_engine(db_uri, echo=echo, default_ordering=True, **opts)
     db = EngineAssert(db)
 
 class PersistTest(unittest.TestCase):