fmdb test case

FetchTest.m

//test method which roughly mimics how I normally fetch results

-(NSTimeInterval)fetchResultsTest
{		
    static NSString * const selectFavorites = @"SELECT songId, title FROM songs LIMIT 50";
    NSMutableArray *fetched = [NSMutableArray array];
        
    FMResultSet *resultSet = [[self database] executeQuery:selectFavorites];
    
    NSTimeInterval start = [NSDate timeIntervalSinceReferenceDate];
    
    while ([resultSet next])
    {
        Song *song = [Song songFromResultSet:resultSet];       
        [fetched addObject:song];
    }
    
    NSTimeInterval end = [NSDate timeIntervalSinceReferenceDate];
    
    return (end - start);
}

-(void)runTest
{
    NSTimeInterval processTotal = 0;
    
    for (int i = 0; i < 100; i++)
    {
        processTotal += [self fetchResultsTest];
    }
    
    NSLog(@"Average time: %f", (processTotal/100));
}

Song.m

+(Song *)songFromResultSet:(FMResultSet *)resultSet
{
    return [[[Song alloc] initWithResultSet:resultSet] autorelease];
}

-(id)initWithResultSet:(FMResultSet *)resultSet
{
    if ((self = [self init]))
    {
	[self setSongID:[resultSet objectForColumnName:@"songId"]];
	[self setTitle:[resultSet stringForColumn:@"title"]];

        //a couple of columns that may not be present from all result sets
	if ([resultSet columnIndexForName:@"offlineStatus"] != -1)
	{
	    offlineStatus = [resultSet intForColumn:@"offlineStatus"];
	}
	
	if ([resultSet columnIndexForName:@"isInLibrary"] != -1)
	{
	    inLibrary = [resultSet boolForColumn:@"isInLibrary"];
	}
    }
	
    return self;
}

SongTable.sql

CREATE TABLE songs (songId INTEGER PRIMARY KEY UNIQUE NOT NULL, title TEXT NOT NULL);