<div>I am try to use a in-memory sqlite db via adbapi, but sqlite gives error:" OperationalError: <em>no such table</em>: test ".</div><div><br></div><div>how can I made it work?</div><div><br></div>This is my test code:<div>
<br><div><div>from twisted.internet import reactor</div><div>from twisted.enterprise import adbapi</div><div><br></div><div>def create():</div><div> db.runOperation("create table test(id)").addCallback(result).addErrback(error)</div>
<div><br></div><div>def insert():</div><div> db.runOperation("insert into test(id) values(1)").addCallback(result).addErrback(error)</div><div><br></div><div>def select():</div><div> db.runQuery("""SELECT * FROM test""").addCallback(result).addErrback(error)</div>
<div><br></div><div>def result(l):</div><div> print l</div><div><br></div><div>def error(fail):</div><div> print fail</div><div><br></div><div>db = adbapi.ConnectionPool("sqlite3", database=":memory:")</div>
<div>reactor.callLater(0.1, create)</div><div>reactor.callLater(1, insert)</div><div>reactor.callLater(2, select)</div><div>reactor.run()</div></div></div>