Flask - Convert request.args to dict

Question

I've been trying to figure out how to pass the request.args to sqlalchemy filter.

I thought this should work:

model.query.filter(**request.args).all()

But it's throwing the error:

TypeError: <lambda>() got an unexpected keyword argument 'userid'

When userid or any other get arg is present.

According to this post - https://stackoverflow.com/questions/19506105/flask-sqlalchemy-query-with-keyword-as-variable - you can pass a dict to the filter function.

Any ideas what I'm doing wrong?

Many thanks :)

UPDATE: Many thanks to the poster below, however now it's throwing the following error:

ProgrammingError: (ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY tblclients.clientname' at line 3") 'SELECT favourites.id AS favourites_id, favourites.userid AS favourites_userid, favourites.clientid AS favourites_clientid, favourites.last_visit AS favourites_last_visit \nFROM favourites INNER JOIN tblclients ON tblclients.clientid = favourites.clientid \nWHERE favourites.userid = %s ORDER BY tblclients.clientname' ([u'41'],)

Any ideas?

Answer 1

First, you have to use filter_by, not filter.

Second, Flask request.args uses a MultiDict, a dict with the values inside a list, allowing more than one value for the same key, because the same field can appear more than once in a querystring. You got the error because the SQL query got the [u'41'] when it expected only '41'. You can use request.args.to_dict() to fix that:

model.query.filter_by(**request.args.to_dict()).all()

Answer 2

You can:

http://localhost:5000/filter-test?var=test

query_dict = request.args.to_dict()

print(query_dict)
{'var': 'test'}

print(query_dict['var'])
var