//
|
// NSObject+LHModelExecute.h
|
// LHDBDemo
|
//
|
// Created by 3wchina01 on 16/2/15.
|
// Copyright © 2016年 李浩. All rights reserved.
|
//
|
|
#import <Foundation/Foundation.h>
|
|
typedef void(^executeError)(NSError* error);
|
|
@class LHSqlite,LHPredicate;
|
@interface NSObject (LHDB)
|
|
/*
|
不在队列中执行，无法保证线程安全
|
*/
|
/*
|
类方法直接建表
|
*/
|
+ (void)createTable;
|
|
/*
|
传人属性名,对一个已经存在的表增加字段
|
*/
|
+ (void)addColum:(NSString*)name;
|
|
/*
|
插入操作
|
*/
|
- (void)save;
|
|
+ (void)saveWithDic:(NSDictionary*)dic;
|
|
/*
|
插入操作,如果失败,返回提示信息
|
*/
|
- (void)saveWithIfError:(executeError)error;
|
|
+ (void)saveWithDic:(NSDictionary*)dic error:(executeError)error;
|
|
/*
|
更新操作,predicate 更新的范围 类似NSPredicate
|
*/
|
- (void)updateWithPredicate:(LHPredicate*)predicate;
|
|
+ (void)updateWithDic:(NSDictionary*)dic predicate:(LHPredicate*)predicate;
|
|
- (void)updateWithPredicate:(LHPredicate*)predicate error:(executeError)error;
|
|
+ (void)updateWithDic:(NSDictionary*)dic predicate:(LHPredicate*)predicate error:(executeError)error;
|
|
+ (void)deleteWithPredicate:(LHPredicate*)predicate;
|
|
+ (void)deleteWithPredicate:(LHPredicate*)predicate error:(executeError)error;
|
|
+ (NSArray*)selectWithPredicate:(LHPredicate*)predicate;
|
|
+ (NSArray*)selectWithPredicate:(LHPredicate*)predicate error:(executeError)error;
|
|
/*
|
所有数据库操作全部是线程安全，不需要担心数据库锁住
|
所有操作都是异步执行,回调的block也是在子线程中
|
*/
|
|
+ (void)inQueueCreateTable;
|
|
+ (void)inQueueAddColum:(NSString*)name;
|
|
- (void)inQueueSave;
|
|
+ (void)inQueueSaveWithDic:(NSDictionary*)dic;
|
|
- (void)inQueueSaveWithIfError:(executeError)fail;
|
|
+ (void)inQueueSaveWithDic:(NSDictionary*)dic error:(executeError)fail;
|
|
- (void)inQueueUpdateWithPredicate:(LHPredicate*)predicate;
|
|
+ (void)inQueueUpdateWithDic:(NSDictionary*)dic predicate:(LHPredicate*)predicate;
|
|
- (void)inQueueUpdateWithPredicate:(LHPredicate*)predicate error:(executeError)fail;
|
|
+ (void)inQueueUpdateWithDic:(NSDictionary*)dic predicate:(LHPredicate *)predicate error:(executeError)error;
|
|
+ (void)inQueueDeleteWithPredicate:(LHPredicate*)predicate;
|
|
+ (void)inQueueDeleteWithPredicate:(LHPredicate*)predicate error:(executeError)fail;
|
|
+ (void)inQueueSelectWithPredicate:(LHPredicate*)predicate result:(void(^)(NSArray* resultArray))result;
|
|
+ (void)inQueueSelectWithPredicate:(LHPredicate*)predicate result:(void(^)(NSArray* resultArray))result error:(executeError)fail;
|
|
@end
|
