I am not sure if I understand your model. Can you explain "tag_link" ?
Marin On Thu, May 17, 2012 at 6:28 PM, Jason Brower <[email protected]> wrote: > I have the event management tool I have been working on for 2 years now > and I have made some changes to the code that require my most complicated > query to be rebuilt. > After thinking about it for several hours I figure I should throw it at > you guys to see what you can come up with. > The winner of this query will get 75€ with paypal or other means after I > have it implemented it in the code. > I have the following model: > model_diagram.png > event_attender.py > tag.py > tag_link.py > Description: > I am building a list of connections based on relevance by tag. > Tags have two states, looking for and attribute. > Users attach themselves to these tags with the two attributes. > "I am looking for someone with this tag." > and/or > "This tag is something about me that I want to offer." > > Now when they do this a list of users will show on the screen. > ID Nickname Tags your looking for that they have Your Relevance > Tags they are looking for that you have Their Relevance Total Relevance > Image city 101 encompass Tag1, Tag2, Tag4 3 Tag4, Tag5, Tag 6 3 10 > http://.... Oulu 102 encompass Tag1, Tag2, Tag4 3 Tag4, Tag 6 3 8 > http://.... Oulu 150 encompass Tag1, Tag2, Tag4 3 Tag 6 3 7 > http://.... Helsinki > This is build with the following: > UserA is the user logged in using the system > If another user has a tag that UserA is looking for, then relevance is +2 > to UserA > If another user is looking for something UserA has, then relevance is +1 > to UserA > If another user lives in the same city as UserA and has something they are > looking for or something to offer then relevance is +1 > Does this make sense? I just need to query that will happen. I can handle > the view just fine. Feel free to comment or ask questions. > If you can think of a good way to connect people better with the data in > the model diagram attached do tell. I will give you another 25€ for that > implementation as well. :) > --- > BR, > Jason Brower >
