An ORM kit of object persistence use SQLite
##SQLitePersistentObject
SQLitePersistentObject is an ORM Kit Write by Jeff LaMarche, it's excellent.
Any class that subclasses this class can have their properties automatically persisted into a sqlite database. There are some limits - currently certain property types aren't supported like void *, char *, structs and unions. Anything that doesn't work correctly with Key Value Coding will not work with this. Ordinary scalars (ints, floats, etc) will be converted to NSNumber, as will BOOL.
SQLite is very good about converting types, so you can search on a number field passing in a number in a string, and can search on a string field by passing in a number. The only limitation we place on the search methods is that we don't allow searching on blobs, which is simply for performance reasons.
but now, Jeff not work on this library. so I will work on this library. in original this library is non-safe-thread in multithread opearations , I just make it thread-safe in multithread use some new methods
##Installation
SQLitePersisentObject is available through CocoaPods, to install
it simply add the following line to your Podfile:
pod "SQLitePersistentObject"
Alternatively, you can just drag the files from SQLitePersistentObject / SQLitePersistentObject into your own project.
create an object inherit SQLitePersistentObject
header file:
#import "SQLitePersistentObject.h"
@interface Device : SQLitePersistentObject
@property (nonatomic, copy) NSString *name;
@property (nonatomic, copy) NSString *model;
@property (nonatomic, strong) NSNumber *price;
@end
implementation file:
#import "Device.h"
@implementation Device
@end
#pragma mark - DeJohn Dong Added Methods
/**
* Asynchronous add/update an object to db.
*/
- (void)save;
/**
* Asynchronous delete an object from db.
*/
- (void)asynDeleteObject;
/**
* Asynchronous delete an object and the cascade objects from db.
*/
- (void)asynDeleteObjectCascade:(BOOL)cascade;
/**
* Asynchronous Query the object list with criteria from db.
*
* @param criteria criteria string
* @param result result list
*/
+ (void)queryByCriteria:(NSString *)criteria result:(DBQueryResult)result;
/**
* Asynchronous Query the first object with criteria from db
*
* @param criteria criteria string
* @param result result object
*/
+ (void)queryFirstItemByCriteria:(NSString *)criteria result:(DBQueryResult)result;
/**
* Asynchronous Query all the objects from db
*
* @param result result list
*/
+ (void)queryResult:(DBQueryResult)result;- Xcode 6
- iOS 5.1.1 or Mac OSX 10.8
Jeff LaMarche [email protected] / DeJohn Dong, [email protected]
SQLitePersistentObject is available under the MIT license. See the LICENSE file for more info.