It didn't seem to make any difference unfortunately. To be thorough I
will include the entire db.py to make sure I didn't miss something. This
site goes live in a few weeks and it would be nice to have this feature.
Best Regards,
Jason Brower
On Wed, 2010-05-12 at 21:05 -0700, mdipierro wrote:
> Not sure this should have ever worked. It needs
>
> This:
> self.settings.table_user = db.users
> should be:
> self.settings.table_user_name = 'users'
>
> Honestly I have not tested much what happens if you rename the
> auth_user table. Please let us know if you encouter ther problems.
>
>
> On May 12, 10:19 pm, Jason Brower <[email protected]> wrote:
> > It used to work back in the day. But it doesn't seem to be working now.
> > Any idea on what I would be doing wrong?
> > This is my model and the view is below when I try to register. As you
> > can see they don't go together. :/ For example, I should have university
> > affiliation there in the view. Any ideas what I did wrong here?
> > ---
> > Best Regards,
> > Jason Brower
> >
> > Screenshot.png
> > 117KViewDownload
> >
> > example-db.py
> > 2KViewDownload
from datetime import datetime, date, time
now = datetime.utcnow()
today = date.today()
db = SQLDB('sqlite://interestID.db')
db.define_table('users',
Field('nickname', 'string', length=20),
Field('first_name', 'string', length=15),
Field('last_name', 'string', length=15),
Field('phone_number', 'string', length=15),
Field('email', 'string'),
Field('password', 'password'),
Field('university_affiliation', 'string', length=25),
Field('created', 'datetime', default=now, readable=False, writable=False),
Field('registration_key', length=128, writable=False, readable=False, default=''),
Field('avatar', 'upload'),
Field('short_description','text'),
Field('sex','text'),)
#######################################
# Authentication System
#######################################
from gluon.tools import Mail, Auth
mail = Mail()
mail.settings.server='smtp.gmail.com:587'
mail.settings.sender= '[email protected]'
mail.settings.login='[email protected]:----'
class MyAuth(Auth):
def __init__(self, environment, T, db = None):
"Initialise parent class & make any necessary modifications"
Auth.__init__(self,environment,db)
self.messages.logged_in = T("Logged in")
self.messages.email_sent = T("Email sent")
self.messages.email_verified = T("Email verified")
self.messages.logged_out = T("Logged out")
self.messages.registration_successful = T("Registration successful")
self.messages.invalid_email = T("Invalid email")
self.messages.invalid_login = T("Invalid login")
self.messages.verify_email_subject = T("Password verify")
self.messages.username_sent = T("Your username was emailed to you.")
self.messages.new_password_sent = T("A new password was emailed to you.")
self.messages.password_changed = T("Password changed")
self.messages.retrieve_username=str(T("Your username is:"))+": %(username)s"
self.messages.retrieve_username_subject="Username retrieve"
self.messages.retrieve_password=str(T("Your password is:"))+": %(password)s"
self.messages.retrieve_password_subject = T("Password retrieve")
self.messages.profile_updated = T("Profile updated")
self.settings.table_user = "users"
auth = MyAuth(globals(), T, db)
auth.settings.mailer = mail
auth.define_tables()
db.define_table('tag',
Field('name', 'string'),
Field('description', 'text'),
Field('logo', 'upload'),
Field('created', 'date', default=now, writable=False),
Field('creator', 'string', writable=False))
db.define_table('user_tags',
Field('tag_id',db.tag),
Field('user_id',db.users))
db.define_table('user_photos',
Field('photo', 'upload'),
Field('description', 'text'),
Field('tag', db.tag),
Field('date_added', 'datetime', default=request.now, readable=False, writable=False))
db.user_photos.tag.requires = IS_IN_DB(db, db.tag.id, '%(name)s')
db.user_tags.tag_id.requires = IS_IN_DB(db,'tag.id')
db.user_tags.user_id.requires = IS_IN_DB(db,'users.id')
db.users.nickname.requires = IS_NOT_IN_DB(db,'users.nickname')
db.users.first_name.requires = IS_NOT_EMPTY()
db.users.last_name.requires = IS_NOT_EMPTY()
db.users.password.requires = CRYPT()
db.users.email.requires = [IS_EMAIL(), IS_NOT_IN_DB(db,'users.email')]
db.users.created.requires = IS_NOT_EMPTY()
db.users.sex.requires = IS_IN_SET(["Male","Female","Unset"])
db.tag.name.requires = [IS_NOT_EMPTY(), IS_NOT_IN_DB(db,'tag.name')]
db.tag.description.requires = IS_NOT_EMPTY()
db.tag.logo.requires = IS_NOT_EMPTY()
db.tag.created.requires = IS_NOT_EMPTY()
#Special condition to default to the current user.
if auth.user:
user_id=auth.user.email
else: user_id=0
db.tag.creator.default=user_id
