db.uploads.up_post.requires = IS_IN_DB(db(db.post.author == auth.user_id),
db.post,'%(summary)s')
The IS_IN_DB validator takes a Set object as the first argument, which can
be used to filter the allowable records.
Anthony
On Wednesday, February 26, 2014 5:23:41 PM UTC-5, brahama von wrote:
>
> Hi guys!
>
> How is the approach to do this?
>
> Here's the model
> -------------------------
> db.define_table('uploads',
> Field('up_name','string',requires=IS_NOT_EMPTY()),
> Field('mainfile','upload'),
> Field('thumb','upload',writable=False,readable=False),
> Field('up_author',db.auth_user,requires=IS_NOT_EMPTY()),
> Field('up_post','reference post'),
> format='%(up_name)s')
>
> db.uploads.up_author.writable = db.uploads.up_author.readable = False
>
> db.define_table('post',
> Field('summary','string',requires=IS_NOT_EMPTY()),
> Field('author',db.auth_user,requires=IS_NOT_EMPTY()),
> Field('body','text'),
> format='%(summary)s')
>
> db.post.author.writable = db.post.author.readable = False
> db.uploads.up_post.requires = IS_IN_DB(db,db.post,'%(summary)s')
>
>
> So when i want the user to upload an image so it can be related to the
> post i only want to show the posts in the form that the user owns.
>
> controller
> ------------------
> @auth.requires_login()
> def newimage():
> dbtable = db.uploads #uploads table name
> if auth.is_logged_in:
> dbtable.up_author.default = auth.user.id
>
> form = SQLFORM(dbtable)
> return dict(form=form)
>
>
> It has a few more lines but are for testing and practice as i am really
> new to web2py :)
>
> That is all. Thanks for any advice.
>
> Cheers!
>
>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
