Thanks Dan, I'll give it a shot On Jun 8, 6:00 pm, Dan Harris <[email protected]> wrote: > Perhaps not the greatest way of doing things, but simple to code/read: > > class Candidate(models.Model): > first_name = models.CharField(max_length=30) > last_name = models.CharField(max_length=30) > incumbent = models.BooleanField() > > class HoldsOffice(models.Model): > first_name = models.CharField(max_length=30) > last_name = models.CharField(max_length=30) > > for officer in HoldsOffice.objects.all(): > candidates = > Candidate.objects.filter(first_name__iequals=officer.first_name).filter(last_name__iequals=officer.last_name) > > if len(candidates)>0: > raise Exception("More than 1 match found") > candidates[0].incumbent = True > candidates[0].save() > > Something like that might work for you assuming that the models and > stuff are similar. Also, this code is just off the top of my head, so > who knows if it will actually work :) > > Cheers, > > Dan Harris > [email protected] > > On Jun 8, 6:30 pm, Nick <[email protected]> wrote: > > > I have two models. One is a list of candidates that have filed to run > > for office. The second is a list of people who currently hold > > office. > > > I'd like to compare the two tables and whenever a match is found > > between the two (an entry in the candidate table shares the same > > last_name and first_name with an office holder from the holds office > > table) I'd like to check off a box in the Candidate table called > > 'incumbent'. > > > how would I begin to do this. They both have columns called last_name > > and first_name that I can use to compare but I don't know the syntax.
-- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
