DBOperation.h 884 B

123456789101112131415161718192021222324252627282930
  1. //
  2. // DBOperation.h
  3. // zhuxun
  4. //
  5. // Created by winsoft on 17/4/24.
  6. //
  7. //
  8. #import <Foundation/Foundation.h>
  9. /**
  10. * 数据库实现底层, sql语句由业务层传入.
  11. */
  12. @interface DBOperation : NSObject
  13. + (instancetype)dbOperationWithPath:(NSString *)path;
  14. //- (void)creatDBbySQL:(NSString *)sql Path:(NSString *)path;
  15. - (void)creatDBWithTableName:(NSString *)tableName dbModelClass:(Class)dbModelClass Path:(NSString *)path autoUpgrade:(BOOL)autoUpgrade uniqueCloumName:(NSString *)uniqueCloumName;
  16. //插入模型
  17. - (void)addDataDBWithTableName:(NSString *)tableName model:(id)model;
  18. - (void)addDatasDBWithTableName:(NSString *)tableName models:(NSArray *)models;
  19. - (void)addDataToDBWithSQL:(NSString *)sql;
  20. //事务批量插入
  21. - (void)addDatasToDBWithSQLs:(NSArray *)sqls;
  22. //查询
  23. - (void)quaryDBbySQL:(NSString *)sql result:(void(^)(NSMutableArray *array))result;
  24. @end