[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]mrtavo[/eluser]
[quote author="mrtavo" date="1248265921"][quote author="OverZealous.com" date="1248264869"]Yes, you can, very simply!

The DataMapper database needs to be the default in CodeIgniter. Then, whenever you need the second DB, use the instructions provided in the CodeIgniter manual. (Scroll down to Connecting to Multiple Databases.)

You can then use DataMapper like normal, and SELECT on your other DB using traditional CodeIgniter methods (include ActiveRecord).[/quote]


Thanks very much for the quick reply I will try that soon.[/quote]


Hello again, I tried to do that, but to get it work properly I had to load my "default" database too in the same function (I don't know if I'm doing something wrong, or if this is the right way to do it).

I'll illustrate this with an example:

function F(){
$A = new A();
A->where_related_X('id', 1)->get();
/* do something with A */
$ExtDB = $this->load->database('extdb', TRUE);
/* that seems to change the default active database */
$r = $ExtDB->query('somequery');
/* do something with r->result() */
(*)
$B = new B();
$B->where_related_A('id', 2000)->get();
/* this gives an error because is using the external database */
}

I needed to add in (*) row the following code to make this work:
$mydb = $this->load->database('mydefaultdatabase', TRUE);
which seems to change the default active database.

Am I doing something wrong ?
Is this the right way to do it ?

the $active_group variable is set properly at the very beginning.