FMDB 加入数据库版本信息

    //创建数据库版本表  
    if (![db tableExists:@"tb_dbInfo"]) {  
        result = [db executeUpdate:@"CREATE TABLE tb_dbInfo(version TEXT)"];  
            }  
    #pragma mark 更新版本号  
    + (BOOL)updateVersionInfoWithString:(NSString*)version  
    {  
        __block BOOL b = FALSE;  
        DataBaseUtil *dbUnit =[DataBaseUtil unit];  
        [dbUnit.queue inDatabase:^(FMDatabase *db) {  
            [db open];  
            b = [db executeUpdate:@"UPDATE tb_dbInfo SET version = ?",version];  
            [db close];  
        }];  
        return b;  
    }  
       
    #pragma mark 插入版本号  
    + (BOOL)insertVersionInfoWithString:(NSString*)version  
    {  
        __block BOOL b = FALSE;  
        DataBaseUtil *dbUnit =[DataBaseUtil unit];  
        [dbUnit.queue inDatabase:^(FMDatabase *db) {  
            [db open];  
            b = [db executeUpdate:@"INSERT INTO tb_dbInfo(version)VALUES(?)",version];  
            [db close];  
        }];  
        return b;  
    }  
    #pragma mark 得到版本信息  
    + (NSString*)getDBInfoValue  
    {  
        __block NSString * version = nil;  
        DataBaseUtil *dbUnit =[DataBaseUtil unit];  
        [dbUnit.queue inDatabase:^(FMDatabase *db) {  
            [db open];  
            FMResultSet* set =[db executeQuery:@"selectversion from tb_dbInfo"];  
            if (set) {  
                while ([set next]) {  
                    version = [set stringForColumn:@"version"];  
                }  
            }  
            [db close];  
        }];  
        return version;  
    }  
    #pragma mark 创建版本信息  
    + (BOOL)setDBInfoValueWithString:(NSString*)string  
    {  
        BOOL result = FALSE;  
        if ([self getDBInfoValue]) {  
            //更新版本  
            result = [self updateVersionInfoWithString:string];  
        }  
        else  
        {  
            //插入版本  
            result =[self insertVersionInfoWithString:string];  
        }  
        return result;  
    }  

 

转载于:https://www.cnblogs.com/weiboyuan/p/8961976.html