shershams/lmongo

LMongo is a MongoDB package for Laravel 4.

LMongo

LMongo is MongoDB package for Laravel 4. Most part of LMongo is based on Illuminate/Database (Thanks to @taylorotwell), _(*1)

Please note that LMongo project is under heavy development, some functionalities are not yet tested. Please report if you find any bug., _(*2)

• Installation
• Basic Usage
• Query Builder
  • Wheres
  • Advanced Wheres
  • Aggregates
  • Inserts
  • Updates
  • Deletes
  • Pagination
• Eloquent for MongoDB
• License

Installation

Add shershams/lmongo as a requirement to composer.json:, _(*3)

{
    "require": {
        "shershams/lmongo": "*"
    }
}

And then run composer update, _(*4)

Once Composer has installed or updated your packages you need to register LMongo. Open up app/config/app.php and find the providers key and add:, _(*5)

'LMongo\LMongoServiceProvider'

Then find the aliases key and add following line to the array:, _(*6)

'LMongo'          => 'LMongo\Facades\LMongo',
'EloquentMongo'   => 'LMongo\Eloquent\Model',

Finally you need to publish a configuration file by running the following Artisan command., _(*7)

$ php artisan config:publish shershams/lmongo

This will copy the default configuration file to app/config/packages/shershams/lmongo/config.php, _(*8)

Basic Usage

You may get a MongoDB instance by calling the LMongo::connection method:, _(*9)

$LMongo = LMongo::connection();

This will give you an instance of the default MongoDB server. You may pass the server name to the connection method to get a specific server as defined in your mongodb configuration:, _(*10)

$LMongo = LMongo::connection('othermongodbserver');

LMongo uses magic method to pass the collection name to the Database class and return MongoCollection instance. Then you can use any of MongoCollection methods:, _(*11)

$item = $LMongo->collection_name->findOne(array('key' => 'value'));

$items = $LMongo->collection_name->find(array('key' => 'value'))->limit(5);

$LMongo->collection_name->remove(array('key' => 'value'));

Get the MongoDB object:, _(*12)

$mongodb = $LMongo->getMongoDB();

$collection_names = $mongodb->getCollectionNames();

Get the MongoClient object:, _(*13)

$mongo = $LMongo->getMongoClient();

$databases = $mongo->listDBs();

Select/switch the database:, _(*14)

$LMongo->selectDB($dbName);

Create the database:, _(*15)

$LMongo->createDB($dbName);

Query Builder

Wheres

Retrieving All Rows From A Collection, _(*16)

$users = LMongo::collection('users')->get();

foreach ($users as $user)
{
    var_dump($user['name']);
}

Retrieving A Single Document From A Collection, _(*17)

$user = LMongo::collection('users')->where('name', 'John')->first();

var_dump($user['name']);

Retrieving A Single Column From A Document, _(*18)

$name = LMongo::collection('users')->where('name', 'John')->pluck('name');

Specifying A Fields, _(*19)

$users = LMongo::collection('users')->get(array('name', 'email'));

Using Where Operators, _(*20)

$users = LMongo::collection('users')->where('votes', 100)->get();

Or Statements, _(*21)

$users = LMongo::collection('users')
                ->where('votes', 100)
                ->orWhere('name', 'John')
                ->get();

Nor Statements, _(*22)

$users = LMongo::collection('users')
                ->where('votes', 100)
                ->norWhere('name', 'John')
                ->get();

Using Where In And Where Not In With An Array, _(*23)

$users = LMongo::collection('users')
                ->whereIn('id', array(1, 2, 3))->get();

Using Where All With An Array, _(*24)

$users = LMongo::collection('users')
                ->whereAll('tags', array('php','mongodb'))->get();

$users = LMongo::collection('users')
                ->whereNin('id', array(1, 2, 3))->get();

Using Where Exists, _(*25)

$users = LMongo::collection('users')
                ->whereExists('updated_at')->get();

Using Where Gt, _(*26)

$users = LMongo::collection('users')
                ->whereGt('votes', 1)->get();

Using Where Gte, _(*27)

$users = LMongo::collection('users')
                ->whereGte('votes', 1)->get();

Using Where Lt, _(*28)

$users = LMongo::collection('users')
                ->whereLt('votes', 1)->get();

Using Where Lte, _(*29)

$users = LMongo::collection('users')
                ->whereLte('votes', 1)->get();

Using Where Between, _(*30)

$users = LMongo::collection('users')
                ->whereBetween('votes', 1, 100)->get();

Using Where Ne, _(*31)

$users = LMongo::collection('users')
                ->whereNe('name', 'John')->get();

Using Where Regex, _(*32)

$users = LMongo::collection('users')
                ->whereRegex('name', '/John/i')->get();
//or
$users = LMongo::collection('users')
                ->whereRegex('name', new MongoRegex('/John/im'))->get();

Using Where Like, _(*33)

$users = LMongo::collection('users')
                ->whereLike('name', 'John','im')->get();

There are more where methods in Query/Builder.php file., _(*34)

Order By, _(*35)

$users = LMongo::collection('users')
                ->orderBy('name', 'desc')
                ->get();

$users = LMongo::collection('users')
                ->orderBy('name', -1)
                ->get();

Offset & Limit, _(*36)

$users = LMongo::collection('users')->skip(10)->take(5)->get();

Advanced Wheres

Parameter Grouping, _(*37)

LMongo::collection('users')
            ->where('name', 'John')
            ->orWhere(function($query)
            {
                $query->whereGt('votes', 100)
                      ->whereNe('title', 'Admin');
            })
            ->get();

Aggregates

$users = LMongo::collection('users')->count();

$price = LMongo::collection('orders')->max('price');

$price = LMongo::collection('orders')->min('price');

$price = LMongo::collection('orders')->avg('price');

$total = LMongo::collection('users')->sum('votes');

Distinct

$emails = LMongo::collection('users')->distinct('email');

Inserts

Inserting Document Into A Collection, _(*38)

$id = LMongo::collection('users')->insert(
    array('email' => 'john@example.com', 'votes' => 0),
);

Inserting Multiple Documents Into A Collection, _(*39)

$ids = LMongo::collection('users')->batchInsert(
            array('email' => 'john@example.com', 'votes' => 0),
            array('email' => 'henry@example.com', 'votes' => 0),
        );

Updates

Updating Documents In A Collection, _(*40)

LMongo::collection('users')
            ->where('id', 1)
            ->update(array('votes' => 1));

Incrementing or decrementing a value of a column, _(*41)

LMongo::collection('users')->increment('votes');

LMongo::collection('users')->decrement('votes');

Deletes

Deleting Documents In A Collection, _(*42)

LMongo::collection('users')->where('votes', 100)->delete();
//or
LMongo::collection('users')->where('votes', 100)->remove();

Deleting All Documents From A Collection, _(*43)

LMongo::collection('users')->delete();
//or
LMongo::collection('users')->truncate();

Pagination

LMongo has pagination support like Laravel's Query Builder., _(*44)

$users = LMongo::collection('users')->orderBy('name')->paginate(10);

foreach ($users as $user)
{
    echo $user['name'];
}

echo $user->links();

Eloquent for MongoDB

It's similar to Eloquent, except few differences: * It has a collection property, not table * Primary key field is _id, not id * No Pivot collections for "Many To Many" relationship. So don't use "Many To Many" relationships on a large datasets., _(*45)

See Eloquent Docs., _(*46)

License

Licensed under the MIT License., _(*47)

TODO

• Aggregate/group support
• Indexes
• GridFS