Re: [sqlalchemy] Is this a bug?(about "Overriding Reflected Columns")

2011-03-31 Thread Inside Zhou
Thank you for you answer,but I'm sorry,I don't quite follow you. My confusion is that with the "s.query(User).all()",SA issues SQL stmt the same as "user_table.select().execute()",but why the latter stmt can return the row what I expected whereas the former couldn't? besides,the table in DB cha

[sqlalchemy] Is this a bug?(about "Overriding Reflected Columns")

2011-03-31 Thread Inside Zhou
First I try to create a table like this: user_table = Table('user', metadata, Column('id', Integer), Column('name', Unicode) ) then I discards the table in metadata and reload it by reflection with overriding: user_table = Table('user', metadata, Column('id', Integer, primary_key=Tru