| commit | author | age | ||
| 6e1425 | 1 | // |
| H | 2 | // FMDatabaseQueue.h |
| 3 | // fmdb | |
| 4 | // | |
| 5 | // Created by August Mueller on 6/22/11. | |
| 6 | // Copyright 2011 Flying Meat Inc. All rights reserved. | |
| 7 | // | |
| 8 | ||
| 9 | #import <Foundation/Foundation.h> | |
| 10 | ||
| 11 | @class FMDatabase; | |
| 12 | ||
| 13 | /** To perform queries and updates on multiple threads, you'll want to use `FMDatabaseQueue`. | |
| 14 | ||
| 15 | Using a single instance of `<FMDatabase>` from multiple threads at once is a bad idea. It has always been OK to make a `<FMDatabase>` object *per thread*. Just don't share a single instance across threads, and definitely not across multiple threads at the same time. | |
| 16 | ||
| 17 | Instead, use `FMDatabaseQueue`. Here's how to use it: | |
| 18 | ||
| 19 | First, make your queue. | |
| 20 | ||
| 21 | FMDatabaseQueue *queue = [FMDatabaseQueue databaseQueueWithPath:aPath]; | |
| 22 | ||
| 23 | Then use it like so: | |
| 24 | ||
| 25 | [queue inDatabase:^(FMDatabase *db) { | |
| 26 | [db executeUpdate:@"INSERT INTO myTable VALUES (?)", [NSNumber numberWithInt:1]]; | |
| 27 | [db executeUpdate:@"INSERT INTO myTable VALUES (?)", [NSNumber numberWithInt:2]]; | |
| 28 | [db executeUpdate:@"INSERT INTO myTable VALUES (?)", [NSNumber numberWithInt:3]]; | |
| 29 | ||
| 30 | FMResultSet *rs = [db executeQuery:@"select * from foo"]; | |
| 31 | while ([rs next]) { | |
| 32 | //… | |
| 33 | } | |
| 34 | }]; | |
| 35 | ||
| 36 | An easy way to wrap things up in a transaction can be done like this: | |
| 37 | ||
| 38 | [queue inTransaction:^(FMDatabase *db, BOOL *rollback) { | |
| 39 | [db executeUpdate:@"INSERT INTO myTable VALUES (?)", [NSNumber numberWithInt:1]]; | |
| 40 | [db executeUpdate:@"INSERT INTO myTable VALUES (?)", [NSNumber numberWithInt:2]]; | |
| 41 | [db executeUpdate:@"INSERT INTO myTable VALUES (?)", [NSNumber numberWithInt:3]]; | |
| 42 | ||
| 43 | if (whoopsSomethingWrongHappened) { | |
| 44 | *rollback = YES; | |
| 45 | return; | |
| 46 | } | |
| 47 | // etc… | |
| 48 | [db executeUpdate:@"INSERT INTO myTable VALUES (?)", [NSNumber numberWithInt:4]]; | |
| 49 | }]; | |
| 50 | ||
| 51 | `FMDatabaseQueue` will run the blocks on a serialized queue (hence the name of the class). So if you call `FMDatabaseQueue`'s methods from multiple threads at the same time, they will be executed in the order they are received. This way queries and updates won't step on each other's toes, and every one is happy. | |
| 52 | ||
| 53 | ### See also | |
| 54 | ||
| 55 | - `<FMDatabase>` | |
| 56 | ||
| 57 | @warning Do not instantiate a single `<FMDatabase>` object and use it across multiple threads. Use `FMDatabaseQueue` instead. | |
| 58 | ||
| 59 | @warning The calls to `FMDatabaseQueue`'s methods are blocking. So even though you are passing along blocks, they will **not** be run on another thread. | |
| 60 | ||
| 61 | */ | |
| 62 | ||
| 63 | @interface FMDatabaseQueue : NSObject { | |
| 64 | NSString *_path; | |
| 65 | dispatch_queue_t _queue; | |
| 66 | FMDatabase *_db; | |
| 67 | int _openFlags; | |
| 68 | } | |
| 69 | ||
| 70 | /** Path of database */ | |
| 71 | ||
| 72 | @property (atomic, retain) NSString *path; | |
| 73 | ||
| 74 | /** Open flags */ | |
| 75 | ||
| 76 | @property (atomic, readonly) int openFlags; | |
| 77 | ||
| 78 | ///---------------------------------------------------- | |
| 79 | /// @name Initialization, opening, and closing of queue | |
| 80 | ///---------------------------------------------------- | |
| 81 | ||
| 82 | /** Create queue using path. | |
| 83 | ||
| 84 | @param aPath The file path of the database. | |
| 85 | ||
| 86 | @return The `FMDatabaseQueue` object. `nil` on error. | |
| 87 | */ | |
| 88 | ||
| 89 | + (instancetype)databaseQueueWithPath:(NSString*)aPath; | |
| 90 | ||
| 91 | /** Create queue using path and specified flags. | |
| 92 | ||
| 93 | @param aPath The file path of the database. | |
| 94 | @param openFlags Flags passed to the openWithFlags method of the database | |
| 95 | ||
| 96 | @return The `FMDatabaseQueue` object. `nil` on error. | |
| 97 | */ | |
| 98 | + (instancetype)databaseQueueWithPath:(NSString*)aPath flags:(int)openFlags; | |
| 99 | ||
| 100 | /** Create queue using path. | |
| 101 | ||
| 102 | @param aPath The file path of the database. | |
| 103 | ||
| 104 | @return The `FMDatabaseQueue` object. `nil` on error. | |
| 105 | */ | |
| 106 | ||
| 107 | - (instancetype)initWithPath:(NSString*)aPath; | |
| 108 | ||
| 109 | /** Create queue using path and specified flags. | |
| 110 | ||
| 111 | @param aPath The file path of the database. | |
| 112 | @param openFlags Flags passed to the openWithFlags method of the database | |
| 113 | ||
| 114 | @return The `FMDatabaseQueue` object. `nil` on error. | |
| 115 | */ | |
| 116 | ||
| 117 | - (instancetype)initWithPath:(NSString*)aPath flags:(int)openFlags; | |
| 118 | ||
| 119 | /** Create queue using path and specified flags. | |
| 120 | ||
| 121 | @param aPath The file path of the database. | |
| 122 | @param openFlags Flags passed to the openWithFlags method of the database | |
| 123 | @param vfsName The name of a custom virtual file system | |
| 124 | ||
| 125 | @return The `FMDatabaseQueue` object. `nil` on error. | |
| 126 | */ | |
| 127 | ||
| 128 | - (instancetype)initWithPath:(NSString*)aPath flags:(int)openFlags vfs:(NSString *)vfsName; | |
| 129 | ||
| 130 | /** Returns the Class of 'FMDatabase' subclass, that will be used to instantiate database object. | |
| 131 | ||
| 132 | Subclasses can override this method to return specified Class of 'FMDatabase' subclass. | |
| 133 | ||
| 134 | @return The Class of 'FMDatabase' subclass, that will be used to instantiate database object. | |
| 135 | */ | |
| 136 | ||
| 137 | + (Class)databaseClass; | |
| 138 | ||
| 139 | /** Close database used by queue. */ | |
| 140 | ||
| 141 | - (void)close; | |
| 142 | ||
| 143 | ///----------------------------------------------- | |
| 144 | /// @name Dispatching database operations to queue | |
| 145 | ///----------------------------------------------- | |
| 146 | ||
| 147 | /** Synchronously perform database operations on queue. | |
| 148 | ||
| 149 | @param block The code to be run on the queue of `FMDatabaseQueue` | |
| 150 | */ | |
| 151 | ||
| 152 | - (void)inDatabase:(void (^)(FMDatabase *db))block; | |
| 153 | ||
| 154 | /** Synchronously perform database operations on queue, using transactions. | |
| 155 | ||
| 156 | @param block The code to be run on the queue of `FMDatabaseQueue` | |
| 157 | */ | |
| 158 | ||
| 159 | - (void)inTransaction:(void (^)(FMDatabase *db, BOOL *rollback))block; | |
| 160 | ||
| 161 | /** Synchronously perform database operations on queue, using deferred transactions. | |
| 162 | ||
| 163 | @param block The code to be run on the queue of `FMDatabaseQueue` | |
| 164 | */ | |
| 165 | ||
| 166 | - (void)inDeferredTransaction:(void (^)(FMDatabase *db, BOOL *rollback))block; | |
| 167 | ||
| 168 | ///----------------------------------------------- | |
| 169 | /// @name Dispatching database operations to queue | |
| 170 | ///----------------------------------------------- | |
| 171 | ||
| 172 | /** Synchronously perform database operations using save point. | |
| 173 | ||
| 174 | @param block The code to be run on the queue of `FMDatabaseQueue` | |
| 175 | */ | |
| 176 | ||
| 177 | // NOTE: you can not nest these, since calling it will pull another database out of the pool and you'll get a deadlock. | |
| 178 | // If you need to nest, use FMDatabase's startSavePointWithName:error: instead. | |
| 179 | - (NSError*)inSavePoint:(void (^)(FMDatabase *db, BOOL *rollback))block; | |
| 180 | ||
| 181 | @end | |
| 182 | ||
