PHP MongoCollection::createIndex方法代码示例

 /**
  * Note that we use TTL Collections to have the Mongo deamon automatically clean
  * expired entries.
  *
  * @link http://docs.mongodb.org/manual/tutorial/expire-data/
  * @param array $options
  */
 public function __construct(array $options = array())
 {
     if (!extension_loaded('mongo')) {
         Zend_Cache::throwException('The MongoDB extension must be loaded for using this backend !');
     }
     parent::__construct($options);
     // Merge the options passed in; overriding any default options
     $this->_options = array_merge($this->_options, $options);
     $conn = new \MongoClient($this->_getServerConnectionUrl());
     $this->_database = $conn->{$this->_options['dbname']};
     $this->_collection = $this->_database->selectCollection($this->_options['collection']);
     $this->_collection->createIndex(array('tags' => 1), array('background' => true));
     $this->_collection->createIndex(array('expires_at' => 1), array('background' => true, 'expireAfterSeconds' => 0));
 }

 /**
  * Specify an index for the collection.
  *
  * @param  string|array  $columns
  * @param  array         $options
  * @return Blueprint
  */
 public function index($columns = null, $options = [])
 {
     $columns = $this->fluent($columns);
     // Columns are passed as a default array.
     if (is_array($columns) && is_int(key($columns))) {
         // Transform the columns to the required array format.
         $transform = [];
         foreach ($columns as $column) {
             $transform[$column] = 1;
         }
         $columns = $transform;
     }
     $this->collection->createIndex($columns, $options);
     return $this;
 }

 public function postUp(Schema $schema)
 {
     $upgradeHelper = new UpgradeHelper($this->container);
     if ($upgradeHelper->areProductsStoredInMongo()) {
         $database = $upgradeHelper->getMongoInstance();
         $tableHelper = new SchemaHelper($this->container);
         echo "Add index to Version document on column loggetAt...\n";
         $versionCollection = new \MongoCollection($database, $tableHelper->getTableOrCollection('version'));
         $versionCollection->createIndex(['loggedAt' => -1], ['background' => true]);
         echo "Done.";
     }
 }

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     set_time_limit(0);
     $db = \DB::getMongoDB();
     $statementsCollection = new MongoCollection($db, 'statements');
     $statementsCollection->createIndex(['stored' => 1], ['background' => 1, 'socketTimeoutMS' => -1]);
     $statementsCollection->createIndex(['stored' => -1], ['background' => 1, 'socketTimeoutMS' => -1]);
     $statementsCollection->createIndex(['lrs_id' => 1, 'stored' => 1], ['background' => 1, 'socketTimeoutMS' => -1]);
     $statementsCollection->createIndex(['lrs_id' => 1, 'stored' => -1], ['background' => 1, 'socketTimeoutMS' => -1]);
     $statementsCursor = $statementsCollection->find();
     $remaining = $statementsCursor->count();
     print $remaining . ' statements total' . PHP_EOL;
     $maxBatchSize = 10000;
     while ($statementsCursor->hasNext()) {
         $batch = new MongoUpdateBatch($statementsCollection);
         $batchSize = 0;
         while ($batchSize < $maxBatchSize && $statementsCursor->hasNext()) {
             $batchSize++;
             $statement = $statementsCursor->next();
             $statementStored = new Carbon\Carbon($statement['statement']['stored']);
             $query = ['q' => ['_id' => $statement['_id']], 'u' => ['$set' => ["stored" => new \MongoDate($statementStored->timestamp, $statementStored->micro)]], 'multi' => false, 'upsert' => false];
             if (isset($statement['refs'])) {
                 foreach ($statement['refs'] as $key => $refStatement) {
                     if (isset($refStatement['timestamp']) && !$refStatement['timestamp'] instanceof MongoDate) {
                         $timestamp = new Carbon\Carbon($refStatement['timestamp']);
                         $query['u']['$set']['refs.' . $key . '.timestamp'] = new \MongoDate($timestamp->timestamp, $timestamp->micro);
                     }
                     if (isset($refStatement['stored']) && !$refStatement['stored'] instanceof MongoDate) {
                         $stored = new Carbon\Carbon($refStatement['stored']);
                         $query['u']['$set']['refs.' . $key . '.stored'] = new \MongoDate($stored->timestamp, $stored->micro);
                     }
                 }
             }
             $batch->add((object) $query);
         }
         $batch->execute();
         $remaining -= $batchSize;
         print $remaining . ' remaining' . PHP_EOL;
     }
 }

$keys['flatsale'] = ['', 'state', 'city', 'county', 'region', 'aptName', 'area'];
$keys['houserent'] = ['', 'state', 'city', 'county', 'region', 'monthlyType'];
$keys['aptrent'] = ['', 'state', 'city', 'county', 'region', 'aptName', 'area', 'monthlyType'];
$keys['flatrent'] = ['', 'state', 'city', 'county', 'region', 'aptName', 'area', 'monthlyType'];
foreach ($keys as $key => $val) {
    echo 'Adding index $key...\\n';
    $col = new MongoCollection($db, $key);
    $col_agg = new MongoCollection($db, $key . '_agg');
    $idx_key = [];
    foreach ($val as $id) {
        if ($id) {
            $idx_key[$id] = 1;
        }
        $added_idx_key = array_merge($idx_key, ['year' => 1]);
        print_r($added_idx_key);
        $r = $col->createIndex($added_idx_key);
        print_r($r);
        $added_idx_key = array_merge($idx_key, ['year' => 1, 'month' => 1]);
        $r = $col->createIndex($added_idx_key);
        print_r($r);
        $added_idx_key = array_merge($idx_key, ['year' => -1, 'month' => -1]);
        $r = $col->createIndex($added_idx_key);
        print_r($r);
        $col->createIndex(['year' => 1, 'month' => 1]);
        $col->createIndex(['year' => -1, 'month' => -1]);
        $r = $col_agg->createIndex($added_idx_key);
        print_r($r);
        $col_agg->createIndex(['year' => 1, 'month' => 1]);
        $col_agg->createIndex(['year' => -1, 'month' => -1]);
    }
}

 /**
  * Run the migrations.
  *
  * @return void
  */
 public function up()
 {
     $db = \DB::getMongoDB();
     $indexOptions = ['background' => 1, 'socketTimeoutMS' => -1];
     $statements = new MongoCollection($db, 'statements');
     $statements->createIndex(['statement.id' => 1, 'lrs_id' => 1], $indexOptions);
     $statements->createIndex(['statement.actor.mbox' => 1], $indexOptions);
     $statements->createIndex(['stored' => 1], $indexOptions);
     $statements->createIndex(['timestamp' => 1], $indexOptions);
     $statements->createIndex(['active' => 1], $indexOptions);
     $statements->createIndex(['voided' => 1], $indexOptions);
     $statements->createIndex(['lrs_id' => 1], $indexOptions);
     $statements->createIndex(['lrs_id' => 1, 'active' => -1, 'voided' => 1], $indexOptions);
     $statements->createIndex(['lrs_id' => 1, 'statement.actor.account.name' => 1, 'statement.actor.account.homePage' => 1], $indexOptions);
     $statements->createIndex(['lrs_id' => 1, 'statement.actor.mbox' => 1], $indexOptions);
     $statements->createIndex(['lrs_id' => 1, 'statement.verb.id' => 1], $indexOptions);
     $statements->createIndex(['lrs_id' => 1, 'statement.object.id' => 1], $indexOptions);
     $statements->createIndex(['lrs_id' => 1, 'stored' => -1], $indexOptions);
     $statements->createIndex(['lrs_id' => 1, 'timestamp' => -1], $indexOptions);
 }

 function __construct($host = 'localhost', $port = 27017)
 {
     $this->connection = new \MongoClient('mongodb://' . $host . ':' . $port);
     $this->index = $this->connection->search->index;
     $this->index->createIndex(array('token' => 1), array('unique' => true));
 }

 public function createIndex()
 {
     $this->collection->createIndex(["packageName" => 1, "packageVersion" => 1]);
 }

 public function ensureIndex($fieldName)
 {
     $this->collection->createIndex([$fieldName => 1]);
 }