Author: Roger Gammans
Posted: 2009-07-13 at 09:31:20
On Fri, Jul 03, 2009 at 08:14:41AM -0500, Ed Leafe wrote:
> code along these lines, but I'll be happy to assist you wherever
> possible; take a look at the db/dbTemplate.py, which is intended to be
> the template for new backend connection scripts.
Ok, So far so good. I've had to make changes to the ConnectionInfo and
XML reader as discussed in a previos email.
However I'm hitting a problem with dCursorMixin - it seems to
expect the records return to be of type tuple,list or dict-compatible.
pyodbc returns records of type pyodbc.Row which offers list/tuple style access
rather than dict style.
This means the test at line 358 of dCursorMixin.py (svn:r5293) takes
the wrong branch and the code in the other branch won't work as pyodbc.Row
hasn't a items() methods and the __getitems__ method requires an in parameter.
Is there anyway we could force dCursorMixin to take the other branch
in this by adding a flag ? Would that be acceptable?
TTFN
--
Roger. Home| http://www.sandman.uklinux.net/
Master of Peng Shui. (Ancient oriental art of Penguin Arranging)
Work|Independent Sys Consultant | http://www.computer-surgery.co.uk/
New key Fpr: 72AF 0ACC 9A53 E59F B1B6 DC14 1983 A13E 5C3D 3CEB