最新消息:20190717 VPS服务器:Vultr新加坡,WordPress主题:大前端D8,统一介绍入口:关于

[已解决]SQLAlchemy初始化mysql出错:sqlalchemy.exc.OperationalError _mysql_exceptions.OperationalError 1067 Invalid default value for datetime

MySQL crifan 2228浏览 0评论

折腾:

[未解决]SQLAlchemy中把sqlite换成mysql

期间,

用SQLAlchemy去初始化mysql时,代码:

/Users/crifan/dev/dev_root/daryun/SIPEvents/sourcecode/sipevents/sipevents/models.py

start_date = db.Column(db.DateTime, server_default = func.now())

出错:

Traceback (most recent call last):
  File “db_create.py”, line 36, in <module>
    db.create_all()
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/flask_sqlalchemy/__init__.py”, line 972, in create_all
    self._execute_for_all_tables(app, bind, ‘create_all’)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/flask_sqlalchemy/__init__.py”, line 964, in _execute_for_all_tables
    op(bind=self.get_engine(app, bind), **extra)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/sql/schema.py”, line 3829, in create_all
    tables=tables)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1917, in _run_visitor
    conn._run_visitor(visitorcallable, element, **kwargs)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1526, in _run_visitor
    **kwargs).traverse_single(element)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py”, line 121, in traverse_single
    return meth(obj, **kw)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py”, line 733, in visit_metadata
    _is_metadata_operation=True)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py”, line 121, in traverse_single
    return meth(obj, **kw)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py”, line 767, in visit_table
    include_foreign_key_constraints=include_foreign_key_constraints
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/engine/base.py”, line 947, in execute
    return meth(self, multiparams, params)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py”, line 68, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1004, in _execute_ddl
    compiled
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1191, in _execute_context
    context)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1386, in _handle_dbapi_exception
    exc_info
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/util/compat.py”, line 202, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1184, in _execute_context
    context)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/sqlalchemy/engine/default.py”, line 462, in do_execute
    cursor.execute(statement, parameters)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
    self.errorhandler(self, exc, value)
  File “/root/Envs/SIPEvents/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
    raise errorclass, errorvalue
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1067, “Invalid default value for ‘start_date'”) [SQL: u”\nCREATE TABLE events (\n\tid VARCHAR(64) NOT NULL, \n\tuser_openid VARCHAR(64), \n\ttitle VARCHAR(128), \n\tstart_date DATETIME DEFAULT now(), \n\tend_date DATETIME DEFAULT now(), \n\tlocation VARCHAR(256), \n\tcur_user_num INTEGER, \n\tmax_user_num INTEGER, \n\tis_public BOOL, \n\tdescription TEXT, \n\tnotification_time ENUM(‘FiftyMinutesBefore’,’OneWeekBefore’,’OneDayBefore’,’OneHourBefore’,’TwoDaysBefore’,’TwoHoursBefore’,’ThirtyMinutesBefore’,’FiveMinutesBefore’,’NotNotify’,’WhenEventHappen’), \n\tcreated_at DATETIME DEFAULT now(), \n\tmodified_at DATETIME, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(user_openid) REFERENCES wechat_users (openid), \n\tCHECK (is_public IN (0, 1))\n)\n\n”]

SQLAlchemy DATETIME DEFAULT now()  sqlalchemy.exc.OperationalError _mysql_exceptions.OperationalError 1067 Invalid default value for

SQLAlchemy DATETIME DEFAULT now() mysql

sqlalchemy.exc.OperationalError _mysql_exceptions.OperationalError 1067, “Invalid default value for

SQLAlchemy mysql datetime default

flask-sqlalchemy的default – 简书

zzzeek / sqlalchemy / issues / #483 – default value for datetime in mysql 5.0 — Bitbucket

“因为mysql的datetime类型的数据不支持函数, 所以没法指定默认值位当前时间”

SQLAlchemy mysql datetime 默认值

简单介绍SQLAlchemy使用方法详解-mysql教程-数据库-壹聚教程网

都改为:

    # start_date = db.Column(db.DateTime, server_default = func.now())
    # end_date = db.Column(db.DateTime, server_default = func.now())
    start_date = db.Column(db.DateTime, default = datetime.now)
    end_date = db.Column(db.DateTime, default = datetime.now)
    # created_at = db.Column(db.DateTime, server_default = func.now())
    # modified_at = db.Column(db.DateTime, onupdate = func.now())
    created_at = db.Column(db.DateTime, default = datetime.now)
    modified_at = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)

然后就可以了。

[总结]

把:

from sqlalchemy.sql import func
    start_date = db.Column(db.DateTime, server_default = func.now())
    end_date = db.Column(db.DateTime, server_default = func.now())
   created_at = db.Column(db.DateTime, server_default = func.now())
    modified_at = db.Column(db.DateTime, onupdate = func.now())

改为:

from datetime import datetime
    start_date = db.Column(db.DateTime, default = datetime.now)
    end_date = db.Column(db.DateTime, default = datetime.now)
    created_at = db.Column(db.DateTime, default = datetime.now)
    modified_at = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)

即可。

转载请注明:在路上 » [已解决]SQLAlchemy初始化mysql出错:sqlalchemy.exc.OperationalError _mysql_exceptions.OperationalError 1067 Invalid default value for datetime

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址
61 queries in 0.224 seconds, using 18.88MB memory