[sqlalchemy] missing constraint

2011-01-03 Thread dhanil anupurath
Hi My app is using SQLAlchemy0.5.6. I have a class defined as follows. class EmailSetup(DeclarativeBase): __tablename__ = 'emailsetup' id = Column(Unicode(50), primary_key=True) mail_server=Column(Unicode(255)) description=Column(String(200)) port = Column(Integer)

Re: [sqlalchemy] missing constraint

2011-01-03 Thread Michael Bayer
That's certainly related to the version of MySQL in use, assuming you're executing the exact same Python code against both backends. The first thing to do here is to turn on echo=True, look at the SQL sqlalchemy emits, and begin testing those specific clauses against the MySQL database