Databases
StackOverflow2013
Postsdbo
POweb2py Custom User Profile?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POweb2py Custom User Profile?
    primarykey
    data
    text
    <blockquote> <p>What is the 'correct' way to extend the base <code>auth_user</code> table/the whole <code>auth</code> system in order to support a number of custom user profile fields (such as username, location, birthday, etc.)?</p> </blockquote> <p>I've caught glances of approaches from Googling, but no one ever seems to give a straight answer. The answer seems to be either completely replacing the base <code>auth_user</code> table with a custom one (and letting the auth system know), or creating a new extension table with a foreign key reference back to the base <code>auth_user</code> table. The first seems to have reusability problems, the second is going to have problems with forms and such.</p> <p>Does anyone have any pointers to patch in something as universal as custom user profiles without breaking too much?</p> <p><strong>EDIT:</strong> A bit more reading suggests overriding the base <code>auth_user</code> table is the way to go, and after some trial and error, I've found it's as easy as dropping in a block of code:</p> <pre><code># before define_tables() auth.settings.table_user = db.define_table('auth_user', Field('email', length=128,label=T('Email'), default='', unique=True), Field('user_name', length=128, label=T('User name'), default='', unique=True, requires=IS_NOT_IN_DB(db, 'auth_user.user_name') ), Field('password', 'password', readable=False, label=T('Password'), requires=CRYPT() ), Field('first_name', length=128, label=T('First name'), default='', requires=(IS_NOT_EMPTY(error_message=auth.messages.is_empty), IS_NOT_IN_DB(db, 'auth_user.first_name')) ), Field('last_name', length=128, label=T('Last name'), default='', requires=(IS_NOT_EMPTY(error_message=auth.messages.is_empty), IS_NOT_IN_DB(db, 'auth_user.last_name')) ), Field('registration_key', length=128, default='', writable=False, readable=False), Field('country', 'string', length=15, label=T('Country'), requires=IS_NULL_OR(IS_IN_SET(('England'))) ), ) </code></pre> <p>So long as this gets executed after <code>auth = Auth(db)</code> and before <code>auth.define_tables()</code> in models/db.py, it all seems to work out okay. The fields show up on the user profile page, and everything else still works as expected.</p> <p>Not sure how to answer my own question, so in the meantime, if someone could explain <em>why</em> this is the right way to do it, and what else must be kept in mind, I'd appreciate it!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USorlade
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POweb2py Custom User Profile?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POweb2py Custom User Profile?
      1. USamit_grepclub
      1. VTFavorite
    3. VO
      singulars
      1. POweb2py Custom User Profile?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload