knodes/li3_ensureindex

There is no license information available for the latest version (dev-master) of this package.

Installs: 723

Dependents: 0

Suggesters: 0

Security: 0

Stars: 3

Watchers: 4

Forks: 2

Open Issues: 0

Type:lithium-library

dev-master 2013-10-16 13:32 UTC

This package is not auto-updated.

Last update: 2024-12-17 06:14:48 UTC


README

li3_ensureindex allows you to define MongoDB indexes within your models, and ensure them on the server via a console command.

Installation

Get the library code:

$ cd /path/to/app/libraries
$ git clone https://github.com/Knodes/li3_ensureindex.git

Make sure it's added on app/config/bootstrap/libraries.php:

Libraries::add('li3_ensureindex');

Index Definition

To define your indexes inside your model, just add a static and public _indexes property, such as:

static public $_indexes = array(
    'indexname' =>  array(
        'keys' => array('somefield' => -1)
    )
);

That's it. The 'indexname' key will be used as the index name in Mongo. Other options detault to these:

'unique' => false,
'dropDups' => false,
'background' => true,
'safe' => true,
'timeout' => 10000

And can be overwritten easily:

static public $_indexes = array(
    'indexname' =>  array(
        'keys' => array('somefield' => -1),
        'background' => false,
    ),

    'anotherindex' =>  array(
        'keys' => array('anotherfield' => -1, 'athirdfield' => 1),
        'unique' => true,
        'dropDups' => true,
        'safe' => false
    ),

);

Please note that MongoCollection::ensureIndex restrictions apply of course, as described in the docs.

Ensuring Indexes

This library comes with a console command to ensure the defined indexes. Ensuring all indexes defined for all models is as simple as:

li3 ensure-indexes

And will result in a detailed report of which indexes were created. Please note that existing indexes are not deleted from the collections.

It's also possible to limit the index ensure to a specific model by supplying it as a parameters:

li3 ensure-indexes --model=MyModel