Unable to use multiple datasources in testing

[trichins]

I have multiple datasources set up in Config/database.php and they each have a test version. Some examples are:

default
test
FileSource
test_FileSource
IniSource
test_IniSource

The models are using their correct datasource and they work fine. In my test fixtures, I have each of the fixtures importing in their corresponding model (public $import = 'ModelName') and using the corresponding test datasource (public $useDbConfig = 'test_source'). I believe that is what book.cakephp.org/2.0/en/development/testing.html says I should do.

But it doesn't work. I get a "MissingTableException" in Model::setSource() because it is always using the "test" datasource.

I'm not sure the best way to fix it but for now, I've overwritten CakeTestCase::getMockForModel and call "ClassRegistry::config('Model', array('ds' => null))" before calling the parent getMockForModel. I think call setDataSource myself using the information from useDbConfig.

[markstory]

So you are importing the schema from the non-test models?

[trichins]

Yes

[markstory]

And how is getMockForModel() getting involved?

[markstory]

You cannot use alternate datasources with the string form of import. You must use the array form:

public $import = array('model' => 'Paste', 'connection' => 'two');

The existing section in the docs covers this. If there is something that could be added to the docs to make the limitations of the string form more clear let me know, I'm happy to update the docs.

[trichins]

That doesn't work. From the docs, that is talking about importing the table definition. My models in the other datasources have their table definition defined inside of them.

And the docs say that what I'm doing should work. If you read the paragraph that starts with "The $useDbConfig property defines the datasource of which the fixture will use." you'll see that it says that I just need to make sure that the datasource starts with "test_" and it will work. That is not happening.

getMockForModel is used to generate the model. I need to mock out a few things in the model so I'm using that. I found that the change in 46b28aa caused this problem. Before, I could pass in a null config and it wouldn't use the default config (which has 'test' always set as the 'ds'). Now, I have to clear out ClassRegistry::config('Model') to prevent that.

[markstory]

The example I posted worked for me last night. I was able to import schema from two different data sources.

The $useDbConfig property defines which connection the fixture will insert its schema and data into. I can double check that my schema and data were going into their respective connections, but reading schema from multiple datasources did work for me.

[trichins]

Yes, I have different test datasources. One is in postgres, another is a file. I don't just want to use the "test" datasource but I also want to use the "test_FileSource" datasource as well.

I've created a basic app that just has my model, datasource, fixture, and test case and I can duplicate it. Is there a way to attach a zip to this issue?

[markstory]

Putting the relevant files into a gist is probably the best option.

[trichins]

The gist is over at https://gist.github.com/trichins/1b538db7aba161f51467.

[markstory]

Thanks 👍

[markstory]

So I finally had some more time to look into this, and from what I can see the issue only crops up when getMockForModel() is used. When using ClassRegistry::init() the correct connection names are used.

I figured out the issue and will have a pull request up shortly.

[markstory]

Closing as a pull request is up now.