From f14fed985dab4260729cd94a103689ce32080653 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Thu, 22 Sep 2005 03:28:36 +0000
Subject: [PATCH]

---
 lib/sqlalchemy/databases/sqlite.py | 42 ++++++++++++++++--------------
 lib/sqlalchemy/mapper.py           |  4 +--
 2 files changed, 23 insertions(+), 23 deletions(-)

diff --git a/lib/sqlalchemy/databases/sqlite.py b/lib/sqlalchemy/databases/sqlite.py
index 76ad83371c..cef18f1e98 100644
--- a/lib/sqlalchemy/databases/sqlite.py
+++ b/lib/sqlalchemy/databases/sqlite.py
@@ -22,33 +22,34 @@ import sqlalchemy.sql as sql
 import sqlalchemy.engine as engine
 import sqlalchemy.schema as schema
 import sqlalchemy.ansisql as ansisql
+import sqlalchemy.types as sqltypes
 from sqlalchemy.ansisql import *
 
 from pysqlite2 import dbapi2 as sqlite
 
 colspecs = {
-    schema.INT : "INTEGER",
-    schema.CHAR : "CHAR(%(length)s)",
-    schema.VARCHAR : "VARCHAR(%(length)s)",
-    schema.TEXT : "TEXT",
-    schema.Numeric : "NUMERIC(%(precision)s, %(length)s)",
-    schema.FLOAT : "NUMERIC(%(precision)s, %(length)s)",
-    schema.DECIMAL : "NUMERIC(%(precision)s, %(length)s)",
-    schema.TIMESTAMP : "TIMESTAMP",
-    schema.DATETIME : "TIMESTAMP",
-    schema.CLOB : "TEXT",
-    schema.BLOB : "BLOB",
-    schema.BOOLEAN : "BOOLEAN",
+    sqltypes.INT : "INTEGER",
+    sqltypes.CHAR : "CHAR(%(length)s)",
+    sqltypes.VARCHAR : "VARCHAR(%(length)s)",
+    sqltypes.TEXT : "TEXT",
+    sqltypes.Numeric : "NUMERIC(%(precision)s, %(length)s)",
+    sqltypes.FLOAT : "NUMERIC(%(precision)s, %(length)s)",
+    sqltypes.DECIMAL : "NUMERIC(%(precision)s, %(length)s)",
+    sqltypes.TIMESTAMP : "TIMESTAMP",
+    sqltypes.DATETIME : "TIMESTAMP",
+    sqltypes.CLOB : "TEXT",
+    sqltypes.BLOB : "BLOB",
+    sqltypes.BOOLEAN : "BOOLEAN",
 }
 
 pragma_names = {
-    'INTEGER' : schema.INT,
-    'VARCHAR' : schema.VARCHAR,
-    'CHAR' : schema.CHAR,
-    'TEXT' : schema.TEXT,
-    'NUMERIC' : schema.FLOAT,
-    'TIMESTAMP' : schema.TIMESTAMP,
-    'BLOB' : schema.BLOB,
+    'INTEGER' : sqltypes.INT,
+    'VARCHAR' : sqltypes.VARCHAR,
+    'CHAR' : sqltypes.CHAR,
+    'TEXT' : sqltypes.TEXT,
+    'NUMERIC' : sqltypes.FLOAT,
+    'TIMESTAMP' : sqltypes.TIMESTAMP,
+    'BLOB' : sqltypes.BLOB,
 }
 
 def engine(filename, opts, **params):
@@ -119,10 +120,11 @@ class SQLiteCompiler(ansisql.ANSICompiler):
 class SQLiteColumnImpl(sql.ColumnSelectable):
     def get_specification(self):
         coltype = self.column.type
-        if isinstance(coltype, types.ClassType):
+        if isinstance(coltype, type):
             key = coltype
         else:
             key = coltype.__class__
+            
 
         colspec = self.name + " " + colspecs[key] % {'precision': getattr(coltype, 'precision', 10), 'length' : getattr(coltype, 'length', 10)}
         if not self.column.nullable:
diff --git a/lib/sqlalchemy/mapper.py b/lib/sqlalchemy/mapper.py
index 8222b81498..dd943325b5 100644
--- a/lib/sqlalchemy/mapper.py
+++ b/lib/sqlalchemy/mapper.py
@@ -165,7 +165,7 @@ class Mapper(object):
 
     def instances(self, cursor, db = None):
         result = util.HistoryArraySet()
-        cursor = engine.ResultProxy(cursor, echo = db and db.echo)
+        cursor = engine.ResultProxy(cursor, echo = db and db.echo, engine = db)
         imap = {}
         while True:
             row = cursor.fetchone()
@@ -439,11 +439,9 @@ class ColumnProperty(MapperProperty):
         return "ColumnProperty(%s)" % repr([hash_key(c) for c in self.columns])
 
     def init(self, key, parent):
-        print "hi im a colprop on key " + key
         self.key = key
         # establish a SmartProperty property manager on the object for this key
         if not hasattr(parent.class_, key):
-            print "Setting the class attribute"
             objectstore.uow().register_attribute(parent.class_, key, uselist = False)
 
     def execute(self, instance, row, identitykey, imap, isnew):
-- 
2.47.2