Re: [sqlalchemy] How to stop SQLAlchemy from adding an ON UPDATE clause to a TIMESTAMP column by default

2011-11-28 Thread Michael Bayer
SQLA doesn't generate those defaults without being told explicitly. Are you sure you don't have some other table metadata, or perhaps schema events in place which are adding defaults ? from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import Table, CHAR, TIMESTAMP, TEXT,

[sqlalchemy] How to stop SQLAlchemy from adding an ON UPDATE clause to a TIMESTAMP column by default

2011-11-28 Thread Ben Hayden
Say I have a model (running on MySQL): *class Foo(DeclarativeBase):* *__tablename__ = 'foo'* * * *#column definitions* *id = Column(u'id', CHAR(length=36), default=uuid, primary_key=True, nullable=False)* *date_added = Column(u'dateAdded', TIMESTAMP(), nullable=False)* *reason