Thank you guys SO MUCH! I'm not only a new learning of Django, but of Python and programming in general. Only con to being self taught is that you learn these things as you go!
Thank you for gearing me in the right direction, and so quickly! After some homework and deciding how to alter my existing models/friends-app, it seemed wise to instead incorporate this little guy: https://github.com/coleifer/django-relationships. On Tuesday, July 3, 2012 3:53:44 AM UTC-4, Jon Black wrote: > > I agree with Kenneth. Your models seem odd. Why not use a > ManyToManyField? The django docs even provides quite a nice example > (see: > > https://docs.djangoproject.com/en/dev/ref/models/fields/#django.db.models.ManyToManyField.symmetrical): > > > > class Person(models.Model): > friends = models.ManyToManyField("self") > > You could adapt this to your UserProfile I suppose. > > -- > Jon Black > www.jonblack.org > > > On Tue, Jul 3, 2012, at 12:57, kenneth gonsalves wrote: > > On Mon, 2012-07-02 at 20:31 -0700, Keith D. Cardin wrote: > > > I'm trying to create a "my friends" page, which will list the user's > > > friends listed in alphabetical order. > > > I have two classes involved with this data: Profile [and] Friendship > > > > > > *class Friendship(models.Model):* > > > friend = models.ForeignKey(User, > > > related_name='friend1') > > > friendwith = models.ForeignKey(User, > > > related_name='friend2') > > > > > > *class Profile(models.Model):* > > > user = models.OneToOneField(User, > > > unique=True, > > > verbose_name=_('user'), > > > related_name='profile') > > > first_name = models.TextField(max_length=50) > > > last_name = models.TextField(max_length=50) > > > > > > The exact raw SQL query [successfully tested] is as follows:: > > > *select profiles_profile.first_name,profiles_profile.last_name FROM > > > profiles_profile, friends_friendship WHERE profiles_profile.user_id = > > > friends_friendship.friendwith_id AND friends_friendship.friend_id = > > > 30 > > > ORDER BY first_name ASC;* > > > * > > > * > > > My problem is I'm not sure how to do this in Python. > > > '30' is the user's id/pk. > > > > to get a list of friends of a particular user this may work: > > > > first get the user: > > me = Profile.objects.get(user = myuser) > > > > then get the friend1 > > friends = me.fiiend1_set.all() > > > > the confusing thing about your models is that it seems to me that your > > Friendship model should be split into two models. > > -- > > regards > > Kenneth Gonsalves > > > > -- > > You received this message because you are subscribed to the Google > Groups > > "Django users" group. > > To post to this group, send email to django-users@googlegroups.com. > > To unsubscribe from this group, send email to > > django-users+unsubscr...@googlegroups.com. > > For more options, visit this group at > > http://groups.google.com/group/django-users?hl=en. > > > -- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/Q9Qt4CXwNkcJ. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
