def test_deepcopy_cursor_littered_with_regexes(self):

cursor = self.db.test.find({

"x": re.compile("^hmmm.*"),

"y": [re.compile("^hmm.*")],

"z": {"a": [re.compile("^hm.*")]},

re.compile("^key.*"): {"a": [re.compile("^hm.*")]}})

cursor2 = copy.deepcopy(cursor)

self.assertEqual(cursor._Cursor__spec, cursor2._Cursor__spec)

def test_add_remove_option(self):

cursor = self.db.test.find()

self.assertEqual(0, cursor._Cursor__query_flags)

cursor.add_option(2)

cursor2 = self.db.test.find(cursor_type=CursorType.TAILABLE)

self.assertEqual(2, cursor2._Cursor__query_flags)

self.assertEqual(cursor._Cursor__query_flags,

cursor2._Cursor__query_flags)

cursor.add_option(32)

cursor2 = self.db.test.find(cursor_type=CursorType.TAILABLE_AWAIT)

self.assertEqual(34, cursor2._Cursor__query_flags)

self.assertEqual(cursor._Cursor__query_flags,

cursor2._Cursor__query_flags)

cursor.add_option(128)

cursor2 = self.db.test.find(

cursor_type=CursorType.TAILABLE_AWAIT).add_option(128)

self.assertEqual(162, cursor2._Cursor__query_flags)

self.assertEqual(cursor._Cursor__query_flags,

cursor2._Cursor__query_flags)

self.assertEqual(162, cursor._Cursor__query_flags)

cursor.add_option(128)

self.assertEqual(162, cursor._Cursor__query_flags)

cursor.remove_option(128)

cursor2 = self.db.test.find(cursor_type=CursorType.TAILABLE_AWAIT)

self.assertEqual(34, cursor2._Cursor__query_flags)

self.assertEqual(cursor._Cursor__query_flags,

cursor2._Cursor__query_flags)

cursor.remove_option(32)

cursor2 = self.db.test.find(cursor_type=CursorType.TAILABLE)

self.assertEqual(2, cursor2._Cursor__query_flags)

self.assertEqual(cursor._Cursor__query_flags,

cursor2._Cursor__query_flags)

self.assertEqual(2, cursor._Cursor__query_flags)

cursor.remove_option(32)

self.assertEqual(2, cursor._Cursor__query_flags)

# Timeout

cursor = self.db.test.find(no_cursor_timeout=True)

self.assertEqual(16, cursor._Cursor__query_flags)

cursor2 = self.db.test.find().add_option(16)

self.assertEqual(cursor._Cursor__query_flags,

cursor2._Cursor__query_flags)

cursor.remove_option(16)

self.assertEqual(0, cursor._Cursor__query_flags)

# Tailable / Await data

cursor = self.db.test.find(cursor_type=CursorType.TAILABLE_AWAIT)

self.assertEqual(34, cursor._Cursor__query_flags)

cursor2 = self.db.test.find().add_option(34)

self.assertEqual(cursor._Cursor__query_flags,

cursor2._Cursor__query_flags)

cursor.remove_option(32)

self.assertEqual(2, cursor._Cursor__query_flags)

# Partial

cursor = self.db.test.find(allow_partial_results=True)

self.assertEqual(128, cursor._Cursor__query_flags)

cursor2 = self.db.test.find().add_option(128)

self.assertEqual(cursor._Cursor__query_flags,

cursor2._Cursor__query_flags)

cursor.remove_option(128)

self.assertEqual(0, cursor._Cursor__query_flags)

def test_add_remove_option_exhaust(self):

# Exhaust - which mongos doesn't support

if client_context.is_mongos:

with self.assertRaises(InvalidOperation):

self.db.test.find(cursor_type=CursorType.EXHAUST)

else:

cursor = self.db.test.find(cursor_type=CursorType.EXHAUST)

self.assertEqual(64, cursor._Cursor__query_flags)

cursor2 = self.db.test.find().add_option(64)

self.assertEqual(cursor._Cursor__query_flags,

cursor2._Cursor__query_flags)

self.assertTrue(cursor._Cursor__exhaust)

cursor.remove_option(64)

self.assertEqual(0, cursor._Cursor__query_flags)

self.assertFalse(cursor._Cursor__exhaust)

def test_max_time_ms(self):

db = self.db

db.pymongo_test.drop()

coll = db.pymongo_test

self.assertRaises(TypeError, coll.find().max_time_ms, 'foo')

coll.insert_one({"amalia": 1})

coll.insert_one({"amalia": 2})

coll.find().max_time_ms(None)

coll.find().max_time_ms(long(1))

cursor = coll.find().max_time_ms(999)

self.assertEqual(999, cursor._Cursor__max_time_ms)

cursor = coll.find().max_time_ms(10).max_time_ms(1000)

self.assertEqual(1000, cursor._Cursor__max_time_ms)

cursor = coll.find().max_time_ms(999)

c2 = cursor.clone()

self.assertEqual(999, c2._Cursor__max_time_ms)

self.assertTrue("$maxTimeMS" in cursor._Cursor__query_spec())

self.assertTrue("$maxTimeMS" in c2._Cursor__query_spec())

self.assertTrue(coll.find_one(max_time_ms=1000))

client = self.client

if (not client_context.is_mongos

and client_context.test_commands_enabled):

# Cursor parses server timeout error in response to initial query.

client.admin.command("configureFailPoint",

"maxTimeAlwaysTimeOut",

mode="alwaysOn")

try:

cursor = coll.find().max_time_ms(1)

try:

next(cursor)

except ExecutionTimeout:

pass

else:

self.fail("ExecutionTimeout not raised")

self.assertRaises(ExecutionTimeout,

coll.find_one, max_time_ms=1)

finally:

client.admin.command("configureFailPoint",

"maxTimeAlwaysTimeOut",

mode="off")

@client_context.require_version_min(3, 1, 9, -1)

def test_max_await_time_ms(self):

db = self.db

db.pymongo_test.drop()

coll = db.create_collection("pymongo_test", capped=True, size=4096)

self.assertRaises(TypeError, coll.find().max_await_time_ms, 'foo')

coll.insert_one({"amalia": 1})

coll.insert_one({"amalia": 2})

coll.find().max_await_time_ms(None)

coll.find().max_await_time_ms(long(1))

# When cursor is not tailable_await

cursor = coll.find()

self.assertEqual(None, cursor._Cursor__max_await_time_ms)

cursor = coll.find().max_await_time_ms(99)

self.assertEqual(None, cursor._Cursor__max_await_time_ms)

# If cursor is tailable_await and timeout is unset

cursor = coll.find(cursor_type=CursorType.TAILABLE_AWAIT)

self.assertEqual(None, cursor._Cursor__max_await_time_ms)

# If cursor is tailable_await and timeout is set

cursor = coll.find(

cursor_type=CursorType.TAILABLE_AWAIT).max_await_time_ms(99)

self.assertEqual(99, cursor._Cursor__max_await_time_ms)

cursor = coll.find(

cursor_type=CursorType.TAILABLE_AWAIT).max_await_time_ms(

10).max_await_time_ms(90)

self.assertEqual(90, cursor._Cursor__max_await_time_ms)

listener = WhiteListEventListener('find', 'getMore')

saved_listeners = monitoring._LISTENERS

monitoring._LISTENERS = monitoring._Listeners([], [], [], [])

coll = rs_or_single_client(

event_listeners=[listener])[self.db.name].pymongo_test

results = listener.results

try:

# Tailable_await defaults.

list(coll.find(cursor_type=CursorType.TAILABLE_AWAIT))

# find

self.assertFalse('maxTimeMS' in results['started'][0].command)

# getMore

self.assertFalse('maxTimeMS' in results['started'][1].command)

results.clear()

# Tailable_await with max_await_time_ms set.

list(coll.find(

cursor_type=CursorType.TAILABLE_AWAIT).max_await_time_ms(99))

# find

self.assertEqual('find', results['started'][0].command_name)

self.assertFalse('maxTimeMS' in results['started'][0].command)

# getMore

self.assertEqual('getMore', results['started'][1].command_name)

self.assertTrue('maxTimeMS' in results['started'][1].command)

self.assertEqual(99, results['started'][1].command['maxTimeMS'])

results.clear()

# Tailable_await with max_time_ms

list(coll.find(

cursor_type=CursorType.TAILABLE_AWAIT).max_time_ms(99))

# find

self.assertEqual('find', results['started'][0].command_name)

self.assertTrue('maxTimeMS' in results['started'][0].command)

self.assertEqual(99, results['started'][0].command['maxTimeMS'])

# getMore

self.assertEqual('getMore', results['started'][1].command_name)

self.assertFalse('maxTimeMS' in results['started'][1].command)

results.clear()

# Tailable_await with both max_time_ms and max_await_time_ms

list(coll.find(

cursor_type=CursorType.TAILABLE_AWAIT).max_time_ms(

99).max_await_time_ms(99))

# find

self.assertEqual('find', results['started'][0].command_name)

self.assertTrue('maxTimeMS' in results['started'][0].command)

self.assertEqual(99, results['started'][0].command['maxTimeMS'])

# getMore

self.assertEqual('getMore', results['started'][1].command_name)

self.assertTrue('maxTimeMS' in results['started'][1].command)

self.assertEqual(99, results['started'][1].command['maxTimeMS'])

results.clear()

# Non tailable_await with max_await_time_ms

list(coll.find(batch_size=1).max_await_time_ms(99))

# find

self.assertEqual('find', results['started'][0].command_name)

self.assertFalse('maxTimeMS' in results['started'][0].command)

# getMore

self.assertEqual('getMore', results['started'][1].command_name)

self.assertFalse('maxTimeMS' in results['started'][1].command)

results.clear()

# Non tailable_await with max_time_ms

list(coll.find(batch_size=1).max_time_ms(99))

# find

self.assertEqual('find', results['started'][0].command_name)

self.assertTrue('maxTimeMS' in results['started'][0].command)

self.assertEqual(99, results['started'][0].command['maxTimeMS'])

# getMore

self.assertEqual('getMore', results['started'][1].command_name)

self.assertFalse('maxTimeMS' in results['started'][1].command)

# Non tailable_await with both max_time_ms and max_await_time_ms

list(coll.find(batch_size=1).max_time_ms(99).max_await_time_ms(88))

# find

self.assertEqual('find', results['started'][0].command_name)

self.assertTrue('maxTimeMS' in results['started'][0].command)

self.assertEqual(99, results['started'][0].command['maxTimeMS'])

# getMore

self.assertEqual('getMore', results['started'][1].command_name)

self.assertFalse('maxTimeMS' in results['started'][1].command)

finally:

monitoring._LISTENERS = saved_listeners

@client_context.require_test_commands

@client_context.require_no_mongos

def test_max_time_ms_getmore(self):

# Test that Cursor handles server timeout error in response to getmore.

coll = self.db.pymongo_test

coll.insert_many([{} for _ in range(200)])

cursor = coll.find().max_time_ms(100)

# Send initial query before turning on failpoint.

next(cursor)

self.client.admin.command("configureFailPoint",

"maxTimeAlwaysTimeOut",

mode="alwaysOn")

try:

try:

# Iterate up to first getmore.

list(cursor)

except ExecutionTimeout:

pass

else:

self.fail("ExecutionTimeout not raised")

finally:

self.client.admin.command("configureFailPoint",

"maxTimeAlwaysTimeOut",

mode="off")

def test_explain(self):

a = self.db.test.find()

a.explain()

for _ in a:

break

b = a.explain()

# "cursor" pre MongoDB 2.7.6, "executionStats" post

self.assertTrue("cursor" in b or "executionStats" in b)

def test_explain_with_read_concern(self):

# Do not add readConcern level to explain.

listener = WhiteListEventListener("explain")

client = rs_or_single_client(event_listeners=[listener])

self.addCleanup(client.close)

coll = client.pymongo_test.test.with_options(

read_concern=ReadConcern(level="local"))

self.assertTrue(coll.find().explain())

started = listener.results['started']

self.assertEqual(len(started), 1)

self.assertNotIn("readConern", started[0].command)

def test_hint(self):

db = self.db

self.assertRaises(TypeError, db.test.find().hint, 5.5)

db.test.drop()

db.test.insert_many([{"num": i, "foo": i} for i in range(100)])

self.assertRaises(OperationFailure,

db.test.find({"num": 17, "foo": 17})

.hint([("num", ASCENDING)]).explain)

self.assertRaises(OperationFailure,

db.test.find({"num": 17, "foo": 17})

.hint([("foo", ASCENDING)]).explain)

spec = [("num", DESCENDING)]

index = db.test.create_index(spec)

first = next(db.test.find())

self.assertEqual(0, first.get('num'))

first = next(db.test.find().hint(spec))

self.assertEqual(99, first.get('num'))

self.assertRaises(OperationFailure,

db.test.find({"num": 17, "foo": 17})

.hint([("foo", ASCENDING)]).explain)

a = db.test.find({"num": 17})

a.hint(spec)

for _ in a:

break

self.assertRaises(InvalidOperation, a.hint, spec)

def test_hint_by_name(self):

db = self.db

db.test.drop()

db.test.insert_many([{"i": i} for i in range(100)])

db.test.create_index([('i', DESCENDING)], name='fooindex')

first = next(db.test.find())

self.assertEqual(0, first.get('i'))

first = next(db.test.find().hint('fooindex'))

self.assertEqual(99, first.get('i'))

def test_limit(self):

db = self.db

self.assertRaises(TypeError, db.test.find().limit, None)

self.assertRaises(TypeError, db.test.find().limit, "hello")

self.assertRaises(TypeError, db.test.find().limit, 5.5)

self.assertTrue(db.test.find().limit(long(5)))

db.test.drop()

db.test.insert_many([{"x": i} for i in range(100)])

count = 0

for _ in db.test.find():

count += 1

self.assertEqual(count, 100)

count = 0

for _ in db.test.find().limit(20):

count += 1

self.assertEqual(count, 20)

count = 0

for _ in db.test.find().limit(99):

count += 1

self.assertEqual(count, 99)

count = 0

for _ in db.test.find().limit(1):

count += 1

self.assertEqual(count, 1)

count = 0

for _ in db.test.find().limit(0):

count += 1

self.assertEqual(count, 100)

count = 0

for _ in db.test.find().limit(0).limit(50).limit(10):

count += 1

self.assertEqual(count, 10)

a = db.test.find()

a.limit(10)

for _ in a:

break

self.assertRaises(InvalidOperation, a.limit, 5)

def test_max(self):

db = self.db

db.test.drop()

db.test.create_index([("j", ASCENDING)])

db.test.insert_many([{"j": j, "k": j} for j in range(10)])

cursor = db.test.find().max([("j", 3)])

self.assertEqual(len(list(cursor)), 3)

# Tuple.

cursor = db.test.find().max((("j", 3), ))

self.assertEqual(len(list(cursor)), 3)

# Compound index.

db.test.create_index([("j", ASCENDING), ("k", ASCENDING)])

cursor = db.test.find().max([("j", 3), ("k", 3)])

self.assertEqual(len(list(cursor)), 3)

# Wrong order.

cursor = db.test.find().max([("k", 3), ("j", 3)])

self.assertRaises(OperationFailure, list, cursor)

# No such index.

cursor = db.test.find().max([("k", 3)])

self.assertRaises(OperationFailure, list, cursor)

self.assertRaises(TypeError, db.test.find().max, 10)

self.assertRaises(TypeError, db.test.find().max, {"j": 10})

def test_min(self):

db = self.db

db.test.drop()

db.test.create_index([("j", ASCENDING)])

db.test.insert_many([{"j": j, "k": j} for j in range(10)])

cursor = db.test.find().min([("j", 3)])

self.assertEqual(len(list(cursor)), 7)

# Tuple.

cursor = db.test.find().min((("j", 3), ))

self.assertEqual(len(list(cursor)), 7)

# Compound index.

db.test.create_index([("j", ASCENDING), ("k", ASCENDING)])

cursor = db.test.find().min([("j", 3), ("k", 3)])

self.assertEqual(len(list(cursor)), 7)

# Wrong order.

cursor = db.test.find().min([("k", 3), ("j", 3)])

self.assertRaises(OperationFailure, list, cursor)

# No such index.

cursor = db.test.find().min([("k", 3)])

self.assertRaises(OperationFailure, list, cursor)

self.assertRaises(TypeError, db.test.find().min, 10)

self.assertRaises(TypeError, db.test.find().min, {"j": 10})

def test_batch_size(self):

db = self.db

db.test.drop()

db.test.insert_many([{"x": x} for x in range(200)])

self.assertRaises(TypeError, db.test.find().batch_size, None)

self.assertRaises(TypeError, db.test.find().batch_size, "hello")

self.assertRaises(TypeError, db.test.find().batch_size, 5.5)

self.assertRaises(ValueError, db.test.find().batch_size, -1)

self.assertTrue(db.test.find().batch_size(long(5)))

a = db.test.find()

for _ in a:

break

self.assertRaises(InvalidOperation, a.batch_size, 5)

def cursor_count(cursor, expected_count):

count = 0

for _ in cursor:

count += 1

self.assertEqual(expected_count, count)

cursor_count(db.test.find().batch_size(0), 200)

cursor_count(db.test.find().batch_size(1), 200)

cursor_count(db.test.find().batch_size(2), 200)

cursor_count(db.test.find().batch_size(5), 200)

cursor_count(db.test.find().batch_size(100), 200)

cursor_count(db.test.find().batch_size(500), 200)

cursor_count(db.test.find().batch_size(0).limit(1), 1)

cursor_count(db.test.find().batch_size(1).limit(1), 1)

cursor_count(db.test.find().batch_size(2).limit(1), 1)

cursor_count(db.test.find().batch_size(5).limit(1), 1)

cursor_count(db.test.find().batch_size(100).limit(1), 1)

cursor_count(db.test.find().batch_size(500).limit(1), 1)

cursor_count(db.test.find().batch_size(0).limit(10), 10)

cursor_count(db.test.find().batch_size(1).limit(10), 10)

cursor_count(db.test.find().batch_size(2).limit(10), 10)

cursor_count(db.test.find().batch_size(5).limit(10), 10)

cursor_count(db.test.find().batch_size(100).limit(10), 10)

cursor_count(db.test.find().batch_size(500).limit(10), 10)

cur = db.test.find().batch_size(1)

next(cur)

if client_context.version.at_least(3, 1, 9):

# find command batchSize should be 1

self.assertEqual(0, len(cur._Cursor__data))

else:

# OP_QUERY ntoreturn should be 2

self.assertEqual(1, len(cur._Cursor__data))

next(cur)

self.assertEqual(0, len(cur._Cursor__data))

next(cur)

self.assertEqual(0, len(cur._Cursor__data))

next(cur)

self.assertEqual(0, len(cur._Cursor__data))

def test_limit_and_batch_size(self):

db = self.db

db.test.drop()

db.test.insert_many([{"x": x} for x in range(500)])

curs = db.test.find().limit(0).batch_size(10)

next(curs)

self.assertEqual(10, curs._Cursor__retrieved)

curs = db.test.find(limit=0, batch_size=10)

next(curs)

self.assertEqual(10, curs._Cursor__retrieved)

curs = db.test.find().limit(-2).batch_size(0)

next(curs)

self.assertEqual(2, curs._Cursor__retrieved)

curs = db.test.find(limit=-2, batch_size=0)

next(curs)

self.assertEqual(2, curs._Cursor__retrieved)

curs = db.test.find().limit(-4).batch_size(5)

next(curs)

self.assertEqual(4, curs._Cursor__retrieved)

curs = db.test.find(limit=-4, batch_size=5)

next(curs)

self.assertEqual(4, curs._Cursor__retrieved)

curs = db.test.find().limit(50).batch_size(500)

next(curs)

self.assertEqual(50, curs._Cursor__retrieved)

curs = db.test.find(limit=50, batch_size=500)

next(curs)

self.assertEqual(50, curs._Cursor__retrieved)

curs = db.test.find().batch_size(500)

next(curs)

self.assertEqual(500, curs._Cursor__retrieved)

curs = db.test.find(batch_size=500)

next(curs)

self.assertEqual(500, curs._Cursor__retrieved)

curs = db.test.find().limit(50)

next(curs)

self.assertEqual(50, curs._Cursor__retrieved)

curs = db.test.find(limit=50)

next(curs)

self.assertEqual(50, curs._Cursor__retrieved)

# these two might be shaky, as the default

# is set by the server. as of 2.0.0-rc0, 101

# or 1MB (whichever is smaller) is default

# for queries without ntoreturn

curs = db.test.find()

next(curs)

self.assertEqual(101, curs._Cursor__retrieved)

curs = db.test.find().limit(0).batch_size(0)

next(curs)

self.assertEqual(101, curs._Cursor__retrieved)

curs = db.test.find(limit=0, batch_size=0)

next(curs)

self.assertEqual(101, curs._Cursor__retrieved)

def test_skip(self):

db = self.db

self.assertRaises(TypeError, db.test.find().skip, None)

self.assertRaises(TypeError, db.test.find().skip, "hello")

self.assertRaises(TypeError, db.test.find().skip, 5.5)

self.assertRaises(ValueError, db.test.find().skip, -5)

self.assertTrue(db.test.find().skip(long(5)))

db.drop_collection("test")

db.test.insert_many([{"x": i} for i in range(100)])

for i in db.test.find():

self.assertEqual(i["x"], 0)

break

for i in db.test.find().skip(20):

self.assertEqual(i["x"], 20)

break

for i in db.test.find().skip(99):

self.assertEqual(i["x"], 99)

break

for i in db.test.find().skip(1):

self.assertEqual(i["x"], 1)

break

for i in db.test.find().skip(0):

self.assertEqual(i["x"], 0)

break

for i in db.test.find().skip(0).skip(50).skip(10):

self.assertEqual(i["x"], 10)

break

for i in db.test.find().skip(1000):

self.fail()

a = db.test.find()

a.skip(10)

for _ in a:

break

self.assertRaises(InvalidOperation, a.skip, 5)

def test_sort(self):

db = self.db

self.assertRaises(TypeError, db.test.find().sort, 5)

self.assertRaises(ValueError, db.test.find().sort, [])

self.assertRaises(TypeError, db.test.find().sort, [], ASCENDING)

self.assertRaises(TypeError, db.test.find().sort,

[("hello", DESCENDING)], DESCENDING)

db.test.drop()

unsort = list(range(10))

random.shuffle(unsort)

db.test.insert_many([{"x": i} for i in unsort])

asc = [i["x"] for i in db.test.find().sort("x", ASCENDING)]

self.assertEqual(asc, list(range(10)))

asc = [i["x"] for i in db.test.find().sort("x")]

self.assertEqual(asc, list(range(10)))

asc = [i["x"] for i in db.test.find().sort([("x", ASCENDING)])]

self.assertEqual(asc, list(range(10)))

expect = list(reversed(range(10)))

desc = [i["x"] for i in db.test.find().sort("x", DESCENDING)]

self.assertEqual(desc, expect)

desc = [i["x"] for i in db.test.find().sort([("x", DESCENDING)])]

self.assertEqual(desc, expect)

desc = [i["x"] for i in

db.test.find().sort("x", ASCENDING).sort("x", DESCENDING)]

self.assertEqual(desc, expect)

expected = [(1, 5), (2, 5), (0, 3), (7, 3), (9, 2), (2, 1), (3, 1)]

shuffled = list(expected)

random.shuffle(shuffled)

db.test.drop()

for (a, b) in shuffled:

db.test.insert_one({"a": a, "b": b})

result = [(i["a"], i["b"]) for i in

db.test.find().sort([("b", DESCENDING),

("a", ASCENDING)])]

self.assertEqual(result, expected)

a = db.test.find()

a.sort("x", ASCENDING)

for _ in a:

break

self.assertRaises(InvalidOperation, a.sort, "x", ASCENDING)

@ignore_deprecations

def test_count(self):

db = self.db

db.test.drop()

self.assertEqual(0, db.test.find().count())

db.test.insert_many([{"x": i} for i in range(10)])

self.assertEqual(10, db.test.find().count())

self.assertTrue(isinstance(db.test.find().count(), int))

self.assertEqual(10, db.test.find().limit(5).count())

self.assertEqual(10, db.test.find().skip(5).count())

self.assertEqual(1, db.test.find({"x": 1}).count())

self.assertEqual(5, db.test.find({"x": {"$lt": 5}}).count())

a = db.test.find()

b = a.count()

for _ in a:

break

self.assertEqual(b, a.count())

self.assertEqual(0, db.test.acollectionthatdoesntexist.find().count())

@ignore_deprecations

def test_count_with_hint(self):

collection = self.db.test

collection.drop()

collection.insert_many([{'i': 1}, {'i': 2}])

self.assertEqual(2, collection.find().count())

collection.create_index([('i', 1)])

self.assertEqual(1, collection.find({'i': 1}).hint("_id_").count())

self.assertEqual(2, collection.find().hint("_id_").count())

self.assertRaises(OperationFailure,

collection.find({'i': 1}).hint("BAD HINT").count)

# Create a sparse index which should have no entries.

collection.create_index([('x', 1)], sparse=True)

self.assertEqual(0, collection.find({'i': 1}).hint("x_1").count())

self.assertEqual(

0, collection.find({'i': 1}).hint([("x", 1)]).count())

if client_context.version.at_least(3, 3, 2):

self.assertEqual(0, collection.find().hint("x_1").count())

self.assertEqual(0, collection.find().hint([("x", 1)]).count())

else:

self.assertEqual(2, collection.find().hint("x_1").count())

self.assertEqual(2, collection.find().hint([("x", 1)]).count())

@ignore_deprecations

def test_where(self):

db = self.db

db.test.drop()

a = db.test.find()

self.assertRaises(TypeError, a.where, 5)

self.assertRaises(TypeError, a.where, None)

self.assertRaises(TypeError, a.where, {})

db.test.insert_many([{"x": i} for i in range(10)])

self.assertEqual(3, len(list(db.test.find().where('this.x < 3'))))

self.assertEqual(3,

len(list(db.test.find().where(Code('this.x < 3')))))

self.assertEqual(3, len(list(db.test.find().where(Code('this.x < i',

{"i": 3})))))

self.assertEqual(10, len(list(db.test.find())))

self.assertEqual(3, db.test.find().where('this.x < 3').count())

self.assertEqual(10, db.test.find().count())

self.assertEqual(3, db.test.find().where(u'this.x < 3').count())

self.assertEqual([0, 1, 2],

[a["x"] for a in

db.test.find().where('this.x < 3')])

self.assertEqual([],

[a["x"] for a in

db.test.find({"x": 5}).where('this.x < 3')])

self.assertEqual([5],

[a["x"] for a in

db.test.find({"x": 5}).where('this.x > 3')])

cursor = db.test.find().where('this.x < 3').where('this.x > 7')

self.assertEqual([8, 9], [a["x"] for a in cursor])

a = db.test.find()

b = a.where('this.x > 3')

for _ in a:

break

self.assertRaises(InvalidOperation, a.where, 'this.x < 3')

def test_rewind(self):

self.db.test.insert_many([{"x": i} for i in range(1, 4)])

cursor = self.db.test.find().limit(2)

count = 0

for _ in cursor:

count += 1

self.assertEqual(2, count)

count = 0

for _ in cursor:

count += 1

self.assertEqual(0, count)

cursor.rewind()

count = 0

for _ in cursor:

count += 1

self.assertEqual(2, count)

cursor.rewind()

count = 0

for _ in cursor:

break

cursor.rewind()

for _ in cursor:

count += 1

self.assertEqual(2, count)

self.assertEqual(cursor, cursor.rewind())

def test_clone(self):

self.db.test.insert_many([{"x": i} for i in range(1, 4)])

cursor = self.db.test.find().limit(2)

count = 0

for _ in cursor:

count += 1

self.assertEqual(2, count)

count = 0

for _ in cursor:

count += 1

self.assertEqual(0, count)

cursor = cursor.clone()

cursor2 = cursor.clone()

count = 0

for _ in cursor:

count += 1

self.assertEqual(2, count)

for _ in cursor2:

count += 1

self.assertEqual(4, count)

cursor.rewind()

count = 0

for _ in cursor:

break

cursor = cursor.clone()

for _ in cursor:

count += 1

self.assertEqual(2, count)

self.assertNotEqual(cursor, cursor.clone())

# Just test attributes

cursor = self.db.test.find({"x": re.compile("^hello.*")},

skip=1,

no_cursor_timeout=True,

cursor_type=CursorType.TAILABLE_AWAIT,

allow_partial_results=True,

manipulate=False,

projection={'_id': False}).limit(2)

cursor.min([('a', 1)]).max([('b', 3)])

cursor.add_option(128)

cursor.comment('hi!')

cursor2 = cursor.clone()

self.assertEqual(cursor._Cursor__skip, cursor2._Cursor__skip)

self.assertEqual(cursor._Cursor__limit, cursor2._Cursor__limit)

self.assertEqual(type(cursor._Cursor__codec_options),

type(cursor2._Cursor__codec_options))

self.assertEqual(cursor._Cursor__manipulate,

cursor2._Cursor__manipulate)

self.assertEqual(cursor._Cursor__query_flags,

cursor2._Cursor__query_flags)

self.assertEqual(cursor._Cursor__comment,

cursor2._Cursor__comment)

self.assertEqual(cursor._Cursor__min,

cursor2._Cursor__min)

self.assertEqual(cursor._Cursor__max,

cursor2._Cursor__max)

# Shallow copies can so can mutate

cursor2 = copy.copy(cursor)

cursor2._Cursor__projection['cursor2'] = False

self.assertTrue('cursor2' in cursor._Cursor__projection)

# Deepcopies and shouldn't mutate

cursor3 = copy.deepcopy(cursor)

cursor3._Cursor__projection['cursor3'] = False

self.assertFalse('cursor3' in cursor._Cursor__projection)

cursor4 = cursor.clone()

cursor4._Cursor__projection['cursor4'] = False

self.assertFalse('cursor4' in cursor._Cursor__projection)

# Test memo when deepcopying queries

query = {"hello": "world"}

query["reflexive"] = query

cursor = self.db.test.find(query)

cursor2 = copy.deepcopy(cursor)

self.assertNotEqual(id(cursor._Cursor__spec),

id(cursor2._Cursor__spec))

self.assertEqual(id(cursor2._Cursor__spec['reflexive']),

id(cursor2._Cursor__spec))

self.assertEqual(len(cursor2._Cursor__spec), 2)

# Ensure hints are cloned as the correct type

cursor = self.db.test.find().hint([('z', 1), ("a", 1)])

cursor2 = copy.deepcopy(cursor)

self.assertTrue(isinstance(cursor2._Cursor__hint, SON))

self.assertEqual(cursor._Cursor__hint, cursor2._Cursor__hint)

@ignore_deprecations