Receiving AssertionError using Flask sqlalchemy and restful

Question

I have been stumped and can't seem to figure out why I am receiving an AssertionError. I am currently working on a rest api using the flask_restful lib. I am querying by:

@staticmethod
def find_by_id(id, user_id):
    f = File.query.filter_by(id=id).first() #Error is happening here
    if f is not None:
        if f.check_permission(user_id)>=4:
            return f
        print f.check_permission(user_id)
        FileErrors.InsufficientFilePermission()
    FileErrors.FileDoesNotExist()

The error message looks like this:

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 2000, in __call__
    return self.wsgi_app(environ, start_response)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1991, in wsgi_app
    response = self.make_response(self.handle_exception(e))
  File "/usr/local/lib/python2.7/dist-packages/flask_restful/__init__.py", line 271, in error_router
    return original_handler(e)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1567, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python2.7/dist-packages/flask_restful/__init__.py", line 268, in error_router
    return self.handle_error(e)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1988, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1641, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python2.7/dist-packages/flask_restful/__init__.py", line 271, in error_router
    return original_handler(e)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1531, in handle_user_exception
    assert exc_value is e
AssertionError

This is how my File model looks like:

class File(db.Model):
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer)
parts = db.Column(db.Integer)
size = db.Column(db.Integer)
name = db.Column(db.String(100))

def __init__ (self, file_info):
    self.user_id = file_info['user_id']
    self.parts = file_info['parts']
    self.size = file_info['size']
    self.name = file_info['name']

@staticmethod
def create(file_info):
    return add_to_db(File(file_info))

@staticmethod
def delete(file_id, user_id):
    pass

def check_permission(self,user_id):
    permission = 0
    print 'self.user_id {}'.format(self.user_id)
    print 'user_id {}'.format(user_id)
    if self.user_id == user_id:
        return 7
    fs = FileShare.find_by_file_and_user_id(self.id, user_id)
    if fs is not None:
        permission = fs.permission
    return permission

@staticmethod
def find_by_id(id, user_id):
    f = File.query.filter_by(id=id).first() #Error is happening here
    if f is not None:
        if f.check_permission(user_id)>=4:
            return f
        print f.check_permission(user_id)
        FileErrors.InsufficientFilePermission()
    FileErrors.FileDoesNotExist()

Any help would be appreciated. Thanks in advance.

@vishes_shell sorry there isn't two. They are the same one. I just wanted to post the whole class for clarity and context. — m0bbin, Oct 04 '16 at 14:32
i'm sorry i didn't mention that there is scroll bar because code is long. — vishes_shell, Oct 04 '16 at 14:34

score 0 · Answer 1 · answered Oct 04 '16 at 08:56

0

Are you sure you want to have an assignment operator instead of comparison in your filter. Try replacing = with == and see if it solves your problem.

f = File.query.filter_by(id == id).first()

Hannu

answered Oct 04 '16 at 08:56

Hannu

11,685
4
35
51

Sadly it doesn't work. On some of my other queries, I do it like how it is above and there seems to be no problem. The error it returns is "TypeError: filter_by() takes exactly 1 argument (2 given)". – m0bbin Oct 04 '16 at 14:38

m0bbin · Accepted Answer · 2016-10-11T08:39:47.007

0

Although I couldn't figure out why the error occurs, I know how as well as how to prevent it. It is created because the query doesn't pull the live data right after the commit. The way to prevent it is by using db.session.query(). So in my example I would change:

f = File.query.filter_by(id=id).first()

to

f = db.session.query(File).filter_by(id=id).first()

For some reason that works. Although I don't know why.

EDIT: It seems to have to do with the class not receiving updated session. For the time being I recommending using queries within session.

edited Oct 11 '16 at 08:39

answered Oct 05 '16 at 06:29

m0bbin

166
2
13

This was most probably caused by having more than 1 instance of the `SQLAlchemy` object of Flask-SQLAlchemy, so the models have one copy of `db` and the views etc. are using another. – Ilja Everilä Nov 13 '18 at 21:23

Receiving AssertionError using Flask sqlalchemy and restful

2 Answers2