python sqlite3 no such table_python – 关于线程操作的Django / sqlite3“OperationalError：no such table”...

通过我在文档中阅读的所有内容,Django和py-sqlite3都可以使用线程访问. (对吗？)但是这段代码片段对我失败了.主线程中的操作可以工作,但不能在我创建的线程中工作.在那里我得到：

File

“C:\Python27\lib\site-packages\django-1.9-py2.7.egg\django\db\backends\sq

lite3\base.py”, line 323, in execute

return Database.Cursor.execute(self, query, params)

OperationalError: no such table: thrtest_mymodel

有什么问题？

我如何准确地追踪修补Django的正在发生的事情或修复它所需的一切？ Django的失败点非常难以理解.我不知道如何查看它看到的表格,或者主要和其他线程之间要查找的差异.

from django.db import models

# Super-simple model

class MyModel(models.Model):

message = models.CharField('Message', max_length=200, blank=True)

#Test

from django.test import TestCase

import time

import threading

import random

done = threading.Event()

nThreads = 1

def InsertRec(msg):

rec = MyModel.objects.create(message=msg)

rec.save()

def InsertThread():

try:

msgNum = 1

thrName = threading.currentThread().name

print 'Starting %s' % thrName

while not done.wait(random.random() * 0.1):

msgNum += 1

msg = '%s: %d' % (thrName, msgNum)

print msg

InsertRec(msg)

finally:

done.set()

pass

class ThreadTestRun(TestCase):

def testRunIt(self):

nThisThread = 10

msgSet = set()

for x in xrange(nThisThread):

msg = 'Some message %d' % x

InsertRec(msg) # From main thread: works!

msgSet.add(msg)

self.assertEqual(MyModel.objects.count(), nThisThread)

# We use sets because .all() doesn't preserve the original order.

self.assertEqual(msgSet, set([r.message for r in MyModel.objects.all()]))

thrSet = set()

for thrNum in xrange(nThreads):

t = threading.Thread(name='Thread %d' % thrNum, target=InsertThread)

t.start()

thrSet.add(t)

done.wait(10.)

done.set()

for t in thrSet:

t.join()

更新：这是来自settings.py的DATABASES：

DATABASES = {

'default': {

'ENGINE': 'django.db.backends.sqlite3',

'NAME': ':memory:', # os.path.join(BASE_DIR, 'db.sqlite3'),

'TEST_NAME' : ':memory:',

},

}

更新：关于Django的票#12118,我使用’：memory：’或磁盘文件(对于TEST_NAME)得到相同的症状.

Django 1.9,Python 2.7.11. (Django 1.6中的症状相同.)