当我试图在python/flask中添加新表时-
class UserRemap(db.Model):
name = db.Column(db.String(40))
email = db.Column(db.String(255))
password = db.Column(db.String(64))
flag = db.Column(db.String(1))
def __init__(self, name, email, password):
self.email = email
self.name = name
self.password = password
self.flag='N'
这是表架构-
mysql> desc UserRemap;
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| name | varchar(40) | NO | | NULL | |
| password | varchar(64) | NO | | NULL | |
| email | varchar(255) | NO | | NULL | |
| flag | char(1) | NO | | N | |
+----------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
当我转到InteractivePythonShell并执行from myapp import db ;
操作时,会收到此错误消息
from server import db; Traceback (most recent call last): File
"<stdin>", line 1, in <module> File "server.py", line 74, in
<module>
class UserRemap(db.Model):
File "/usr/lib/python2.7/site-packages/Flask_SQLAlchemy-0.15-py2.7.egg/flaskext/sqlalchemy.py",
line 467, in __init__
DeclarativeMeta.__init__(self, name, bases, d)
File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.5-py2.7-linux-i686.egg/sqlalchemy/ext/declarative.py",
line 1336, in __init__
_as_declarative(cls, classname, cls.__dict__)
File "/usr/lib/python2.7/site-packages/SQLAlchemy-0.7.5-py2.7-linux-i686.egg/sqlalchemy/ext/declarative.py",
line 1261, in _as_declarative
"table-mapped class." % cls sqlalchemy.exc.InvalidRequestError: Class <class 'server.UserRemap'> does not have a __table__ or
__tablename__ specified and does not inherit from an existing table-mapped class.
关于如何解决这个问题的任何想法
从
db.Model
继承的Flask-SQLAlchemy docs将自动为您设置表名。您看到此消息是因为没有为该表定义主键。错误消息没有帮助,但是添加主键将解决此问题。
在类定义中指定
__tablename__
。必须提到
__tablename__
或__table__
才能通知数据库中表的sqlalchemy。相关问题 更多 >
编程相关推荐