What is the DAL Code to generate a query like this:
SELECT * FROM product WHERE product.id=1 OR product.id=2 OR product.id=3 OR
product.id product.id=4 OR product.id=5;
or even:
SELECT * FROM product WHERE (product.id=1) OR (product.id=2) OR
(product.id=3) OR (product.id=4) OR (product.id=5);
I've tried both the DAL code approaches below and I always end up with
crazy parentheses nesting which will eventually crash the DB driver e.g. in
sqlite: <class 'sqlite3.OperationalError'> parser stack overflow
Is there another way to use the DAL, or is my only option to write the SQL
manually?
db.define_table("product")
selected_ids = [1,2,3,4,5]
query = []
for pid in selected_ids:
query.append(db.product.id == pid)
query = reduce(lambda a,b:a|b,query)
#Ouputs this : (((((product.id = 1) OR (product.id = 2)) OR (product.id
= 3)) OR (product.id = 4)) OR (product.id = 5))
selected_ids = [1,2,3,4,5]
query = []
for pid in selected_ids:
query |= db.product.id == pid
#I get a bonus parenthesis with this method ((((((product.id = 1) OR )
OR (product.id = 2)) OR (product.id = 3)) OR (product.id = 4)) OR
(product.id = 5))
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
