Re: looks like one database from the outside, but it's two inside
- From: shixilun@xxxxxxxxx (Theron Stanford)
- Date: Thu, 19 Jul 2007 10:22:00 -0700
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 <ngdvakigyotuia@xxxxxxxxx> 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.
- Follow-Ups:
- Re: looks like one database from the outside, but it's two inside
- From: Sven Miller
- Re: looks like one database from the outside, but it's two inside
- References:
- looks like one database from the outside, but it's two inside
- From: Theron Stanford
- Re: looks like one database from the outside, but it's two inside
- From: Tim Bunce
- Re: looks like one database from the outside, but it's two inside
- From: Theron Stanford
- Re: looks like one database from the outside, but it's two inside
- From: Sven Miller
- looks like one database from the outside, but it's two inside
- Prev by Date: Re: looks like one database from the outside, but it's two inside
- Next by Date: Re: looks like one database from the outside, but it's two inside
- Previous by thread: Re: looks like one database from the outside, but it's two inside
- Next by thread: Re: looks like one database from the outside, but it's two inside
- Index(es):
Relevant Pages
|
