// Grab the Documents folder
NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
NSString *documentsDirectory = [paths objectAtIndex:0];

// Sets the database filename
NSString *filePath = [documentsDirectory stringByAppendingPathComponent:@"MTLFMDBTests.sqlite"];

// Tell FMDB where the database is
db = [FMDatabase databaseWithPath:filePath];
// Open the database
[db open];

// Remove the tables if they're already there. You won't usually do this in real life applications
[db executeUpdate:@"drop table if exists user"];
[db executeUpdate:@"drop table if exists repository"];

// Create the tables we're going to work with
[db executeUpdate:@"create table if not exists user "
    "(guid text primary key, name text, age integer)"];
[db executeUpdate:@"create table if not exists repository "
    "(guid text primary key, url text)"];

// An empty model we will fill with the record retrieved from the database
MTLFMDBMockUser *resultUser = nil;
// The initial model we will write to the database
MTLFMDBMockUser *user = [[MTLFMDBMockUser alloc] init];
user.guid = @"myuniqueid";
user.name = @"John Doe";
user.age = [NSNumber numberWithInt:42];

// Create the INSERT statement
NSString *stmt = [MTLFMDBAdapter insertStatementForModel:user];
// Get the values of the record in a format we can use with FMDB
NSArray *params = [MTLFMDBAdapter columnValues:user];
// Execute our INSERT
[db executeUpdate:stmt withArgumentsInArray:params];

// Read the record we've just written to the database        
NSError *error = nil;
FMResultSet *resultSet = [db executeQuery:@"select * from user"];
if ([resultSet next]) {
    resultUser = [MTLFMDBAdapter modelOfClass:MTLFMDBMockUser.class fromFMResultSet:resultSet error:&error];
}

    #import "MTLModel.h"
    #import <Mantle/Mantle.h>
    #import <MTLFMDBAdapter/MTLFMDBAdapter.h>

    @interface MTLFMDBMockUser : MTLModel<MTLFMDBSerializing>

    @property (nonatomic, copy) NSString *guid;
    @property (nonatomic, copy) NSString *name;
    @property (nonatomic, copy) NSNumber *age;
    @property (nonatomic, copy) NSSet *repositories;

    @end

    #import "MTLFMDBMockUser.h"

    @implementation MTLFMDBMockUser

    + (NSDictionary *)FMDBColumnsByPropertyKey
    {
        return @{
                 @"guid": @"guid",
                 @"name": @"name",
                 @"age": @"age",
                 @"repositories": [NSNull null],
                 };
    }

    + (NSArray *)FMDBPrimaryKeys
    {
        return @[@"guid"];
    }

    + (NSString *)FMDBTableName {
        return @"user";
    }

    NSString *stmt = [MTLFMDBAdapter insertStatementForModel:user];

NSArray *params = [MTLFMDBAdapter columnValues:user];