[sqlalchemy] Re: similiraty search

On Jan 30, 4:16 am, Michael Bayer mike...@zzzcomputing.com wrote: You're in luck since this is a fun relational problem -   yes I'm in luck, as everyone on this list to have you around ! thank you so much, I'm quite new to relational problems, and I was way over my head with this one. Now I

[sqlalchemy] Trailing L after my Primary Key

Hi, I'm reflecting some tables out of MySQL for a User object and when I call: user.ID I get a value like this: 10L instead of: 10 If I wrap it up like this: int(user.ID) I get: 10 It seems that the reflection thinks my int column is a long. Why is that happening and how can I fix it?

Re: [sqlalchemy] Trailing L after my Primary Key

On Jan 30, 2011, at 8:55 PM, ObjectEvolution wrote: Hi, I'm reflecting some tables out of MySQL for a User object and when I call: user.ID I get a value like this: 10L instead of: 10 If I wrap it up like this: int(user.ID) I get: 10 It seems that the reflection

[sqlalchemy] Re: Trailing L after my Primary Key

Thanks Michael. So then it looks like my options are to: 1. Convert the longs. 2. Declare my columns instead of using reflection so I get the right types. On Jan 30, 7:18 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Jan 30, 2011, at 8:55 PM, ObjectEvolution wrote: Hi, I'm

[sqlalchemy] Re: Trailing L after my Primary Key

Actually, answered that myself as soon as I pressed 'send'. ;-) On Jan 30, 7:23 pm, ObjectEvolution objectevolut...@gmail.com wrote: Thanks Michael. So then it looks like my options are to: 1. Convert the longs. 2. Declare my columns instead of using reflection so I get the right types.

Re: [sqlalchemy] Re: Trailing L after my Primary Key

On Jan 30, 2011, at 10:23 PM, ObjectEvolution wrote: Thanks Michael. So then it looks like my options are to: 1. Convert the longs. 2. Declare my columns instead of using reflection so I get the right types. If your concern is they print funny, you should use str() for formatting.