db().select() and db.executesql() quetstion

[Richard]

Hello,

I would like to clarify how DAL handle backend query.

For instance, if I assign a db().select() or executesql to a var like so :

query = db().select() 

or

query = db.executesql() 

Is the backend query occurs then or it occurs when I use the query var in a for loop for instance.

And if I am loop 2-3 differents times over the same query var does that trigger backend query each time?

Thanks

Richard

[Anthony]

No, the database is queried when you call the .select() or .executesql() method. The former returns a Rows object and the latter a list of tuples, so when you loop over your "query" object (which is confusingly named), you are simply looping over a Python data structure.

Anthony

[Richard Vézina]

Thanks Anthony,

I should use rows...

I had investigate that with help postgresql log and as you said DAL does queried the database at the assignation of the db select or executesql...

Richard

--
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+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.