Re: Can't figure out how to obtain organized list of my friends
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.
Re: Can't figure out how to obtain organized list of my friends
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 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.
Re: Can't figure out how to obtain organized list of my friends
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.
