Re: [sqlalchemy] server_onupdate issue

2012-10-01 Thread Michael Bayer
yeah in that thread I was forgetting/unaware that MySQL's TIMESTAMP generates a "default" and "on update" implicitly, so when he looked back at MySQL's rendering of the table, it included these defaults. On Oct 1, 2012, at 3:12 AM, Roy Shan wrote: > Michael, > > Thanks for your clarification

Re: [sqlalchemy] server_onupdate issue

2012-10-01 Thread Roy Shan
Michael, Thanks for your clarification. I understand what server_onupdate does now. It's weird that I saw some examples like this one: https://groups.google.com/d/topic/sqlalchemy/qYpPtgNXzAg/discussion On Monday, October 1, 2012 1:52:22 PM UTC+8, Michael Bayer wrote: > > > On Sep 30, 2012, a

Re: [sqlalchemy] server_onupdate issue

2012-09-30 Thread Michael Bayer
On Sep 30, 2012, at 9:48 PM, Roy Shan wrote: > Hi, Michael: > > I am trying to use server_onupdate in schema definition, but server_onupdate > doesn't seem to work. > > Here's an example: > > from sqlalchemy import * > engine = create_engine('mysql://root:@localhost:3306/test?charset=utf8',

[sqlalchemy] server_onupdate issue

2012-09-30 Thread Roy Shan
Hi, Michael: I am trying to use server_onupdate in schema definition, but server_onupdate doesn't seem to work. Here's an example: from sqlalchemy import * engine = create_engine('mysql://root:@localhost:3306/test?charset=utf8', echo =True) m = MetaData(bind=engine) t = Table('t', m, Colu