custom auth table

[patito feo]

Hi all,

Havent see any documentation on this matter. Ive been trying to make it work based on web2py but dont know if posible in py4web and where it should be placed.

Thanx,

[Massimo]

If you look into common.py you find this...

auth = Auth(session, db, define_tables=False) # define the object

auth.enable(uses=(session, T, db), env=dict(T=T)) # exposes the action

You can do:

auth = Auth(session, db, define_tables=False) # define the object

db.define_table('auth_user', ....)

auth.enable(uses=(session, T, db), env=dict(T=T)) # exposes the action

and you can make your own auth_user table but make sure it contains the basic fields.

There is only one table auth_user.

You can also do:

auth = Auth(session, db, define_tables=True, extra_fields = [Field('birthday', 'datetime')])

auth.enable(uses=(session, T, db), env=dict(T=T)) # exposes the action

and just add fields to the table.

[patito feo]

Thank you Massimo, It worked perfectly.

[Mamisoa Andriantafika]

Hi,

Can you add an auth.signature in the auth_user table as this, done with Web2py ?

-----------------------------------------------------

auth.settings.extra_fields['auth_user']= [  Field('maiden_name_pid6','string', label='Maiden name'),

                                            Field('dob_pid7','date', label='Date of birth'), 

                                            auth.signature]

def represent_auth(auth_ref, row):

    user = db(db.auth_user.id == auth_ref).select(db.auth_user.first_name, db.auth_user.last_name).first()

    return ('%(first_name)s %(last_name)s' % user) if user else '<system>'  # else assume it was the scheduler.

auth.signature.created_by.represent = auth.signature.modified_by.represent = represent_auth

auth.define_tables(username=False, signature=False)

---------------------------------------------

Mamisoa

[Jim Steil]

I think you can do it like this:

-----------------------------

auth = Auth(

    session,

    db,

    define_tables=False,

    allowed_actions=["change_password", "login", "logout", "profile"]

)

auth.extra_auth_user_fields = [Field('field_1', length=25),

                               Field('field_2', length=50),

                               auth.signature]

auth.define_tables()

-----------------------------

[Mamisoa Andriantafika]

Thanks. It works perfectly.