RE: Join Tables between db

Yeah I have all that setup and everything works except telling Cake where to
look for the table. It never finds the table in my default config for that 1
model. If I move the tables to resources DB (where I do not want it) it
works. Move it to default_db and tell the model to look in default
$useDBconfig I get missing table. So just a little stumped.

From: Alex Ciobanu [mailto:ics.cakephp@gmail.com]
Sent: Wednesday, January 26, 2011 10:41 PM
To: cake-php@googlegroups.com
Subject: Re: Join Tables between db

On 1/26/2011 3:08 AM, Dave Maharaj wrote:
I have a site with 2 databases (same server)
Being resources_db (data that never changes, Country, States, various
selects and options to select from throughout the site)
default_db users, profiles, things that can be changed, edited by users.
 
Now join tables happen to cross between resources_db and default_db where
does the join tables go in these situations? How do you tell Cake where to
look?
 
Hi Dave,
I use something similar in one of my apps. Here are some snippets from my
code, slightly adapted to your example.

app/config/database.php
class DATABASE_CONFIG {

    var $default = array(
        'driver' => 'mysql',
        'persistent' => false,
        'host' => 'host',
        'login' => 'user',
        'password' => 'pass',
        'database' => 'default_db',
        'prefix' => '',
    );
....
    var $resource = array(
        'driver' => 'mysql',
        'persistent' => false,
        'host' => 'host',
        'login' => 'user',
        'password' => 'pass',
        'database' => 'resources_db',
        'prefix' => '',
    );
....
}

app/models/user.php
class User extends AppModel {
   ......
    public $belongsTo = array(
        'Country' => array(
            'className' => 'Country',
            'foreignKey' => 'country_id',
        ),
    );
....
}

app/models/country.php
class Country extends AppModel {

    public $useDbConfig = 'resource';
....
    public $hasMany = array(
        'User' => array(
            'className' => 'User',
            'foreignKey' => 'country_id',
            ....
        )
    );
....
}

With this setup I can do something like:

$this->User->find('random', array('contain' => array('Country'), 'limit' =>
10));

HTH
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help
others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php