[web2py] Re: Add extra fields to db.auth_user
Beside adding extra field, is it possible to split the table for auth_user?
For example, I want the profile to be broken in different tables based on
address, education, portfolio...etc. that someone can create a profile. And
add fields to that tables as that person see fit.
On Wednesday, December 4, 2013 at 11:56:06 AM UTC-5, Gael Princivalle wrote:
> Thanks a lot Massimo, in fact I've made testing on an existing user. Now
> with requires=IS_NOT_EMPTY() the form ask to fill the company field.
> Perfect.
>
> For problem 2 I'm gone define my own auth_user table, have a nice day.
>
> Il giorno mercoledì 4 dicembre 2013 16:29:14 UTC+1, Massimo Di Pierro ha
> scritto:
>>
>> I cannot reproduce problem 1. There is nothing wrong in your code and
>> something else is causing the problem. Are you sure the issue is that "A
>> user can register without filling this field." or is it the users who
>> registered before the contraint was introduced do not have a company field?
>>
>> Problem 2. To fix that you need define your own auth_user table. If you
>> do:
>>
>> db.define_table('auth_user', )
>>
>> before auth.define_tables() it should use yours.
>>
>> On Tuesday, 3 December 2013 09:14:02 UTC-6, Gael Princivalle wrote:
>>>
>>> Hi.
>>>
>>> I've had extra fields to db.auth_user like that in db.py:
>>>
>>> auth = Auth(db)
>>> auth.settings.extra_fields['auth_user']= [Field('Company',
>>> requires=IS_NOT_EMPTY()),Field('Phone')]
>>>
>>> Problem n°1, requires=IS_NOT_EMPTY() don't have any effect. A user can
>>> register without filling this field.
>>>
>>> Problem n° 2, Company and Phone fields are in the form after passwords
>>> field, I would like to change the fild order.
>>>
>>> How can I do it ?
>>>
>>> Thanks.
>>>
>>
--
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.
[web2py] Re: Add extra fields to db.auth_user
Thanks James but also required=True don't have any effect. Perhaps I have
to make a custom form or register, do you know I can do it ?
Il giorno martedì 3 dicembre 2013 19:56:39 UTC+1, James Burke ha scritto:
For problem no1, you could try using required=True instead of
requires=IS_NOT_EMPTY()
For your second problem you can define the auth_user table yourself (from
web2py book):
Another way to do this, although not really recommended, consists of
defining your auth tables yourself. If a table is declared before
auth.define_tables() it is used instead of the default one. Here is how
to do it:
## after auth = Auth(db)
db.define_table(
auth.settings.table_user_name,
Field('first_name', length=128, default=''),
Field('last_name', length=128, default=''),
Field('email', length=128, default='', unique=True), # required
Field('password', 'password', length=512,# required
readable=False, label='Password'),
Field('address'),
Field('city'),
Field('zip'),
Field('phone'),
Field('registration_key', length=512,# required
writable=False, readable=False, default=''),
Field('reset_password_key', length=512, # required
writable=False, readable=False, default=''),
Field('registration_id', length=512, # required
writable=False, readable=False, default=''))
## do not forget validators
custom_auth_table = db[auth.settings.table_user_name] # get the
custom_auth_table
custom_auth_table.first_name.requires =
IS_NOT_EMPTY(error_message=auth.messages.is_empty)
custom_auth_table.last_name.requires =
IS_NOT_EMPTY(error_message=auth.messages.is_empty)
custom_auth_table.password.requires = [IS_STRONG(), CRYPT()]
custom_auth_table.email.requires = [
IS_EMAIL(error_message=auth.messages.invalid_email),
IS_NOT_IN_DB(db, custom_auth_table.email)]
auth.settings.table_user = custom_auth_table # tell auth to use
custom_auth_table
## before auth.define_tables()
--
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.
[web2py] Re: Add extra fields to db.auth_user
I cannot reproduce problem 1. There is nothing wrong in your code and
something else is causing the problem. Are you sure the issue is that A
user can register without filling this field. or is it the users who
registered before the contraint was introduced do not have a company field?
Problem 2. To fix that you need define your own auth_user table. If you do:
db.define_table('auth_user', )
before auth.define_tables() it should use yours.
On Tuesday, 3 December 2013 09:14:02 UTC-6, Gael Princivalle wrote:
Hi.
I've had extra fields to db.auth_user like that in db.py:
auth = Auth(db)
auth.settings.extra_fields['auth_user']= [Field('Company',
requires=IS_NOT_EMPTY()),Field('Phone')]
Problem n°1, requires=IS_NOT_EMPTY() don't have any effect. A user can
register without filling this field.
Problem n° 2, Company and Phone fields are in the form after passwords
field, I would like to change the fild order.
How can I do it ?
Thanks.
--
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.
[web2py] Re: Add extra fields to db.auth_user
Thanks a lot Massimo, in fact I've made testing on an existing user. Now
with requires=IS_NOT_EMPTY() the form ask to fill the company field.
Perfect.
For problem 2 I'm gone define my own auth_user table, have a nice day.
Il giorno mercoledì 4 dicembre 2013 16:29:14 UTC+1, Massimo Di Pierro ha
scritto:
I cannot reproduce problem 1. There is nothing wrong in your code and
something else is causing the problem. Are you sure the issue is that A
user can register without filling this field. or is it the users who
registered before the contraint was introduced do not have a company field?
Problem 2. To fix that you need define your own auth_user table. If you do:
db.define_table('auth_user', )
before auth.define_tables() it should use yours.
On Tuesday, 3 December 2013 09:14:02 UTC-6, Gael Princivalle wrote:
Hi.
I've had extra fields to db.auth_user like that in db.py:
auth = Auth(db)
auth.settings.extra_fields['auth_user']= [Field('Company',
requires=IS_NOT_EMPTY()),Field('Phone')]
Problem n°1, requires=IS_NOT_EMPTY() don't have any effect. A user can
register without filling this field.
Problem n° 2, Company and Phone fields are in the form after passwords
field, I would like to change the fild order.
How can I do it ?
Thanks.
--
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.
[web2py] Re: Add extra fields to db.auth_user
For problem no1, you could try using required=True instead of
requires=IS_NOT_EMPTY()
For your second problem you can define the auth_user table yourself (from
web2py book):
Another way to do this, although not really recommended, consists of
defining your auth tables yourself. If a table is declared before
auth.define_tables() it is used instead of the default one. Here is how to
do it:
## after auth = Auth(db)
db.define_table(
auth.settings.table_user_name,
Field('first_name', length=128, default=''),
Field('last_name', length=128, default=''),
Field('email', length=128, default='', unique=True), # required
Field('password', 'password', length=512,# required
readable=False, label='Password'),
Field('address'),
Field('city'),
Field('zip'),
Field('phone'),
Field('registration_key', length=512,# required
writable=False, readable=False, default=''),
Field('reset_password_key', length=512, # required
writable=False, readable=False, default=''),
Field('registration_id', length=512, # required
writable=False, readable=False, default=''))
## do not forget validators
custom_auth_table = db[auth.settings.table_user_name] # get the
custom_auth_table
custom_auth_table.first_name.requires =
IS_NOT_EMPTY(error_message=auth.messages.is_empty)
custom_auth_table.last_name.requires =
IS_NOT_EMPTY(error_message=auth.messages.is_empty)
custom_auth_table.password.requires = [IS_STRONG(), CRYPT()]
custom_auth_table.email.requires = [
IS_EMAIL(error_message=auth.messages.invalid_email),
IS_NOT_IN_DB(db, custom_auth_table.email)]
auth.settings.table_user = custom_auth_table # tell auth to use
custom_auth_table
## before auth.define_tables()
--
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.
