diff options
Diffstat (limited to 'src/mango/test/18-json-sort.py')
-rw-r--r-- | src/mango/test/18-json-sort.py | 122 |
1 files changed, 0 insertions, 122 deletions
diff --git a/src/mango/test/18-json-sort.py b/src/mango/test/18-json-sort.py deleted file mode 100644 index d4e60a32c..000000000 --- a/src/mango/test/18-json-sort.py +++ /dev/null @@ -1,122 +0,0 @@ -# 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 -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# 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. - -import mango -import copy -import unittest - -DOCS = [ - {"_id": "1", "name": "Jimi", "age": 10, "cars": 1}, - {"_id": "2", "name": "Eddie", "age": 20, "cars": 1}, - {"_id": "3", "name": "Jane", "age": 30, "cars": 2}, - {"_id": "4", "name": "Mary", "age": 40, "cars": 2}, - {"_id": "5", "name": "Sam", "age": 50, "cars": 3}, -] - - -class JSONIndexSortOptimisations(mango.DbPerClass): - def setUp(self): - self.db.recreate() - self.db.save_docs(copy.deepcopy(DOCS)) - - def test_works_for_basic_case(self): - self.db.create_index(["cars", "age"], name="cars-age") - selector = {"cars": "2", "age": {"$gt": 10}} - explain = self.db.find(selector, sort=["age"], explain=True) - self.assertEqual(explain["index"]["name"], "cars-age") - self.assertEqual(explain["mrargs"]["direction"], "fwd") - - def test_works_for_all_fields_specified(self): - self.db.create_index(["cars", "age"], name="cars-age") - selector = {"cars": "2", "age": {"$gt": 10}} - explain = self.db.find(selector, sort=["cars", "age"], explain=True) - self.assertEqual(explain["index"]["name"], "cars-age") - - def test_works_for_no_sort_fields_specified(self): - self.db.create_index(["cars", "age"], name="cars-age") - selector = {"cars": {"$gt": 10}, "age": {"$gt": 10}} - explain = self.db.find(selector, explain=True) - self.assertEqual(explain["index"]["name"], "cars-age") - - def test_works_for_opp_dir_sort(self): - self.db.create_index(["cars", "age"], name="cars-age") - selector = {"cars": "2", "age": {"$gt": 10}} - explain = self.db.find(selector, sort=[{"age": "desc"}], explain=True) - self.assertEqual(explain["index"]["name"], "cars-age") - self.assertEqual(explain["mrargs"]["direction"], "rev") - - def test_not_work_for_non_constant_field(self): - self.db.create_index(["cars", "age"], name="cars-age") - selector = {"cars": {"$gt": 10}, "age": {"$gt": 10}} - try: - self.db.find(selector, explain=True, sort=["age"]) - raise Exception("Should not get here") - except Exception as e: - resp = e.response.json() - self.assertEqual(resp["error"], "no_usable_index") - - def test_three_index_one(self): - self.db.create_index(["cars", "age", "name"], name="cars-age-name") - selector = {"cars": "2", "age": 10, "name": {"$gt": "AA"}} - explain = self.db.find(selector, sort=["name"], explain=True) - self.assertEqual(explain["index"]["name"], "cars-age-name") - - def test_three_index_two(self): - self.db.create_index(["cars", "age", "name"], name="cars-age-name") - selector = {"cars": "2", "name": "Eddie", "age": {"$gt": 10}} - explain = self.db.find(selector, sort=["age"], explain=True) - self.assertEqual(explain["index"]["name"], "cars-age-name") - - def test_three_index_fails(self): - self.db.create_index(["cars", "age", "name"], name="cars-age-name") - selector = {"name": "Eddie", "age": {"$gt": 1}, "cars": {"$gt": "1"}} - try: - self.db.find(selector, explain=True, sort=["name"]) - raise Exception("Should not get here") - except Exception as e: - resp = e.response.json() - self.assertEqual(resp["error"], "no_usable_index") - - def test_empty_sort(self): - self.db.create_index(["cars", "age", "name"], name="cars-age-name") - selector = {"name": {"$gt": "Eddie"}, "age": 10, "cars": {"$gt": "1"}} - explain = self.db.find(selector, explain=True) - self.assertEqual(explain["index"]["name"], "cars-age-name") - - def test_in_between(self): - self.db.create_index(["cars", "age", "name"], name="cars-age-name") - selector = {"name": "Eddie", "age": 10, "cars": {"$gt": "1"}} - explain = self.db.find(selector, explain=True) - self.assertEqual(explain["index"]["name"], "cars-age-name") - - try: - self.db.find(selector, sort=["cars", "name"], explain=True) - raise Exception("Should not get here") - except Exception as e: - resp = e.response.json() - self.assertEqual(resp["error"], "no_usable_index") - - def test_ignore_after_set_sort_value(self): - self.db.create_index(["cars", "age", "name"], name="cars-age-name") - selector = {"age": {"$gt": 10}, "cars": 2, "name": {"$gt": "A"}} - explain = self.db.find(selector, sort=["age"], explain=True) - self.assertEqual(explain["index"]["name"], "cars-age-name") - - def test_not_use_index_if_other_fields_in_sort(self): - self.db.create_index(["cars", "age"], name="cars-age") - selector = {"age": 10, "cars": {"$gt": "1"}} - try: - self.db.find(selector, sort=["cars", "name"], explain=True) - raise Exception("Should not get here") - except Exception as e: - resp = e.response.json() - self.assertEqual(resp["error"], "no_usable_index") |