类型错误:在0x7f86789f9bf8 sqlalchemy.orm.attributes.InstrumentedAttribute对象不是JSON序列化
我使用烧瓶瓶,登录用户认证。烧瓶SQLAlchemy中存储这些车型在SQLite数据库:类型错误:在0x7f86789f9bf8 sqlalchemy.orm.attributes.InstrumentedAttribute对象不是JSON序列化
ROLE_USER = 0
ROLE_ADMIN = 1
class Anonymous(AnonymousUserMixin):
def __init__(self):
self.username = 'Guest'
lm.anonymous_user = Anonymous
class User(UserMixin, db.Model):
__tablename__ = "users"
id = db.Column(db.Integer, primary_key = True)
username = db.Column(db.String(64), index = True, unique = True)
password = db.Column(db.String(20), index = False, unique = True)
email = db.Column(db.String(120), index = True, unique = True)
registered_on = db.Column('registered_on' , db.DateTime)
role = db.Column(db.SmallInteger, default = ROLE_USER)
def __repr__(self):
return '<User %r>' % (self.username)
def get_id(self):
return User.id
class PostVote(db.Model):
__tablename__ = "postvotes"
post_id = db.Column(db.Integer, db.ForeignKey('posts.id'), primary_key = True)
user_id = db.Column(db.Integer, default = 0)
type = db.Column(db.Boolean, default = True)
class Post(db.Model):
__tablename__ = "posts"
id = db.Column(db.Integer, primary_key = True)
body = db.Column(db.String(320))
points = db.Column(db.Integer, default = 0)
votes = db.relationship(PostVote)
timestamp = db.Column(db.DateTime)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'))
def __repr__(self):
return '<Post %r>' % self.body
我的登录代码:
@app.route('/login', methods = ['GET', 'POST'])
def init_login():
form = LoginForm()
if request.method == 'GET':
return render_template('login/index.html', form = form, active = 'login')
if form.validate():
uname = form.username.data
passw = form.password.data
print('DBG: Loginning ' + uname) #for debug purposes
registered_user = User.query.filter_by(username = uname).first()
if registered_user is None:
flash('User not found')
return render_template('/login/index.html', form=form,
msgtype = 'alert-warning', active = 'login')
if check_passw(passw, registered_user.password):
login_user(registered_user)
session['username'] = uname
return redirect(url_for('init_login_success'))
else:
flash('Incorrect password')
return render_template('/login/index.html', form=form,
msgtype = 'alert-danger', active = 'login')
return render_template('login/index.html', form = form, active = 'login')
当我试图登录,SQLAlchemy的触发错误,您可以在文章标题(TypeError: <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7f86789f9bf8> is not JSON serializable
)见。 AFAIK,InstumentedAttribute用于关系,但它没有帮助我。
我还发现发生该错误则()执行login_user。登录无需登录即可正常工作。
我怎样才能解决这个问题?
眼下get_id()
在文档同时返回一个整数:
get_id()
This method must return a unicode that uniquely identifies this user, and can be used to load the user from the user_loader callback. Note that this must be a unicode - if the ID is natively an int or some other type, you will need to convert it to unicode.
我写了这个要解决的问题:
def get_id(self):
return str(self.id)
确实提到了,原来是返回类属性'User.id'代替实例属性,因此整个麻烦与InstrumentedA ttribute';它没有返回一个整数。 –
我忘记说了。谢谢。 – NeoCortex
这是不是你的问题,但我想提一提的是:默认情况下,支持每个烧瓶取景功能'GET'方法,这样你就不用写'如果request.method ==“GET'' – metmirr