I have a big fat book on SQL syntax. But I am hoping on using Web2Py's
python syntax.
I want to make it so my users that have tags that are the same can be
listed with the tag is the same between them. The user I am looking up
is the logged in user, I am using the auth feature.
Soo I have tag "One" and Billy has tag "One" so I want to be able to
see that user "billy" has the tag "One" that I do.
Hope that explains it.
I have the following relevent tables...
------
db.define_table('users',
SQLField('first_name', 'string', length=15),
SQLField('last_name', 'string', length=15),
SQLField('phone_number', 'string', length=15),
SQLField('email', 'string'),
SQLField('password', 'password'),
SQLField('university_affiliation', 'string', length=25),
SQLField('created', 'datetime', default=now, readable=False,
writable=False),
SQLField('registration_key', length=128, writable=False,
readable=False, default=''),
SQLField('avatar', 'upload'),
SQLField('short_description','text'))
db.define_table('tag',
SQLField('name', 'string'),
SQLField('description', 'text'),
SQLField('logo', 'upload'),
SQLField('created', 'date', default=now, writable=False),
SQLField('creator', 'string', writable=False))
db.define_table('user_tags',
SQLField('tag_id',db.tag),
SQLField('user_id',db.users))
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.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()
----
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
