From ee665372f66a16039e2383875f34afec93192789 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Mon, 28 Nov 2005 05:11:53 +0000 Subject: [PATCH] strips possible schema/table info from a column name returned in cursor metadata --- lib/sqlalchemy/engine.py | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) diff --git a/lib/sqlalchemy/engine.py b/lib/sqlalchemy/engine.py index f32f7ba42f..ef6c8de00f 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 -- 2.47.2