I am try to use a in-memory sqlite db via adbapi, but sqlite gives
error:" OperationalError: *no such table*: test ".
how can I made it work?
This is my test code:
from twisted.internet import reactor
from twisted.enterprise import adbapi
def create():
db.runOperation("create table
test(id)").addCallback(result).addErrback(error)
def insert():
db.runOperation("insert into test(id)
values(1)").addCallback(result).addErrback(error)
def select():
db.runQuery("""SELECT * FROM
test""").addCallback(result).addErrback(error)
def result(l):
print l
def error(fail):
print fail
db = adbapi.ConnectionPool("sqlite3", database=":memory:")
reactor.callLater(0.1, create)
reactor.callLater(1, insert)
reactor.callLater(2, select)
reactor.run()
_______________________________________________
Twisted-Python mailing list
Twisted-Python@twistedmatrix.com
http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
