I am new to Django facing this error while saving data into DB:
"ValueError at /breedingRecApp/pairing
Cannot assign "<SpeciesDetail: Black Mask Yellow Chest>": "Pair.male_mutation" must be a "Mutation" instance."
I've 4 foreign keys in Pair model each with specific reason/purposes. when I save data then error come.
in the same error page Form Valid is TRUE and Data What I want is also exactly the same. I don't know why data is not saving in DB.
Note: When I insert the same data from Admin interface it get save without any error it also get updated and delete as well from admin interface.
following are models:
models.py
class Mutation(models.Model):
species = models.ForeignKey(Species, on_delete=models.CASCADE)
name = models.CharField(max_length=120, blank=False, null=False)
description = models.TextField(max_length=300, blank=False, null=False)
class Meta:
verbose_name_plural = "Mutations"
ordering = ('name',)
def __str__(self):
return self.name
def get_absolute_url_delete(self):
return reverse("breedingRecApp:delete_mutation", kwargs={"mutation_id": self.pk})
class SpeciesDetail(models.Model):
GENDER_CHOICES = (
('M', 'Male'),
('F', 'Female'),
)
species = models.ForeignKey(Species, on_delete=models.CASCADE)
mutation = models.ForeignKey(Mutation, on_delete=models.CASCADE)
fatherName = models.CharField(max_length=120)
motherName = models.CharField(max_length=120)
birdBandNo = models.IntegerField()
cageNo = models.IntegerField()
picture = models.ImageField(upload_to='pics')
gender = models.CharField(max_length=1, choices=GENDER_CHOICES)
health = models.CharField(max_length=120)
breedingHistory = models.TextField(max_length=300)
age = models.IntegerField()
dateAcquired = models.DateTimeField(auto_now_add=False, auto_now=True)
class Meta:
verbose_name_plural = "Species Detail"
ordering = ('species', )
def __str__(self):
return str(self.mutation)
class Pair(models.Model):
species = models.ForeignKey(Species, on_delete=models.CASCADE)
male_mutation = models.ForeignKey(Mutation, on_delete=models.CASCADE, related_name='male_mutation')
male = models.ForeignKey(SpeciesDetail, on_delete=models.CASCADE, related_name='male')
female_mutation = models.ForeignKey(Mutation, on_delete=models.CASCADE, related_name='female_mutation')
female = models.ForeignKey(SpeciesDetail, on_delete=models.CASCADE, related_name='female')
boxNo = models.IntegerField()
cageNo = models.IntegerField()
dateTimeStamp = models.DateTimeField(auto_now_add=True, auto_now=False)
description = models.TextField(max_length=300)
class Meta:
verbose_name_plural = "Pairs"
def __str__(self):
return str(self.male) + ',' + str(self.female)
views.py
def pairing(request):
if request.method == "POST":
form = Pair_ModelForm(request.POST or None)
if form.is_valid():
try:
form.save()
return redirect('breedingRecApp:pairs')
except:
pass
else:
form = Pair_ModelForm()
context = {'title': 'Pairing',
'active': 'active',
'model': Pair,
'form': form,
}
return render(request, 'breedingRecApp/pairing.html', context)
def load_mutations(request):
species_id = request.GET.get('species')
specific_mutations = Mutation.objects.filter(species_id=species_id).order_by('name')
return render(request, 'breedingRecApp/mutations_dropdown_list_options.html', {'mutations': specific_mutations})
def load_males(request):
mutation_id = request.GET.get('mutation')
print(mutation_id)
males = SpeciesDetail.objects.filter(mutation_id=mutation_id).filter(gender='M').order_by('id')
print('Male Detail', males)
return render(request, 'breedingRecApp/males_dropdown_list_options.html', {'males': males})
def load_females(request):
mutation_id = request.GET.get('mutation')
print(mutation_id)
females = SpeciesDetail.objects.filter(mutation_id=mutation_id).filter(gender='F').order_by('id')
print(females)
return render(request, 'breedingRecApp/females_dropdown_list_options.html', {'females': females})
-- "ValueError at /breedingRecApp/pairing
Cannot assign "<SpeciesDetail: Black Mask Yellow Chest>": "Pair.male_mutation" must be a "Mutation" instance."
I've 4 foreign keys in Pair model each with specific reason/purposes. when I save data then error come.
in the same error page Form Valid is TRUE and Data What I want is also exactly the same. I don't know why data is not saving in DB.
Note: When I insert the same data from Admin interface it get save without any error it also get updated and delete as well from admin interface.
following are models:
models.py
class Mutation(models.Model):
species = models.ForeignKey(Species, on_delete=models.CASCADE)
name = models.CharField(max_length=120, blank=False, null=False)
description = models.TextField(max_length=300, blank=False, null=False)
class Meta:
verbose_name_plural = "Mutations"
ordering = ('name',)
def __str__(self):
return self.name
def get_absolute_url_delete(self):
return reverse("breedingRecApp:delete_mutation", kwargs={"mutation_id": self.pk})
class SpeciesDetail(models.Model):
GENDER_CHOICES = (
('M', 'Male'),
('F', 'Female'),
)
species = models.ForeignKey(Species, on_delete=models.CASCADE)
mutation = models.ForeignKey(Mutation, on_delete=models.CASCADE)
fatherName = models.CharField(max_length=120)
motherName = models.CharField(max_length=120)
birdBandNo = models.IntegerField()
cageNo = models.IntegerField()
picture = models.ImageField(upload_to='pics')
gender = models.CharField(max_length=1, choices=GENDER_CHOICES)
health = models.CharField(max_length=120)
breedingHistory = models.TextField(max_length=300)
age = models.IntegerField()
dateAcquired = models.DateTimeField(auto_now_add=False, auto_now=True)
class Meta:
verbose_name_plural = "Species Detail"
ordering = ('species', )
def __str__(self):
return str(self.mutation)
class Pair(models.Model):
species = models.ForeignKey(Species, on_delete=models.CASCADE)
male_mutation = models.ForeignKey(Mutation, on_delete=models.CASCADE, related_name='male_mutation')
male = models.ForeignKey(SpeciesDetail, on_delete=models.CASCADE, related_name='male')
female_mutation = models.ForeignKey(Mutation, on_delete=models.CASCADE, related_name='female_mutation')
female = models.ForeignKey(SpeciesDetail, on_delete=models.CASCADE, related_name='female')
boxNo = models.IntegerField()
cageNo = models.IntegerField()
dateTimeStamp = models.DateTimeField(auto_now_add=True, auto_now=False)
description = models.TextField(max_length=300)
class Meta:
verbose_name_plural = "Pairs"
def __str__(self):
return str(self.male) + ',' + str(self.female)
views.py
def pairing(request):
if request.method == "POST":
form = Pair_ModelForm(request.POST or None)
if form.is_valid():
try:
form.save()
return redirect('breedingRecApp:pairs')
except:
pass
else:
form = Pair_ModelForm()
context = {'title': 'Pairing',
'active': 'active',
'model': Pair,
'form': form,
}
return render(request, 'breedingRecApp/pairing.html', context)
def load_mutations(request):
species_id = request.GET.get('species')
specific_mutations = Mutation.objects.filter(species_id=species_id).order_by('name')
return render(request, 'breedingRecApp/mutations_dropdown_list_options.html', {'mutations': specific_mutations})
def load_males(request):
mutation_id = request.GET.get('mutation')
print(mutation_id)
males = SpeciesDetail.objects.filter(mutation_id=mutation_id).filter(gender='M').order_by('id')
print('Male Detail', males)
return render(request, 'breedingRecApp/males_dropdown_list_options.html', {'males': males})
def load_females(request):
mutation_id = request.GET.get('mutation')
print(mutation_id)
females = SpeciesDetail.objects.filter(mutation_id=mutation_id).filter(gender='F').order_by('id')
print(females)
return render(request, 'breedingRecApp/females_dropdown_list_options.html', {'females': females})
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/a68b1659-d34b-4aaa-bfdb-0d2c6bfa30c9%40googlegroups.com.
No comments:
Post a Comment