You can do
rows=db(db.events.id==id)(db.events.status==db.status.id)
(db.events.severity==db.severity.id).select()
for row in rows:
print row.events.message, row.status.status,
row.severity.severity
On Oct 18, 12:12 am, Sebastian Brandt <[email protected]> wrote:
> Hi everyone,
> I am having a hard time understanding SQL Queries in web2py.
>
> I have a database layout like that:
>
> db.define_table(
> 'status',
> SQLField('status')
> )
> db.define_table(
> 'severity',
> SQLField('severity')
> )
> db.define_table(
> 'events',
> SQLField('host'),
> SQLField('message'),
> SQLField('datetime_submitted','datetime',default=request.now,
> writable=False),
> SQLField('status',db.status),
> SQLField('severity',db.severity)
> )
>
> As shown, I use reference in the events table. I have a dropdown-menu
> that you can select events of a special status and not see all events.
> The IDs of those events are stored in id.
> My query I perform to get events back that have a special status is
> the following:
>
> events=db(db.events.id==id).select() #
>
> The events are printed in the view with a simple {{=events}}
> statement. I return exaclty what I have in the db-table, which are
> also the IDs of the fields in the referenced tables and not the "text"
> of the status and severity.
>
> Is there a way I can build a query that gives back the entry stored
> in .db.status.status and db.status.severity instead of their reference-
> id or would you normally match the id given back in events with the
> referenced entry while printing it somewhere in the view?
>
> I am asking because this would mean for the second option, that I have
> to do 2 more queries to the db and I would need some kind of loop to
> replace the id with the referenced entry and I am really wondering if
> this is the most performanced optimize approach.
>
> Thanks in advance
> Sebastian Brandt
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
