On 09:24 am, [email protected] wrote: >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? > >[snip] > >db = adbapi.ConnectionPool("sqlite3", database=":memory:")
It doesn't make sense to use a connection pool for an in-memory SQLite3 database. Every time you connect to ":memory:", you get a brand new, empty database. If you want this to work, you need to be able to establish multiple connections to the same database. You could do that by making your own DB-API 2.0 module that wraps sqlite3 and always hands back the same :memory: connection when its connect function is called. Jean-Paul _______________________________________________ Twisted-Python mailing list [email protected] http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
