TestCase中缺少ROLLBACK在多db django应用程序中导致独特的违反违规行为 [英] Lack of ROLLBACK within TestCase causes unique contraint violation in multi-db django app
问题描述
我刚刚开始使用测试工厂的 factory_boy django库,并发出问题重复键限制违规。
I'm just getting started with the factory_boy django library for test factories, and having an issue with a duplicate key constraint violation.
from datetime import date, timedelta
from django.test import TestCase
from app.test.factories import MemberFactory, ProgrammeFactory
from app.models.member_programme import MemberProgramme
class MemberProgrammeTestCase(TestCase):
def member_programme(self):
yesterday = date.today() - timedelta(days=1)
return MemberProgramme.objects.create(
mem=MemberFactory(),
prg=ProgrammeFactory(),
date_registered=yesterday)
def date_registered_should_be_defined_test(self):
# This test passes
memprg = self.member_programme()
assert hasattr(memprg, 'date_registered')
def date_registered_should_be_in_past_test(self):
# This test fails
memprg = self.member_programme()
assert memprg.date_registered < date.today()
factories.py
factories.py
class CountryOfOriginFactory(factory.Factory):
""" Factory class for app.models.CountryOfOrigin
"""
FACTORY_FOR = CountryOfOrigin
code = 'UK'
the_country = 'United Kingdom'
class MemberFactory(factory.Factory):
""" Factory class for app.models.Member
"""
FACTORY_FOR = Member
first_name = 'Test'
surname = 'User'
sex = 'M'
date_of_birth = datetime.date(1990, 1, 1)
origin = factory.LazyAttribute(lambda a: CountryOfOriginFactory())
运行第一个测试成功通过,但第二个失败,出现以下错误:
When running the first test passes successfully, but the second fails with the following error:
IntegrityError: duplicate key value violates unique constraint "country_of_origin_code_key"
我的理解是每个TestCase都应该在一个事务中运行,但在第二个测试运行之前,外键的创建似乎没有回滚。显然我在做一些从根本上错误的事情,但是我有点困惑!谢谢!
My understanding is that every TestCase should run within a transaction, yet the creation of the foreign key does not appear to have rolled back before the second test runs. Clearly I'm doing something fundamentally wrong, but I'm a bit stumped! Thanks!
我已经跟踪了问题,但不幸的是不知道如何解决它。问题是ROLLBACKs 发生,但仅在一个数据库(此应用程序有2个数据库)。由于遗留原因,我们有一个单独的数据库,用于django auth,flatpages等,另一个数据库用于我们的应用程序。
I've tracked down the problem, but unfortunately don't know how to resolve it. The issue is that ROLLBACKs are occurring, but only on one database (this app has 2 databases). For legacy reasons, we have a separate database for django auth, flatpages etc and another db for our app.
dba test_app 127.0.0.1 2012-09-04 21:51:50.806 UTC LOG: duration: 0.038 ms statement: BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED
dba test_app 127.0.0.1 2012-09-04 21:51:50.808 UTC LOG: duration: 0.903 ms statement: INSERT INTO "member_programme" ("mem_id", "prgm_id", "date_registered", "date_completed", "ordinality") VALUES (1, 1, E'2012-09-04', NULL, 1)
dba test_app 127.0.0.1 2012-09-04 21:51:50.808 UTC LOG: duration: 0.150 ms statement: SELECT CURRVAL(pg_get_serial_sequence('"member_programme"','id'))
dba test_app 127.0.0.1 2012-09-04 21:51:50.810 UTC LOG: duration: 1.796 ms statement: COMMIT
dba test_app_django 127.0.0.1 2012-09-04 21:51:50.811 UTC LOG: duration: 0.056 ms statement: ROLLBACK <---- ROLLBACK ON DJANGO DB ONLY
dba test_app_django 127.0.0.1 2012-09-04 21:51:50.814 UTC LOG: disconnection: session time: 0:00:21.005 user=dba database=test_app_django host=127.0.0.1 port=60355
dba test_app 127.0.0.1 2012-09-04 21:51:50.818 UTC LOG: disconnection: session time: 0:00:04.751 user=dba database=test_app host=127.0.0.1 port=60357
dba test_app 127.0.0.1 2012-09-04 21:54:00.796 UTC LOG: connection authorized: user=dba database=test_app
dba test_app 127.0.0.1 2012-09-04 21:54:00.802 UTC LOG: duration: 0.243 ms statement: SET DATESTYLE TO 'ISO'
dba test_app 127.0.0.1 2012-09-04 21:54:00.802 UTC LOG: duration: 0.156 ms statement: SHOW client_encoding
dba test_app 127.0.0.1 2012-09-04 21:54:00.803 UTC LOG: duration: 0.047 ms statement: SHOW default_transaction_isolation
dba test_app 127.0.0.1 2012-09-04 21:54:00.803 UTC LOG: duration: 0.068 ms statement: BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED
dba test_app 127.0.0.1 2012-09-04 21:54:00.804 UTC LOG: duration: 0.410 ms statement: SET TIME ZONE E'Pacific/Auckland'
dba test_app 127.0.0.1 2012-09-04 21:54:00.805 UTC ERROR: duplicate key value violates unique constraint "country_of_origin_code_key"
有类似问题的人这里。
推荐答案
Django 有有支持针对多个数据库进行测试自1.2!
Django has had support for testing against multiple databases since 1.2!
将以下属性添加到我的TestCase解决了问题:
Adding the following property to my TestCase resolved the issue:
multi_db = True
这篇关于TestCase中缺少ROLLBACK在多db django应用程序中导致独特的违反违规行为的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!