python – Django测试 – 南迁移报告’没有这样的表’,但我可以

使用内存数据库在源上运行django测试很好,但我也尝试使用PhantomCSS(PhantomJS)执行测试以执行CSS回归测试.

为此,我有一个LiveServerTestCase(source)的子类.我正在使用磁盘上的sqlite数据库运行Django测试,在启动自定义服务器进程时通过调用loaddata来加载fixture(请参阅最后的服务器函数).

它的测试看起来像这样;

class PhantomTestBackupRestore(PhantomTestCase):

    fixtures = ['basic_db.json',]

    def test_backup(self):
        self.assertTrue(
            self.phantom(RUNNER_PATH,screenID='lupyvAQL',host='http://127.0.0.1',port=buildconstants.PRODUCT_LISTENPORT)
        )

我用以下命令创建的0??7001(这昨天加载所以似乎是loaddata的一个气质问题);

manage.py dumpdata -n --indent 4 --exclude=contenttypes --exclude=auth --format=json > phantom/fixtures/basic_db.json

我得到以下stacktrace;

[exec] Traceback (most recent call last):
 [exec]   File "C:Python27libmultiprocessingprocess.py",line 258,in _bootstrap
 [exec]     self.run()
 [exec]   File "C:Python27libmultiprocessingprocess.py",line 114,in run
 [exec]     self._target(*self._args,**self._kwargs)
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjango_offlinestartuphelpers.py",line 124,in django_server_helper
 [exec]     *fixture_list
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangocoremanagementbase.py",line 283,in execute
 [exec]     output = self.handle(*args,**options)
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangocoremanagementcommandsloaddata.py",line 55,in handle
 [exec]     self.loaddata(fixture_labels)
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangocoremanagementcommandsloaddata.py",line 84,in loaddata
 [exec]     self.load_label(fixture_label)
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangocoremanagementcommandsloaddata.py",line 140,in load_label
 [exec]     obj.save(using=self.using)
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangocoreserializersbase.py",line 164,in save
 [exec]     models.Model.save_base(self.object,using=using,raw=True)
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangodbmodelsbase.py",line 578,in save_base
 [exec]     updated = self._save_table(raw,cls,force_insert,force_update,using,update_fields)
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangodbmodelsbase.py",line 638,in _save_table
 [exec]     updated = self._do_update(base_qs,pk_val,values,line 676,in _do_update
 [exec]     return base_qs.filter(pk=pk_val)._update(values) > 0
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangodbmodelsquery.py",line 509,in _update
 [exec]     return query.get_compiler(self.db).execute_sql(None)
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangodbmodelssqlcompiler.py",line 971,in execute_sql
 [exec]     cursor = super(SQLUpdateCompiler,self).execute_sql(result_type)

 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangodbmodelssqlcompiler.py",line 777,in execute_sql
 [exec]     cursor.execute(sql,params)
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangodbutils.py",line 105,in inner
 [exec]     return func(*args,**kwargs)
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangodbutils.py",line 99,in __exit__
 [exec]     six.reraise(dj_exc_type,dj_exc_value,traceback)
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangodbutils.py",**kwargs)
 [exec]   File "C:Usersmarkwworkbptrti3bsrcdjangodbbackendssqlite3base.py",line 445,in execute
 [exec]     return Database.Cursor.execute(self,query,params)
 [exec] OperationalError: Problem installing fixture 'C:Usersmarkwworksrcphantomfixturesbasic_db.json': 
Could not load sites.Site(pk=1): no such table: django_site

因为我正在处理多处理,我不确定manage.py是否可能在发生这些错误时使用内存数据库或其他东西,但是使用以下数据库设置我不认为它使用内存进行测试;

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3','NAME': os.path.join(
            APPDATA_DIR,'sqlite3.db',),'TEST_NAME': os.path.join(
            APPDATA_DIR,'test.db',)
    }
}

如果它有用,启动服务器的功能;

def django_server_helper(qt_pipe=None,fixture_list=None):
    """    
    This is for use in testing-only modes (e.g. PhantomCSS).

    If this process is a subprocess of the main application,qt_pipe will be
    supplied to allow us to access functionality provided by django_offline.
    The other end of this pipe comes out in the DjangoOfflineApp instance.

    @type qt_pipe: multiprocessing.Connection
    @param qt_pipe: Pipe for communicating with the main django_offline app.
    @type fixture_list: list or None
    @param fixture_list: List of JSON fixture files to load in for testing.

    @rtype: None
    """
    use_threading = True

    if fixture_list is not None:
        # A fixture list has been supplied,so we're in test mode.
        from django.core.management.commands import loaddata
        loaddata.Command().execute(
            verbosity = 0,database = "default",settings = "mysite.settings",*fixture_list
        )

    if qt_pipe is not None:
        # A pipe has been supplied,so we're a subprocess
        from django_offline import connector
        connector.QT_PIPE = qt_pipe

    # start the django server up
    from django_offline import settings_central
    try:
        from django.contrib.staticfiles.management.commands import runserver
        runserver.Command().execute(
            use_threading=use_threading,use_static_handler=True,insecure_serving=True,addrport='127.0.0.1:{0}'.format(settings_central.LISTEN_PORT),)
    except socket.error as e:
        logging.exception("Socket occupied; not starting a server.")
        sys.exit(1)
    sys.exit(0)

我是否需要在运行loaddata之前调用syncdb,或者这可以通过使用fixture列表向South调用来完成？