| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096 |
- /*
- * Copyright 2023 Google LLC
- *
- * 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 <FirebaseFirestore/FIRAggregateField.h>
- #import <FirebaseFirestore/FIRFieldPath.h>
- #import <FirebaseFirestore/FirebaseFirestore.h>
- #import <XCTest/XCTest.h>
- #import "Firestore/Example/Tests/Util/FSTIntegrationTestCase.h"
- #import "Firestore/core/src/util/exception.h"
- @interface FIRAggregateTests : FSTIntegrationTestCase
- @end
- @implementation FIRAggregateTests
- - (void)testCountAggregateFieldQueryEquals {
- FIRCollectionReference* coll1 = [self collectionRefWithDocuments:@{}];
- FIRCollectionReference* coll1Same = [[coll1 firestore] collectionWithPath:[coll1 path]];
- FIRAggregateQuery* query1 = [coll1 aggregate:@[ [FIRAggregateField aggregateFieldForCount] ]];
- FIRAggregateQuery* query1Same =
- [coll1Same aggregate:@[ [FIRAggregateField aggregateFieldForCount] ]];
- FIRAggregateQuery* query1DiffAgg =
- [coll1Same aggregate:@[ [FIRAggregateField aggregateFieldForSumOfField:@"baz"] ]];
- FIRCollectionReference* sub = [[coll1 documentWithPath:@"bar"] collectionWithPath:@"baz"];
- FIRAggregateQuery* query2 = [[[sub queryWhereField:@"a" isEqualTo:@1] queryLimitedTo:100]
- aggregate:@[ [FIRAggregateField aggregateFieldForCount] ]];
- FIRAggregateQuery* query2Same = [[[sub queryWhereField:@"a"
- isEqualTo:@1] queryLimitedTo:100] count];
- FIRAggregateQuery* query3 = [[[sub queryWhereField:@"b" isEqualTo:@1] queryOrderedByField:@"c"]
- aggregate:@[ [FIRAggregateField aggregateFieldForCount] ]];
- FIRAggregateQuery* query3Same = [[[sub queryWhereField:@"b"
- isEqualTo:@1] queryOrderedByField:@"c"] count];
- XCTAssertEqualObjects(query1, query1Same);
- XCTAssertEqualObjects(query2, query2Same);
- XCTAssertEqualObjects(query3, query3Same);
- XCTAssertEqual([query1 hash], [query1Same hash]);
- XCTAssertEqual([query2 hash], [query2Same hash]);
- XCTAssertEqual([query3 hash], [query3Same hash]);
- XCTAssertFalse([query1 isEqual:nil]);
- XCTAssertFalse([query1 isEqual:@"string"]);
- XCTAssertFalse([query1 isEqual:query2]);
- XCTAssertFalse([query2 isEqual:query3]);
- XCTAssertNotEqual([query1 hash], [query1DiffAgg hash]);
- XCTAssertNotEqual([query1 hash], [query2 hash]);
- XCTAssertNotEqual([query2 hash], [query3 hash]);
- }
- - (void)testSumAggregateFieldQueryEquals {
- FIRCollectionReference* coll1 = [self collectionRefWithDocuments:@{}];
- FIRCollectionReference* coll1Same = [[coll1 firestore] collectionWithPath:[coll1 path]];
- FIRAggregateQuery* query1 =
- [coll1 aggregate:@[ [FIRAggregateField aggregateFieldForSumOfField:@"baz"] ]];
- FIRAggregateQuery* query1Same =
- [coll1Same aggregate:@[ [FIRAggregateField aggregateFieldForSumOfField:@"baz"] ]];
- FIRAggregateQuery* query1WithFieldPath =
- [coll1Same aggregate:@[ [FIRAggregateField
- aggregateFieldForSumOfFieldPath:[[FIRFieldPath alloc]
- initWithFields:@[ @"baz" ]]] ]];
- FIRAggregateQuery* query1DiffAgg =
- [coll1Same aggregate:@[ [FIRAggregateField aggregateFieldForCount] ]];
- FIRCollectionReference* sub = [[coll1 documentWithPath:@"bar"] collectionWithPath:@"baz"];
- FIRAggregateQuery* query2 = [[[sub queryWhereField:@"a" isEqualTo:@1] queryLimitedTo:100]
- aggregate:@[ [FIRAggregateField aggregateFieldForSumOfField:@"baz"] ]];
- FIRAggregateQuery* query2Same = [[[sub queryWhereField:@"a" isEqualTo:@1] queryLimitedTo:100]
- aggregate:@[ [FIRAggregateField aggregateFieldForSumOfField:@"baz"] ]];
- FIRAggregateQuery* query3 = [[[sub queryWhereField:@"b" isEqualTo:@1] queryOrderedByField:@"c"]
- aggregate:@[ [FIRAggregateField aggregateFieldForSumOfField:@"baz"] ]];
- FIRAggregateQuery* query3Same = [[[sub queryWhereField:@"b"
- isEqualTo:@1] queryOrderedByField:@"c"]
- aggregate:@[ [FIRAggregateField aggregateFieldForSumOfField:@"baz"] ]];
- XCTAssertEqualObjects(query1, query1Same);
- XCTAssertEqualObjects(query1, query1WithFieldPath);
- XCTAssertEqualObjects(query2, query2Same);
- XCTAssertEqualObjects(query3, query3Same);
- XCTAssertEqual([query1 hash], [query1Same hash]);
- XCTAssertEqual([query1 hash], [query1WithFieldPath hash]);
- XCTAssertEqual([query2 hash], [query2Same hash]);
- XCTAssertEqual([query3 hash], [query3Same hash]);
- XCTAssertFalse([query1 isEqual:nil]);
- XCTAssertFalse([query1 isEqual:@"string"]);
- XCTAssertFalse([query1 isEqual:query2]);
- XCTAssertFalse([query2 isEqual:query3]);
- XCTAssertNotEqual([query1 hash], [query1DiffAgg hash]);
- XCTAssertNotEqual([query1 hash], [query2 hash]);
- XCTAssertNotEqual([query2 hash], [query3 hash]);
- }
- - (void)testAverageAggregateFieldQueryEquals {
- FIRCollectionReference* coll1 = [self collectionRefWithDocuments:@{}];
- FIRCollectionReference* coll1Same = [[coll1 firestore] collectionWithPath:[coll1 path]];
- FIRAggregateQuery* query1 =
- [coll1 aggregate:@[ [FIRAggregateField aggregateFieldForAverageOfField:@"baz"] ]];
- FIRAggregateQuery* query1Same =
- [coll1Same aggregate:@[ [FIRAggregateField aggregateFieldForAverageOfField:@"baz"] ]];
- FIRAggregateQuery* query1WithFieldPath = [coll1Same aggregate:@[
- [FIRAggregateField
- aggregateFieldForAverageOfFieldPath:[[FIRFieldPath alloc] initWithFields:@[ @"baz" ]]]
- ]];
- FIRAggregateQuery* query1DiffAgg =
- [coll1Same aggregate:@[ [FIRAggregateField aggregateFieldForCount] ]];
- FIRCollectionReference* sub = [[coll1 documentWithPath:@"bar"] collectionWithPath:@"baz"];
- FIRAggregateQuery* query2 = [[[sub queryWhereField:@"a" isEqualTo:@1] queryLimitedTo:100]
- aggregate:@[ [FIRAggregateField aggregateFieldForAverageOfField:@"baz"] ]];
- FIRAggregateQuery* query2Same = [[[sub queryWhereField:@"a" isEqualTo:@1] queryLimitedTo:100]
- aggregate:@[ [FIRAggregateField aggregateFieldForAverageOfField:@"baz"] ]];
- FIRAggregateQuery* query3 = [[[sub queryWhereField:@"b" isEqualTo:@1] queryOrderedByField:@"c"]
- aggregate:@[ [FIRAggregateField aggregateFieldForAverageOfField:@"baz"] ]];
- FIRAggregateQuery* query3Same = [[[sub queryWhereField:@"b"
- isEqualTo:@1] queryOrderedByField:@"c"]
- aggregate:@[ [FIRAggregateField aggregateFieldForAverageOfField:@"baz"] ]];
- XCTAssertEqualObjects(query1, query1Same);
- XCTAssertEqualObjects(query1, query1WithFieldPath);
- XCTAssertEqualObjects(query2, query2Same);
- XCTAssertEqualObjects(query3, query3Same);
- XCTAssertEqual([query1 hash], [query1Same hash]);
- XCTAssertEqual([query1 hash], [query1WithFieldPath hash]);
- XCTAssertEqual([query2 hash], [query2Same hash]);
- XCTAssertEqual([query3 hash], [query3Same hash]);
- XCTAssertFalse([query1 isEqual:nil]);
- XCTAssertFalse([query1 isEqual:@"string"]);
- XCTAssertFalse([query1 isEqual:query2]);
- XCTAssertFalse([query2 isEqual:query3]);
- XCTAssertNotEqual([query1 hash], [query1DiffAgg hash]);
- XCTAssertNotEqual([query1 hash], [query2 hash]);
- XCTAssertNotEqual([query2 hash], [query3 hash]);
- }
- - (void)testAggregateFieldQueryNotEquals {
- FIRCollectionReference* coll = [self collectionRefWithDocuments:@{}];
- FIRAggregateQuery* query1 = [coll aggregate:@[ [FIRAggregateField aggregateFieldForCount] ]];
- FIRAggregateQuery* query2 =
- [coll aggregate:@[ [FIRAggregateField aggregateFieldForSumOfField:@"baz"] ]];
- FIRAggregateQuery* query3 =
- [coll aggregate:@[ [FIRAggregateField aggregateFieldForAverageOfField:@"baz"] ]];
- XCTAssertNotEqualObjects(query1, query2);
- XCTAssertNotEqualObjects(query2, query3);
- XCTAssertNotEqualObjects(query3, query1);
- XCTAssertNotEqual([query1 hash], [query2 hash]);
- XCTAssertNotEqual([query2 hash], [query3 hash]);
- XCTAssertNotEqual([query3 hash], [query1 hash]);
- FIRQuery* baseQuery = [[[[coll documentWithPath:@"bar"] collectionWithPath:@"baz"]
- queryWhereField:@"a"
- isEqualTo:@1] queryLimitedTo:100];
- FIRAggregateQuery* query4 = [baseQuery aggregate:@[ [FIRAggregateField aggregateFieldForCount] ]];
- FIRAggregateQuery* query5 =
- [baseQuery aggregate:@[ [FIRAggregateField aggregateFieldForSumOfField:@"baz"] ]];
- FIRAggregateQuery* query6 =
- [baseQuery aggregate:@[ [FIRAggregateField aggregateFieldForAverageOfField:@"baz"] ]];
- XCTAssertNotEqualObjects(query4, query5);
- XCTAssertNotEqualObjects(query5, query6);
- XCTAssertNotEqualObjects(query6, query4);
- XCTAssertNotEqual([query4 hash], [query5 hash]);
- XCTAssertNotEqual([query5 hash], [query6 hash]);
- XCTAssertNotEqual([query6 hash], [query4 hash]);
- }
- - (void)testCanRunAggregateQuery {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"pages" : @100,
- @"height" : @24.5,
- @"weight" : @24.1,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"pages" : @50,
- @"height" : @25.5,
- @"weight" : @75.5,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- }
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection aggregate:@[
- [FIRAggregateField aggregateFieldForCount],
- [FIRAggregateField aggregateFieldForSumOfField:@"pages"],
- [FIRAggregateField aggregateFieldForAverageOfField:@"pages"]
- ]]];
- // Count
- XCTAssertEqual([snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForCount]],
- [NSNumber numberWithLong:2L]);
- XCTAssertEqual([snapshot count], [NSNumber numberWithLong:2L]);
- // Sum
- XCTAssertEqual(
- [snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"pages"]],
- [NSNumber numberWithLong:150L], );
- // Average
- XCTAssertEqual([snapshot valueForAggregateField:[FIRAggregateField
- aggregateFieldForAverageOfField:@"pages"]],
- [NSNumber numberWithDouble:75.0]);
- }
- - (void)testCanRunEmptyAggregateQuery {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"pages" : @100,
- @"height" : @24.5,
- @"weight" : @24.1,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"pages" : @50,
- @"height" : @25.5,
- @"weight" : @75.5,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- }
- }];
- FIRAggregateQuery* emptyQuery = [testCollection aggregate:@[]];
- __block NSError* result;
- XCTestExpectation* expectation = [self expectationWithDescription:@"aggregate result"];
- [emptyQuery aggregationWithSource:FIRAggregateSourceServer
- completion:^(FIRAggregateQuerySnapshot* snapshot, NSError* error) {
- XCTAssertNil(snapshot);
- result = error;
- [expectation fulfill];
- }];
- [self awaitExpectation:expectation];
- XCTAssertNotNil(result);
- XCTAssertTrue([[result localizedDescription] containsString:@"Aggregations can not be empty"]);
- }
- // (TODO:b/283101111): Try thread sanitizer to see if timeout on Github Actions is gone.
- #if !defined(THREAD_SANITIZER)
- - (void)testAggregateFieldQuerySnapshotEquality {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"pages" : @100,
- @"height" : @24.5,
- @"weight" : @24.1,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"pages" : @50,
- @"height" : @25.5,
- @"weight" : @75.5,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- }
- }];
- FIRAggregateQuerySnapshot* snapshot1 =
- [self readSnapshotForAggregate:[testCollection aggregate:@[
- [FIRAggregateField aggregateFieldForCount],
- [FIRAggregateField aggregateFieldForSumOfField:@"pages"],
- [FIRAggregateField aggregateFieldForAverageOfField:@"pages"]
- ]]];
- FIRAggregateQuerySnapshot* snapshot2 =
- [self readSnapshotForAggregate:[testCollection aggregate:@[
- [FIRAggregateField aggregateFieldForCount],
- [FIRAggregateField aggregateFieldForSumOfField:@"pages"],
- [FIRAggregateField aggregateFieldForAverageOfField:@"pages"]
- ]]];
- // different aggregates
- FIRAggregateQuerySnapshot* snapshot3 =
- [self readSnapshotForAggregate:[testCollection aggregate:@[
- [FIRAggregateField aggregateFieldForCount],
- [FIRAggregateField aggregateFieldForSumOfField:@"weight"],
- [FIRAggregateField aggregateFieldForAverageOfField:@"weight"]
- ]]];
- // different data set
- FIRAggregateQuerySnapshot* snapshot4 =
- [self readSnapshotForAggregate:[[testCollection queryWhereField:@"pages" isGreaterThan:@50]
- aggregate:@[
- [FIRAggregateField aggregateFieldForCount],
- [FIRAggregateField aggregateFieldForSumOfField:@"pages"],
- [FIRAggregateField
- aggregateFieldForAverageOfField:@"pages"]
- ]]];
- XCTAssertEqualObjects(snapshot1, snapshot2);
- XCTAssertNotEqualObjects(snapshot1, snapshot3);
- XCTAssertNotEqualObjects(snapshot1, snapshot4);
- XCTAssertNotEqualObjects(snapshot3, snapshot4);
- XCTAssertEqual([snapshot1 hash], [snapshot2 hash]);
- XCTAssertNotEqual([snapshot1 hash], [snapshot3 hash]);
- XCTAssertNotEqual([snapshot1 hash], [snapshot4 hash]);
- XCTAssertNotEqual([snapshot3 hash], [snapshot4 hash]);
- }
- #endif // #if !defined(THREAD_SANITIZER)
- - (void)testAggregateOnFieldNameWithMaxLength {
- // The longest field name and alias allowed is 1500 bytes or 1499 characters.
- NSString* longField = [@"" stringByPaddingToLength:1499
- withString:@"0123456789"
- startingAtIndex:0];
- FIRCollectionReference* testCollection =
- [self collectionRefWithDocuments:@{@"a" : @{longField : @1}, @"b" : @{longField : @2}}];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection
- aggregate:@[ [FIRAggregateField
- aggregateFieldForSumOfField:longField] ]]];
- // Sum
- XCTAssertEqual(
- [snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:longField]],
- [NSNumber numberWithLong:3], );
- }
- - (void)testCanGetDuplicateAggregations {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"pages" : @100,
- @"height" : @24.5,
- @"weight" : @24.1,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"pages" : @50,
- @"height" : @25.5,
- @"weight" : @75.5,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- }
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection aggregate:@[
- [FIRAggregateField aggregateFieldForCount],
- [FIRAggregateField aggregateFieldForSumOfField:@"pages"],
- [FIRAggregateField aggregateFieldForSumOfField:@"pages"]
- ]]];
- // Count
- XCTAssertEqual([snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForCount]],
- [NSNumber numberWithLong:2L]);
- // Sum
- XCTAssertEqual(
- [snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"pages"]],
- [NSNumber numberWithLong:150L], );
- }
- - (void)testTerminateDoesNotCrashWithFlyingAggregateQuery {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"pages" : @100,
- @"height" : @24.5,
- @"weight" : @24.1,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"pages" : @50,
- @"height" : @25.5,
- @"weight" : @75.5,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- }
- }];
- FIRAggregateQuery* aggQuery = [testCollection aggregate:@[
- [FIRAggregateField aggregateFieldForCount],
- [FIRAggregateField aggregateFieldForSumOfField:@"pages"],
- [FIRAggregateField aggregateFieldForAverageOfField:@"pages"]
- ]];
- __block FIRAggregateQuerySnapshot* result;
- XCTestExpectation* expectation = [self expectationWithDescription:@"aggregate result"];
- [aggQuery aggregationWithSource:FIRAggregateSourceServer
- completion:^(FIRAggregateQuerySnapshot* snapshot, NSError* error) {
- XCTAssertNil(error);
- result = snapshot;
- [expectation fulfill];
- }];
- [self awaitExpectation:expectation];
- // Count
- XCTAssertEqual([result valueForAggregateField:[FIRAggregateField aggregateFieldForCount]],
- [NSNumber numberWithLong:2L]);
- // Sum
- XCTAssertEqual(
- [result valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"pages"]],
- [NSNumber numberWithLong:150L], );
- }
- - (void)testCannotPerformMoreThanMaxAggregations {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"pages" : @100,
- @"height" : @24.5,
- @"weight" : @24.1,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"pages" : @50,
- @"height" : @25.5,
- @"weight" : @75.5,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- }
- }];
- // Max is 5, we're attempting 6. I also like to live dangerously.
- FIRAggregateQuery* query = [testCollection aggregate:@[
- [FIRAggregateField aggregateFieldForCount],
- [FIRAggregateField aggregateFieldForSumOfField:@"pages"],
- [FIRAggregateField aggregateFieldForSumOfField:@"weight"],
- [FIRAggregateField aggregateFieldForAverageOfField:@"pages"],
- [FIRAggregateField aggregateFieldForAverageOfField:@"weight"],
- [FIRAggregateField aggregateFieldForAverageOfField:@"foo"]
- ]];
- __block NSError* result;
- XCTestExpectation* expectation = [self expectationWithDescription:@"aggregate result"];
- [query aggregationWithSource:FIRAggregateSourceServer
- completion:^(FIRAggregateQuerySnapshot* snapshot, NSError* error) {
- XCTAssertNil(snapshot);
- result = error;
- [expectation fulfill];
- }];
- [self awaitExpectation:expectation];
- XCTAssertNotNil(result);
- XCTAssertTrue([[result localizedDescription] containsString:@"maximum number of aggregations"]);
- }
- - (void)testThrowsAnErrorWhenGettingTheResultOfAnUnrequestedAggregation {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"pages" : @100,
- @"height" : @24.5,
- @"weight" : @24.1,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"pages" : @50,
- @"height" : @25.5,
- @"weight" : @75.5,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- }
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection
- aggregate:@[ [FIRAggregateField
- aggregateFieldForSumOfField:@"pages"] ]]];
- @try {
- [snapshot count];
- XCTAssertTrue(false, "Exception expected");
- } @catch (NSException* exception) {
- XCTAssertEqualObjects(exception.name, @"FIRInvalidArgumentException");
- XCTAssertEqualObjects(exception.reason,
- @"'count()' was not requested in the aggregation query.");
- }
- @
- try {
- [snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"foo"]];
- XCTAssertTrue(false, "Exception expected");
- } @catch (NSException* exception) {
- XCTAssertEqualObjects(exception.name, @"FIRInvalidArgumentException");
- XCTAssertEqualObjects(exception.reason,
- @"'sum(foo)' was not requested in the aggregation query.");
- }
- @
- try {
- [snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForAverageOfField:@"pages"]];
- XCTAssertTrue(false, "Exception expected");
- } @catch (NSException* exception) {
- XCTAssertEqualObjects(exception.name, @"FIRInvalidArgumentException");
- XCTAssertEqualObjects(exception.reason,
- @"'avg(pages)' was not requested in the aggregation query.");
- }
- }
- - (void)testPerformsAggregationWhenUsingInOperator {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"pages" : @100,
- @"year" : @1980,
- @"rating" : @5
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"pages" : @50,
- @"year" : @2020,
- @"rating" : @4
- },
- @"c" : @{
- @"author" : @"authorC",
- @"title" : @"titleC",
- @"pages" : @100,
- @"year" : @1980,
- @"rating" : @3
- },
- @"d" : @{
- @"author" : @"authorD",
- @"title" : @"titleD",
- @"pages" : @50,
- @"year" : @2020,
- @"rating" : @0
- }
- }];
- FIRAggregateQuerySnapshot* snapshot = [self
- readSnapshotForAggregate:[[testCollection queryWhereField:@"rating" in:@[ @5, @3 ]]
- aggregate:@[
- [FIRAggregateField aggregateFieldForSumOfField:@"rating"],
- [FIRAggregateField aggregateFieldForAverageOfField:@"rating"],
- [FIRAggregateField aggregateFieldForCount]
- ]]];
- // Count
- XCTAssertEqual(
- [[snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForCount]] longValue], 2L);
- // Sum
- XCTAssertEqual(
- [[snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"rating"]]
- longValue],
- 8L);
- // Average
- XCTAssertEqual([[snapshot valueForAggregateField:[FIRAggregateField
- aggregateFieldForAverageOfField:@"rating"]]
- doubleValue],
- 4.0);
- }
- - (void)testPerformsAggregationsOnNestedMapValues {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"metadata" : @{@"pages" : @100, @"rating" : @{@"critic" : @2, @"user" : @5}}
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"metadata" : @{@"pages" : @50, @"rating" : @{@"critic" : @4, @"user" : @4}}
- },
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection aggregate:@[
- [FIRAggregateField aggregateFieldForSumOfField:@"metadata.pages"],
- [FIRAggregateField aggregateFieldForAverageOfField:@"metadata.pages"],
- [FIRAggregateField aggregateFieldForCount]
- ]]];
- // Count
- XCTAssertEqual(
- [[snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForCount]] longValue], 2L);
- // Sum
- XCTAssertEqual(
- [[snapshot
- valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"metadata.pages"]]
- longValue],
- 150L);
- // Average
- XCTAssertEqual(
- [[snapshot valueForAggregateField:[FIRAggregateField
- aggregateFieldForAverageOfField:@"metadata.pages"]]
- doubleValue],
- 75.0);
- }
- - (void)testPerformsSumThatOverflowsMaxLong {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"rating" : [NSNumber numberWithLong:LLONG_MAX]
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"rating" : [NSNumber numberWithLong:LLONG_MAX]
- },
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection
- aggregate:@[ [FIRAggregateField
- aggregateFieldForSumOfField:@"rating"] ]]];
- // Sum
- XCTAssertEqual(
- [[snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"rating"]]
- doubleValue],
- [[NSNumber numberWithLong:LLONG_MAX] doubleValue] +
- [[NSNumber numberWithLong:LLONG_MAX] doubleValue]);
- }
- - (void)testPerformsSumThatCanOverflowLongValuesDuringAccumulation {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"rating" : [NSNumber numberWithLong:LLONG_MAX]
- },
- @"b" : @{@"author" : @"authorB", @"title" : @"titleB", @"rating" : [NSNumber numberWithLong:1]},
- @"c" :
- @{@"author" : @"authorC", @"title" : @"titleC", @"rating" : [NSNumber numberWithLong:-101]}
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection
- aggregate:@[ [FIRAggregateField
- aggregateFieldForSumOfField:@"rating"] ]]];
- // Sum
- XCTAssertEqual(
- [[snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"rating"]]
- longLongValue],
- [[NSNumber numberWithLong:LLONG_MAX - 100] longLongValue]);
- }
- - (void)testPerformsSumThatIsNegative {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"rating" : [NSNumber numberWithLong:LLONG_MAX]
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"rating" : [NSNumber numberWithLong:-LLONG_MAX]
- },
- @"c" :
- @{@"author" : @"authorC", @"title" : @"titleC", @"rating" : [NSNumber numberWithLong:-101]},
- @"d" : @{
- @"author" : @"authorD",
- @"title" : @"titleD",
- @"rating" : [NSNumber numberWithLong:-10000]
- }
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection
- aggregate:@[ [FIRAggregateField
- aggregateFieldForSumOfField:@"rating"] ]]];
- // Sum
- XCTAssertEqual(
- [[snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"rating"]]
- longLongValue],
- [[NSNumber numberWithLong:-10101] longLongValue]);
- }
- - (void)testPerformsSumThatIsPositiveInfinity {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"rating" : [NSNumber numberWithDouble:DBL_MAX]
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"rating" : [NSNumber numberWithDouble:DBL_MAX]
- }
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection
- aggregate:@[ [FIRAggregateField
- aggregateFieldForSumOfField:@"rating"] ]]];
- // Sum
- XCTAssertEqual(
- [snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"rating"]],
- [NSNumber numberWithDouble:INFINITY]);
- }
- - (void)testPerformsSumThatIsNegativeInfinity {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"rating" : [NSNumber numberWithDouble:-DBL_MAX]
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"rating" : [NSNumber numberWithDouble:-DBL_MAX]
- }
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection
- aggregate:@[ [FIRAggregateField
- aggregateFieldForSumOfField:@"rating"] ]]];
- // Sum
- XCTAssertEqual(
- [snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"rating"]],
- [NSNumber numberWithDouble:-INFINITY]);
- }
- - (void)testPerformsSumThatIsValidButCouldOverflowDuringAggregation {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{@"rating" : [NSNumber numberWithDouble:DBL_MAX]},
- @"b" : @{@"rating" : [NSNumber numberWithDouble:DBL_MAX]},
- @"c" : @{@"rating" : [NSNumber numberWithDouble:-DBL_MAX]},
- @"d" : @{@"rating" : [NSNumber numberWithDouble:-DBL_MAX]}
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection
- aggregate:@[ [FIRAggregateField
- aggregateFieldForSumOfField:@"rating"] ]]];
- // Sum
- long long ratingL =
- [[snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"rating"]]
- longLongValue];
- XCTAssertTrue(ratingL == [[NSNumber numberWithDouble:-INFINITY] longLongValue] || ratingL == 0 ||
- ratingL == [[NSNumber numberWithDouble:INFINITY] longLongValue]);
- double ratingD =
- [[snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"rating"]]
- doubleValue];
- XCTAssertTrue(ratingD == -INFINITY || ratingD == 0 || ratingD == INFINITY);
- }
- - (void)testPerformsSumOverResultSetOfZeroDocuments {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"pages" : @100,
- @"height" : @24.5,
- @"weight" : @24.1,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"pages" : @50,
- @"height" : @25.5,
- @"weight" : @75.5,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- }
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[[testCollection queryWhereField:@"pages" isGreaterThan:@200]
- aggregate:@[ [FIRAggregateField
- aggregateFieldForSumOfField:@"pages"] ]]];
- // Sum
- XCTAssertEqual(
- [snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"pages"]],
- [NSNumber numberWithLong:0L]);
- }
- - (void)testPerformsSumOnlyOnNumericFields {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{@"rating" : [NSNumber numberWithLong:5]},
- @"b" : @{@"rating" : [NSNumber numberWithLong:4]},
- @"c" : @{@"rating" : @"3"},
- @"d" : @{@"rating" : [NSNumber numberWithLong:1]}
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection aggregate:@[
- [FIRAggregateField aggregateFieldForCount],
- [FIRAggregateField aggregateFieldForSumOfField:@"rating"]
- ]]];
- // Count
- XCTAssertEqual(
- [[snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForCount]] longValue], 4L);
- // Sum
- XCTAssertEqual(
- [[snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"rating"]]
- longLongValue],
- [[NSNumber numberWithLong:10] longLongValue]);
- }
- - (void)testPerformsSumOfMinIEEE754 {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{@"rating" : [NSNumber numberWithDouble:__DBL_DENORM_MIN__]}
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection
- aggregate:@[ [FIRAggregateField
- aggregateFieldForSumOfField:@"rating"] ]]];
- // Sum
- XCTAssertEqual(
- [[snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForSumOfField:@"rating"]]
- doubleValue],
- [[NSNumber numberWithDouble:__DBL_DENORM_MIN__] doubleValue]);
- }
- - (void)testPerformsAverageOfVariousNumericTypes {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"x" : @1,
- @"intToInt" : [NSNumber numberWithLong:10],
- @"floatToInt" : [NSNumber numberWithDouble:10.5],
- @"mixedToInt" : [NSNumber numberWithLong:10],
- @"floatToFloat" : [NSNumber numberWithDouble:5.5],
- @"mixedToFloat" : [NSNumber numberWithDouble:8.6],
- @"intToFloat" : [NSNumber numberWithLong:10]
- },
- @"b" : @{
- @"intToInt" : [NSNumber numberWithLong:5],
- @"floatToInt" : [NSNumber numberWithDouble:9.5],
- @"mixedToInt" : [NSNumber numberWithDouble:9.5],
- @"floatToFloat" : [NSNumber numberWithDouble:4.5],
- @"mixedToFloat" : [NSNumber numberWithLong:9],
- @"intToFloat" : [NSNumber numberWithLong:9]
- },
- @"c" : @{
- @"intToInt" : [NSNumber numberWithLong:0],
- @"floatToInt" : @"ignore",
- @"mixedToInt" : [NSNumber numberWithDouble:10.5],
- @"floatToFloat" : [NSNumber numberWithDouble:3.5],
- @"mixedToFloat" : [NSNumber numberWithLong:10],
- @"intToFloat" : @"ignore"
- }
- }];
- NSArray* testCases = @[
- @{
- @"agg" : [FIRAggregateField aggregateFieldForAverageOfField:@"intToInt"],
- @"expected" : [NSNumber numberWithLong:5]
- },
- @{
- @"agg" : [FIRAggregateField aggregateFieldForAverageOfField:@"floatToInt"],
- @"expected" : [NSNumber numberWithLong:10]
- },
- @{
- @"agg" : [FIRAggregateField aggregateFieldForAverageOfField:@"mixedToInt"],
- @"expected" : [NSNumber numberWithLong:10]
- },
- @{
- @"agg" : [FIRAggregateField aggregateFieldForAverageOfField:@"floatToFloat"],
- @"expected" : [NSNumber numberWithDouble:4.5]
- },
- @{
- @"agg" : [FIRAggregateField aggregateFieldForAverageOfField:@"mixedToFloat"],
- @"expected" : [NSNumber numberWithDouble:9.2]
- },
- @{
- @"agg" : [FIRAggregateField aggregateFieldForAverageOfField:@"intToFloat"],
- @"expected" : [NSNumber numberWithDouble:9.5]
- }
- ];
- for (NSDictionary* testCase in testCases) {
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection aggregate:@[ testCase[@"agg"] ]]];
- // Average
- XCTAssertEqual([[snapshot valueForAggregateField:testCase[@"agg"]] longValue],
- [testCase[@"expected"] longLongValue]);
- XCTAssertEqualWithAccuracy([[snapshot valueForAggregateField:testCase[@"agg"]] doubleValue],
- [testCase[@"expected"] doubleValue], 0.00000000000001);
- }
- }
- - (void)testPerformsAverageCausingUnderflow {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{@"rating" : [NSNumber numberWithDouble:__DBL_DENORM_MIN__]},
- @"b" : @{@"rating" : [NSNumber numberWithDouble:0]}
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection aggregate:@[
- [FIRAggregateField aggregateFieldForAverageOfField:@"rating"]
- ]]];
- // Average
- XCTAssertEqual([[snapshot valueForAggregateField:[FIRAggregateField
- aggregateFieldForAverageOfField:@"rating"]]
- doubleValue],
- [[NSNumber numberWithDouble:0] doubleValue]);
- }
- - (void)testPerformsAverageOfMinIEEE754 {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{@"rating" : [NSNumber numberWithDouble:__DBL_DENORM_MIN__]}
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection aggregate:@[
- [FIRAggregateField aggregateFieldForAverageOfField:@"rating"]
- ]]];
- // Average
- XCTAssertEqual([[snapshot valueForAggregateField:[FIRAggregateField
- aggregateFieldForAverageOfField:@"rating"]]
- doubleValue],
- [[NSNumber numberWithDouble:__DBL_DENORM_MIN__] doubleValue]);
- }
- - (void)testPerformsAverageOverflowIEEE754DuringAccumulation {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{@"rating" : [NSNumber numberWithDouble:DBL_MAX]},
- @"b" : @{@"rating" : [NSNumber numberWithDouble:DBL_MAX]}
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection aggregate:@[
- [FIRAggregateField aggregateFieldForAverageOfField:@"rating"]
- ]]];
- // Average
- XCTAssertEqual([[snapshot valueForAggregateField:[FIRAggregateField
- aggregateFieldForAverageOfField:@"rating"]]
- doubleValue],
- [[NSNumber numberWithDouble:INFINITY] doubleValue]);
- }
- - (void)testPerformsAverageOverResultSetOfZeroDocuments {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{
- @"author" : @"authorA",
- @"title" : @"titleA",
- @"pages" : @100,
- @"height" : @24.5,
- @"weight" : @24.1,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- },
- @"b" : @{
- @"author" : @"authorB",
- @"title" : @"titleB",
- @"pages" : @50,
- @"height" : @25.5,
- @"weight" : @75.5,
- @"foo" : @1,
- @"bar" : @2,
- @"baz" : @3
- }
- }];
- FIRAggregateQuerySnapshot* snapshot = [self
- readSnapshotForAggregate:[[testCollection queryWhereField:@"pages" isGreaterThan:@200]
- aggregate:@[ [FIRAggregateField
- aggregateFieldForAverageOfField:@"pages"] ]]];
- // Average
- XCTAssertEqual([snapshot valueForAggregateField:[FIRAggregateField
- aggregateFieldForAverageOfField:@"pages"]],
- [NSNull null]);
- }
- - (void)testPerformsAverageOnlyOnNumericFields {
- FIRCollectionReference* testCollection = [self collectionRefWithDocuments:@{
- @"a" : @{@"rating" : [NSNumber numberWithLong:5]},
- @"b" : @{@"rating" : [NSNumber numberWithLong:4]},
- @"c" : @{@"rating" : @"3"},
- @"d" : @{@"rating" : [NSNumber numberWithLong:6]}
- }];
- FIRAggregateQuerySnapshot* snapshot =
- [self readSnapshotForAggregate:[testCollection aggregate:@[
- [FIRAggregateField aggregateFieldForCount],
- [FIRAggregateField aggregateFieldForAverageOfField:@"rating"]
- ]]];
- // Count
- XCTAssertEqual(
- [[snapshot valueForAggregateField:[FIRAggregateField aggregateFieldForCount]] longValue], 4L);
- // Average
- XCTAssertEqual([[snapshot valueForAggregateField:[FIRAggregateField
- aggregateFieldForAverageOfField:@"rating"]]
- doubleValue],
- [[NSNumber numberWithDouble:5] doubleValue]);
- }
- @end
|