FMDatabaseQueue
Jojo Batista
FMDatabaseQueue* queue = [[FMManager sharedFMManager] getQueue];
__block NSArray* arr = [NSArray array];
[queue inDatabase:^(FMDatabase *db) {
FMResultSet* result = [db executeQuery:queryString];
arr = [self createResponseFromQuery:result];
[result close];
}];
//Should i add a (while (!end))?
return arr;
And i've been using some helper methods in my singleton to access the dbase.
Should it work if i create this method in my singleton?
-(BOOL)deleteTable:(NSString*)table wherePrimaryKey:(NSString*)key is:(NSString*)keyValue
{
FMDatabaseQueue* queue = [self getQueue];
[queue inDatabase:^(FMDatabase *db) {
[db executeUpdate:[NSString stringWithFormat:@"DELETE FROM %@ WHERE %@ = ?", table, key], keyValue];
if ([db hadError]) {
NSLog(@"Err %d: %@", [db lastErrorCode], [db lastErrorMessage]);
}
}];
return YES;
}
Cause i keep getting problems with race conditions :S EXC_BAD_ACCESS , etc
Gus Mueller
> Hi, i'm trying to use queues in a singleton that is called across multiple
> threads. But i can't seem to make it work.
> I don't fully understand how to use it.
> I have, 1 connection, shared between threads, and one dbase.
> Is it ok to ask for the queue in a singleton, and then use it in another
> threads? If that's ok, is ok to use it like this?
-gus