Run sql like "OR" query on appengine
How can I run the equivalent of this query:
"select * from users where username='john' or email='john@email.com';
on appengine? I know appengine doesn't support the 开发者_运维技巧"OR" but has "IN" just not sure how to use it for such a query.
This question gives an example of using 'IN' as an 'OR' equivalent. However, as noted in the comments, GAE will treat 'IN' like multiple queries and is generally a bad idea, especially when querying on many list values.
Your best bet is often to perform the separate queries yourself and combine them programmatically.
EDIT: As pointed out, using an IN filter won't work anyway for your specific example.
You cannot do that in one query in Appengine. You can do two querys and combine the two results.You should do something like this to achieve the above query
result_1 = users.all().filter("username = ","john").fetch(100)
result_2 = users.all().filter("email = ",'john@email.com').fetch(100)
results = result_1.extend(result_2)
精彩评论