[web2py] Re: Associate a db record with a logged in user

[Dave Cenker]

Thank you very much! I knew it had to be simple. I just didn't infer that 
information from the way the book explained it. Your help is much 
appreciated!
 

On Monday, January 7, 2013 3:31:33 PM UTC-5, Dave Cenker wrote:

 This seems so elementary, but I can't seem to find out how to do it in the 
 book or googling the group ...
  
 I have several users defined and when that user is logged in and is 
 creating a db record that is specific to that user, I want it to be 
 automatically assigned to him/her.
  
 For example, given a model that defines a checking account,
  
 db.define_table('account',
   Field('type'),
   Field('balance'),
   Field('user', db.auth_user))
  
 How can I use the crud.create forms to automatically assign the value of 
 the user field on the account model to the currently logged in user?
  
 Thanks,
 Dave
  


-- 

[web2py] Re: Associate a db record with a logged in user

[Massimo Di Pierro]

You can do:

Field('user', db.auth_user, default=auth.user_id, writable=False))

Anyway, type and user are not valid field names. They work with sqlite 
but will break with postgresql and other databases.

On Monday, 7 January 2013 14:31:33 UTC-6, Dave Cenker wrote:

 This seems so elementary, but I can't seem to find out how to do it in the 
 book or googling the group ...
  
 I have several users defined and when that user is logged in and is 
 creating a db record that is specific to that user, I want it to be 
 automatically assigned to him/her.
  
 For example, given a model that defines a checking account,
  
 db.define_table('account',
   Field('type'),
   Field('balance'),
   Field('user', db.auth_user))
  
 How can I use the crud.create forms to automatically assign the value of 
 the user field on the account model to the currently logged in user?
  
 Thanks,
 Dave
  


-- 

[web2py] Re: Associate a db record with a logged in user

[Niphlod]

Field('user_id', 'reference auth_user', default=auth.user_id)

On Monday, January 7, 2013 9:31:33 PM UTC+1, Dave Cenker wrote:

 This seems so elementary, but I can't seem to find out how to do it in the 
 book or googling the group ...
  
 I have several users defined and when that user is logged in and is 
 creating a db record that is specific to that user, I want it to be 
 automatically assigned to him/her.
  
 For example, given a model that defines a checking account,
  
 db.define_table('account',
   Field('type'),
   Field('balance'),
   Field('user', db.auth_user))
  
 How can I use the crud.create forms to automatically assign the value of 
 the user field on the account model to the currently logged in user?
  
 Thanks,
 Dave
  


--