Query Array In Objective C (Like MySQL)

Question

So basically I have a huge array of arrays (only a 2-d array)...

My root array lets say has 100 child arrays...

I want to query the root/child arrays and return only the child arrays that have its 2 object equal to hello...

So basically I have a made-up idea below...

updatedArray = [rootArray WHERE childArray objectAtIndex:2 == @"hello"];

Now as you can see I want updated array to contain like 40 or 50 of the child arrays in the rootArray...

See what I mean - its kind of like MySQL only with an array instead of a database?

btw this is unrelated to MySQL - it's a generic data structure question. And databases are also a data structure... :-) — user529758
– user529758, Commented Jul 3, 2012 at 20:27
I removed the MySQL and C tags, which are definitely unrelated. — ArjunShankar
– ArjunShankar, Commented Jul 3, 2012 at 20:28
@TheMan, read this question. I would even say its a possible duplicate. — ArjunShankar
– ArjunShankar, Commented Jul 3, 2012 at 20:30
Btw, the second object is not at index 2! Obviously, it's at index one. — Joost
– Joost, Commented Jul 3, 2012 at 20:32

score 3 · Accepted Answer · 2012-07-03 20:48:00Z

3

Try this:

NSMutableArray *updated = [[NSMutableArray alloc] init];
for (NSArray *a in rootArray)
{
    if ([[a objectAtIndex:2] isEqualToString:@"hello"])
        [updated addObject:a];
}

Now updated will contain the arrays in rootArray whose 3rd object is @"hello".

Don't forget to release it after use (if you don't use ARC).

You can also use predicates for simple logic; see the NSPredicate class.

edited Jul 3, 2012 at 20:48

answered Jul 3, 2012 at 20:26

user529758

Sign up to request clarification or add additional context in comments.

1 Comment

JustSid Over a year ago

Surely a predicate would be better here?

Sergey Kalinichenko · Accepted Answer · 2012-07-03 20:40:14Z

2

You can filter your array using NSPredicate, like this:

NSArray *data = [NSArray arrayWithObjects:
    [NSArray arrayWithObjects:@"One", @"Two", nil]
,   [NSArray arrayWithObjects:@"Three", @"Four", nil]
,   [NSArray arrayWithObjects:@"Nine", @"Two", nil]
,   nil];
NSPredicate *filter = [NSPredicate predicateWithBlock:^BOOL(id array, NSDictionary *bindings) {
    // This is the place where the condition is specified.
    // You can perform arbitrary testing on your nested arrays
    // to determine their eligibility:
    return [[array objectAtIndex:1] isEqual:@"Two"];
}];
NSArray *res = [data filteredArrayUsingPredicate:filter];
NSLog(@"%lu", res.count);

answered Jul 3, 2012 at 20:40

Sergey Kalinichenko

729k85 gold badges1.2k silver badges1.6k bronze badges

Collectives™ on Stack Overflow

Query Array In Objective C (Like MySQL)

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related