#1
|
|||
|
|||
Access database in (non-main) thread
Hi,
when I execute my code (simplified code stated below) I get this error: sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread.The object was created in thread id 6596 and this is thread id 5748 But when I'm running the exact same code in Vizards main thread it works just fine. So what am I doing wrong or do I have to use another way to store data in a database from a separate (non-main) thread? Code:
def example(): con = sqlite3.connect("test.db") con.execute(""" CREATE TABLE tbl_01( test TEXT) """) def onKeyDown(key): if key == viz.KEY_UP: con.execute(""" INSERT INTO tbl_01 VALUES(?) """, "t") con.commit() viz.callback(viz.KEYDOWN_EVENT,onKeyDown) viz.director(example) |
#2
|
|||
|
|||
You would have to return the value from the director function to a task to get it back in the main thread:
|
Tags |
database, thread |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sending a value by Thread | Alex Miranda | Vizard | 0 | 11-19-2014 06:52 AM |
Access the vertices of a model | pankaj bansal | Vizard | 1 | 03-29-2013 07:02 PM |
Access to Geometry Data in a c++ plugin for vizard. | xabbu | Plug-in development | 1 | 01-16-2009 03:14 PM |
Prioritize Director thread | aznan | Vizard | 9 | 05-14-2008 09:57 AM |
running into a thread limit | tavaksai | Vizard | 4 | 10-27-2004 03:59 PM |