> > On Tuesday, April 10, 2018 at 3:14:06 PM UTC-7, Yoel Benitez Fonseca wrote: >> >> Is this not working any more ? >> >> >>> q = (db.photo.id == 1) >> >>> db(q.as_dict(flat=True)).select() >> File "<string>", line unknown >> SyntaxError: Operator not supported: eq >> >> That is in a web2py shell,i mean is the same thing passing around the >> query in the session as a dict, is not ? >> > > > The following works: > > >>> q = (db.photo.id == 1) > >>> db(q).select().as_dict() > > as_dict() and as_list() are defined as operating on a Rows object. q is > a query object. > <URL: > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#as_dict-and-as_list > > > > flat=True gives an unexpected keyword argument error. >
The Query class also has an as_dict method, though I don't think it is documented: https://github.com/web2py/pydal/blob/master/pydal/objects.py#L2004 Anthony -- 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.
