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 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 django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
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/dce1c0b8-8e3e-4a86-b7f3-f968bd848d8d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
