Cake2 AppModel

Cake2_AppModel.php

<?php
App::uses('Model', 'Model');

class AppModel extends Model
{
	/**
	 * Connects to specified database
	 *
	 * @param String name of different database to connect with.
	 * @param String name of existing datasource
	 * @return boolean true on success, false on failure
	 */
	public function setDatabase($database, $datasource = 'default')
	{
		$newDatasource = $datasource . '_' . $database;
		try {
			$db = ConnectionManager::getDataSource($newDatasource);
			$this->useDbConfig  = $newDatasource;
			$this->cacheQueries = false;
			return true;
		} catch (Exception $e) {
			// debug($e->getMessage());
		}

		$db  = ConnectionManager::getDataSource($datasource);
		$db->setConfig(array(
			'name'       => $newDatasource,
			'database'   => $database,
			'persistent' => false
		));

		if ( $ds = ConnectionManager::create($newDatasource, $db->config) ) {
			$this->useDbConfig  = $newDatasource;
			$this->cacheQueries = false;
			return true;
		}

		return false;
	}
}