Django-UNIQUE约束失败:auth_user.username [英] Django - UNIQUE constraint failed: auth_user.username

问题描述

我正在为Django REST Framework应用编写单元测试并使用 factory_boy 创建我的虚假测试数据.运行测试时出现以下错误:

I'm writing unit tests for a Django REST Framework app and using factory_boy to create my fake testing data. I'm getting the following error when I run my test:

File "/usr/local/Cellar/python/2.7.11/Frameworks/Python.framework/Versions/2.7/lib/python2.7/unittest/loader.py", line 254, in _find_tests
  module = self._get_module_from_name(name)
File "/usr/local/Cellar/python/2.7.11/Frameworks/Python.framework/Versions/2.7/lib/python2.7/unittest/loader.py", line 232, in _get_module_from_name
  __import__(name)
File "/Users/thomasheatwole/osf-meetings/meetings/conferences/tests.py", line 27, in <module>
  class SubmissionFactory(factory.DjangoModelFactory):
File "/Users/thomasheatwole/osf-meetings/meetings/conferences/tests.py", line 34, in SubmissionFactory
  username = 'contributor'
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/factory/base.py", line 67, in __call__
  return cls.create(**kwargs)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/factory/base.py", line 594, in create
  return cls._generate(True, attrs)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/factory/base.py", line 519, in _generate
  obj = cls._prepare(create, **attrs)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/factory/base.py", line 494, in _prepare
  return cls._create(model_class, *args, **kwargs)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/factory/django.py", line 181, in _create
  return manager.create(*args, **kwargs)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/db/models/manager.py", line 122, in manager_method
  return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/db/models/query.py", line 401, in create
  obj.save(force_insert=True, using=self.db)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/contrib/auth/base_user.py", line 74, in save
  super(AbstractBaseUser, self).save(*args, **kwargs)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/db/models/base.py", line 708, in save
  force_update=force_update, update_fields=update_fields)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/db/models/base.py", line 736, in save_base
  updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/db/models/base.py", line 820, in _save_table
  result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/db/models/base.py", line 859, in _do_insert
  using=using, raw=raw)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/db/models/manager.py", line 122, in manager_method
  return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/db/models/query.py", line 1039, in _insert
  return query.get_compiler(using=using).execute_sql(return_id)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 1060, in execute_sql
  cursor.execute(sql, params)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
  return self.cursor.execute(sql, params)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/db/utils.py", line 95, in __exit__
  six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
  return self.cursor.execute(sql, params)
File "/Users/thomasheatwole/.virtualenvs/django/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 323, in execute
  return Database.Cursor.execute(self, query, params)
IntegrityError: UNIQUE constraint failed: auth_user.username

不确定是什么意思还是什么原因.这是定义工厂的地方:

Not really sure what it means or what's causing it. Here's where the factory is defined:

class UserFactory(factory.DjangoModelFactory):
    class Meta: 
        model = User

在这里创建实例:

contributor = UserFactory(
    username = 'contributor'
    )

这是完整文件:测试.py

让我知道是否有简单的解决方法. 谢谢！

Let me know if there's an easy fix. Thanks!

推荐答案

原来我两次给工厂打电话，所以两个用户都得到了username = 'contributor'.简单的解决方法是不在工厂内部定义用户名，而是在致电工厂时进行定义.

Turns out I was calling the factory twice so both Users were getting username = 'contributor'. Simple fix is to not define the username inside the factory but to define it when you call the factory.

这篇关于Django-UNIQUE约束失败:auth_user.username的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！