Convert FMResultSet to NSMutableArray?

Question

I am trying out FMDB and it looks like it will work perfectly for me IF I can get my FMResultSet turned into an NSMutableArray.

How would I accomplish this?

Answer 1

You could try this.

NSMutableArray *array = [NSMutableArray array];
FMDatabase *database = [FMDatabase databaseWithPath:databasePath];

[database open];

FMResultSet *results = [database executeQuery:@"SELECT * FROM Table"];
while ([results next]) {
    [array addObject:[results resultDictionary]];
}

NSLog(@"%@", array);

[database close];

I am using this in project, and it's working just fine.

Answer 2

The sample code for FMDB illustrates pretty clearly how FMResultSet works. You iterate over the rows in the result set by calling the next method on each iteration. Inside the loop you use the data accessor methods to retrieve the data per column for the current row. If you want to turn this into an array, you have to do this manually. Like this:

NSMutableArray *array = [NSMutableArray array];
FMResultSet *rs = [db executeQuery:@"select * from table"];
while ([rs next]) {
    // Get the column data for this record and put it into a custom Record object
    int col1 = [rs intForColumn:@"col1"];
    int col2 = [rs intForColumn:@"col2"];
    Record *record = [Record recordWithCol1:col1 col2:col2];
    [array addObject:record];
}
[rs close];

As you see, I am assuming that you have built a custom Record class that represents a record in your database table. You could also work with a dictionary, of course.