Topic: How do I test an app with multiple databases?
I have a large application that has a main database and a secondary statistics database. We use the stattistics database to crunch site usage figures in the background. We achieve this by having an ActiveRecord class that creates it's own connection, and all of the tables in this database inherit from our StasDb class.
We use spec for testing. When I test the main application, the database gets cleared on initialization of each test. My question is, how can we get the testing framework to also clear out the stats database prior to each test run so that we can test portions of the application that touch both of them?
Thanks in advance...