ConnectionManagerTest.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345
  1. <?php
  2. /**
  3. * Connection Manager tests
  4. *
  5. * PHP 5
  6. *
  7. * Copyright 2005-2012, Cake Software Foundation, Inc. (http://cakefoundation.org)
  8. *
  9. * Licensed under The MIT License
  10. * Redistributions of files must retain the above copyright notice
  11. *
  12. * @copyright Copyright 2005-2012, Cake Software Foundation, Inc. (http://cakefoundation.org)
  13. * @link http://book.cakephp.org/2.0/en/development/testing.html CakePHP(tm) Tests
  14. * @package Cake.Test.Case.Model
  15. * @since CakePHP(tm) v 1.2.0.5550
  16. * @license MIT License (http://www.opensource.org/licenses/mit-license.php)
  17. */
  18. App::uses('ConnectionManager', 'Model');
  19. /**
  20. * ConnectionManagerTest
  21. *
  22. * @package Cake.Test.Case.Model
  23. */
  24. class ConnectionManagerTest extends CakeTestCase {
  25. /**
  26. * tearDown method
  27. *
  28. * @return void
  29. */
  30. public function tearDown() {
  31. parent::tearDown();
  32. CakePlugin::unload();
  33. }
  34. /**
  35. * testEnumConnectionObjects method
  36. *
  37. * @return void
  38. */
  39. public function testEnumConnectionObjects() {
  40. $sources = ConnectionManager::enumConnectionObjects();
  41. $this->assertTrue(count($sources) >= 1);
  42. $connections = array('default', 'test', 'test');
  43. $this->assertTrue(count(array_intersect(array_keys($sources), $connections)) >= 1);
  44. }
  45. /**
  46. * testGetDataSource method
  47. *
  48. * @return void
  49. */
  50. public function testGetDataSource() {
  51. App::build(array(
  52. 'Model/Datasource' => array(
  53. CAKE . 'Test' . DS . 'test_app' . DS . 'Model' . DS . 'Datasource' . DS
  54. )
  55. ));
  56. $name = 'test_get_datasource';
  57. $config = array('datasource' => 'Test2Source');
  58. ConnectionManager::create($name, $config);
  59. $connections = ConnectionManager::enumConnectionObjects();
  60. $this->assertTrue((bool)(count(array_keys($connections) >= 1)));
  61. $source = ConnectionManager::getDataSource('test_get_datasource');
  62. $this->assertTrue(is_object($source));
  63. ConnectionManager::drop('test_get_datasource');
  64. }
  65. /**
  66. * testGetDataSourceException() method
  67. *
  68. * @return void
  69. * @expectedException MissingDatasourceConfigException
  70. */
  71. public function testGetDataSourceException() {
  72. ConnectionManager::getDataSource('non_existent_source');
  73. }
  74. /**
  75. * testGetPluginDataSource method
  76. *
  77. * @return void
  78. */
  79. public function testGetPluginDataSource() {
  80. App::build(array(
  81. 'Plugin' => array(CAKE . 'Test' . DS . 'test_app' . DS . 'Plugin' . DS)
  82. ), App::RESET);
  83. CakePlugin::load('TestPlugin');
  84. $name = 'test_source';
  85. $config = array('datasource' => 'TestPlugin.TestSource');
  86. $connection = ConnectionManager::create($name, $config);
  87. $this->assertTrue(class_exists('TestSource'));
  88. $this->assertEquals($connection->configKeyName, $name);
  89. $this->assertEquals($connection->config, $config);
  90. ConnectionManager::drop($name);
  91. }
  92. /**
  93. * testGetPluginDataSourceAndPluginDriver method
  94. *
  95. * @return void
  96. */
  97. public function testGetPluginDataSourceAndPluginDriver() {
  98. App::build(array(
  99. 'Plugin' => array(CAKE . 'Test' . DS . 'test_app' . DS . 'Plugin' . DS)
  100. ), App::RESET);
  101. CakePlugin::load('TestPlugin');
  102. $name = 'test_plugin_source_and_driver';
  103. $config = array('datasource' => 'TestPlugin.Database/TestDriver');
  104. $connection = ConnectionManager::create($name, $config);
  105. $this->assertTrue(class_exists('TestSource'));
  106. $this->assertTrue(class_exists('TestDriver'));
  107. $this->assertEquals($connection->configKeyName, $name);
  108. $this->assertEquals($connection->config, $config);
  109. ConnectionManager::drop($name);
  110. }
  111. /**
  112. * testGetLocalDataSourceAndPluginDriver method
  113. *
  114. * @return void
  115. */
  116. public function testGetLocalDataSourceAndPluginDriver() {
  117. App::build(array(
  118. 'Plugin' => array(CAKE . 'Test' . DS . 'test_app' . DS . 'Plugin' . DS)
  119. ));
  120. CakePlugin::load('TestPlugin');
  121. $name = 'test_local_source_and_plugin_driver';
  122. $config = array('datasource' => 'TestPlugin.Database/DboDummy');
  123. $connection = ConnectionManager::create($name, $config);
  124. $this->assertTrue(class_exists('DboSource'));
  125. $this->assertTrue(class_exists('DboDummy'));
  126. $this->assertEquals($connection->configKeyName, $name);
  127. ConnectionManager::drop($name);
  128. }
  129. /**
  130. * testGetPluginDataSourceAndLocalDriver method
  131. *
  132. * @return void
  133. */
  134. public function testGetPluginDataSourceAndLocalDriver() {
  135. App::build(array(
  136. 'Plugin' => array(CAKE . 'Test' . DS . 'test_app' . DS . 'Plugin' . DS),
  137. 'Model/Datasource/Database' => array(
  138. CAKE . 'Test' . DS . 'test_app' . DS . 'Model' . DS . 'Datasource' . DS . 'Database' . DS
  139. )
  140. ));
  141. $name = 'test_plugin_source_and_local_driver';
  142. $config = array('datasource' => 'Database/TestLocalDriver');
  143. $connection = ConnectionManager::create($name, $config);
  144. $this->assertTrue(class_exists('TestSource'));
  145. $this->assertTrue(class_exists('TestLocalDriver'));
  146. $this->assertEquals($connection->configKeyName, $name);
  147. $this->assertEquals($connection->config, $config);
  148. ConnectionManager::drop($name);
  149. }
  150. /**
  151. * testSourceList method
  152. *
  153. * @return void
  154. */
  155. public function testSourceList() {
  156. ConnectionManager::getDataSource('test');
  157. $sources = ConnectionManager::sourceList();
  158. $this->assertTrue(count($sources) >= 1);
  159. $this->assertTrue(in_array('test', array_keys($sources)));
  160. }
  161. /**
  162. * testGetSourceName method
  163. *
  164. * @return void
  165. */
  166. public function testGetSourceName() {
  167. $source = ConnectionManager::getDataSource('test');
  168. $result = ConnectionManager::getSourceName($source);
  169. $this->assertEquals('test', $result);
  170. $source = new StdClass();
  171. $result = ConnectionManager::getSourceName($source);
  172. $this->assertNull($result);
  173. }
  174. /**
  175. * testLoadDataSource method
  176. *
  177. * @return void
  178. */
  179. public function testLoadDataSource() {
  180. $connections = array(
  181. array('classname' => 'Mysql', 'filename' => 'Mysql', 'package' => 'Database'),
  182. array('classname' => 'Postgres', 'filename' => 'Postgres', 'package' => 'Database'),
  183. array('classname' => 'Sqlite', 'filename' => 'Sqlite', 'package' => 'Database'),
  184. );
  185. foreach ($connections as $connection) {
  186. $exists = class_exists($connection['classname']);
  187. $loaded = ConnectionManager::loadDataSource($connection);
  188. $this->assertEquals($loaded, !$exists, "Failed loading the {$connection['classname']} datasource");
  189. }
  190. }
  191. /**
  192. * testLoadDataSourceException() method
  193. *
  194. * @return void
  195. * @expectedException MissingDatasourceException
  196. */
  197. public function testLoadDataSourceException() {
  198. $connection = array('classname' => 'NonExistentDataSource', 'filename' => 'non_existent');
  199. ConnectionManager::loadDataSource($connection);
  200. }
  201. /**
  202. * testCreateDataSource method
  203. *
  204. * @return void
  205. */
  206. public function testCreateDataSourceWithIntegrationTests() {
  207. $name = 'test_created_connection';
  208. $connections = ConnectionManager::enumConnectionObjects();
  209. $this->assertTrue((bool)(count(array_keys($connections) >= 1)));
  210. $source = ConnectionManager::getDataSource('test');
  211. $this->assertTrue(is_object($source));
  212. $config = $source->config;
  213. $connection = ConnectionManager::create($name, $config);
  214. $this->assertTrue(is_object($connection));
  215. $this->assertEquals($name, $connection->configKeyName);
  216. $this->assertEquals($name, ConnectionManager::getSourceName($connection));
  217. $source = ConnectionManager::create(null, array());
  218. $this->assertEquals(null, $source);
  219. $source = ConnectionManager::create('another_test', array());
  220. $this->assertEquals(null, $source);
  221. $config = array('classname' => 'DboMysql', 'filename' => 'dbo' . DS . 'dbo_mysql');
  222. $source = ConnectionManager::create(null, $config);
  223. $this->assertEquals(null, $source);
  224. }
  225. /**
  226. * testConnectionData method
  227. *
  228. * @return void
  229. */
  230. public function testConnectionData() {
  231. App::build(array(
  232. 'Plugin' => array(CAKE . 'Test' . DS . 'test_app' . DS . 'Plugin' . DS),
  233. 'Model/Datasource' => array(
  234. CAKE . 'Test' . DS . 'test_app' . DS . 'Model' . DS . 'Datasource' . DS
  235. )
  236. ), App::RESET);
  237. CakePlugin::load(array('TestPlugin', 'TestPluginTwo'));
  238. $expected = array(
  239. 'datasource' => 'Test2Source'
  240. );
  241. ConnectionManager::create('connection1', array('datasource' => 'Test2Source'));
  242. $connections = ConnectionManager::enumConnectionObjects();
  243. $this->assertEquals($expected, $connections['connection1']);
  244. ConnectionManager::drop('connection1');
  245. ConnectionManager::create('connection2', array('datasource' => 'Test2Source'));
  246. $connections = ConnectionManager::enumConnectionObjects();
  247. $this->assertEquals($expected, $connections['connection2']);
  248. ConnectionManager::drop('connection2');
  249. ConnectionManager::create('connection3', array('datasource' => 'TestPlugin.TestSource'));
  250. $connections = ConnectionManager::enumConnectionObjects();
  251. $expected['datasource'] = 'TestPlugin.TestSource';
  252. $this->assertEquals($expected, $connections['connection3']);
  253. ConnectionManager::drop('connection3');
  254. ConnectionManager::create('connection4', array('datasource' => 'TestPlugin.TestSource'));
  255. $connections = ConnectionManager::enumConnectionObjects();
  256. $this->assertEquals($expected, $connections['connection4']);
  257. ConnectionManager::drop('connection4');
  258. ConnectionManager::create('connection5', array('datasource' => 'Test2OtherSource'));
  259. $connections = ConnectionManager::enumConnectionObjects();
  260. $expected['datasource'] = 'Test2OtherSource';
  261. $this->assertEquals($expected, $connections['connection5']);
  262. ConnectionManager::drop('connection5');
  263. ConnectionManager::create('connection6', array('datasource' => 'Test2OtherSource'));
  264. $connections = ConnectionManager::enumConnectionObjects();
  265. $this->assertEquals($expected, $connections['connection6']);
  266. ConnectionManager::drop('connection6');
  267. ConnectionManager::create('connection7', array('datasource' => 'TestPlugin.TestOtherSource'));
  268. $connections = ConnectionManager::enumConnectionObjects();
  269. $expected['datasource'] = 'TestPlugin.TestOtherSource';
  270. $this->assertEquals($expected, $connections['connection7']);
  271. ConnectionManager::drop('connection7');
  272. ConnectionManager::create('connection8', array('datasource' => 'TestPlugin.TestOtherSource'));
  273. $connections = ConnectionManager::enumConnectionObjects();
  274. $this->assertEquals($expected, $connections['connection8']);
  275. ConnectionManager::drop('connection8');
  276. }
  277. /**
  278. * Tests that a connection configuration can be deleted in runtime
  279. *
  280. * @return void
  281. */
  282. public function testDrop() {
  283. App::build(array(
  284. 'Model/Datasource' => array(
  285. CAKE . 'Test' . DS . 'test_app' . DS . 'Model' . DS . 'Datasource' . DS
  286. )
  287. ));
  288. ConnectionManager::create('droppable', array('datasource' => 'Test2Source'));
  289. $connections = ConnectionManager::enumConnectionObjects();
  290. $this->assertEquals(array('datasource' => 'Test2Source'), $connections['droppable']);
  291. $this->assertTrue(ConnectionManager::drop('droppable'));
  292. $connections = ConnectionManager::enumConnectionObjects();
  293. $this->assertFalse(isset($connections['droppable']));
  294. }
  295. }