iOS-FMDB事務【批量更新數據】

打開資料庫（sqlite）

///打開資料庫
+ (BOOL)openDataBase{
   
    _TYDatabase = [[FMDatabase alloc]initWithPath:[self databasePath]];
    if ([_TYDatabase open]) {
        return YES;
    }
    return NO;
}
///資料庫路徑
+ (NSString *)databasePath{
    NSString *documentPath = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];
    NSString *dataPath = [documentPath stringByAppendingPathComponent:@"TY.SQLite"];
    NSFileManager *fileM = [NSFileManager defaultManager];
    if (![fileM fileExistsAtPath:dataPath]) {
        NSString *filePath = [[NSBundle mainBundle] pathForResource:@"TY" ofType:@"SQLite"];
        [fileM copyItemAtPath:filePath toPath:dataPath error:nil];
    }
    NSLog(@"%@",dataPath);
    return dataPath;
    
}

事務

/**
 事務
 arraySql：SQL語句數組
 */
- (void)beginTransaction:(NSArray *)arraySql;
{
    ////  static FMDatabase *_TYDatabase = nil;
    BOOL isOpen=[_TYDatabase open];
    if (!isOpen) {
        NSLog(@"打開資料庫失敗！");
        return;
    }
    ///開始事物
    [_TYDatabase beginTransaction];
    BOOL isRollBack = NO;
    @try {
        for (int i = 0; i<arraySql.count; i++) {
            BOOL result = [_TYDatabase executeUpdate:arraySql[i]];
            if (!result) {
                NSLog(@"操作失敗【%d】== SQL：%@",i,arraySql[i]);
            }
        }
    }
    @catch (NSException *exception) {
        isRollBack = YES;
        ///回滾
        [_TYDatabase rollback];
    }
    @finally {
        if (!isRollBack) {
            ///提交
            [_TYDatabase commit];
        }
    }
    [_TYDatabase close];
}

多線程事務

/**
 多線程事務
 arraySql：SQL語句數組
 */
+ (void)beginTransactionT:(NSArray *)arraySql{
    FMDatabaseQueue *databaseQueue = [FMDatabaseQueue databaseQueueWithPath:[self databasePath]];
    [databaseQueue inTransaction:^(FMDatabase *db, BOOL *rollback) {
        BOOL result = NO;
        for (int i = 0; i < arraySql.count; i++) {
            result = [_TYDatabase executeUpdate:arraySql[i]];
        }
        if (result) {
            NSLog(@"成功");
        }
    }];
}