running this script:
import sqlalchemy
from sqlalchemy.databases import mysql
engine = sqlalchemy.create_engine('mysql://scott:[EMAIL PROTECTED]/
test', echo=True)
metadata = sqlalchemy.MetaData(engine)
purchases_table = sqlalchemy.Table('fu_op_purchases',metadata,
sqlalchemy.Column('fu_op_purchases_id',sqlalchemy.Integer,
primary_key=True),
sqlalchemy.Column('name', sqlalchemy.String(50)),
sqlalchemy.Column('purchased_item',sqlalchemy.VARCHAR(300)),
sqlalchemy.Column('price', sqlalchemy.Float(4)),
sqlalchemy.Column('comments', sqlalchemy.VARCHAR(300)),
sqlalchemy.Column('date_created',
mysql
.MSTimeStamp
,sqlalchemy
.PassiveDefault(sqlalchemy.text("CURRENT_TIMESTAMP")),nullable=False))
purchases_table.create()
produces this output:
CREATE TABLE fu_op_purchases (
fu_op_purchases_id INTEGER NOT NULL AUTO_INCREMENT,
name VARCHAR(50),
purchased_item VARCHAR(300),
price FLOAT(4),
comments VARCHAR(300),
date_created TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
PRIMARY KEY (fu_op_purchases_id)
)
On Jun 30, 2008, at 5:51 PM, Gloria W wrote:
>
> I thought this was a scope problem, but it seems to be even bigger.
> This is the error I get:
> OperationalError: (OperationalError) (1067, "Invalid default value for
> 'date_created'") u'\nCREATE TABLE fu_op_requests (\n
> \tfu_op_requests_id INTEGER NOT NULL AUTO_INCREMENT, \n\tname
> VARCHAR(50), \n\trequested_items VARCHAR(300), \n\tamount_donated
> FLOAT(4), \n\tcomments VARCHAR(300), \n\tdate_created DATETIME DEFAULT
> now() NOT NULL, \n\tPRIMARY KEY (fu_op_requests_id)\n)\n\n' {}
>
> Wow, how could it be generating a DATETIME DEFAULT now() raw command
> from this syntax?
>
> from sqlalchemy.databases import mysql
> purchases_table = sqlalchemy.Table('fu_op_purchases',
> metadata,
> sqlalchemy.Column('fu_op_purchases_id',
> sqlalchemy.Integer, primary_key=True),
> sqlalchemy.Column('name', sqlalchemy.String(50)),
> sqlalchemy.Column('purchased_item',
> sqlalchemy.VARCHAR(300)),
> sqlalchemy.Column('price', sqlalchemy.Float(4)),
> sqlalchemy.Column('comments', sqlalchemy.VARCHAR(300)),
> sqlalchemy.Column('date_created', mysql.MSTimeStamp,
> sqlalchemy.PassiveDefault(sqlalchemy.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 [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
-~----------~----~----~----~------~----~------~--~---
