#
# Copyright 2009-2013 MongoDB, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
use strict;
use version;
use MongoDB;
use lib "t/lib";
use MongoDBTest qw/build_client get_test_db server_version server_type/;
my $conn = build_client();
my $testdb = get_test_db($conn);
my $server_version = server_version($conn);
my $server_type = server_type($conn);
my $coll = $testdb->get_collection('test_collection');
my $coll2 = $testdb->get_collection("cap_collection");
# after dropping coll2, must run command below to make it capped
my $create_capped_cmd = [ create => "cap_collection", capped => 1, size => 10000 ];
my $cursor;
my @values;
# test setup
{
$coll->drop;
$coll->insert_one({ foo => 9, bar => 3, shazbot => 1 });
$coll->insert_one({ foo => 2, bar => 5 });
$coll->insert_one({ foo => -3, bar => 4 });
$coll->insert_one({ foo => 4, bar => 9, shazbot => 1 });
}
# $coll->query
{
@values = $coll->query({}, { sort_by => { foo => 1 } })->all;
is(scalar @values, 4);
is ($values[0]->{foo}, -3);
is ($values[1]->{foo}, 2);
is ($values[2]->{foo}, 4);
is ($values[3]->{foo}, 9);
@values = $coll->query({}, { sort_by => { bar => -1 } })->all;
is(scalar @values, 4);
is($values[0]->{bar}, 9);
is($values[1]->{bar}, 5);
is($values[2]->{bar}, 4);
is($values[3]->{bar}, 3);
}
# criteria
{
@values = $coll->query({ shazbot => 1 }, { sort_by => { foo => -1 } })->all;
is(scalar @values, 2);
is($values[0]->{foo}, 9);
is($values[1]->{foo}, 4);
}
# limit
{
@values = $coll->query({}, { limit => 3, sort_by => { foo => 1 } })->all;
is(scalar @values, 3) or diag explain \@values;
is ($values[0]->{foo}, -3);
is ($values[1]->{foo}, 2);
is ($values[2]->{foo}, 4);
}
# skip
{
@values = $coll->query({}, { limit => 3, skip => 1, sort_by => { foo => 1 } })->all;
is(scalar @values, 3);
is ($values[0]->{foo}, 2);
is ($values[1]->{foo}, 4);
is ($values[2]->{foo}, 9);
}
$coll->drop;
# next and all
{
is($coll->query->next, undef, 'test undef');
is_deeply([$coll->query->all], []);
my $id1 = $coll->insert_one({x => 1})->inserted_id;
my $id2 = $coll->insert_one({x => 5})->inserted_id;
is($coll->count, 2);
$cursor = $coll->query;
is($cursor->next->{'x'}, 1);
is($cursor->next->{'x'}, 5);
is($cursor->next, undef);
my $cursor2 = $coll->query({x => 5});
is_deeply([$cursor2->all], [{_id => $id2, x => 5}]);
is_deeply([$coll->query->all], [{_id => $id1, x => 1}, {_id => $id2, x => 5}]);
}
# sort, and sort by tie::ixhash
{
my $cursor_sort = $coll->query->sort({'x' => -1});
is($cursor_sort->has_next, 1);
is($cursor_sort->next->{'x'}, 5, 'Cursor->sort');
is($cursor_sort->next->{'x'}, 1);
$cursor_sort = $coll->query->sort({'x' => 1});
is($cursor_sort->next->{'x'}, 1);
is($cursor_sort->next->{'x'}, 5);
my $hash = Tie::IxHash->new("x" => -1);
$cursor_sort = $coll->query->sort($hash);
is($cursor_sort->has_next, 1);
is($cursor_sort->next->{'x'}, 5, 'Tie::IxHash cursor->sort');
is($cursor_sort->next->{'x'}, 1);
}
# snapshot
# XXX tests don't fail if snapshot is turned off ?!?
{
my $cursor3 = $coll->query->snapshot(1);
is($cursor3->has_next, 1, 'check has_next');
my $r1 = $cursor3->next;
is($cursor3->has_next, 1, 'if this failed, the database you\'re running is old and snapshot won\'t work');
$cursor3->next;
is(int $cursor3->has_next, 0, 'check has_next is false');
like(
exception { $coll->query->snapshot },
qr/requires a defined, boolean argument/,
"snapshot exception without argument"
);
}
# paging
{
$coll->insert_one({x => 2});
$coll->insert_one({x => 3});
$coll->insert_one({x => 4});
my $paging = $coll->query->skip(1)->limit(2);
is($paging->has_next, 1, 'check skip/limit');
$paging->next;
is($paging->has_next, 1);
$paging->next;
is(int $paging->has_next, 0);
}
# bigger test, with index
{
$coll = $testdb->get_collection('test');
$coll->drop;
$coll->indexes->create_one({'sn'=>1});
my $bulk = $coll->unordered_bulk;
$bulk->insert_one({sn => $_}) for 0 .. 5000;
$bulk->execute;
$cursor = $coll->query;
my $count = 0;
while (my $doc = $cursor->next()) {
$count++;
}
is(5001, $count);
my @all = $coll->find->limit(3999)->all;
is( 0+@all, 3999, "got limited documents" );
}
# reset
{
$cursor->reset;
my $r1 = $cursor->next;
$cursor->reset;
my $r2 = $cursor->next;
is($r1->{'sn'}, $r2->{'sn'}, 'reset');
}
# explain
{
my $exp = $cursor->explain;
if ( $server_version >= v2.7.3 ) {
is ($exp->{executionStats}{nReturned}, 5001, "count of items" );
$cursor->reset;
$exp = $cursor->limit(20)->explain;
is ($exp->{executionStats}{nReturned}, 20, "explain with limit" );
$cursor->reset;
$exp = $cursor->limit(-20)->explain;
is ($exp->{executionStats}{nReturned}, 20, "explain with negative limit" );
}
else {
is($exp->{'n'}, 5001, 'explain');
is($exp->{'cursor'}, 'BasicCursor');
$cursor->reset;
$exp = $cursor->limit(20)->explain;
is(20, $exp->{'n'}, 'explain limit');
$cursor->reset;
$exp = $cursor->limit(-20)->explain;
is(20, $exp->{'n'});
}
}
# hint
{
$cursor->reset;
my $hinted = $cursor->hint({'x' => 1});
is($hinted, $cursor, "hint returns self");
$coll->drop;
$coll->insert_one({'num' => 1, 'foo' => 1});
like( exception { $coll->query->hint( { 'num' => 1 } )->explain },
qr/MongoDB::DatabaseError/, "check error on hint with explain" );
}
# count
{
$coll->drop;
is ($coll->count, 0, "empty" );
$coll->insert_many([{'x' => 1}, {'x' => 1}, {'y' => 1}, {'x' => 1, 'z' => 1}]);
is($coll->query->count, 4, 'count');
is($coll->query({'x' => 1})->count, 3, 'count query');
is($coll->query->limit(1)->count(1), 1, 'count limit');
is($coll->query->skip(1)->count(1), 3, 'count skip');
is($coll->query->limit(1)->skip(1)->count(1), 1, 'count limit & skip');
}
# cursor opts
# not a functional test, just make sure they don't blow up
{
$cursor = $coll->find();
$cursor = $cursor->tailable(1);
is($cursor->query->cursorType, 'tailable', "set tailable");
$cursor = $cursor->tailable(0);
is($cursor->query->cursorType, 'non_tailable', "clear tailable");
$cursor = $cursor->tailable_await(1);
is($cursor->query->cursorType, 'tailable_await', "set tailable_await");
$cursor = $cursor->tailable_await(0);
is($cursor->query->cursorType, 'non_tailable', "clear tailable_await");
$cursor = $cursor->tailable(1);
is($cursor->query->cursorType, 'tailable', "set tailable");
$cursor = $cursor->tailable_await(0);
is($cursor->query->cursorType, 'non_tailable', "clear tailable_await");
$cursor = $cursor->tailable_await(1);
is($cursor->query->cursorType, 'tailable_await', "set tailable_await");
$cursor = $cursor->tailable(0);
is($cursor->query->cursorType, 'non_tailable', "clear tailable");
#test is actual cursor
$coll->drop;
$coll->insert_one({"x" => 1});
$cursor = $coll->find()->tailable(0);
my $doc = $cursor->next;
is($doc->{'x'}, 1);
$cursor = $coll->find();
$cursor->immortal(1);
ok($cursor->query->noCursorTimeout, "set immortal");
$cursor->immortal(0);
ok(! $cursor->query->noCursorTimeout, "clear immortal");
$cursor->slave_okay(1);
is($cursor->query->read_preference->mode, 'secondaryPreferred', "set slave_ok");
$cursor->slave_okay(0);
is($cursor->query->read_preference->mode, 'primary', "clear slave_ok");
}
# explain
{
$coll->drop;
$coll->insert_one({"x" => 1});
$cursor = $coll->find;
my $doc = $cursor->next;
is($doc->{'x'}, 1);
my $exp = $cursor->explain;
# cursor should not be reset
$doc = $cursor->next;
is($doc, undef) or diag explain $doc;
}
# info
{
$cursor = $coll->find;
my $count = $coll->count;
my $info = $cursor->info;
is_deeply( $info, {num => 0}, "before execution, info only has num field");
ok( $cursor->has_next, "cursor executed and has results" );
$info = $cursor->info;
is($info->{'num'}, 1);
is($info->{'at'}, 0);
is($info->{'num'}, $count);
is($info->{'start'}, 0);
is($info->{'cursor_id'}, scalar("\0" x 8));
$cursor->next;
$info = $cursor->info;
is($info->{'at'}, 1);
}
# sort_by
{
$coll->drop;
for (my $i=0; $i < 5; $i++) {
$coll->insert_one({x => $i});
}
$cursor = $coll->query({}, { limit => 10, skip => 0, sort_by => {created => 1 }});
is($cursor->count(), 5);
}
# delayed tailable cursor
subtest "delayed tailable cursor" => sub {
$coll2->drop;
$testdb->run_command($create_capped_cmd);
$coll2->insert_one( { x => $_ } ) for 0 .. 9;
# Get last doc
my $cursor = $coll2->find()->sort({x => -1})->limit(1);
my $last_doc = $cursor->next();
$cursor = $coll2->find({_id => {'$gt' => $last_doc->{_id}}})->tailable(1);
# We won't get anything yet
$cursor->next();
for (my $i=10; $i < 20; $i++) {
$coll2->insert_one({x => $i});
}
# We should retrieve documents here since we are tailable.
my $count =()= $cursor->all;
is($count, 10);
};
# tailable_await
subtest "await data" => sub {
$coll2->drop;
$testdb->run_command($create_capped_cmd);
$coll2->insert_one( { x => $_ } ) for 0 .. 9;
# Get last doc
my $cursor = $coll2->find()->sort( { x => -1 } )->limit(1);
my $last_doc = $cursor->next();
my $start = time;
$cursor = $coll2->find( { _id => { '$gt' => $last_doc->{_id} } } )->tailable_await(1);
# We won't get anything yet
$cursor->next();
my $end = time;
# did it actually block for a bit?
ok( $end >= $start + 1, "cursor blocked to await data" )
or diag "START: $start; END: $end";
};
subtest "count w/ hint" => sub {
$coll->drop;
$coll->insert_one( { i => 1 } );
$coll->insert_one( { i => 2 } );
is ($coll->find()->count(), 2, 'count = 2');
$coll->indexes->create_one( { i => 1 } );
is( $coll->find( { i => 1 } )->hint( '_id_' )->count(), 1, 'count w/ hint & spec');
is( $coll->find()->hint( '_id_' )->count(), 2, 'count w/ hint');
my $current_version = version->parse($server_version);
my $version_2_6 = version->parse('v2.6');
if ( $current_version > $version_2_6 ) {
eval { $coll->find( { i => 1 } )->hint( 'BAD HINT')->count() };
like($@, ($server_type eq "Mongos" ? qr/failed/ : qr/bad hint/ ), 'check bad hint error');
} else {
is( $coll->find( { i => 1 } )->hint( 'BAD HINT' )->count(), 1, 'bad hint and spec');
}
$coll->indexes->create_one( { x => 1 }, { sparse => 1 } );
if ($current_version > $version_2_6 ) {
is( $coll->find( { i => 1 } )->hint( 'x_1' )->count(), 0, 'spec & hint on empty sparse index');
} else {
is( $coll->find( { i => 1 } )->hint( 'x_1' )->count(), 1, 'spec & hint on empty sparse index');
}
is( $coll->find()->hint( 'x_1' )->count(), 2, 'hint on empty sparse index');
};
done_testing;