jason kirtland wrote:
> 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)
err, mysql.MSTimeStamp ^^^^^^^^^^^^^^^^
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
