EnvironmentStub missing config data for sqlite::memory:

[tumma72@…]

While testing using the EnvironmentStub, if one want to make use of the ConnectionManager and a Connector to use for example the to_sql() method, an exception is rosen because the default string for sqlite connection point to sqlite:db/trac.db which doesn't match with the in memory DB. I fixed the problem adding the following line in the trac.test.py file @178:

if not os.path.isabs(self.path):
        self.path = os.path.join(os.getcwd(), self.path)

self.config = Configuration(None)

# Set the connection type in the config as sqlite in memory
self.config.set('trac', 'database', 'sqlite::memory:')

# We have to have a ticket-workflow config for ''lots'' of things to
# work.  So insert the basic-workflow config here.  There may be a
# better solution than this.
load_workflow_config_snippet(self.config, 'basic-workflow.ini')

[tumma72@…]

Diff file for test.py

[Christian Boos]

Could you also upload a small test program reproducing the problem?

[tumma72@…]

Script to break the sqlite_backend.py via EnvironmentStub

[anonymous]

Replying to cboos:

Could you also upload a small test program reproducing the problem?

Sure, here you go… with the patch it works, without it breaks :-)

Of course we could debate on the fact that the DatabaseManager._get_connector() is private… but still… ;-)

[Remy Blank]

Is this still needed, now that we can run the tests against all database backends?

[Christian Boos]

I think this is actually what makes the tests fail in #9470.

[Christian Boos]

Slightly modified patch applied in r10067.

[Christian Boos]

this is actually what makes the tests fail in #9470

Actually no, it's a bit more involved than that.