Python Daily

Json serialize error

I am trying to return data from database to jquery to get the data dynamically(you know without refreshing), as you can see im returning a sqlalchemy object with jsonify but i get a serialize error i have searched around but i dont quite understand what that really is or how it works

@home_blueprint.route('/_posting_process/', methods=['POST'])
@login_required
def _posting_process():

post = PostForm()
user = Users.query.filter_by(id=current_user.id).first()

if post.validate_on_submit():
posted = Comments(comment=post.onmind.data,
user_id=user.id)
db.session.add(posted)
db.session.commit()

return jsonify({'posts': post.comments})
return 'not posted'

Traceback (most recent call last):
File "/usr/lib/python3.5/site-packages/flask/app.py", line 2000, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/lib/python3.5/site-packages/flask/app.py", line 1991, in wsgi_app
response = self.make_response(self.handle_exception(e))
File "/usr/lib/python3.5/site-packages/flask/app.py", line 1567, in handle_exception
reraise(exc_type, exc_value, tb)
File "/usr/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/usr/lib/python3.5/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/usr/lib/python3.5/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/lib/python3.5/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/lib/python3.5/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/usr/lib/python3.5/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/lib/python3.5/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/lib/python3.5/site-packages/flask_login.py", line 792, in decorated_view
return func(*args, **kwargs)
File "/home/quechon/PycharmProjects/untitled3/myapp/home/routes.py", line 48, in _posting_process
return jsonify({'posts': user.comments})
File "/usr/lib/python3.5/site-packages/flask/json.py", line 266, in jsonify
(dumps(data, indent=indent, separators=separators), '\n'),
File "/usr/lib/python3.5/site-packages/flask/json.py", line 126, in dumps
rv = _json.dumps(obj, **kwargs)
File "/usr/lib/python3.5/site-packages/simplejson/__init__.py", line 397, in dumps
**kw).encode(obj)
File "/usr/lib/python3.5/site-packages/simplejson/encoder.py", line 291, in encode
chunks = self.iterencode(o, _one_shot=True)
File "/usr/lib/python3.5/site-packages/simplejson/encoder.py", line 373, in iterencode
return _iterencode(o, 0)
File "/usr/lib/python3.5/site-packages/flask/json.py", line 83, in default
return _json.JSONEncoder.default(self, o)
File "/usr/lib/python3.5/site-packages/simplejson/encoder.py", line 268, in default
raise TypeError(repr(o) + " is not JSON serializable")
TypeError: <sqlalchemy.orm.dynamic.AppenderBaseQuery object at 0x7f3ff14f5748> is not JSON serializable

if you guys please can explain to me what serialize mean and do thanks

/r/flask
https://redd.it/5kbmg9

Json serialize error • /r/flask

I am trying to return data from database to jquery to get the data dynamically(you know without refreshing), as you can see im returning a...

15 views04:30