On Sun, 12 Oct 2014 22:01:51 -0700 (PDT)
dk <[email protected]> wrote:
> I have this 2 models
>
> class Choice(models.Model):
> restaurant = models.ForeignKey(Restaurant)
> person = models.ForeignKey(Person)
> date = models.DateField("time published")
> time = models.TimeField("date published")
>
> class Person(models.Model):
> name = models.CharField(max_length=100)
> last_name = models.CharField(max_length=100)
> email = models.EmailField()
>
> and I would like to be able to see check if in a certain date, a certain
> person does exist in the record.
> I am currently querying the date first.
>
> date_query = Choice.objects.filter(date=dater)
> for i in date_query:
> if i.person_id == to_email_i_am_looking:
>
> might be another way to chain the querys?
> kinda
>
> SELECT person FROM choice JOIN people
> ON choice.person_ID=person+ID;
> WHERE date= today and person=someone
> ?
>
> I read about select_related that use the ForeignKey, but I have 2 in my
> case, the person and the restaurant, does it loop on bouth?
You can leverage reverse relation managers rather easily:
If you do have a person available already you can do the following:
choices_for_person_on_date = person.choice_set.filter(date=dater)
--
Jani Tiainen
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/20141013141555.422f4b4a%40jns42-l.w2k.keypro.fi.
For more options, visit https://groups.google.com/d/optout.
