Re: [SQLObject] Parametrized queries

[Oleg B. <ph...@ma...>]

On Wed, Oct 19, 2005 at 10:12:27AM +0200, M. Dietrich wrote:
> please tell me if and where you put it, thnx alot!

   http://svn.colorstudy.com/home/phd/SQLObject/paramstyles/

   The work is again stalled because I stumbled upon a major troubles in
drivers. Low-level drives do a poor job converting different types to SQL.
For example, PySQLite1 does not convert boolean values - it actually does

   query_string % parameters

in the code, and SQLite barfs on 'True'/'False' constants.

   psycopg1 does not quote datetime and mxDateTime instances, so

cursor.execute("INSERT VALUES (?,?,?)", 'Yes', datetime.now(), True)

   is executed as

INSERT VALUES ('Yes', 2005-10-10 12:00:01, .t.)

   and Postgres of course aborts such a broken query. Date instances are
even more funny:

INSERT VALUES ('Yes', 2005-10-10, .t.)

   and Postgres report the error: "You are trying to insert an integer into
a DATE column; use cast."
   Yes, 2005-10-10 is an integer, 1985.

   PySQLite2 works a bit better, and I am going to try psycopg2. If anyone
has experience with psycopg2 and MySQLdb in this area - I'd like to hear
advice.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.