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.
