[sqlalchemy] reflected column spec doesn't match model column spec

2010-08-26 Thread Chris Withers
Hi All, For the following model: class Header(Base): __tablename__ = 'header' id = Column(Integer, primary_key=True) message_id = Column(Integer,ForeignKey('message.id')) name = Column(String(50)) value = Column(Text(255)) sqlalchemy-migrate's SchemaDiff tool against the

Re: [sqlalchemy] reflected column spec doesn't match model column spec

2010-08-26 Thread Michael Bayer
On Aug 26, 2010, at 11:42 AM, Chris Withers wrote: Hi All, For the following model: class Header(Base): __tablename__ = 'header' id = Column(Integer, primary_key=True) message_id = Column(Integer,ForeignKey('message.id')) name = Column(String(50)) value =

Re: [sqlalchemy] reflected column spec doesn't match model column spec

2010-08-26 Thread Chris Withers
Michael Bayer wrote: How can it be changed so that the column reflected from the DB and the column calculated from the model end up being the same? if schemas are being diffed, types can be compared generically using type affinity. This is described at:

Re: [sqlalchemy] reflected column spec doesn't match model column spec

2010-08-26 Thread Michael Bayer
On Aug 26, 2010, at 12:15 PM, Chris Withers wrote: Michael Bayer wrote: How can it be changed so that the column reflected from the DB and the column calculated from the model end up being the same? if schemas are being diffed, types can be compared generically using type affinity. This