Hello
Sorry for the probably obvious questions, but I do search for answers
honest :)
Anyway, what I want is for my table rows to be user specific. Such that
when each user registers, the database looks empty to them, until they
start creating rows in their forms.
I have added these definitions to each table:
db.define_table(
'shoe',
Field('model',db.model),
Field('purchased','date'),
Field('price','integer'),
Field('created_on', 'datetime',
default=request.now, update=request.now, writable=False),
* Field('created_by', 'reference auth_user',*
* default=auth.user_id, update=auth.user_id, writable=False),*
format=lambda r: '%s %s %s' %
(r.model.manufacturer.name,r.model.model,r.purchased))
So I've added created_by referencing auth_user, and this places the logged
in user into the row
I could add code to the controller, the simple controller looks like
@auth.requires_login()
def shoe():
form = SQLFORM(db.shoe)
if form.process().accepted:
response.flash = 'form accepted'
elif form.errors:
response.flash = 'form has errors'
else:
response.flash = 'please fill out the form'
return dict(form=form)
Perhaps with a SQLFORM.factory somehow?
Or is CRUD the way to go? I have no idea about CRUD yet (nor much of an
idea about most of this right now, but I'm learning)
Or perhaps using common_filter? Somehow like this:
table._common_filter = lambda query: db.shoe.created_by == auth.user.id
I don't mind really which way this gets done, but if there's a canonical way,
or a best practice way, I'd like to learn that, instead of the 'wrong but
works' way.
Thanks!
Gary
--
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/d/optout.
