| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686 |
- <?php
- namespace Alcaeus\MongoDbAdapter\Tests;
- use MongoDB\Driver\ReadPreference;
- /**
- * @author alcaeus <alcaeus@alcaeus.org>
- */
- class MongoCollectionTest extends TestCase
- {
- public function testGetNestedCollections()
- {
- $collection = $this->getCollection()->foo->bar;
- $this->assertSame('mongo-php-adapter.test.foo.bar', (string) $collection);
- }
- public function testCreateRecord()
- {
- $collection = $this->getCollection();
- $expected = [
- 'ok' => 1.0,
- 'n' => 0,
- 'err' => null,
- 'errmsg' => null,
- ];
- $document = ['foo' => 'bar'];
- $this->assertSame($expected, $collection->insert($document));
- $this->assertInstanceOf('MongoId', $document['_id']);
- $id = (string) $document['_id'];
- $newCollection = $this->getCheckDatabase()->selectCollection('test');
- $this->assertSame(1, $newCollection->count());
- $object = $newCollection->findOne();
- $this->assertNotNull($object);
- $this->assertAttributeInstanceOf('MongoDB\BSON\ObjectID', '_id', $object);
- $this->assertSame($id, (string) $object->_id);
- $this->assertObjectHasAttribute('foo', $object);
- $this->assertAttributeSame('bar', 'foo', $object);
- }
- public function testUnacknowledgedWrite()
- {
- $document = ['foo' => 'bar'];
- $this->assertTrue($this->getCollection()->insert($document, ['w' => 0]));
- }
- public function testInsertMany()
- {
- $expected = [
- 'connectionId' => 0,
- 'n' => 0,
- 'syncMillis' => 0,
- 'writtenTo' => null,
- 'err' => null,
- 'errmsg' => null
- ];
- $documents = [
- ['foo' => 'bar'],
- ['bar' => 'foo']
- ];
- $this->assertSame($expected, $this->getCollection()->batchInsert($documents));
- foreach ($documents as $document) {
- $this->assertInstanceOf('MongoId', $document['_id']);
- }
- }
- public function testInsertManyWithNonNumericKeys()
- {
- $expected = [
- 'connectionId' => 0,
- 'n' => 0,
- 'syncMillis' => 0,
- 'writtenTo' => null,
- 'err' => null,
- 'errmsg' => null
- ];
- $documents = [
- 'a' => ['foo' => 'bar'],
- 'b' => ['bar' => 'foo']
- ];
- $this->assertSame($expected, $this->getCollection()->batchInsert($documents));
- }
- public function testUpdateOne()
- {
- $document = ['foo' => 'bar'];
- $this->getCollection()->insert($document);
- // Unset ID to re-insert
- unset($document['_id']);
- $this->getCollection()->insert($document);
- $expected = [
- 'ok' => 1.0,
- 'nModified' => 1,
- 'n' => 1,
- 'err' => null,
- 'errmsg' => null,
- 'updatedExisting' => true,
- ];
- $result = $this->getCollection()->update(['foo' => 'bar'], ['$set' => ['foo' => 'foo']]);
- $this->assertSame($expected, $result);
- $this->assertSame(1, $this->getCheckDatabase()->selectCollection('test')->count(['foo' => 'foo']));
- }
- public function testUpdateMany()
- {
- $document = ['change' => true, 'foo' => 'bar'];
- $this->getCollection()->insert($document);
- unset($document['_id']);
- $this->getCollection()->insert($document);
- $document = ['change' => true, 'foo' => 'foo'];
- $this->getCollection()->insert($document);
- $expected = [
- 'ok' => 1.0,
- 'nModified' => 2,
- 'n' => 3,
- 'err' => null,
- 'errmsg' => null,
- 'updatedExisting' => true,
- ];
- $result = $this->getCollection()->update(['change' => true], ['$set' => ['foo' => 'foo']], ['multiple' => true]);
- $this->assertSame($expected, $result);
- $this->assertSame(3, $this->getCheckDatabase()->selectCollection('test')->count(['foo' => 'foo']));
- }
- public function testUnacknowledgedUpdate()
- {
- $document = ['foo' => 'bar'];
- $this->getCollection()->insert($document);
- unset($document['_id']);
- $this->getCollection()->insert($document);
- $this->assertTrue($this->getCollection()->update($document, ['$set' => ['foo' => 'foo']], ['w' => 0]));
- }
- public function testRemoveMultiple()
- {
- $document = ['change' => true, 'foo' => 'bar'];
- $this->getCollection()->insert($document);
- unset($document['_id']);
- $this->getCollection()->insert($document);
- $document = ['change' => true, 'foo' => 'foo'];
- $this->getCollection()->insert($document);
- $expected = [
- 'ok' => 1.0,
- 'n' => 2,
- 'err' => null,
- 'errmsg' => null,
- ];
- $result = $this->getCollection()->remove(['foo' => 'bar']);
- $this->assertSame($expected, $result);
- $this->assertSame(1, $this->getCheckDatabase()->selectCollection('test')->count());
- }
- public function testRemoveSingle()
- {
- $document = ['change' => true, 'foo' => 'bar'];
- $this->getCollection()->insert($document);
- unset($document['_id']);
- $this->getCollection()->insert($document);
- unset($document['_id']);
- $this->getCollection()->insert($document);
- $expected = [
- 'ok' => 1.0,
- 'n' => 1,
- 'err' => null,
- 'errmsg' => null,
- ];
- $result = $this->getCollection()->remove(['foo' => 'bar'], ['justOne' => true]);
- $this->assertSame($expected, $result);
- $this->assertSame(2, $this->getCheckDatabase()->selectCollection('test')->count());
- }
- public function testRemoveUnacknowledged()
- {
- $document = ['change' => true, 'foo' => 'bar'];
- $this->getCollection()->insert($document);
- unset($document['_id']);
- $this->getCollection()->insert($document);
- unset($document['_id']);
- $this->getCollection()->insert($document);
- $this->assertTrue($this->getCollection()->remove(['foo' => 'bar'], ['w' => 0]));
- }
- public function testFindReturnsCursor()
- {
- $this->prepareData();
- $collection = $this->getCollection();
- $this->assertInstanceOf('MongoCursor', $collection->find());
- }
- public function testCount()
- {
- $this->prepareData();
- $collection = $this->getCollection();
- $this->assertSame(3, $collection->count());
- $this->assertSame(2, $collection->count(['foo' => 'bar']));
- }
- public function testFindOne()
- {
- $this->prepareData();
- $document = $this->getCollection()->findOne(['foo' => 'foo'], ['_id' => false]);
- $this->assertSame(['foo' => 'foo'], $document);
- }
- public function testDistinct()
- {
- $this->prepareData();
- $values = $this->getCollection()->distinct('foo');
- $this->assertInternalType('array', $values);
- sort($values);
- $this->assertEquals(['bar', 'foo'], $values);
- }
- public function testDistinctWithQuery()
- {
- $this->prepareData();
- $values = $this->getCollection()->distinct('foo', ['foo' => 'bar']);
- $this->assertInternalType('array', $values);
- $this->assertEquals(['bar'], $values);
- }
- public function testAggregate()
- {
- $collection = $this->getCollection();
- $this->prepareData();
- $pipeline = [
- [
- '$group' => [
- '_id' => '$foo',
- 'count' => [ '$sum' => 1 ],
- ],
- ],
- [
- '$sort' => ['_id' => 1]
- ]
- ];
- $result = $collection->aggregate($pipeline);
- $this->assertInternalType('array', $result);
- $this->assertArrayHasKey('result', $result);
- $this->assertEquals([
- ['_id' => 'bar', 'count' => 2],
- ['_id' => 'foo', 'count' => 1],
- ], $result['result']);
- }
- public function testAggregateCursor()
- {
- $collection = $this->getCollection();
- $this->prepareData();
- $pipeline = [
- [
- '$group' => [
- '_id' => '$foo',
- 'count' => [ '$sum' => 1 ],
- ],
- ],
- [
- '$sort' => ['_id' => 1]
- ]
- ];
- $cursor = $collection->aggregateCursor($pipeline);
- $this->assertInstanceOf('MongoCommandCursor', $cursor);
- $this->assertEquals([
- ['_id' => 'bar', 'count' => 2],
- ['_id' => 'foo', 'count' => 1],
- ], iterator_to_array($cursor));
- }
- public function testReadPreference()
- {
- $collection = $this->getCollection();
- $this->assertSame(['type' => \MongoClient::RP_PRIMARY], $collection->getReadPreference());
- $this->assertFalse($collection->getSlaveOkay());
- $this->assertTrue($collection->setReadPreference(\MongoClient::RP_SECONDARY, ['a' => 'b']));
- $this->assertSame(['type' => \MongoClient::RP_SECONDARY, 'tagsets' => ['a' => 'b']], $collection->getReadPreference());
- $this->assertTrue($collection->getSlaveOkay());
- // Only way to check whether options are passed down is through debugInfo
- $writeConcern = $collection->getCollection()->__debugInfo()['readPreference'];
- $this->assertSame(ReadPreference::RP_SECONDARY, $writeConcern->getMode());
- $this->assertSame(['a' => 'b'], $writeConcern->getTagSets());
- $this->assertTrue($collection->setSlaveOkay(true));
- $this->assertSame(['type' => \MongoClient::RP_SECONDARY_PREFERRED, 'tagsets' => ['a' => 'b']], $collection->getReadPreference());
- $this->assertTrue($collection->setSlaveOkay(false));
- $this->assertSame(['type' => \MongoClient::RP_PRIMARY], $collection->getReadPreference());
- }
- public function testReadPreferenceIsInherited()
- {
- $database = $this->getDatabase();
- $database->setReadPreference(\MongoClient::RP_SECONDARY, ['a' => 'b']);
- $collection = $database->selectCollection('test');
- $this->assertSame(['type' => \MongoClient::RP_SECONDARY, 'tagsets' => ['a' => 'b']], $collection->getReadPreference());
- }
- public function testWriteConcern()
- {
- $collection = $this->getCollection();
- $this->assertSame(['w' => 1, 'wtimeout' => 0], $collection->getWriteConcern());
- $this->assertSame(1, $collection->w);
- $this->assertSame(0, $collection->wtimeout);
- $this->assertTrue($collection->setWriteConcern('majority', 100));
- $this->assertSame(['w' => 'majority', 'wtimeout' => 100], $collection->getWriteConcern());
- $collection->w = 2;
- $this->assertSame(['w' => 2, 'wtimeout' => 100], $collection->getWriteConcern());
- $collection->wtimeout = -1;
- $this->assertSame(['w' => 2, 'wtimeout' => 0], $collection->getWriteConcern());
- // Only way to check whether options are passed down is through debugInfo
- $writeConcern = $collection->getCollection()->__debugInfo()['writeConcern'];
- $this->assertSame(2, $writeConcern->getW());
- $this->assertSame(0, $writeConcern->getWtimeout());
- }
- public function testWriteConcernIsInherited()
- {
- $database = $this->getDatabase();
- $database->setWriteConcern('majority', 100);
- $collection = $database->selectCollection('test');
- $this->assertSame(['w' => 'majority', 'wtimeout' => 100], $collection->getWriteConcern());
- }
- public function testSaveInsert()
- {
- $collection = $this->getCollection();
- $document = ['foo' => 'bar'];
- $collection->save($document);
- $this->assertInstanceOf('MongoId', $document['_id']);
- $id = (string) $document['_id'];
- $newCollection = $this->getCheckDatabase()->selectCollection('test');
- $this->assertSame(1, $newCollection->count());
- $object = $newCollection->findOne();
- $this->assertNotNull($object);
- $this->assertAttributeInstanceOf('MongoDB\BSON\ObjectID', '_id', $object);
- $this->assertSame($id, (string) $object->_id);
- $this->assertObjectHasAttribute('foo', $object);
- $this->assertAttributeSame('bar', 'foo', $object);
- }
- public function testRemoveOne()
- {
- $id = '54203e08d51d4a1f868b456e';
- $collection = $this->getCollection();
- $document = ['_id' => new \MongoId($id), 'foo' => 'bar'];
- $collection->insert($document);
- $collection->remove(['_id' => new \MongoId($id)]);
- $newCollection = $this->getCheckDatabase()->selectCollection('test');
- $this->assertSame(0, $newCollection->count());
- }
- public function testSaveUpdate()
- {
- $id = '54203e08d51d4a1f868b456e';
- $collection = $this->getCollection();
- $insertDocument = ['_id' => new \MongoId($id), 'foo' => 'bar'];
- $saveDocument = ['_id' => new \MongoId($id), 'foo' => 'foo'];
- $collection->insert($insertDocument);
- $collection->save($saveDocument);
- $newCollection = $this->getCheckDatabase()->selectCollection('test');
- $this->assertSame(1, $newCollection->count());
- $object = $newCollection->findOne();
- $this->assertNotNull($object);
- $this->assertAttributeInstanceOf('MongoDB\BSON\ObjectID', '_id', $object);
- $this->assertSame($id, (string) $object->_id);
- $this->assertObjectHasAttribute('foo', $object);
- $this->assertAttributeSame('foo', 'foo', $object);
- }
- public function testGetDBRef()
- {
- $collection = $this->getCollection();
- $insertDocument = ['_id' => 1, 'foo' => 'bar'];
- $collection->insert($insertDocument);
- $document = $collection->getDBRef([
- '$ref' => 'test',
- '$id' => 1,
- ]);
- $this->assertEquals($insertDocument, $document);
- }
- public function testCreateDBRef()
- {
- $collection = $this->getCollection();
- $reference = $collection->createDBRef(['_id' => 'foo']);
- $this->assertSame(
- [
- '$ref' => 'test',
- '$id' => 'foo',
- ],
- $reference
- );
- }
- public function testCreateIndex()
- {
- $collection = $this->getCollection();
- $collection->createIndex(['foo' => 1]);
- $newCollection = $this->getCheckDatabase()->selectCollection('test');
- $iterator = $newCollection->listIndexes();
- $indexes = iterator_to_array($iterator);
- $this->assertCount(2, $indexes);
- $index = $indexes[1];
- $this->assertSame(['foo' => 1], $index->getKey());
- $this->assertSame('mongo-php-adapter.test', $index->getNamespace());
- }
- public function testEnsureIndex()
- {
- $collection = $this->getCollection();
- $this->assertTrue($collection->ensureIndex(['bar' => 1], ['unique' => true]));
- $newCollection = $this->getCheckDatabase()->selectCollection('test');
- $indexes = iterator_to_array($newCollection->listIndexes());
- $this->assertCount(2, $indexes);
- $index = $indexes[1];
- $this->assertSame(['bar' => 1], $index->getKey());
- $this->assertTrue($index->isUnique());
- $this->assertSame('mongo-php-adapter.test', $index->getNamespace());
- }
- public function testDeleteIndexUsingIndexName()
- {
- $newCollection = $this->getCheckDatabase()->selectCollection('test');
- $newCollection->createIndex(['bar' => 1], ['name' => 'bar']);
- $expected = [
- 'nIndexesWas' => 2,
- 'ok' => 1.0,
- ];
- $this->assertSame($expected, $this->getCollection()->deleteIndex('bar'));
- $this->assertCount(1, iterator_to_array($newCollection->listIndexes()));
- }
- public function testDeleteIndexUsingKeys()
- {
- $newCollection = $this->getCheckDatabase()->selectCollection('test');
- $newCollection->createIndex(['bar' => 1]);
- $expected = [
- 'nIndexesWas' => 2,
- 'ok' => 1.0,
- ];
- $this->assertSame($expected, $this->getcollection()->deleteIndex(['bar' => 1]));
- $this->assertCount(1, iterator_to_array($newCollection->listIndexes()));
- }
- public function testDeleteIndexes()
- {
- $newCollection = $this->getCheckDatabase()->selectCollection('test');
- $newCollection->createIndex(['bar' => 1]);
- $expected = [
- 'nIndexesWas' => 2,
- 'msg' => 'non-_id indexes dropped for collection',
- 'ok' => 1.0,
- ];
- $this->assertSame($expected, $this->getcollection()->deleteIndexes());
- $this->assertCount(1, iterator_to_array($newCollection->listIndexes())); // ID index is present by default
- }
- public function testGetIndexInfo()
- {
- $collection = $this->getCollection();
- $collection->createIndex(['foo' => 1]);
- $expected = [
- [
- 'v' => 1,
- 'key' => ['_id' => 1],
- 'name' => '_id_',
- 'ns' => 'mongo-php-adapter.test',
- ],
- [
- 'v' => 1,
- 'key' => ['foo' => 1],
- 'name' => 'foo_1',
- 'ns' => 'mongo-php-adapter.test',
- ],
- ];
- $this->assertSame(
- $expected,
- $collection->getIndexInfo()
- );
- }
- public function testFindAndModifyUpdate()
- {
- $id = '54203e08d51d4a1f868b456e';
- $collection = $this->getCollection();
- $document = ['_id' => new \MongoId($id), 'foo' => 'bar'];
- $collection->insert($document);
- $document = $collection->findAndModify(
- ['_id' => new \MongoId($id)],
- ['$set' => ['foo' => 'foo']]
- );
- $this->assertSame('bar', $document['foo']);
- $newCollection = $this->getCheckDatabase()->selectCollection('test');
- $this->assertSame(1, $newCollection->count());
- $object = $newCollection->findOne();
- $this->assertNotNull($object);
- $this->assertAttributeSame('foo', 'foo', $object);
- }
- public function testFindAndModifyUpdateReturnNew()
- {
- $id = '54203e08d51d4a1f868b456e';
- $collection = $this->getCollection();
- $document = ['_id' => new \MongoId($id), 'foo' => 'bar'];
- $collection->insert($document);
- $document = $collection->findAndModify(
- ['_id' => new \MongoId($id)],
- ['$set' => ['foo' => 'foo']],
- null,
- ['new' => true]
- );
- $this->assertSame('foo', $document['foo']);
- }
- public function testFindAndModifyWithFields()
- {
- $id = '54203e08d51d4a1f868b456e';
- $collection = $this->getCollection();
- $document = [
- '_id' => new \MongoId($id),
- 'foo' => 'bar',
- 'bar' => 'foo',
- ];
- $collection->insert($document);
- $document = $collection->findAndModify(
- ['_id' => new \MongoId($id)],
- ['$set' => ['foo' => 'foo']],
- ['foo' => true]
- );
- $this->assertArrayNotHasKey('bar', $document);
- $this->assertArrayHasKey('foo', $document);
- }
- public function testGroup()
- {
- $collection = $this->getCollection();
- $document1 = ['a' => 2];
- $collection->insert($document1);
- $document2 = ['b' => 5];
- $collection->insert($document2);
- $document3 = ['a' => 1];
- $collection->insert($document3);
- $keys = [];
- $initial = ["count" => 0];
- $reduce = "function (obj, prev) { prev.count++; }";
- $condition = ['condition' => ["a" => [ '$gt' => 1]]];
- $result = $collection->group($keys, $initial, $reduce, $condition);
- $this->assertArraySubset(
- [
- 'retval' => [['count' => 1.0]],
- 'count' => 1.0,
- 'keys' => 1,
- 'ok' => 1.0,
- ],
- $result
- );
- }
- public function testFindAndModifyRemove()
- {
- $id = '54203e08d51d4a1f868b456e';
- $collection = $this->getCollection();
- $document = ['_id' => new \MongoId($id), 'foo' => 'bar'];
- $collection->insert($document);
- $document = $collection->findAndModify(
- ['_id' => new \MongoId($id)],
- null,
- null,
- ['remove' => true]
- );
- $this->assertEquals('bar', $document['foo']);
- $newCollection = $this->getCheckDatabase()->selectCollection('test');
- $this->assertSame(0, $newCollection->count());
- }
- public function testValidate()
- {
- $collection = $this->getCollection();
- $document = ['foo' => 'bar'];
- $collection->insert($document);
- $result = $collection->validate();
- $this->assertArraySubset(
- [
- 'ns' => 'mongo-php-adapter.test',
- 'nrecords' => 1,
- 'nIndexes' => 1,
- 'keysPerIndex' => ['mongo-php-adapter.test.$_id_' => 1],
- 'valid' => true,
- 'errors' => [],
- 'warning' => 'Some checks omitted for speed. use {full:true} option to do more thorough scan.',
- 'ok' => 1.0
- ],
- $result
- );
- }
- public function testDrop()
- {
- $document = ['foo' => 'bar'];
- $this->getCollection()->insert($document);
- $expected = [
- 'ns' => (string) $this->getCollection(),
- 'nIndexesWas' => 1,
- 'ok' => 1.0
- ];
- $this->assertSame($expected, $this->getCollection()->drop());
- }
- }
|