Thanks Mengu, it helps a lot.
On Dec 18, 8:35 am, Mengu <[email protected]> wrote: > Dear Jake > > the information goes between db() is the query. for example, > usersWithNameJake = (db.auth_user.first_name == "Jake") is a query > which you can use as db(usersWithNameJake). > > the select() method takes the table field arguments to select, like db > (usersWithNameJake).select(db.auth_user.first_name, > db.auth_user.last_name). > > it also allows us to limit, order and group the results like this: > > db(usersWthNameJake).select(order=~db.auth_user.id, > group=db.auth_user.city, limit=(1,5)) > > p.s. as you noticed, you don't have to pass the field parameters to > select, by default it selects all. > > p.p.s: there is no such field called city in auth_user, i just made it > up. > > hope this helps. > > On Dec 18, 2:57 pm, Jake <[email protected]> wrote: > > > First, let me say that i'm 10 days into Python and Web2Py. I > > apologize if this is so rudimentary as to appear stupid. > > > So there is no DAL class. DAL is a function, exported from the > > gluon.sql module, that returns a SQLDB object if not using GAE, so: > > > db = DAL('foo') > > > makes db an instance of SQLDB. > > > Now, lets say you do a db().select(). There is no select() method in > > the SQLDB class. After going crazy for a couple hours, i learned what > > __call__ was, and realized that this allows you to use the select() > > method of the Set class from an instance of SQLDB. > > > The select() method of the Set class always returns an instance of the > > Rows class, which operates like a list, so you always have to access > > the return value of the .select() method with iteration or indexes, > > even if return value is guaranteed to return one or no values (a > > lookup on an id, lets say). > > > My question: What information do you have to send as parameters of > > the db() call, what information do you send as parameters of > > the .select() method, and why? > > > Thank you very much, and please correct me if i'm wrong about > > something, which is very likely. > > > Jake -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
