Can I set the Database adapter to use permanently from within a Zend_Db_Table_Abstract Class?

Question

I have 2 databases that my site uses including a central user database that relates to other site-specific databases.

Sometimes it is adequate to call new User(array('db'=>'adapter1')); (but never convenient); other times, though, such as when declaring relationships between tables on different databases, there is no way to do this.

Does anyone know a way to specify which database adapter to use from within the Zend_Db_Table_Abstract class?

Thanks!

Answer 1

You could set the class variable $_db to the correct adapter in the constructor.

global $adapter1; //There are better ways than using a global variable

$this->_db = $adapter1;

Assuming the adapter object can be referenced in the constructor. That doesn't seem to portable, but I believe it would work.

Answer 2

Zend_Db_Table_Abstract provides a static method to set the default database adapter. Do this as follows:

Zend_Db_Table_Abstract::setDefaultAdapter($adapter);

Now, all your Table objects will use your adapter by default.

Note: the online docs sometimes don't make this obvious, so your second best place to check is in the API here: http://framework.zend.com/apidoc/core/

Answer 3

Getting back to this pretty late, but none of the answers here quite did it for me. A select few of my database models needed to use 'tdb' and the following code was added to each of those classes to have that happen automatically:

protected function _setupDatabaseAdapter()
{
 $this->_db = Zend_Registry::get('tdb');
 parent::_setupDatabaseAdapter();
}

I thank you all for your suggestions along the way!

Answer 4

The init function can be used, it is not used in Zend_Db_Adapter_Abstract, can be used in your class to setup whatever needs to be done. _setAdapter accepts a string naming a Registry Key.

public function init()
{
    $this->_setAdapter('tdb');
}