????????????
????????FMDatabase?????????????????????????????????????????????????? FMDatabaseQueue??????????????????????????????????????????FMDatabaseQueue??????????block??inDatabase?У?????????????????????queue????????Щ???????????У???????????
???????????У?
????FMDatabaseQueue *queue = [FMDatabaseQueue databaseQueueWithPath:aPath];
??????÷?????
[queue inDatabase:^(FMDatabase *db) {
[db executeUpdate:@"INSERT INTO myTable VALUES (?)"?? [NSNumber numberWithInt:1]];
[db executeUpdate:@"INSERT INTO myTable VALUES (?)"?? [NSNumber numberWithInt:2]];
FMResultSet *rs = [db executeQuery:@"select * from foo"];
while([rs next]) {
…
}
}];
??????????????????????????
[queue inTransaction:^(FMDatabase *db?? BOOL *rollback) {
[db executeUpdate:@"INSERT INTO myTable VALUES (?)"?? [NSNumber numberWithInt:1]];
[db executeUpdate:@"INSERT INTO myTable VALUES (?)"?? [NSNumber numberWithInt:2]];
[db executeUpdate:@"INSERT INTO myTable VALUES (?)"?? [NSNumber numberWithInt:3]];
if (somethingWrongHappened) {
*rollback = YES??
return;
}
// etc…
[db executeUpdate:@"INSERT INTO myTable VALUES (?)"?? [NSNumber numberWithInt:4]];
}];