При создании записи объявляется ошибка: NOT NULL constraint failed: faq.user_id, но пользователь был объявлен в представлениях

Как видите, form.user = request.user объявляется после p fom.save(commit=false), но ошибка сохраняется. кто-нибудь может мне помочь?

либо с request.user, либо без request.user ошибка сохраняется. помня, что я вошел как администратор, и в /admin функциональность работает правильно, вставка null=True создает запись, но функциональность не верна.

models.py

from django.db import models
from django.utils import timezone
from .. import settings


class Faq(models.Model):

    CAT_FAQ_CHOICES = (
        (0, 'Selecione'),
        (1, 'FAQ Todos'),
        (2, 'FAQ Psicologo'),
        (3, 'FAQ Paciente'),
        (4, 'FAQ Empresa'),
    )

    idfaq = models.AutoField(primary_key=True)
    titulo = models.CharField(
        verbose_name='Titulo da Dúvida', max_length=100, null=False, blank=False)
    descricao = models.TextField(
        verbose_name='Descrição', null=True, blank=True)
    data_cadastro = models.DateTimeField(
        verbose_name='Data de Cadastro', auto_now=True)
    is_active = models.BooleanField('Ativado | Desativado', default=True)
    user = models.ForeignKey(settings.AUTH_USER_MODEL,
                             on_delete=models.CASCADE)
    tipofaq = models.IntegerField(choices=CAT_FAQ_CHOICES,default=0)

    def __str__(self):
        return self.titulo

    class Meta:
        db_table = 'faq'
        verbose_name = 'faq'
        verbose_name_plural = 'faqs'

views.py

@login_required
def criar_faq(request):

    if request.user.is_paciente:
        form = FaqForm(request.POST or None, initial={
                       'user': request.user.paciente, 'tipofaq': 3})

        custom_template_name = 'area_pacientes/base_paciente.html'
        if form.is_valid():
            form = form.save(commit=False)
            form.user = request.user
            form.save()
            return redirect('faq:listar_faq')
        else:
            print(form.errors)
        return render(request, 'area_administrativa/faq/novo-faq.html',
                      {'form': form,
                       'custom_template_name': custom_template_name})

    elif request.user.is_psicologo:
        form = FaqForm(request.POST or None, initial={
                       'user': request.user.psicologo, 'tipofaq': 2})

        custom_template_name = 'area_psicologos/base_psicologo.html'
        if form.is_valid():
            form = form.save(commit=False)
            form.user = request.user
            form.save()
            return redirect('faq:listar_faq')
        else:
            print(form.errors)
        return render(request, 'area_administrativa/faq/novo-faq.html',
                      {'form': form,
                       'custom_template_name': custom_template_name})

    elif request.user.is_company:
        form = FaqForm(request.POST or None, initial={
                       'user': request.user.is_company, 'tipofaq': 4})

        custom_template_name = 'area_empresa/base_empresa.html'
        if form.is_valid():
            form = form.save(commit=False)
            form.user = request.user
            form.save()
            return redirect('faq:listar_faq')
        else:
            print(form.errors)
        return render(request, 'area_administrativa/faq/novo-faq.html',
                      {'form': form,
                       'custom_template_name': custom_template_name})

    else:
        form = FaqForm(request.POST or None, initial={'tipofaq': 1})
        custom_template_name = 'area_administrativa/base_adm.html'

        if form.is_valid():
            form.save()
            return redirect('faq:listar_faq')
        else:
            print(form.errors)
        return render(request, 'area_administrativa/faq/novo-faq.html',
                      {'form': form,
                       'custom_template_name': custom_template_name,
                       })

forms.py

class FaqForm(forms.ModelForm):
     
    class Meta:
        
        model = Faq
        fields = ['titulo', 'descricao','tipofaq']

        widgets = {
            'titulo': forms.TextInput(
                attrs={'class': 'form-control',
                       'placeholder': "Título da Dúvida"}
            ),
            'descricao': forms.Textarea(
                attrs={'class': 'form-control',
                       'placeholder': "Digite seu texto aqui..."}
            ),
            'tipofaq':forms.Select(
                attrs={'class':'form-control'}
            )
        }

Internal Server Error: /faq/novo
Traceback (most recent call last):
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\backends\utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\backends\sqlite3\base.py", line 416, in execute
    return Database.Cursor.execute(self, query, params)
sqlite3.IntegrityError: NOT NULL constraint failed: faq.user_id

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\core\handlers\exception.py", line 47, in inner
    response = get_response(request)
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\core\handlers\base.py", line 181, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\contrib\auth\decorators.py", line 21, in _wrapped_view
    return view_func(request, *args, **kwargs)
  File "D:\terapiadebolso\desenvolvimento\projeto\faq\views.py", line 101, in criar_faq
    form.save()
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\forms\models.py", line 466, in save
    self.instance.save()
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\models\base.py", line 743, in save
    self.save_base(using=using, force_insert=force_insert,
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\models\base.py", line 780, in save_base
    updated = self._save_table(
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\models\base.py", line 885, in _save_table
    results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw)
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\models\base.py", line 923, in _do_insert
    return manager._insert(
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\models\manager.py", line 85, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\models\query.py", line 1301, in _insert
    return query.get_compiler(using=using).execute_sql(returning_fields)
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\models\sql\compiler.py", line 1441, in execute_sql
    cursor.execute(sql, params)
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\backends\utils.py", line 99, in execute
    return super().execute(sql, params)
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\backends\utils.py", line 67, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\backends\utils.py", line 76, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\backends\utils.py", line 80, in _execute
    with self.db.wrap_database_errors:
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\backends\utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "D:\terapiadebolso\desenvolvimento\.venv\lib\site-packages\django\db\backends\sqlite3\base.py", line 416, in execute
adjango.db.utils.IntegrityError: NOT NULL constraint failed: faq.user_id
Вернуться на верх