Note: I added in an 'email' virtual field, but still no luck.
This is right before auth.define_tables(username=True, signature=False,
migrate=False)
class MyVirtualFields(object):
def email(self):
return self.user.username
db.user.virtualfields.append(MyVirtualFields())
On Thursday, May 31, 2012 1:09:39 PM UTC-7, Osman Masood wrote:
>
> Hi,
> I have a custom table, and I'm trying to use a 'username' field instead of
> an 'email' field (since the book says if there's a username field, it will
> be used instead of the email field).
> However, whenever I try the 'forgot my username' function, it gives me an
> error, saying:
> <type 'exceptions.KeyError'> 'email'
> (Looks like it's trying to access the email field, which of course doesn't
> exist.)
>
> Here's my code:
> auth.settings.table_user_name = 'user'
> db.define_table(auth.settings.table_user_name,
> Field('username', length=60, unique=True, label='Email address'), #
> required
> Field('password', 'password', length=512, writable=False,
> readable=False, label='Password'), # required
> Field('registration_key', length=512, writable=False, readable=False,
> default=''), # required
> Field('reset_password_key', length=512, writable=False,
> readable=False, default=''), # required
> Field('registration_id', length=512, writable=False, readable=False,
> default=''), # required
> format='%(username)s')
>
> ## do not forget validators
> custom_auth_table = db[auth.settings.table_user_name] # get the
> custom_auth_table
> custom_auth_table.password.requires = [ CRYPT(key="mykey",
> digest_alg="sha512") ]
> custom_auth_table.username.requires = [
> IS_EMAIL(error_message=auth.messages.invalid_email),
> IS_NOT_IN_DB(db, custom_auth_table.username)] # we need this so that
> web2py uses username as the email address. unique is not good enough
> auth.settings.table_user = custom_auth_table # tell auth to use
> custom_auth_table
>
> ## configure auth policy
> auth.settings.registration_requires_verification = True
> auth.settings.registration_requires_approval = True
> auth.settings.reset_password_requires_verification = True
> auth.messages.verify_email = 'Click on the link http://' + \
> request.env.http_host + \
> URL(r=request,c='default',f='user',args=['verify_email']) + \
> '/%(key)s to verify your email'
> auth.messages.reset_password = 'Click on the link http://' + \
> request.env.http_host + \
> URL(r=request,c='default',f='user',args=['reset_password']) + \
> '/%(key)s to reset your password'
>
> auth.define_tables(username=True, signature=False, migrate=False)
>
> ## configure email
> mail=auth.settings.mailer
> mail.settings.server = 'smtp.gmail.com:587' or 'logging'
> mail.settings.sender = '[email protected]'
> mail.settings.login = '[email protected]:mypass'
>
>
> And here's the error traceback:
>
> Traceback (most recent call last):
> File "/home/www-data/web2py/gluon/restricted.py", line 205, in restricted
> exec ccode in environment
> File "/home/www-data/web2py/applications/Talent_Web/controllers/default.py"
> <https://ec2-204-236-184-137.us-west-1.compute.amazonaws.com/admin/default/edit/Talent_Web/controllers/default.py>,
> line 73, in <module>
> File "/home/www-data/web2py/gluon/globals.py", line 175, in <lambda>
> self._caller = lambda f: f()
> File "/home/www-data/web2py/applications/Talent_Web/controllers/default.py"
> <https://ec2-204-236-184-137.us-west-1.compute.amazonaws.com/admin/default/edit/Talent_Web/controllers/default.py>,
> line 34, in user
> return dict(form=auth())
> File "/home/www-data/web2py/gluon/tools.py", line 1196, in __call__
> return getattr(self,args[0])()
> File "/home/www-data/web2py/gluon/tools.py", line 2158, in retrieve_username
> old_requires = table_user.email.requires
> File "/home/www-data/web2py/gluon/dal.py", line 7180, in __getattr__
> return self[key]
> File "/home/www-data/web2py/gluon/dal.py", line 7120, in __getitem__
> return dict.__getitem__(self, str(key))
> KeyError: 'email'
>
>