diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-11-28 05:11:53 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-11-28 05:11:53 +0000 |
| commit | ee665372f66a16039e2383875f34afec93192789 (patch) | |
| tree | 988092aa1f506e865355ec6202679c1bb2ec1a50 /lib/sqlalchemy/engine.py | |
| parent | 69303e16b414709fb1621a2422b0f3f11b177dae (diff) | |
| download | sqlalchemy-ee665372f66a16039e2383875f34afec93192789.tar.gz | |
strips possible schema/table info from a column name returned in cursor metadata
Diffstat (limited to 'lib/sqlalchemy/engine.py')
| -rw-r--r-- | lib/sqlalchemy/engine.py | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/lib/sqlalchemy/engine.py b/lib/sqlalchemy/engine.py index f32f7ba42..ef6c8de00 100644 --- a/lib/sqlalchemy/engine.py +++ b/lib/sqlalchemy/engine.py @@ -333,12 +333,14 @@ class ResultProxy: i = 0 if metadata is not None: for item in metadata: + # sqlite possibly prepending table name to colnames so strip + colname = item[0].split('.')[-1].lower() if typemap is not None: - rec = (typemap.get(item[0], types.NULLTYPE), i) + rec = (typemap.get(colname, types.NULLTYPE), i) else: rec = (types.NULLTYPE, i) - if self.props.setdefault(item[0].lower(), rec) is not rec: - self.props[item[0].lower()] = (ResultProxy.AmbiguousColumn(item[0].lower()), 0) + if self.props.setdefault(colname, rec) is not rec: + self.props[colname] = (ResultProxy.AmbiguousColumn(colname), 0) self.props[i] = rec i+=1 |