Re: [dabo-users] Odbc and Bizobj's

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

©2009 Roger Gammans