Good morning my friends.
Before sending this doubt I searched a lot in the forums of life!
I have the following code that does bulk inclusion:
def seach_create(request):
template_name = 'seach_create.html'
if request.method == 'POST':
form = SearchForm(request.POST)
if form.is_valid():
data = dict(
search_key=form.cleaned_data['search_key'],
person=form.cleaned_data['person'],
researched=form.cleaned_data['researched'],
questions=Question.objects.all(),
)
#criar_pesquisa(**data)
addQuestions(**data)
# Não usar o método save().
# form.save()
return redirect('core:seach_create')
else:
form = SearchForm()
context = {'form': form}
return render(request, template_name, context)
def addQuestions(**data):
#person = Person.objects.get(pk=1)
questions = Search.objects.all()
for question in questions:
try:
Search.objects.get(
search_key=data['search_key'],
person=data['person'],
researched=data['researched'],
question=question
)
print('existe')
except Search.DoesNotExist:
for question in questions:
Search.objects.get_or_create(
search_key=data['search_key'],
person=data['person'],
researched=data['researched'],
question=question
)
print('Não existe')
return HttpResponseRedirect('/')
The problem is precisely this, if the registry already exists it should
ignore or edit the existing data, however I'm getting the error mentioned
in this post.
Where can I fix this problem?
Below I will put the models used in this project:
class Person(models.Model):
cdalterdata = models.IntegerField('Cód. Alterdata', db_index=True)
name = models.CharField('Nome', max_length=100)
#email = models.EmailField(null=True, blank=True)
phone = models.CharField('Telefone', max_length=11, null=True, blank=True)
class Meta:
ordering = ('name',)
verbose_name = 'Pessoa'
verbose_name_plural = 'Pessoas'
def __str__(self):
return self.name
def to_dict_json(self):
return {
'cdalterdata': self.cdalterdata,
'name': self.name,
'email': self.email,
'phone': self.phone,
# 'gender': self.get_gender_display(),
}
# def get_absolute_url(self):
# return reverse('pesquisa_alter:add_pesquisa', args=[str(self.id)])
class Client(Person):
last_search = models.CharField('Última pesquisa.', max_length=11,
null=True, blank=True)
created_on = models.DateField(
'Criado em.',
auto_now_add=True,
auto_now=False
)
class Meta:
ordering = ('name',)
verbose_name = 'Cliente'
verbose_name_plural = 'Clientes'
def get_absolute_url(self):
return reverse('person_client_detail', args=[str(self.pk)])
class Question(models.Model):
LEVEL_CHOICES = (
('0', 'Indefinido'),
('1', 'Dependencia'),
('2', 'Confianca'),
('3', 'Comprometimento'),
('4', 'Preditiva'),
)
question = models.CharField('Pergunta', max_length=200)
level = models.CharField('Nível', max_length=15,
choices=LEVEL_CHOICES, default='0')
class Meta:
verbose_name = 'Questão'
verbose_name_plural = 'Questões'
ordering = ('-level',)
def __str__(self):
return self.question
class SearchManager(models.Manager):
def add_question(self, search_key, person, researched, question):
search, created = self.get_or_create(
search_key=search_key, person=person, researched=researched,
question=question)
if not created:
search.search_key = search.search_key
search.person = search.person
search.question = search.question
search.researched = search.researched
search.save()
return search
class Search(models.Model):
RESPONSE_CHOICES = (
('V', 'Verdadeiro'),
('F', 'Falso'),
('I', 'Indefinido'),
)
search_key = models.CharField(
'Chave da pesquisa', max_length=200, db_index=False)
person = models.ForeignKey(
'core.client', related_name='Cliente', on_delete=models.CASCADE)
researched = models.CharField('Entrevistado', max_length=200)
question = models.ForeignKey(
'core.question', related_name='Pergunta', on_delete=models.CASCADE,)
response = models.CharField(
'Resposta', max_length=1, choices=RESPONSE_CHOICES, default='I')
participation_on = models.DateField(
'período da pesquisa',
auto_now_add=True,
auto_now=False
)
created_on = models.DateTimeField(
'solicitado em',
auto_now_add=True,
auto_now=False
)
#objects = SearchManager()
class Meta:
verbose_name = 'Pesquisa'
verbose_name_plural = 'Pesquisas'
unique_together = (('search_key', 'person', 'question'),)
ordering = ('-participation_on',)
def __str__(self):
return self.question.question
--
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 https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/92b6809a-3bd1-40db-aecd-87cadf077bb5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
