def retrieve_aql_documents(big_collection): """ """ all_aql_query = Query() all_aql_query.append_collection(collection_name=big_collection.name) all_aql_query.execute()
def test_lower_equals_filtering(self): q = Query() q.append_collection(self.test_1_col.name) q.filter(little_number__lte=3) docs = q.execute() self.assertEqual(len(docs), 2)
def test_lower_filtering(self): q = Query() q.append_collection(self.test_1_col.name) q.filter(little_number__lt=3) docs = q.execute() self.assertEqual(len(docs), 1) self.assertDocumentsEqual(self.col1_doc2, docs[0])
def test_filter_string_field_in_document(self): q = Query() q.append_collection(self.test_1_col.name) q.filter(small_text=self.col1_doc2.small_text) docs = q.execute() self.assertEqual(len(docs), 1) doc = docs[0] self.assertDocumentsEqual(doc, self.col1_doc2)
def test_filter_number_field_in_document(self): q = Query() q.append_collection(self.test_1_col.name) q.filter(little_number=self.col1_doc3.little_number) docs = q.execute() self.assertEqual(len(docs), 1) doc = docs[0] self.assertDocumentsEqual(doc, self.col1_doc3)
def test_icontains_filtering(self): q = Query() q.append_collection(self.test_1_col.name) q.filter(small_text__icontains='LL') docs = q.execute() self.assertEqual(len(docs), 1) doc1 = docs[0] self.assertDocumentsEqual(doc1, self.col1_doc1)
def test_exclude_document_from_list(self): q = Query() q.append_collection(self.test_1_col.name) q.exclude(loved=False) docs = q.execute() self.assertEqual(len(docs), 1) doc1 = docs[0] self.assertDocumentsEqual(doc1, self.col1_doc3)
def test_limit_with_start_simple_list(self): q = Query() q.append_collection(self.test_1_col.name) q.order_by('little_number') q.limit(count=1, start=1) docs = q.execute() self.assertEqual(len(docs), 1) doc1 = docs[0] self.assertDocumentsEqual(doc1, self.col1_doc3)
def test_sorting_asc_document_list(self): q = Query() q.append_collection(self.test_1_col.name) q.order_by('little_number') docs = q.execute() self.assertEqual(len(docs), 3) doc1 = docs[0] doc2 = docs[1] doc3 = docs[2] self.assertDocumentsEqual(doc1, self.col1_doc2) self.assertDocumentsEqual(doc2, self.col1_doc3) self.assertDocumentsEqual(doc3, self.col1_doc1)
def test_filter_from_multiple_collections(self): q = Query() q.append_collection(self.test_1_col.name) q.append_collection(self.test_2_col.name) dynamic_filter_dict = {} col_1_filter_name = "%s__%s" % (self.test_1_col.name, "little_number") col_2_filter_name = "%s__%s" % (self.test_2_col.name, "little_number") dynamic_filter_dict[col_1_filter_name] = 33 dynamic_filter_dict[col_2_filter_name] = 33 q.filter(bit_operator=Query.OR_BIT_OPERATOR, **dynamic_filter_dict) docs = q.execute() self.assertEqual(len(docs), 2) doc1 = docs[0] doc2 = docs[1] self.assertNotEqual(doc1.id, doc2.id) self.assertEqual(doc1.little_number, 33) self.assertEqual(doc2.little_number, 33)
def test_get_all_doc_from_1_collection(self): q = Query() q.append_collection(self.test_2_col.name) docs = q.execute() self.assertEqual(len(docs), 2)