[sqlalchemy] Re: 'TypeError: expecting numeric data' is only raised for do_executemany

2012-01-03 Thread Kent
Oh.  Makes sense.  Then the only reason I'm starting to hit this is
that you've optimized the orm to use executemany() more often,
correct?

On Jan 3, 3:09 pm, Michael Bayer mike...@zzzcomputing.com wrote:
 On Jan 3, 2012, at 1:58 PM, Kent wrote:

  The statements that are executed as a single statement make no such
  check (and the database engine correctly translates a string to
  integer), but cursor.executemany checks type:

  lib/sqlalchemy/engine/default.py, line 327, in do_executemany
     cursor.executemany(statement, parameters)
  TypeError: expecting numeric data

  You know that inconsistency?

 cursor is the DBAPI cursor, so any inconsistencies there are on the DBAPI 
 side.    I don't know what the numeric data in question would be here.

-- 
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.



Re: [sqlalchemy] Re: 'TypeError: expecting numeric data' is only raised for do_executemany

2012-01-03 Thread Michael Bayer

On Jan 3, 2012, at 3:20 PM, Kent wrote:

 Oh.  Makes sense.  Then the only reason I'm starting to hit this is
 that you've optimized the orm to use executemany() more often,
 correct?

that it does, yes.




 
 On Jan 3, 3:09 pm, Michael Bayer mike...@zzzcomputing.com wrote:
 On Jan 3, 2012, at 1:58 PM, Kent wrote:
 
 The statements that are executed as a single statement make no such
 check (and the database engine correctly translates a string to
 integer), but cursor.executemany checks type:
 
 lib/sqlalchemy/engine/default.py, line 327, in do_executemany
cursor.executemany(statement, parameters)
 TypeError: expecting numeric data
 
 You know that inconsistency?
 
 cursor is the DBAPI cursor, so any inconsistencies there are on the DBAPI 
 side.I don't know what the numeric data in question would be here.
 
 -- 
 You received this message because you are subscribed to the Google Groups 
 sqlalchemy group.
 To post to this group, send email to sqlalchemy@googlegroups.com.
 To unsubscribe from this group, send email to 
 sqlalchemy+unsubscr...@googlegroups.com.
 For more options, visit this group at 
 http://groups.google.com/group/sqlalchemy?hl=en.
 

-- 
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.