FMDBHelpers provides helper methods for executing common SQL statements with FMDB.
For example, instead of:
FMResultSet * results = [db executeQuery:@"SELECT * FROM people ORDER BY firstName"];
NSMutableArray * people = [NSMutableArray array];
while ([results next])
{
[people addObject:results.resultsDictionary];
}
You can simply write:
NSArray * people = [db selectAllFrom:@"people" orderBy:@"firstName" error:NULL];
In addition to basic SELECT statements, there are also helpers for creating tables and indexes, inserting, updating, and deleting records.
FMDBHelpers contains categories for FMDatabase and FMResultSet. Both are documented on cocoadocs.org
FMDBHelpers can be installed with Cocoapods:
pod 'FMDBHelpers'
Contributors are listed in CONTRIBUTORS.md. Thanks!
FMDBHelpers is covered by the MIT license. See the LICENSE file for full text.