You want belongs, I think:
query = db.product.id.belongs((selected_ids))
On Saturday, March 28, 2015 at 12:14:44 PM UTC-4, gb wrote:
>
> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
