This sounds like a good idea. I guess I just don't know enough about databases yet to know how to do this linking. Mostly I just know about how to get DBI to interact with MySQL.
I should mention that I'd also like to be able to make some rules in the "real" database temporarily disappear while testing, but I fear this will make things even more complicated. On 7/19/07, Sven Miller <[EMAIL PROTECTED]> wrote:
I would consider setting up the test database to consist of a database link to the "real" database, along with views for all the tables. Then on those tables where I wanted to interject some data, I would create test-data tables and alter the views to merge the data. Then switching from "test" to "real" is a matter of changing where you connect to. Alternately, you could change the views to only incorporate test-data if a certain flag is set in yet another test table.