.select(
db.auth_user.first_name,
db.auth_user.last_name,
db.auth_user. ...
...
)
or
blacklist = ['password' ....]
whitelist = []
for f in db.auth_user.fields:
if f not in blacklist:
whitelist.append(db.auth_user[f])
.select(*whitelist)
On Wednesday, March 20, 2013 1:28:21 AM UTC-4, Alec Taylor wrote:
>
> Thanks, this did the trick:
>
> return db((db.auth_user.id == db.far_members.user_id) &
> (db.far_members.far_id == request.args(0))
> ).select(db.auth_user.ALL)
>
> Finally is there a way to exclude a field (blacklist) in the select
> function query?
>
> (I don't want password to appear there; even though it's hashed)
>
> On Wed, Mar 20, 2013 at 1:30 PM, Ricardo Pedroso
> <[email protected]<javascript:>>
> wrote:
> > On Tue, Mar 19, 2013 at 8:06 PM, Alec Taylor
> > <[email protected]<javascript:>>
> wrote:
> >> # Model [appname/models/far.py]
> >>
> >> db.define_table('far_members',
> >> Field('far_id', db.far, requires=IS_IN_DB(db, 'far.id')),
> >> Field('user_id', db.auth_user, default=auth.user_id,
> writable=False,
> >> requires=IS_IN_DB(db, 'auth_user.id'))
> >> )
> >>
> >> db.define_table('far',
> >> Field('cool_title'),
> >> Field('cool_content')
> >> )
> >>
> >> # Controller [appname/controllers/default.py]
> >>
> >> ''' I want to return the user profiles of all `far_members` '''
> >> def far():
> >> return db(db.auth_user.id == db(db.far_members.far_id ==
> >> request.args(0)).select(self.db.far_members.user_id)).select()
> >>
> >> # Call (id=1 is not blank)
> >>
> >> $ curl -X GET localhost/appname/far/1
> >>
> >> Server Error
> >
> > See if it's what you want:
> >
> > def far():
> > _set = db(
> > (db.auth_user.id == db.far_members.user_id)
> > & (request.args(0) == db.far_members.far_id))
> > rows = _set.select(db.auth_user.ALL)
> > _select = DIV(_set._select(db.auth_user.ALL))
> > return DIV(TABLE(rows), _select)
> >
> > Ricardo
> >
> > --
> >
> > ---
> > 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] <javascript:>.
> > For more options, visit https://groups.google.com/groups/opt_out.
> >
> >
>
--
---
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/groups/opt_out.
