FMDB userver 扩展

FMDatabase+UserVer.h

#import "FMDatabase.h"

@interface FMDatabase (UserVer)

@property (nonatomic) int userVer;

@end

FMDatabase+UserVer.m

#import "FMDatabase+UserVer.h"

@implementation FMDatabase (UserVer)

- (int)userVer
{
    FMResultSet *rs = [self executeQuery:@"PRAGMA user_version;"];
    if ([rs next]) {
        return [rs intForColumnIndex:0];
    }
    return 0;
}

- (void)setUserVer:(int)userVer
{
    NSString *sql = [NSString stringWithFormat:@"PRAGMA user_version = %d;", userVer];
    BOOL succes = [self executeUpdate:sql];
    NSAssert(succes, @"Set Uer Ver");
}

@end