Zend Framework: Connecting to 2 databases

 
[production]
database.adapter               = "PDO_MYSQL"
database.params.host           = "localhost"
database.params.dbname         = "Database_A"
database.params.username       = "root"
database.params.password       = "1234"
 
psdatabase.adapter             = "PDO_MYSQL"
psdatabase.params.host         = "localhost"
psdatabase.params.dbname       = "Database_B"
psdatabase.params.username     = "root"
psdatabase.params.password     = "1234"
 
[development : production]
database.params.dbname         = "Database_A"
database.params.username       = "root"
database.params.password       = "1234"
 
psdatabase.params.dbname       = "Database_B"
psdatabase.params.username     = "root"
psdatabase.params.password     = "1234"
 
[testing : production]
database.params.dbname         = "Database_A"
database.params.username       = "root"
database.params.password       = "1234"
 
psdatabase.params.dbname       = "Database_B"
psdatabase.params.username     = "root"
psdatabase.params.password     = "1234"

//bootstrap code...
$dbAdapter = Zend_Db::factory($configuration->database);
Zend_Db_Table_Abstract::setDefaultAdapter($dbAdapter);
$registry = Zend_Registry::getInstance();
$registry->configuration = $configuration;
$registry->dbAdapter     = $dbAdapter;
 
$psdbAdapter = Zend_Db::factory($configuration->psdatabase);
$registry->psdbAdapter   = $psdbAdapter;
//bootstrap code

<?php
/**
 * Psdump.php
 * /opt/apache2/htdocs/apps/org_v2/application/models/Psdump.php
 */
require_once APPLICATION_PATH.'/models/PsdumpTable.php';
class Psdump extends Zend_Db_Table 
{
    protected $_table;
 
    public function getTable()
    {
        if(null === $this->_table) {
            $this->_table = new PsdumpTable;
        }
        return $this->_table;
    }
 
    public function fetchAllEmployees()
    {
        //return $this->getTable()->fetchActiveEmployees();
        return $this->getTable()->getLatestPSDumpTable();
    }
}

<?php
/**
 * PsdumpTable
 * /opt/apache2/htdocs/apps/org_v2/application/models/PsdumpTable.php
 *
 */
class PsdumpTable extends Zend_Db_Table_Abstract 
{
    protected $_name = 'psdump';
    protected $_psdb;
 
    public function init()
    {
        //load the other adapter
        $this->_psdb = Zend_Registry::getInstance('psdbAdapter')->psdbAdapter;
    }
 
    public function insert(array $data)
    {
        return parent::insert($data);
    }
 
    /**
     * fetch all employees with Status = A
     *
     * @return unknown
     */
    public function fetchActiveEmployees()
    {
        $sql = "SELECT * FROM ".$this->_name." WHERE Status=".$this->_db->quote('A');
        return $this->_db->fetchAll($sql);
    }
 
    /**
     * We are using the psdb here!!!
     *
     * @return unknown
     */
    public function getLatestPSDumpTable()
    {
        $sql = "SHOW tables";
        return $this->_psdb->fetchAll($sql);
    }
}