MongoDB

<?php
$mongo = \ByJG\AnyDataset\NoSql\Factory::getInstance('mongodb://server');

The full connection string format:

mongodb://username:password@server1,server2,server3/dbname?uri.param1=value1&driver.param2=value2

Inserting data to a Collection

To insert data:

<?php
$mongo = \ByJG\AnyDataset\NoSql\Factory::getInstance('mongodb://server');
$document = new \ByJG\AnyDataset\NoSql\NoSqlDocument(
    null,
    'mycollection',
    [
        'field1' => 'value1',
        'field2' => 'value2',
        'field3' => 'value3',
    ]
);
$mongo->save($document);

info

When a document is inserted, the fields created and updated are automatically added with the current date. Because there is no ID (first parameter) provided, this is treated as an INSERT operation.

Updating a document

<?php
$mongo = \ByJG\AnyDataset\NoSql\Factory::getInstance('mongodb://server');
$document = new \ByJG\AnyDataset\NoSql\NoSqlDocument(
    'someid',
    'mycollection',
    [
        'field1' => 'value1',
        'field2' => 'value2',
        'field3' => 'value3',
    ]
);
$mongo->save($document);

info

When updating a document, the field updated is automatically updated with the current date. Because an ID (first parameter) is provided, this is treated as an UPDATE operation.

Querying the collection

Querying the database will return documents as NoSqlDocument objects.

Retrieve a document by Id

<?php
$mongo = \ByJG\AnyDataset\NoSql\Factory::getInstance('mongodb://server');
$document = $mongo->getDocumentById($id, 'mycollection');
if (!empty($document)) {
    print_r($document->getIdDocument());
    print_r($document->getDocument());
}

note

The collection name is required as the second parameter.

Retrieve all data

<?php
$mongo = \ByJG\AnyDataset\NoSql\Factory::getInstance('mongodb://server');
$result = $mongo->getDocuments(null, 'mycollection');
foreach ($result as $document)
{
    print_r($document->getIdDocument());
    print_r($document->getDocument());
}

Filtering the data

You can use the IteratorFilter to filter documents:

<?php
$filter = new \ByJG\AnyDataset\Core\IteratorFilter();
$filter->addRelation('field', \ByJG\AnyDataset\Core\Enum\Relation::EQUAL, 'value');

$mongo = \ByJG\AnyDataset\NoSql\Factory::getInstance('mongodb://server');
$result = $mongo->getDocuments($filter, 'mycollection');
foreach ($result as $document)
{
    // Do something
}

Supported Relations

The MongoDbDriver supports the following filter relations:

• EQUAL
• GREATER_THAN
• LESS_THAN
• GREATER_OR_EQUAL_THAN
• LESS_OR_EQUAL_THAN
• NOT_EQUAL
• STARTS_WITH
• CONTAINS
• IN
• NOT_IN

Deleting Documents

<?php
// Delete by ID
$mongo->deleteDocumentById($id, 'mycollection');

// Delete multiple documents by filter
$filter = new \ByJG\AnyDataset\Core\IteratorFilter();
$filter->addRelation('field', \ByJG\AnyDataset\Core\Enum\Relation::EQUAL, 'value');
$mongo->deleteDocuments($filter, 'mycollection');

Updating Multiple Documents

<?php
$filter = new \ByJG\AnyDataset\Core\IteratorFilter();
$filter->addRelation('field', \ByJG\AnyDataset\Core\Enum\Relation::EQUAL, 'value');

$data = [
    'field1' => 'new_value1',
    'field2' => 'new_value2'
];

$mongo->updateDocuments($filter, $data, 'mycollection');

Full Connection String

mongodb://username:password@server:27017/dbname?uri.option1=value1&driver.option2=value2

Connection Parameters

Parameters must be prefixed with:

• uri. - Passed to the MongoDB URI connection string
• driver. - Passed to the MongoDB driver options

Any other parameters will throw an exception.

For the complete list of available parameters, see the PHP MongoDB Driver documentation.

---

Open source ByJG