通过核心数据的不同计数，NSExpression 到 NSFetchedResultsController [英] Distinct Count via Core Data, NSExpression Into NSFetchedResultsController

问题描述

目前正在使用核心数据.我有一张表，我试图在其中检索以下信息:

Currently using Core Data. I have one table in which I am trying to retrieve information along these lines:

SELECT item, COUNT(*) FROM myTable GROUP BY item;

为了产生这种类型的结果:

in order to produce this type of result:

+---------+------+-------+
| item        | COUNT(*) |
+---------+------+-------+
| group 1     |   2      |
| group 2     |   5      |
| group 3     |   8      |
+---------+------+-------+

我有一个使用 NSExpression 的好主意，希望 Core Data 为我完成所有工作.我开始转动我的轮子.count: 表达式函数在我身上崩溃了.异常不是很清楚.使用其他表达式函数，例如 sum: 不会使应用程序崩溃.

I had the bright idea to use an NSExpression, with hopes of having Core Data do all the work for me. I am beginning to spin my wheels. The count: expression function is crashing on me. The exception is not very clear. The use of other expression functions, such as sum: doesn't crash the app.

最好将结果存储在 NSFetchedResultsController 中.我探索了其他选择，没有一个不太吸引人.在这种情况下，编写 SQL 查询并完成它是否更有意义，而不是使用 Core Data 作为 SQL 包装器?

It would be nice to store the results in a NSFetchedResultsController. I've explored other options, none of which aren't too appealing. Would it make more sense to write a SQL query and get it over with, rather than to use Core Data as a SQL wrapper in this case?

供您参考的源代码如下.

For your reference source code is below.

NSExpression *keyPathExpression = [NSExpression expressionForKeyPath:@"item"];
NSExpression *totalExpression = [NSExpression expressionForFunction:@"count:" arguments:[NSArray arrayWithObject:keyPathExpression]];

NSExpressionDescription * totalExpressionDescription = [[NSExpressionDescription alloc] init];
[totalExpressionDescription setExpression:totalExpression];
[totalExpressionDescription setExpressionResultType:NSInteger64AttributeType];
[totalExpressionDescription setName:@"totalInstances"];

NSFetchRequest *fetchRequest = [[NSFetchRequest alloc] init];
NSEntityDescription *entity = [NSEntityDescription entityForName:@"myEntity" inManagedObjectContext:self.managedObjectContext];
NSArray *propertiesToFetch = [[NSArray alloc] initWithObjects:strFieldName, totalExpressionDescription, nil];

[fetchRequest setEntity:entity];
[fetchRequest setReturnsDistinctResults:YES];
[fetchRequest setResultType:NSDictionaryResultType];
[fetchRequest setPropertiesToFetch:propertiesToFetch];
[fetchRequest setFetchBatchSize:20];

NSSortDescriptor *sortDescriptor = [[NSSortDescriptor alloc] initWithKey:strFieldName ascending:YES];
NSArray *sortDescriptors = [[NSArray alloc] initWithObjects:sortDescriptor, nil];
[fetchRequest setSortDescriptors:sortDescriptors];

NSFetchedResultsController* aFetchedResultsController = [[NSFetchedResultsController alloc] initWithFetchRequest:fetchRequest managedObjectContext:[self managedObjectContext] sectionNameKeyPath:nil cacheName:nil];

...

NSError *error = nil;
if (![self.fetchedResultsController performFetch:&error])
{
    NSLog(@"Unresolved error %@, %@", error, [error userInfo]);
    abort();
}

推荐答案

正如您最初提出的那样，NSExpression 可以实现这一点，在我设计的示例中，我有一个名为Person"的实体，其中包含一个名为emailAddress"的属性，我希望得到计数.

This is possible with NSExpression as you originally proposed, in my contrived example I have an entity called "Person" with a property called "emailAddress" that I wish to get the count for.

NSPropertyDescription *propDesc = [[[[model entitiesByName] objectForKey:@"Person"] propertiesByName] objectForKey:@"emailAddress"];
NSExpression *emailExpr = [NSExpression expressionForKeyPath:@"emailAddress"];
NSExpression *countExpr = [NSExpression expressionForFunction:@"count:" arguments:[NSArray arrayWithObject:emailExpr]];
NSExpressionDescription *exprDesc = [[NSExpressionDescription alloc] init];
[exprDesc setExpression:countExpr];
[exprDesc setExpressionResultType:NSInteger64AttributeType];
[exprDesc setName:@"count"];

NSFetchRequest *fr = [NSFetchRequest fetchRequestWithEntityName:@"Person"];
[fr setPropertiesToGroupBy:[NSArray arrayWithObject:propDesc]];
[fr setPropertiesToFetch:[NSArray arrayWithObjects:propDesc, exprDesc, nil]];
[fr setResultType:NSDictionaryResultType];
NSArray *results = [moc executeFetchRequest:fr error:&error];

我编写了一段代码来用 1000 条记录预填充数据库:

I wrote a snippet of code to pre-populate the database with 1000 records:

NSArray *emailAddresses = [NSArray arrayWithObjects:@"[e-mail]", @"[e-mail]", @"[e-mail]", @"[e-mail]", @"[e-mail]", nil];
    for (int i = 0; i < 1000; i++) {
        NSManagedObject *person = [NSEntityDescription insertNewObjectForEntityForName:@"Person" inManagedObjectContext:moc];
        [person setValue:[NSNumber numberWithInt:i] forKey:@"aNumber"];
        [person setValue:[[NSUUID UUID] UUIDString] forKey:@"aUUID"];
        [person setValue:[emailAddresses objectAtIndex:(i % [emailAddresses count])] forKey:@"emailAddress"];
    }

上面的代码将每个电子邮件地址插入 200 次，结果如下:

The above code will insert each email address 200 times, here are the results:

2012-05-31 15:17:42.160 Scratch[16084:10d03] CoreData: sql: SELECT t0.ZEMAILADDRESS, COUNT( t0.ZEMAILADDRESS) FROM ZPERSON t0 GROUP BY  t0.ZEMAILADDRESS 
2012-05-31 15:17:42.162 Scratch[16084:10d03] CoreData: annotation: sql connection fetch time: 0.0024s
2012-05-31 15:17:42.163 Scratch[16084:10d03] CoreData: annotation: total fetch execution time: 0.0029s for 5 rows.
(gdb) po results
(NSArray *) $2 = 0x0f811280 <_PFArray 0xf811280>(
{
    count = 200;
    emailAddress = "[e-mail]";
},
{
    count = 200;
    emailAddress = "[e-mail]";
},
{
    count = 200;
    emailAddress = "[e-mail]";
},
{
    count = 200;
    emailAddress = "[e-mail]";
},
{
    count = 200;
    emailAddress = "[e-mail]";
}
)

这篇关于通过核心数据的不同计数，NSExpression 到 NSFetchedResultsController的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！