I don't think it did.
I am looking for something like this...
Name1:
- Tag1
- Tag2
- Tag3
- Tag4
- Tag5
Name2:
- Tag3
- Tag4
- Tag5
- Tag6
- Tag7
Name3:
- Tag5
- Tag7
- Tag8
- Tag9
- Tag0
Or vice versa...
I kind of have it with this method...
-----
@auth.requires_login()
def status():
response.title = "Your Profile Page"
current_user_id=auth.user.id
tags = db((db.users.id==db.user_tags.user_id)
&(db.user_tags.tag_id==db.tag.id)
&(db.user_tags.tag_id.belongs(
db(db.user_tags.user_id==current_user_id)._select(
db.user_tags.tag_id)))).select(
db.users.ALL,db.tag.ALL,groupby=db.users.id)
allTags = db().select(db.tag.ALL,orderby=db.tag.name)
relatedTags = {}
tagID = {}
for tag in tags:
if not tag.users.id == auth.user.id:
if relatedTags.has_key(tag.tag.id):
relatedTags[tag.tag.id].append(db(db.users.id==tag.users.id).select()[0])
else:
relatedTags[tag.tag.id] =
[db(db.users.id==tag.users.id).select()[0]]
tagID[tag.tag.id] = db(db.tag.id==tag.tag.id).select()[0]
return dict(tags= tags, user = auth.user, allTags = allTags,
relatedTags = relatedTags, tagID = tagID)
-----
This creates tags with User names listed inside, but I think the idea
is very similar.
On Sun, Jun 7, 2009 at 1:09 AM, mdipierro<mdipie...@cs.depaul.edu> wrote:
>
> This should do it.
>
> current_user_id=...
> db((db.users.id==db.user_tags.user_id)&(db.user_tags.tag_id==db.tag.id)
> &(db.user_tags.tag_id.belongs(db
> (db.user_tags.user_id==current_user_id)._select
> (db.user_tags.tag_id)))).select
> (db.users.ALL,db.tag.ALL,groupby=db.users.id)
>
> Massimo
>
> On Jun 6, 2:54 pm, Jason Brower <encomp...@gmail.com> wrote:
>> 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
-~----------~----~----~----~------~----~------~--~---
