[sqlalchemy] Re: Unsigned attributes brake autoload

AUTO_INCREMENT=2 ; -- Using sqlalchemy version 0.5.8 I don't get this error. Thanks, Mathieu On Mar 10, 6:40 pm, Michael Bayer mike...@zzzcomputing.com wrote: MattQc wrote: Hi there, Using sqlalchemy version 0.6beta1, I am trying to load a mysql table which has a field unsigned int. Here

[sqlalchemy] Unsigned attributes brake autoload

Hi there, Using sqlalchemy version 0.6beta1, I am trying to load a mysql table which has a field unsigned int. Here is the error I got: File /usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.6beta1- py2.6.egg/sqlalchemy/schema.py, line 205, in __new__ table._init(name, metadata, *args,

[sqlalchemy] Re: Different results with select and object using outerjoin

Thank you for the answer! Does it have any performance differences between the 3 manners? Which one could be the fastest if I have a lot of nested joins to do with other tables? Thanks On Jan 23, 4:30 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Jan 23, 2008, at 3:28 PM, MattQc wrote

[sqlalchemy] Different results with select and object using outerjoin

Hi, I have different outputs depending on using a select statement as oppose to an object mapped query. This is happening when I am using outer joins. Here is the trace of the select that gives me something: In 1: a = select([tblspotbandsol.c.spotbandsolid, tbllane.c.laneid],

[sqlalchemy] distinct entries when mapping many-to-many

I am mapping 3 tables linearly. The first 2 have a many-to-many relation and the last one is a one-to-one relation. I would like to get all the distinct entries from the third table. I was not able to figure how to do the mapping. So, I tried by doing my own set of entries outside of SA but when