Closed
Description
Issue when a user has two or more databases -- say, test1.db
and test2.db
-- that they try to use in the same request. The way the library currently works, whichever database I execute on first in this request will be the only database I'm allowed to connect to in the request. So if I try test1.execute(...)
followed by test2.execute(...)
in the same request, I'm not going to get what I wanted, since the library limits us to one database connection per request -- in this case, the library will try to execute my second SQL statement on test1.db
. And that's because of the request global flask.g._connection
we're setting, and then using as a gatekeeper against opening new connections.