Gloria W wrote: > Hi All, > > Looking back in these posts, I tried several older variants of MySQL > datetime column initialization discussed here, and they're not > working. > > This works in Postgresql: > > sqlalchemy.Column('date_created', sqlalchemy.DateTime, > sqlalchemy.PassiveDefault(sqlalchemy.sql.func.now()), > nullable=False) > > But the MySQL equivalent fails: > > sqlalchemy.Column('date_created', sqlalchemy.DateTime, > sqlalchemy.PassiveDefault(text("CURRENT_TIMESTAMP")), > nullable=False) > > What is the valid syntax? Is it failing for other reasons?
The MySQL TIMESTAMP type is required for that default: from sqlalchemy.databases import mysql sqlalchemy.Column('date_created', mysql.MSDateTime, sqlalchemy.PassiveDefault(text("CURRENT_TIMESTAMP")), nullable=False) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---