MongoCollectionTest.php 42 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381
  1. <?php
  2. namespace Alcaeus\MongoDbAdapter\Tests\Mongo;
  3. use MongoDB\Driver\ReadPreference;
  4. use Alcaeus\MongoDbAdapter\Tests\TestCase;
  5. /**
  6. * @author alcaeus <alcaeus@alcaeus.org>
  7. */
  8. class MongoCollectionTest extends TestCase
  9. {
  10. public function testSerialize()
  11. {
  12. $this->assertInternalType('string', serialize($this->getCollection()));
  13. }
  14. public function testGetNestedCollections()
  15. {
  16. $collection = $this->getCollection()->foo->bar;
  17. $this->assertSame('mongo-php-adapter.test.foo.bar', (string) $collection);
  18. }
  19. public function testCreateRecord()
  20. {
  21. $collection = $this->getCollection();
  22. $expected = [
  23. 'ok' => 1.0,
  24. 'n' => 0,
  25. 'err' => null,
  26. 'errmsg' => null,
  27. ];
  28. $document = ['foo' => 'bar'];
  29. $this->assertSame($expected, $collection->insert($document));
  30. $this->assertInstanceOf('MongoId', $document['_id']);
  31. $id = (string) $document['_id'];
  32. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  33. $this->assertSame(1, $newCollection->count());
  34. $object = $newCollection->findOne();
  35. $this->assertNotNull($object);
  36. $this->assertAttributeInstanceOf('MongoDB\BSON\ObjectID', '_id', $object);
  37. $this->assertSame($id, (string) $object->_id);
  38. $this->assertObjectHasAttribute('foo', $object);
  39. $this->assertAttributeSame('bar', 'foo', $object);
  40. }
  41. public function testInsertInvalidData()
  42. {
  43. $this->setExpectedException('PHPUnit_Framework_Error_Warning', 'MongoCollection::insert(): expects parameter 1 to be an array or object, integer given');
  44. $document = 8;
  45. $this->getCollection()->insert($document);
  46. }
  47. public function testInsertEmptyArray()
  48. {
  49. $document = [];
  50. $this->getCollection()->insert($document);
  51. $this->assertSame(1, $this->getCollection()->count());
  52. }
  53. public function testInsertArrayWithNumericKeys()
  54. {
  55. $document = [1 => 'foo'];
  56. $this->getCollection()->insert($document);
  57. $this->assertSame(1, $this->getCollection()->count(['_id' => $document['_id']]));
  58. }
  59. public function testInsertEmptyObject()
  60. {
  61. $document = (object) [];
  62. $this->getCollection()->insert($document);
  63. $this->assertSame(1, $this->getCollection()->count());
  64. }
  65. public function testInsertObjectWithPrivateProperties()
  66. {
  67. $this->setExpectedException('MongoException', 'zero-length keys are not allowed, did you use $ with double quotes?');
  68. $document = new PrivatePropertiesStub();
  69. $this->getCollection()->insert($document);
  70. }
  71. public function testInsertWithInvalidKey()
  72. {
  73. $document = ['*' => 'foo'];
  74. $this->getCollection()->insert($document);
  75. $this->assertSame(1, $this->getCollection()->count(['*' => 'foo']));
  76. }
  77. public function testInsertWithEmptyKey()
  78. {
  79. $this->setExpectedException('MongoException', 'zero-length keys are not allowed, did you use $ with double quotes?');
  80. $document = ['' => 'foo'];
  81. $this->getCollection()->insert($document);
  82. }
  83. public function testInsertWithNumericKey()
  84. {
  85. $document = ['foo'];
  86. $this->getCollection()->insert($document);
  87. $this->assertSame(1, $this->getCollection()->count(['foo']));
  88. }
  89. public function testInsertDuplicate()
  90. {
  91. $collection = $this->getCollection();
  92. $collection->createIndex(['foo' => 1], ['unique' => true]);
  93. $document = ['foo' => 'bar'];
  94. $collection->insert($document);
  95. unset($document['_id']);
  96. $this->setExpectedExceptionRegExp('MongoDuplicateKeyException', '/E11000 duplicate key error .* mongo-php-adapter\.test/');
  97. $collection->insert($document);
  98. }
  99. public function testUnacknowledgedWrite()
  100. {
  101. $document = ['foo' => 'bar'];
  102. $this->assertTrue($this->getCollection()->insert($document, ['w' => 0]));
  103. }
  104. public function testInsertWriteConcernException()
  105. {
  106. $this->setExpectedException(
  107. 'MongoWriteConcernException',
  108. "cannot use 'w' > 1 when a host is not replicated"
  109. );
  110. $document = ['foo' => 'bar'];
  111. $this->getCollection()->insert($document, ['w' => 2]);
  112. }
  113. public function testInsertMany()
  114. {
  115. $expected = [
  116. 'ok' => 1.0,
  117. 'n' => 0,
  118. 'syncMillis' => 0,
  119. 'writtenTo' => null,
  120. 'err' => null,
  121. ];
  122. $documents = [
  123. ['foo' => 'bar'],
  124. ['bar' => 'foo']
  125. ];
  126. $this->assertArraySubset($expected, $this->getCollection()->batchInsert($documents));
  127. foreach ($documents as $document) {
  128. $this->assertInstanceOf('MongoId', $document['_id']);
  129. }
  130. }
  131. public function testInsertManyWithNonNumericKeys()
  132. {
  133. $expected = [
  134. 'ok' => 1.0,
  135. 'n' => 0,
  136. 'syncMillis' => 0,
  137. 'writtenTo' => null,
  138. 'err' => null,
  139. ];
  140. $documents = [
  141. 'a' => ['foo' => 'bar'],
  142. 'b' => ['bar' => 'foo']
  143. ];
  144. $this->assertArraySubset($expected, $this->getCollection()->batchInsert($documents));
  145. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  146. $this->assertSame(2, $newCollection->count());
  147. }
  148. public function testBatchInsertContinuesOnError()
  149. {
  150. $expected = [
  151. 'ok' => 1.0,
  152. 'n' => 0,
  153. 'syncMillis' => 0,
  154. 'writtenTo' => null,
  155. 'err' => null,
  156. ];
  157. $documents = [
  158. 8,
  159. 'b' => ['bar' => 'foo']
  160. ];
  161. $this->assertArraySubset($expected, $this->getCollection()->batchInsert($documents, ['continueOnError' => true]));
  162. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  163. $this->assertSame(1, $newCollection->count());
  164. }
  165. public function testBatchInsertException()
  166. {
  167. $this->setExpectedExceptionRegExp('MongoDuplicateKeyException', '/E11000 duplicate key error .* mongo-php-adapter.test.*_id_/');
  168. $id = new \MongoId();
  169. $documents = [['_id' => $id, 'foo' => 'bar'], ['_id' => $id, 'foo' => 'bleh']];
  170. $this->getCollection()->batchInsert($documents);
  171. }
  172. public function testBatchInsertObjectWithPrivateProperties()
  173. {
  174. $this->setExpectedException('MongoException', 'zero-length keys are not allowed, did you use $ with double quotes?');
  175. $documents = [new PrivatePropertiesStub()];
  176. $this->getCollection()->batchInsert($documents);
  177. }
  178. public function testBatchInsertWithInvalidKey()
  179. {
  180. $documents = [['*' => 'foo']];
  181. $this->getCollection()->batchInsert($documents);
  182. $this->assertSame(1, $this->getCollection()->count(['*' => 'foo']));
  183. }
  184. public function testBatchInsertWithEmptyKey()
  185. {
  186. $this->setExpectedException('MongoException', 'zero-length keys are not allowed, did you use $ with double quotes?');
  187. $documents = [['' => 'foo']];
  188. $this->getCollection()->batchInsert($documents);
  189. }
  190. public function testBatchInsertWithNumericKey()
  191. {
  192. $documents = [['foo']];
  193. $this->getCollection()->batchInsert($documents);
  194. $this->assertSame(1, $this->getCollection()->count(['foo']));
  195. }
  196. public function testBatchInsertEmptyBatchException()
  197. {
  198. $this->setExpectedException('MongoException', 'No write ops were included in the batch');
  199. $documents = [];
  200. $this->getCollection()->batchInsert($documents, ['w' => 2]);
  201. }
  202. public function testUpdateWriteConcern()
  203. {
  204. $this->setExpectedException('MongoWriteConcernException', "cannot use 'w' > 1 when a host is not replicated");
  205. $this->getCollection()->update([], ['$set' => ['foo' => 'bar']], ['w' => 2]);
  206. }
  207. public function testUpdateOne()
  208. {
  209. $document = ['foo' => 'bar'];
  210. $this->getCollection()->insert($document);
  211. // Unset ID to re-insert
  212. unset($document['_id']);
  213. $this->getCollection()->insert($document);
  214. $expected = [
  215. 'ok' => 1.0,
  216. 'nModified' => 1,
  217. 'n' => 1,
  218. 'err' => null,
  219. 'errmsg' => null,
  220. 'updatedExisting' => true,
  221. ];
  222. $result = $this->getCollection()->update(['foo' => 'bar'], ['$set' => ['foo' => 'foo']]);
  223. $this->assertSame($expected, $result);
  224. $this->assertSame(1, $this->getCheckDatabase()->selectCollection('test')->count(['foo' => 'foo']));
  225. }
  226. public function testUpdateReplaceOne()
  227. {
  228. $document = ['foo' => 'bar', 'bar' => 'foo'];
  229. $this->getCollection()->insert($document);
  230. // Unset ID to re-insert
  231. unset($document['_id']);
  232. $this->getCollection()->insert($document);
  233. $expected = [
  234. 'ok' => 1.0,
  235. 'nModified' => 1,
  236. 'n' => 1,
  237. 'err' => null,
  238. 'errmsg' => null,
  239. 'updatedExisting' => true,
  240. ];
  241. $result = $this->getCollection()->update(['foo' => 'bar'], ['foo' => 'foo']);
  242. $this->assertSame($expected, $result);
  243. $this->assertSame(1, $this->getCheckDatabase()->selectCollection('test')->count(['foo' => 'foo']));
  244. $this->assertSame(1, $this->getCheckDatabase()->selectCollection('test')->count(['bar' => 'foo']));
  245. }
  246. public function testUpdateReplaceMultiple()
  247. {
  248. $this->setExpectedExceptionRegExp('MongoWriteConcernException', '/multi update only works with \$ operators/', 9);
  249. $this->getCollection()->update(['foo' => 'bar'], ['foo' => 'foo'], ['multiple' => true]);
  250. }
  251. public function testUpdateDuplicate()
  252. {
  253. $collection = $this->getCollection();
  254. $collection->createIndex(['foo' => 1], ['unique' => 1]);
  255. $document = ['foo' => 'bar'];
  256. $collection->insert($document);
  257. $document = ['foo' => 'foo'];
  258. $collection->insert($document);
  259. $this->setExpectedException('MongoDuplicateKeyException');
  260. $collection->update(['foo' => 'bar'], ['$set' => ['foo' => 'foo']]);
  261. }
  262. public function testUpdateMany()
  263. {
  264. $document = ['change' => true, 'foo' => 'bar'];
  265. $this->getCollection()->insert($document);
  266. unset($document['_id']);
  267. $this->getCollection()->insert($document);
  268. $document = ['change' => true, 'foo' => 'foo'];
  269. $this->getCollection()->insert($document);
  270. $expected = [
  271. 'ok' => 1.0,
  272. 'nModified' => 2,
  273. 'n' => 3,
  274. 'err' => null,
  275. 'errmsg' => null,
  276. 'updatedExisting' => true,
  277. ];
  278. $result = $this->getCollection()->update(['change' => true], ['$set' => ['foo' => 'foo']], ['multiple' => true]);
  279. $this->assertSame($expected, $result);
  280. $this->assertSame(3, $this->getCheckDatabase()->selectCollection('test')->count(['foo' => 'foo']));
  281. }
  282. public function testUnacknowledgedUpdate()
  283. {
  284. $document = ['foo' => 'bar'];
  285. $this->getCollection()->insert($document);
  286. unset($document['_id']);
  287. $this->getCollection()->insert($document);
  288. $this->assertTrue($this->getCollection()->update($document, ['$set' => ['foo' => 'foo']], ['w' => 0]));
  289. }
  290. public function testRemoveMultiple()
  291. {
  292. $document = ['change' => true, 'foo' => 'bar'];
  293. $this->getCollection()->insert($document);
  294. unset($document['_id']);
  295. $this->getCollection()->insert($document);
  296. $document = ['change' => true, 'foo' => 'foo'];
  297. $this->getCollection()->insert($document);
  298. $expected = [
  299. 'ok' => 1.0,
  300. 'n' => 2,
  301. 'err' => null,
  302. 'errmsg' => null,
  303. ];
  304. $result = $this->getCollection()->remove(['foo' => 'bar']);
  305. $this->assertSame($expected, $result);
  306. $this->assertSame(1, $this->getCheckDatabase()->selectCollection('test')->count());
  307. }
  308. public function testRemoveSingle()
  309. {
  310. $document = ['change' => true, 'foo' => 'bar'];
  311. $this->getCollection()->insert($document);
  312. unset($document['_id']);
  313. $this->getCollection()->insert($document);
  314. unset($document['_id']);
  315. $this->getCollection()->insert($document);
  316. $expected = [
  317. 'ok' => 1.0,
  318. 'n' => 1,
  319. 'err' => null,
  320. 'errmsg' => null,
  321. ];
  322. $result = $this->getCollection()->remove(['foo' => 'bar'], ['justOne' => true]);
  323. $this->assertSame($expected, $result);
  324. $this->assertSame(2, $this->getCheckDatabase()->selectCollection('test')->count());
  325. }
  326. public function testRemoveUnacknowledged()
  327. {
  328. $document = ['change' => true, 'foo' => 'bar'];
  329. $this->getCollection()->insert($document);
  330. unset($document['_id']);
  331. $this->getCollection()->insert($document);
  332. unset($document['_id']);
  333. $this->getCollection()->insert($document);
  334. $this->assertTrue($this->getCollection()->remove(['foo' => 'bar'], ['w' => 0]));
  335. }
  336. public function testFindReturnsCursor()
  337. {
  338. $this->prepareData();
  339. $collection = $this->getCollection();
  340. $this->assertInstanceOf('MongoCursor', $collection->find());
  341. }
  342. public function testCount()
  343. {
  344. $this->prepareData();
  345. $collection = $this->getCollection();
  346. $this->assertSame(3, $collection->count());
  347. $this->assertSame(2, $collection->count(['foo' => 'bar']));
  348. }
  349. public function testCountTimeout()
  350. {
  351. $this->failMaxTimeMS();
  352. $this->setExpectedException('MongoExecutionTimeoutException');
  353. $this->getCollection()->count([], ['maxTimeMS' => 1]);
  354. }
  355. public function testFindOne()
  356. {
  357. $this->prepareData();
  358. $document = $this->getCollection()->findOne(['foo' => 'foo'], ['_id' => false]);
  359. $this->assertSame(['foo' => 'foo'], $document);
  360. }
  361. public function testFindOneNotFound()
  362. {
  363. $document = $this->getCollection()->findOne(['foo' => 'foo'], ['_id' => false]);
  364. $this->assertNull($document);
  365. }
  366. public function testFindOneConnectionIssue()
  367. {
  368. $this->setExpectedException('MongoConnectionException');
  369. $client = $this->getClient([], 'mongodb://localhost:28888?connectTimeoutMS=1');
  370. $collection = $client->selectCollection('mongo-php-adapter', 'test');
  371. $collection->findOne();
  372. }
  373. public function testDistinct()
  374. {
  375. $this->prepareData();
  376. $values = $this->getCollection()->distinct('foo');
  377. $this->assertInternalType('array', $values);
  378. sort($values);
  379. $this->assertEquals(['bar', 'foo'], $values);
  380. }
  381. public function testDistinctWithQuery()
  382. {
  383. $this->prepareData();
  384. $values = $this->getCollection()->distinct('foo', ['foo' => 'bar']);
  385. $this->assertInternalType('array', $values);
  386. $this->assertEquals(['bar'], $values);
  387. }
  388. public function testAggregate()
  389. {
  390. $collection = $this->getCollection();
  391. $this->prepareData();
  392. $pipeline = [
  393. [
  394. '$group' => [
  395. '_id' => '$foo',
  396. 'count' => [ '$sum' => 1 ],
  397. ],
  398. ],
  399. [
  400. '$sort' => ['_id' => 1]
  401. ]
  402. ];
  403. $result = $collection->aggregate($pipeline);
  404. $this->assertInternalType('array', $result);
  405. $this->assertArrayHasKey('result', $result);
  406. $this->assertEquals([
  407. ['_id' => 'bar', 'count' => 2],
  408. ['_id' => 'foo', 'count' => 1],
  409. ], $result['result']);
  410. }
  411. public function testAggregateInvalidPipeline()
  412. {
  413. $collection = $this->getCollection();
  414. $pipeline = [
  415. [
  416. '$invalid' => []
  417. ],
  418. ];
  419. $this->setExpectedException('MongoResultException', 'Unrecognized pipeline stage name');
  420. $collection->aggregate($pipeline);
  421. }
  422. public function testAggregateTimeoutException()
  423. {
  424. $collection = $this->getCollection();
  425. $this->failMaxTimeMS();
  426. $this->setExpectedException('MongoExecutionTimeoutException');
  427. $pipeline = [
  428. [
  429. '$group' => [
  430. '_id' => '$foo',
  431. 'count' => [ '$sum' => 1 ],
  432. ],
  433. ],
  434. [
  435. '$sort' => ['_id' => 1]
  436. ]
  437. ];
  438. $collection->aggregate($pipeline, ['maxTimeMS' => 1]);
  439. }
  440. public function testAggregateCursor()
  441. {
  442. $collection = $this->getCollection();
  443. $this->prepareData();
  444. $pipeline = [
  445. [
  446. '$group' => [
  447. '_id' => '$foo',
  448. 'count' => [ '$sum' => 1 ],
  449. ],
  450. ],
  451. [
  452. '$sort' => ['_id' => 1]
  453. ]
  454. ];
  455. $cursor = $collection->aggregateCursor($pipeline);
  456. $this->assertInstanceOf('MongoCommandCursor', $cursor);
  457. $this->assertEquals([
  458. ['_id' => 'bar', 'count' => 2],
  459. ['_id' => 'foo', 'count' => 1],
  460. ], iterator_to_array($cursor));
  461. }
  462. public function testReadPreference()
  463. {
  464. $collection = $this->getCollection();
  465. $this->assertSame(['type' => \MongoClient::RP_PRIMARY], $collection->getReadPreference());
  466. $this->assertFalse($collection->getSlaveOkay());
  467. $this->assertTrue($collection->setReadPreference(\MongoClient::RP_SECONDARY, [['a' => 'b']]));
  468. $this->assertSame(['type' => \MongoClient::RP_SECONDARY, 'tagsets' => [['a' => 'b']]], $collection->getReadPreference());
  469. $this->assertTrue($collection->getSlaveOkay());
  470. $this->assertTrue($collection->setSlaveOkay(true));
  471. $this->assertSame(['type' => \MongoClient::RP_SECONDARY_PREFERRED, 'tagsets' => [['a' => 'b']]], $collection->getReadPreference());
  472. $this->assertTrue($collection->setSlaveOkay(false));
  473. $this->assertArraySubset(['type' => \MongoClient::RP_PRIMARY], $collection->getReadPreference());
  474. }
  475. public function testReadPreferenceIsSetInDriver()
  476. {
  477. $this->skipTestIf(extension_loaded('mongo'));
  478. $collection = $this->getCollection();
  479. $this->assertTrue($collection->setReadPreference(\MongoClient::RP_SECONDARY, [['a' => 'b']]));
  480. // Only way to check whether options are passed down is through debugInfo
  481. $readPreference = $collection->getCollection()->__debugInfo()['readPreference'];
  482. $this->assertSame(ReadPreference::RP_SECONDARY, $readPreference->getMode());
  483. $this->assertSame([['a' => 'b']], $readPreference->getTagSets());
  484. }
  485. public function testReadPreferenceIsInherited()
  486. {
  487. $database = $this->getDatabase();
  488. $database->setReadPreference(\MongoClient::RP_SECONDARY, [['a' => 'b']]);
  489. $collection = $database->selectCollection('test');
  490. $this->assertSame(['type' => \MongoClient::RP_SECONDARY, 'tagsets' => [['a' => 'b']]], $collection->getReadPreference());
  491. }
  492. public function testWriteConcern()
  493. {
  494. $collection = $this->getCollection();
  495. $this->assertTrue($collection->setWriteConcern('majority', 100));
  496. $this->assertSame(['w' => 'majority', 'wtimeout' => 100], $collection->getWriteConcern());
  497. }
  498. public function testWriteConcernIsSetInDriver()
  499. {
  500. $this->skipTestIf(extension_loaded('mongo'));
  501. $collection = $this->getCollection();
  502. $this->assertTrue($collection->setWriteConcern(2, 100));
  503. // Only way to check whether options are passed down is through debugInfo
  504. $writeConcern = $collection->getCollection()->__debugInfo()['writeConcern'];
  505. $this->assertSame(2, $writeConcern->getW());
  506. $this->assertSame(100, $writeConcern->getWtimeout());
  507. }
  508. public function testWriteConcernIsInherited()
  509. {
  510. $database = $this->getDatabase();
  511. $database->setWriteConcern('majority', 100);
  512. $collection = $database->selectCollection('test');
  513. $this->assertSame(['w' => 'majority', 'wtimeout' => 100], $collection->getWriteConcern());
  514. }
  515. public function testSaveInsert()
  516. {
  517. $id = '54203e08d51d4a1f868b456e';
  518. $collection = $this->getCollection();
  519. $objectId = new \MongoId($id);
  520. $expected = [
  521. 'ok' => 1.0,
  522. 'nModified' => 0,
  523. 'n' => 1,
  524. 'err' => null,
  525. 'errmsg' => null,
  526. 'upserted' => $objectId,
  527. 'updatedExisting' => false,
  528. ];
  529. $document = ['_id' => $objectId, 'foo' => 'bar'];
  530. $this->assertEquals($expected, $collection->save($document));
  531. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  532. $this->assertSame(1, $newCollection->count());
  533. $object = $newCollection->findOne();
  534. $this->assertNotNull($object);
  535. $this->assertAttributeInstanceOf('MongoDB\BSON\ObjectID', '_id', $object);
  536. $this->assertSame($id, (string) $object->_id);
  537. $this->assertObjectHasAttribute('foo', $object);
  538. $this->assertAttributeSame('bar', 'foo', $object);
  539. }
  540. public function testRemoveOne()
  541. {
  542. $id = '54203e08d51d4a1f868b456e';
  543. $collection = $this->getCollection();
  544. $document = ['_id' => new \MongoId($id), 'foo' => 'bar'];
  545. $collection->insert($document);
  546. $collection->remove(['_id' => new \MongoId($id)]);
  547. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  548. $this->assertSame(0, $newCollection->count());
  549. }
  550. public function testSaveUpdate()
  551. {
  552. $expected = [
  553. 'ok' => 1.0,
  554. 'nModified' => 1,
  555. 'n' => 1,
  556. 'err' => null,
  557. 'errmsg' => null,
  558. 'updatedExisting' => true,
  559. ];
  560. $id = '54203e08d51d4a1f868b456e';
  561. $collection = $this->getCollection();
  562. $insertDocument = ['_id' => new \MongoId($id), 'foo' => 'bar'];
  563. $saveDocument = ['_id' => new \MongoId($id), 'foo' => 'foo'];
  564. $collection->insert($insertDocument);
  565. $this->assertSame($expected, $collection->save($saveDocument));
  566. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  567. $this->assertSame(1, $newCollection->count());
  568. $object = $newCollection->findOne();
  569. $this->assertNotNull($object);
  570. $this->assertAttributeInstanceOf('MongoDB\BSON\ObjectID', '_id', $object);
  571. $this->assertSame($id, (string) $object->_id);
  572. $this->assertObjectHasAttribute('foo', $object);
  573. $this->assertAttributeSame('foo', 'foo', $object);
  574. }
  575. public function testSavingShouldReplaceTheWholeDocument() {
  576. $id = '54203e08d51d4a1f868b456e';
  577. $collection = $this->getCollection();
  578. $insertDocument = ['_id' => new \MongoId($id), 'foo' => 'bar'];
  579. $saveDocument = ['_id' => new \MongoId($id)];
  580. $collection->insert($insertDocument);
  581. $collection->save($saveDocument);
  582. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  583. $this->assertSame(1, $newCollection->count());
  584. $object = $newCollection->findOne();
  585. $this->assertNotNull($object);
  586. $this->assertObjectNotHasAttribute('foo', $object);
  587. }
  588. public function testSaveDuplicate()
  589. {
  590. $collection = $this->getCollection();
  591. $collection->createIndex(['foo' => 1], ['unique' => true]);
  592. $document = ['foo' => 'bar'];
  593. $collection->save($document);
  594. $this->setExpectedException('MongoDuplicateKeyException');
  595. unset($document['_id']);
  596. $collection->save($document);
  597. }
  598. public function testSaveEmptyKeys()
  599. {
  600. $document = [];
  601. $this->getCollection()->save($document);
  602. $this->assertSame(1, $this->getCollection()->count());
  603. }
  604. public function testSaveEmptyObject()
  605. {
  606. $document = (object) [];
  607. $this->getCollection()->save($document);
  608. $this->assertSame(1, $this->getCollection()->count());
  609. }
  610. public function testGetDBRef()
  611. {
  612. $collection = $this->getCollection();
  613. $insertDocument = ['_id' => 1, 'foo' => 'bar'];
  614. $collection->insert($insertDocument);
  615. $document = $collection->getDBRef([
  616. '$ref' => 'test',
  617. '$id' => 1,
  618. ]);
  619. $this->assertEquals($insertDocument, $document);
  620. }
  621. public function testCreateDBRef()
  622. {
  623. $collection = $this->getCollection();
  624. $reference = $collection->createDBRef(['_id' => 'foo']);
  625. $this->assertSame(
  626. [
  627. '$ref' => 'test',
  628. '$id' => 'foo',
  629. ],
  630. $reference
  631. );
  632. }
  633. public function testCreateIndex()
  634. {
  635. $expected = [
  636. 'createdCollectionAutomatically' => true,
  637. 'numIndexesBefore' => 1,
  638. 'numIndexesAfter' => 2,
  639. 'ok' => 1.0,
  640. ];
  641. $collection = $this->getCollection();
  642. $this->assertSame($expected, $collection->createIndex(['foo' => 1]));
  643. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  644. $iterator = $newCollection->listIndexes();
  645. $indexes = iterator_to_array($iterator);
  646. $this->assertCount(2, $indexes);
  647. $index = $indexes[1];
  648. $this->assertSame(['foo' => 1], $index->getKey());
  649. $this->assertSame('mongo-php-adapter.test', $index->getNamespace());
  650. }
  651. public function testCreateIndexInvalid()
  652. {
  653. $this->setExpectedException('MongoException', 'index specification has no elements');
  654. $this->getCollection()->createIndex([]);
  655. }
  656. public function testCreateIndexTwice()
  657. {
  658. $this->getCollection()->createIndex(['foo' => 1]);
  659. $expected = [
  660. 'createdCollectionAutomatically' => false,
  661. 'numIndexesBefore' => 2,
  662. 'numIndexesAfter' => 2,
  663. 'note' => 'all indexes already exist',
  664. 'ok' => 1.0
  665. ];
  666. $this->assertSame($expected, $this->getCollection()->createIndex(['foo' => 1]));
  667. }
  668. public function testCreateIndexWithDeprecatedOptions()
  669. {
  670. $this->getCollection()->createIndex(['foo' => 1], ['w' => 1]);
  671. $expected = [
  672. 'createdCollectionAutomatically' => false,
  673. 'numIndexesBefore' => 2,
  674. 'numIndexesAfter' => 2,
  675. 'note' => 'all indexes already exist',
  676. 'ok' => 1.0
  677. ];
  678. $this->assertSame($expected, $this->getCollection()->createIndex(['foo' => 1]));
  679. }
  680. public function testCreateIndexTwiceWithSameName()
  681. {
  682. $this->getCollection()->createIndex(['foo' => 1], ['name' => 'test_index']);
  683. $expected = [
  684. 'createdCollectionAutomatically' => false,
  685. 'numIndexesBefore' => 2,
  686. 'numIndexesAfter' => 2,
  687. 'note' => 'all indexes already exist',
  688. 'ok' => 1.0
  689. ];
  690. $this->assertSame($expected, $this->getCollection()->createIndex(['foo' => 1], ['name' => 'test_index']));
  691. }
  692. public function testCreateIndexTwiceWithDifferentName()
  693. {
  694. $this->getCollection()->createIndex(['foo' => 1], ['name' => 'test_index']);
  695. $expected = [
  696. 'createdCollectionAutomatically' => false,
  697. 'numIndexesBefore' => 2,
  698. 'numIndexesAfter' => 2,
  699. 'note' => 'all indexes already exist',
  700. 'ok' => 1.0
  701. ];
  702. $this->assertSame($expected, $this->getCollection()->createIndex(['foo' => 1], ['name' => 'index_test']));
  703. }
  704. public function testCreateIndexTwiceWithDifferentOrder()
  705. {
  706. $this->getCollection()->createIndex(['foo' => 1, 'bar' => 1]);
  707. $expected = [
  708. 'createdCollectionAutomatically' => false,
  709. 'numIndexesBefore' => 2,
  710. 'numIndexesAfter' => 3,
  711. 'ok' => 1.0
  712. ];
  713. $this->assertSame($expected, $this->getCollection()->createIndex(['bar' => 1, 'foo' => 1]));
  714. }
  715. public function testCreateIndexesWithDifferentOptions()
  716. {
  717. $this->setExpectedException('MongoResultException');
  718. $this->getCollection()->createIndex(['foo' => 1]);
  719. $this->getCollection()->createIndex(['foo' => 1], ['unique' => true]);
  720. }
  721. /**
  722. * @dataProvider createIndexIgnoredOptions
  723. */
  724. public function testCreateIndexesWithIgnoredOptions($option)
  725. {
  726. $this->getCollection()->createIndex(['foo' => 1]);
  727. $expected = [
  728. 'createdCollectionAutomatically' => false,
  729. 'numIndexesBefore' => 2,
  730. 'numIndexesAfter' => 2,
  731. 'note' => 'all indexes already exist',
  732. 'ok' => 1.0
  733. ];
  734. $this->assertSame($expected, $this->getCollection()->createIndex(['foo' => 1], [$option => true]));
  735. }
  736. public static function createIndexIgnoredOptions()
  737. {
  738. return [
  739. 'background' => ['background'],
  740. 'dropDups' => ['dropDups'],
  741. ];
  742. }
  743. public function testCreateIndexWithSameNameAndDifferentOptions()
  744. {
  745. $this->setExpectedException('MongoResultException');
  746. $this->getCollection()->createIndex(['foo' => 1], ['name' => 'foo']);
  747. $this->getCollection()->createIndex(['bar' => 1], ['name' => 'foo']);
  748. }
  749. public function testEnsureIndex()
  750. {
  751. $expected = [
  752. 'createdCollectionAutomatically' => true,
  753. 'numIndexesBefore' => 1,
  754. 'numIndexesAfter' => 2,
  755. 'ok' => 1.0
  756. ];
  757. $collection = $this->getCollection();
  758. $this->assertEquals($expected, $collection->ensureIndex(['bar' => 1], ['unique' => true]));
  759. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  760. $indexes = iterator_to_array($newCollection->listIndexes());
  761. $this->assertCount(2, $indexes);
  762. $index = $indexes[1];
  763. $this->assertSame(['bar' => 1], $index->getKey());
  764. $this->assertTrue($index->isUnique());
  765. $this->assertSame('mongo-php-adapter.test', $index->getNamespace());
  766. }
  767. public function testEnsureIndexAlreadyExists()
  768. {
  769. $collection = $this->getCollection();
  770. $collection->ensureIndex(['bar' => 1], ['unique' => true]);
  771. $expected = [
  772. 'createdCollectionAutomatically' => false,
  773. 'numIndexesBefore' => 2,
  774. 'numIndexesAfter' => 2,
  775. 'ok' => 1.0,
  776. 'note' => 'all indexes already exist',
  777. ];
  778. $this->assertEquals($expected, $collection->ensureIndex(['bar' => 1], ['unique' => true]));
  779. }
  780. public function testEnsureIndexAlreadyExistsWithDifferentOptions()
  781. {
  782. $collection = $this->getCollection();
  783. $collection->ensureIndex(['bar' => 1], ['unique' => true]);
  784. $this->setExpectedException('MongoResultException', 'Index with name: bar_1 already exists with different options');
  785. $collection->ensureIndex(['bar' => 1]);
  786. }
  787. public function testDeleteIndexUsingIndexName()
  788. {
  789. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  790. $newCollection->createIndex(['bar' => 1], ['name' => 'bar']);
  791. $expected = [
  792. 'nIndexesWas' => 2,
  793. 'errmsg' => 'index not found with name [bar_1]',
  794. 'ok' => 0.0,
  795. 'code' => 27,
  796. ];
  797. $this->assertEquals($expected, $this->getCollection()->deleteIndex('bar'));
  798. $this->assertCount(2, iterator_to_array($newCollection->listIndexes()));
  799. }
  800. public function testDeleteIndexUsingField()
  801. {
  802. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  803. $newCollection->createIndex(['bar' => 1]);
  804. $expected = [
  805. 'nIndexesWas' => 2,
  806. 'ok' => 1.0,
  807. ];
  808. $this->assertSame($expected, $this->getCollection()->deleteIndex('bar'));
  809. $this->assertCount(1, iterator_to_array($newCollection->listIndexes()));
  810. }
  811. public function testDeleteIndexUsingKeys()
  812. {
  813. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  814. $newCollection->createIndex(['bar' => 1]);
  815. $expected = [
  816. 'nIndexesWas' => 2,
  817. 'ok' => 1.0,
  818. ];
  819. $this->assertSame($expected, $this->getcollection()->deleteIndex(['bar' => 1]));
  820. $this->assertCount(1, iterator_to_array($newCollection->listIndexes()));
  821. }
  822. public function testDeleteIndexes()
  823. {
  824. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  825. $newCollection->createIndex(['bar' => 1]);
  826. $expected = [
  827. 'nIndexesWas' => 2,
  828. 'msg' => 'non-_id indexes dropped for collection',
  829. 'ok' => 1.0,
  830. ];
  831. $this->assertSame($expected, $this->getcollection()->deleteIndexes());
  832. $this->assertCount(1, iterator_to_array($newCollection->listIndexes())); // ID index is present by default
  833. }
  834. public function testDeleteIndexesForNonExistingCollection()
  835. {
  836. $expected = [
  837. 'ok' => 0.0,
  838. 'errmsg' => 'ns not found',
  839. 'code' => 26,
  840. ];
  841. $this->assertSame($expected, $this->getcollection('nonExisting')->deleteIndexes());
  842. }
  843. public function testGetIndexInfo()
  844. {
  845. $collection = $this->getCollection();
  846. $collection->createIndex(['foo' => 1]);
  847. $expected = [
  848. [
  849. 'v' => 1,
  850. 'key' => ['_id' => 1],
  851. 'name' => '_id_',
  852. 'ns' => 'mongo-php-adapter.test',
  853. ],
  854. [
  855. 'v' => 1,
  856. 'key' => ['foo' => 1],
  857. 'name' => 'foo_1',
  858. 'ns' => 'mongo-php-adapter.test',
  859. ],
  860. ];
  861. $this->assertSame(
  862. $expected,
  863. $collection->getIndexInfo()
  864. );
  865. }
  866. public function testFindAndModifyUpdate()
  867. {
  868. $id = '54203e08d51d4a1f868b456e';
  869. $collection = $this->getCollection();
  870. $document = ['_id' => new \MongoId($id), 'foo' => 'bar'];
  871. $collection->insert($document);
  872. $document = $collection->findAndModify(
  873. ['_id' => new \MongoId($id)],
  874. ['$set' => ['foo' => 'foo']]
  875. );
  876. $this->assertSame('bar', $document['foo']);
  877. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  878. $this->assertSame(1, $newCollection->count());
  879. $object = $newCollection->findOne();
  880. $this->assertNotNull($object);
  881. $this->assertAttributeSame('foo', 'foo', $object);
  882. }
  883. public function testFindAndModifyUpdateReplace()
  884. {
  885. $id = '54203e08d51d4a1f868b456e';
  886. $collection = $this->getCollection();
  887. $document = ['_id' => new \MongoId($id), 'foo' => 'bar'];
  888. $collection->insert($document);
  889. $document = $collection->findAndModify(
  890. ['_id' => new \MongoId($id)],
  891. ['_id' => new \MongoId($id), 'foo' => 'boo']
  892. );
  893. $this->assertSame('bar', $document['foo']);
  894. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  895. $this->assertSame(1, $newCollection->count());
  896. $object = $newCollection->findOne();
  897. $this->assertNotNull($object);
  898. $this->assertAttributeSame('boo', 'foo', $object);
  899. $this->assertObjectNotHasAttribute('bar', $object);
  900. }
  901. public function testFindAndModifyUpdateReturnNew()
  902. {
  903. $id = '54203e08d51d4a1f868b456e';
  904. $collection = $this->getCollection();
  905. $document = ['_id' => new \MongoId($id), 'foo' => 'bar'];
  906. $collection->insert($document);
  907. $document = $collection->findAndModify(
  908. ['_id' => new \MongoId($id)],
  909. ['$set' => ['foo' => 'foo']],
  910. null,
  911. ['new' => true]
  912. );
  913. $this->assertSame('foo', $document['foo']);
  914. }
  915. public function testFindAndModifyWithFields()
  916. {
  917. $id = '54203e08d51d4a1f868b456e';
  918. $collection = $this->getCollection();
  919. $document = [
  920. '_id' => new \MongoId($id),
  921. 'foo' => 'bar',
  922. 'bar' => 'foo',
  923. ];
  924. $collection->insert($document);
  925. $document = $collection->findAndModify(
  926. ['_id' => new \MongoId($id)],
  927. ['$set' => ['foo' => 'foo']],
  928. ['foo' => true]
  929. );
  930. $this->assertArrayNotHasKey('bar', $document);
  931. $this->assertArrayHasKey('foo', $document);
  932. }
  933. public function testGroup()
  934. {
  935. $collection = $this->getCollection();
  936. $document1 = ['a' => 2];
  937. $collection->insert($document1);
  938. $document2 = ['b' => 5];
  939. $collection->insert($document2);
  940. $document3 = ['a' => 1];
  941. $collection->insert($document3);
  942. $keys = [];
  943. $initial = ["count" => 0];
  944. $reduce = "function (obj, prev) { prev.count++; }";
  945. $condition = ['condition' => ["a" => [ '$gt' => 1]]];
  946. $result = $collection->group($keys, $initial, $reduce, $condition);
  947. $this->assertArraySubset(
  948. [
  949. 'retval' => [['count' => 1.0]],
  950. 'count' => 1.0,
  951. 'keys' => 1,
  952. 'ok' => 1.0,
  953. ],
  954. $result
  955. );
  956. }
  957. public function testMapReduce()
  958. {
  959. $data = array(
  960. array(
  961. 'username' => 'jones',
  962. 'likes' => 20.0,
  963. 'text' => 'Hello world!'
  964. ),
  965. array(
  966. 'username' => 'bob',
  967. 'likes' => 100.0,
  968. 'text' => 'Hello world!'
  969. ),
  970. array(
  971. 'username' => 'bob',
  972. 'likes' => 100.0,
  973. 'text' => 'Hello world!'
  974. ),
  975. );
  976. $collection = $this->getCollection();
  977. $collection->batchInsert($data);
  978. $map = 'function() {
  979. emit(this.username, { count: 1, likes: this.likes });
  980. }';
  981. $reduce = 'function(key, values) {
  982. var result = {count: 0, likes: 0};
  983. values.forEach(function(value) {
  984. result.count += value.count;
  985. result.likes += value.likes;
  986. });
  987. return result;
  988. }';
  989. $finalize = 'function (key, value) { value.test = "test"; return value; }';
  990. $command = [
  991. 'mapreduce' => $this->getCollection()->getName(),
  992. 'map' => new \MongoCode($map),
  993. 'reduce' => new \MongoCode($reduce),
  994. 'query' => (object) [],
  995. 'out' => ['inline' => true],
  996. 'finalize' => new \MongoCode($finalize),
  997. ];
  998. $result = $this->getDatabase()->command($command);
  999. $expected = [
  1000. [
  1001. '_id' => 'bob',
  1002. 'value' => [
  1003. 'count' => 2.0,
  1004. 'likes' => 200.0,
  1005. 'test' => 'test',
  1006. ],
  1007. ],
  1008. [
  1009. '_id' => 'jones',
  1010. 'value' => [
  1011. 'count' => 1.0,
  1012. 'likes' => 20.0,
  1013. 'test' => 'test',
  1014. ],
  1015. ],
  1016. ];
  1017. $this->assertSame(1.0, $result['ok']);
  1018. $this->assertSame($expected, $result['results']);
  1019. }
  1020. public function testFindAndModifyResultException()
  1021. {
  1022. $this->markTestSkipped('Test fails on travis-ci - skipped while investigating this');
  1023. $collection = $this->getCollection();
  1024. $this->setExpectedException('MongoResultException');
  1025. $collection->findAndModify(
  1026. array("inprogress" => false, "name" => "Next promo"),
  1027. array('$unsupportedOperator' => array("tasks" => -1)),
  1028. array("tasks" => true),
  1029. array("new" => true)
  1030. );
  1031. }
  1032. public function testFindAndModifyExceptionTimeout()
  1033. {
  1034. $this->failMaxTimeMS();
  1035. $id = '54203e08d51d4a1f868b456e';
  1036. $collection = $this->getCollection();
  1037. $this->setExpectedException('MongoExecutionTimeoutException');
  1038. $document = $collection->findAndModify(
  1039. ['_id' => new \MongoId($id)],
  1040. null,
  1041. null,
  1042. ['maxTimeMS' => 1, 'remove' => true]
  1043. );
  1044. }
  1045. public function testFindAndModifyRemove()
  1046. {
  1047. $id = '54203e08d51d4a1f868b456e';
  1048. $collection = $this->getCollection();
  1049. $document = ['_id' => new \MongoId($id), 'foo' => 'bar'];
  1050. $collection->insert($document);
  1051. $document = $collection->findAndModify(
  1052. ['_id' => new \MongoId($id)],
  1053. null,
  1054. null,
  1055. ['remove' => true]
  1056. );
  1057. $this->assertEquals('bar', $document['foo']);
  1058. $newCollection = $this->getCheckDatabase()->selectCollection('test');
  1059. $this->assertSame(0, $newCollection->count());
  1060. }
  1061. public function testValidate()
  1062. {
  1063. $collection = $this->getCollection();
  1064. $document = ['foo' => 'bar'];
  1065. $collection->insert($document);
  1066. $result = $collection->validate();
  1067. $this->assertArraySubset(
  1068. [
  1069. 'ns' => 'mongo-php-adapter.test',
  1070. 'nrecords' => 1,
  1071. 'nIndexes' => 1,
  1072. 'keysPerIndex' => ['mongo-php-adapter.test.$_id_' => 1],
  1073. 'valid' => true,
  1074. 'errors' => [],
  1075. 'warning' => 'Some checks omitted for speed. use {full:true} option to do more thorough scan.',
  1076. 'ok' => 1.0
  1077. ],
  1078. $result
  1079. );
  1080. }
  1081. public function testDrop()
  1082. {
  1083. $document = ['foo' => 'bar'];
  1084. $this->getCollection()->insert($document);
  1085. $expected = [
  1086. 'ns' => (string) $this->getCollection(),
  1087. 'nIndexesWas' => 1,
  1088. 'ok' => 1.0
  1089. ];
  1090. $this->assertSame($expected, $this->getCollection()->drop());
  1091. }
  1092. public function testEmptyCollectionName()
  1093. {
  1094. $this->setExpectedException('Exception', 'Collection name cannot be empty');
  1095. new \MongoCollection($this->getDatabase(), '');
  1096. }
  1097. public function testSelectCollectionWithNullBytes()
  1098. {
  1099. $this->setExpectedException('Exception', 'Collection name cannot contain null bytes');
  1100. new \MongoCollection($this->getDatabase(), 'foo' . chr(0));
  1101. }
  1102. public function testSubCollectionWithNullBytes()
  1103. {
  1104. $collection = $this->getCollection();
  1105. $this->assertInstanceOf('MongoCollection', $collection->{'foo' . chr(0)});
  1106. $this->assertSame('test', $collection->getName());
  1107. }
  1108. }
  1109. class PrivatePropertiesStub
  1110. {
  1111. private $foo = 'bar';
  1112. }