python table类_python – 类没有指定表或tablename,不会从现有的表映射类继承

当我试图添加一个新的表到

Python /烧瓶 –

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)

当我去互动python shell并且从myapp导入db;我收到这个错误消息,

from server import db; Traceback (most recent call last): File

"", line 1, in File "server.py", line 74, in

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 does not have a __table__ or

__tablename__ specified and does not inherit from an existing table-mapped class.

关于如何解决这个问题的任何想法