why reinventing the wheel ? IS_IN_DB takes a Set...
gr = db.auth_group
me = db.auth_membership
us = db.auth_user
theset = db(
(us.id == me.user_id) &
(gr.id == me.group_id) &
(gr.role == 'roletest')
)
....
Field('a_field', requires=IS_IN_DB(theset, 'auth_user.id', '%(first_name)s
- %(last_name)s'))
On Monday, December 1, 2014 4:04:32 PM UTC+1, Andrew Buchan wrote:
>
> Hi,
>
> I wanted to create a validator which creates a dropdown of users in a
> certain auth group.
> I figured I could shortcut this by inheriting from IS_IN_SET, see class
> below.
> This works fine for SQLFORMS in create mode (drop dow with just what I
> want to see) and for read-only mode (I see the user name, not the id) , but
> for a SQLFORM in edit mode which is pointing at an existing record, it
> doesn't pre-select the entry in the options drop-down.
>
> Any ideas on how I go about getting this to work, or is there a simpler
> solution?
>
> If you use this validator in the DAL, you can see the result the admin
> pages, so you have an easy way to test if you want to play around with it.
>
> Thanks,
>
> class IS_USER_IN_GROUP(IS_IN_SET):
> """A validator that can be used like "requires = IS_USER_IN_GROUP()"
> Provides a drop down of users in that group.
> """
> def __init__(self, group_name):
> keys = []
> labels = []
> staff_groups = db((db.auth_user.id==db.auth_membership.user_id) &
> (db.auth_group.id==db.auth_membership.group_id))
> rows = staff_groups(db.auth_group.role ==
> group_name).select(db.auth_user.ALL,
> orderby=db.auth_user.first_name|db.auth_user.last_name)
> for user in rows:
> keys.append(user.id)
> labels.append('%s %s' % (user.first_name, user.last_name))
> IS_IN_SET.__init__(self, keys, labels)
>
> def formatter(self, user_id):
> hits = db(db.auth_user.id == user_id).select()
> if len(hits) == 1:
> user = hits.first()
> return '%s %s' % (user.first_name, user.last_name)
> return ''
>
--
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.
