>
> query = db.auth_event.description.contains('connect')
> query &= db.auth_event.time_stamp.max()
> lastUserLogged = db(query).select(db.auth_event.user_id)
>
First, db.auth_event.time_stamp.max() simply produces the following SQL:
MAX("auth_event"."time_stamp")
It is not a query, just an expression.
Second, your approach will not necessarily give you what you want, as there
is no guarantee that the maximum timestamp value in the entire auth_event
table happens to coincide with the most recent "connect" event (as opposed
to some other type of event).
Instead, a better approach is to (reverse) order by timestamp and limit the
select to the first record:
db(db.auth_event.description.contains('connect')).select(orderby=~db.
auth_event.time_stamp,
limitby=(0, 1))
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.
