[SQLObject] ADO DB-API support?

[Magnus <ma...@th...>]

I've been thinking of adding support for adodbapi to SQLObject.
Has anyone done that? Any comments?

The problem I see is that SQLObject doesn't use the param part
of cursor.execute(sql, param).

That will at least cause problems with dates for my current
backend, MS Access 97, since the warped SQL dialect there uses
dates like #1999-04-12# instead of '1999-04-12'. :(

But it seems I can get basic support by just overriding the
insert or update methods. After all, dates are never key
values, and I suppose I can live with the limitations in
selects for the time being.

But in the long run, It's like to be able to do
Person.select('birthdate < ?', (Date(1999,4,12),)) though...

What's the rationale behind not using params today? Would
a change have any negative consequences (beyond some labour)?


--
Magnus Lycka (It's really Lyck&aring;), ma...@th...
Thinkware AB, Sweden, www.thinkware.se
I code Python ~ The shortest path from thought to working program