[PonyORM-list] Running in thread ?

Tomislav Tustonic tomislavtustonic at outlook.com
Sat Jul 26 22:27:53 UTC 2014


Is it possible to run a Pony ORM query in a different thread.
In the following example the first call to 'printPersons' works fine, but the 
call from the thread throws an exception:
OperationalError: no such table: Person

from pony.orm import *
import threading

db = Database('sqlite', ':memory:')
class Person(db.Entity):
    name = Required(unicode)
    age = Required(int)
with db_session:
    p1 = Person(name="Bing Bang", age="31")
    p2 = Person(name="Kick Mick", age="75")

def printPersons():
    print "print persons: "
    with db_session:
        ps = Person.select(lambda p: True)
        for p in ps:
            print p.name

print "-------------------------"
ppt = threading.Thread(target = printPersons)
ppt.daemon = True
a = raw_input('[Enter]')

 Thanks in advance,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </ponyorm-list/attachments/20140727/9238310f/attachment.html>

More information about the ponyorm-list mailing list