On Mon, Feb 1, 2010 at 12:33 PM, Ramiro Morales <cra...@gmail.com> wrote:
> ...
> Are you using sqlite3?
I think I understand why you're asking this. Here's a little test I ran:
-----
import sqlite3,thread
from time import sleep
conn = sqlite3.connect(':memory:')
c = conn.cursor()
c.execute('''create table stocks
(date text, trans text, symbol text,
qty real, price real)''')
conn.commit()
def t():
c.execute('select * from stocks')
print c.fetchall()
thread.start_new_thread(t,())
sleep(60)
-----
and here's what I got:
-----
Unhandled exception in thread started by <function t at 0x385cb0>
Traceback (most recent call last):
File "sqlite.py", line 14, in t
c.execute('select * from stocks')
sqlite3.ProgrammingError: SQLite objects created in a thread can only
be used in that same thread.The object was created in thread id
-1609415424 and this is thread id -1341648896
-----
So, it seems that every thread must open its own connection to the DB.
Anyway, an in-memory sqlite3 DB's scope is bound to the connection's
scope so, in the end, it can't be shared.
Thank you for your help.
Cristiano
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
