From 8a403280539e1c23240c0fd1f5e503883307ab7a Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Wed, 7 Sep 2005 06:01:57 +0000
Subject: [PATCH]

---
 lib/sqlalchemy/sql.py |  9 ---------
 test/mapper.py        | 18 ++++++++++++++----
 2 files changed, 14 insertions(+), 13 deletions(-)

diff --git a/lib/sqlalchemy/sql.py b/lib/sqlalchemy/sql.py
index b80436cde8..653e87ee66 100644
--- a/lib/sqlalchemy/sql.py
+++ b/lib/sqlalchemy/sql.py
@@ -766,7 +766,6 @@ class UpdateBase(ClauseElement):
                 values.append((c, value))
         return values
 
-
     def compile(self, engine = None, bindparams = None):
         if engine is None:
             engine = self.engine
@@ -789,14 +788,6 @@ class Insert(UpdateBase):
 
         visitor.visit_insert(self)
 
-        
-    def compile(self, engine = None, bindparams = None):
-        if engine is None:
-            engine = self.engine
-        if engine is None:
-            raise "no engine supplied, and no engine could be located within the clauses!"
-        return engine.compile(self, bindparams)
-
 class Update(UpdateBase):
     def __init__(self, table, whereclause, parameters = None, **params):
         self.table = table
diff --git a/test/mapper.py b/test/mapper.py
index 555dc334c1..6aa965335a 100644
--- a/test/mapper.py
+++ b/test/mapper.py
@@ -1,6 +1,7 @@
 from testbase import PersistTest
 import unittest, sys, os
 from sqlalchemy.mapper import *
+import sqlalchemy.objectstore as objectstore
 
 #ECHO = True
 ECHO = False
@@ -144,7 +145,7 @@ class LazyTest(AssertMixin):
             {'item_id' : 2, 'keywords' : (Keyword, [{'keyword_id' : 2}, {'keyword_id' : 5}, {'keyword_id' : 7}])},
         )
 
-class EagerTest(PersistTest):
+class EagerTest(AssertMixin):
     
     def setUp(self):
         #globalidentity().clear()
@@ -226,10 +227,19 @@ class EagerTest(PersistTest):
                 keywords = relation(Keyword, keywords, itemkeywords, lazy = False),
             ))
         l = m.select()
-        print repr(l)
+        self.assert_result(l, Item, 
+            {'item_id' : 1, 'keywords' : (Keyword, [{'keyword_id' : 2}, {'keyword_id' : 4}, {'keyword_id' : 6}])},
+            {'item_id' : 2, 'keywords' : (Keyword, [{'keyword_id' : 2}, {'keyword_id' : 7}, {'keyword_id' : 5}])},
+            {'item_id' : 3, 'keywords' : (Keyword, [{'keyword_id' : 6}, {'keyword_id' : 3}, {'keyword_id' : 4}])},
+            {'item_id' : 4, 'keywords' : (Keyword, [])},
+            {'item_id' : 5, 'keywords' : (Keyword, [])}
+        )
         
         l = m.select(and_(keywords.c.name == 'red', keywords.c.keyword_id == itemkeywords.c.keyword_id, items.c.item_id==itemkeywords.c.item_id))
-        print repr(l)
+        self.assert_result(l, Item, 
+            {'item_id' : 1, 'keywords' : (Keyword, [{'keyword_id' : 2}, {'keyword_id' : 4}, {'keyword_id' : 6}])},
+            {'item_id' : 2, 'keywords' : (Keyword, [{'keyword_id' : 2}, {'keyword_id' : 7}, {'keyword_id' : 5}])},
+        )
     
     def testoneandmany(self):
         items = orderitems
@@ -263,7 +273,7 @@ class SaveTest(AssertMixin):
         self.assert_(u is nu)
 
         # clear out the identity map, so next get forces a SELECT
-        m.identitymap.clear()
+        objectstore.clear()
 
         # check it again, identity should be different but ids the same
         nu = m.get(u.user_id)
-- 
2.47.2