完整性错误不能为空

Question

我正在建立一个类似于易货网站的网站，但我们是以物易物的时间，我有一个类交易，在那里它采取“优惠”的价值，从请求用户的余额中扣除该价值，并将价值贷记到优惠‘r。

现在，当我从我的模板中点击"Accept Offer“时，我得到了这个错误

ofertoj_transaction.accepted_by may not be NULL

堆栈跟踪：

IntegrityError at /oferto/accept/

环境：

Request Method: GET
Request URL: http://127.0.0.1:8000/oferto/accept/?offer_id=1&creator=2

Django Version: 1.5.4
Python Version: 2.7.4
Installed Applications:
('django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'django.contrib.admin',
 'django.contrib.admindocs',
 'django.contrib.comments',
 'django.contrib.sitemaps',
 'zinnia',
 'tagging',
 'mptt',
 'south',
 'registration',
 'blogs',
 'turtle',
 'ofertoj',
 'petoj',
 'x',
 'profiles')
Installed Middleware:
('django.middleware.common.CommonMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware')


Traceback:
File "/home/talisman/virt_env/tempilo/local/lib/python2.7/site-packages/Django-1.5.4-py2.7.egg/django/core/handlers/base.py" in get_response
  115.                         response = callback(request, *callback_args, **callback_kwargs)
File "/home/talisman/virt_env/tempilo/local/lib/python2.7/site-packages/Django-1.5.4-py2.7.egg/django/views/generic/base.py" in view
  68.             return self.dispatch(request, *args, **kwargs)
File "/home/talisman/virt_env/tempilo/local/lib/python2.7/site-packages/Django-1.5.4-py2.7.egg/django/views/generic/base.py" in dispatch
  86.         return handler(request, *args, **kwargs)
File "/home/talisman/projects/tempilo/ofertoj/views.py" in get
  74.                   accepted_by=self.request.user.id
File "/home/talisman/projects/tempilo/ofertoj/models.py" in create
  59.       new_transaction.save()
File "/home/talisman/virt_env/tempilo/local/lib/python2.7/site-packages/Django-1.5.4-py2.7.egg/django/db/models/base.py" in save
  546.                        force_update=force_update, update_fields=update_fields)
File "/home/talisman/virt_env/tempilo/local/lib/python2.7/site-packages/Django-1.5.4-py2.7.egg/django/db/models/base.py" in save_base
  650.                 result = manager._insert([self], fields=fields, return_id=update_pk, using=using, raw=raw)
File "/home/talisman/virt_env/tempilo/local/lib/python2.7/site-packages/Django-1.5.4-py2.7.egg/django/db/models/manager.py" in _insert
  215.         return insert_query(self.model, objs, fields, **kwargs)
File "/home/talisman/virt_env/tempilo/local/lib/python2.7/site-packages/Django-1.5.4-py2.7.egg/django/db/models/query.py" in insert_query
  1675.     return query.get_compiler(using=using).execute_sql(return_id)
File "/home/talisman/virt_env/tempilo/local/lib/python2.7/site-packages/Django-1.5.4-py2.7.egg/django/db/models/sql/compiler.py" in execute_sql
  937.             cursor.execute(sql, params)
File "/home/talisman/virt_env/tempilo/local/lib/python2.7/site-packages/Django-1.5.4-py2.7.egg/django/db/backends/util.py" in execute
  41.             return self.cursor.execute(sql, params)
File "/home/talisman/virt_env/tempilo/local/lib/python2.7/site-packages/Django-1.5.4-py2.7.egg/django/db/backends/sqlite3/base.py" in execute
  364.             six.reraise(utils.IntegrityError, utils.IntegrityError(*tuple(e.args)), sys.exc_info()[2])
File "/home/talisman/virt_env/tempilo/local/lib/python2.7/site-packages/Django-1.5.4-py2.7.egg/django/db/backends/sqlite3/base.py" in execute
  362.             return Database.Cursor.execute(self, query, params)

Exception Type: IntegrityError at /oferto/accept/
Exception Value: ofertoj_transaction.accepted_by may not be NULL

ofertoj.views.py的一部分

class TransactionView(TemplateView, LoginRequiredMixin):
    template_name = "ofertoj/offer_accepted.html"

    def get(self, request, *args, **kwargs):
        context = self.get_context_data(**kwargs)
        if self.request.GET.get("offer_id"):
            oferto = Oferto.objects.get(id=self.request.GET.get("offer_id"))
            if oferto.valid:
                transaction = Transaction()
                transaction.create(
                    creator=self.request.GET.get("creator"),
                    amount=oferto.time,
                    accepted_by=self.request.user.id
                )
                acceptor = Profile.objects.get(user=self.request.user)
                acceptor.balance = acceptor.balance - oferto.time
                acceptor.save()

                # credit the coins to the creator
                creator = Profile.objects.get(user=oferto.user)
                creator.balance = creator.balance + oferto.time
                creator.save()
            else:
                return HttpResponse("This offer is already accepted")
        else:
            raise Http404

        return self.render_to_response(context)

Ofertoj.models的一部分

class Transaction(models.Model):
    creator = models.IntegerField()
    amount = models.IntegerField()
    accepted_by = models.IntegerField()

    def __unicode__(self):
        return self.id

    def create(self, **kwargs):
        new_transaction = Transaction(
                creator = kwargs['creator'],
                amount = kwargs['amount'],
                accepted_by = kwargs['accepted_by']
            )
        new_transaction.save()
        return

此行在堆栈跟踪中高亮显示

acceptor = Profile.objects.get(user=self.request.user)

ofertoj.urls

url(
    regex=r"^accept/$",
    view = TransactionView.as_view(),
    name = "accept_offer"
    ),

我模板的一部分

{% if oferto.valid and not oferto.user == request.user %}
<a href="{% url "accept_offer" %}?offer_id={{ oferto.id }}&creator={{ oferto.user.id }}">Accept this Offer</a>
{% endif %}

<br /><br />

Answer 1

您的ofertoj应用程序正在尝试存储一个Transaction对象，该对象的accepted_by字段为NULL，但是您的数据库架构不允许该字段为NULL。

检查以下代码：

transaction.create(
                creator=self.request.GET.get("creator"),
                amount=oferto.time,
                accepted_by=self.request.user.id
            )

以及transaction.create的代码。

一种可能性是:如果您的用户未登录，则self.request.user.id将为None，这在数据库中转换为NULL。我在您的代码中看不到任何需要用户登录的内容。

Answer 2

由于配置文件模型中的unicode方法存在问题，因此余额默认为空