[sqlalchemy] Get python type from sqlalchemy.orm.synonym

2011-01-16 Thread Hector Blanco
Hello everyone! I have created a little module that generates a sqlalchemy query from an string (yeah, I needed some help: http://groups.google.com/group/sqlalchemy/browse_thread/thread/6ea3241b1c653444 ) At certain point, I check the type of the field I'm filtering by creating an instance of

Re: [sqlalchemy] Get python type from sqlalchemy.orm.synonym

2011-01-16 Thread Michael Bayer
On Jan 16, 2011, at 4:30 PM, Hector Blanco wrote: - The user can input a query as: Product.model=='foo' Product.number=='5' (number may be an string -quoted, I mean- here) if the user says number == '5' , why not consider that to be a string ? why is

Re: [sqlalchemy] Get python type from sqlalchemy.orm.synonym

2011-01-16 Thread Hector Blanco
Thanks for replying so quickly... if the user says number == '5' , why not consider that to be a string ?   why is casting needed ?  if they want an int, they should type an int, no ? I don't trust my users :-) I don't think they know what they want, most of the times :-D The problem is

Re: [sqlalchemy] Get python type from sqlalchemy.orm.synonym

2011-01-16 Thread Michael Bayer
On Jan 16, 2011, at 5:36 PM, Hector Blanco wrote: Thanks for replying so quickly... if the user says number == '5' , why not consider that to be a string ? why is casting needed ? if they want an int, they should type an int, no ? I don't trust my users :-) I don't think they know