新增删除指定对象方法,执行自定义sql语句方法

ChrisCai · ChrisCai · commit 36944244209c · 2016-07-26T15:54:57.000+08:00
diff --git a/GKDatabase/GKDatabase/GKDatabaseManager.h b/GKDatabase/GKDatabase/GKDatabaseManager.h
@@ -126,6 +126,14 @@ typedef NS_ENUM(NSInteger ,GKDatabaseSelectLocation){
 
 #pragma mark -
 #pragma mark - =============== 删除数据 ===============
+/**
+ *  移除指定对象
+ *
+ *  @param object 模型对象
+ *
+ *  @return 删除结果
+ */
+- (BOOL)deleteObject:(id)object;
 /**
  *  删除数据
  *
@@ -153,4 +161,12 @@ typedef NS_ENUM(NSInteger ,GKDatabaseSelectLocation){
  *  @return 删除结果
  */
 - (BOOL)deleteTableWithTableName:(id)className;
+/**
+ *  执行自定义的sql语句
+ *
+ *  @param sqlString 自定义的sql语句
+ *
+ *  @return 执行结果
+ */
+- (BOOL)executeSqlString:(NSString *)sqlString;
 @end
diff --git a/GKDatabase/GKDatabase/GKDatabaseManager.m b/GKDatabase/GKDatabase/GKDatabaseManager.m
@@ -398,6 +398,24 @@ - (NSArray *)ConditionProcessingWithString:(NSString *)string {
 
 #pragma mark -
 #pragma mark - =============== 数据删除 ===============
+/// 删除指定对象
+- (BOOL)deleteObject:(id)object {
+    // 获取类的属性和sql类型
+    NSDictionary * propertsDict = [GKObjcProperty getSQLProperties:[object class]];
+    // 拼接字符串
+    NSMutableString * sqlString = [NSMutableString stringWithFormat:@"delete from %@ where ",[object class]];
+    [propertsDict enumerateKeysAndObjectsUsingBlock:^(id  _Nonnull key, id  _Nonnull value, BOOL * _Nonnull stop) {
+        if ([value isEqualToString:@"integer"] || [value isEqualToString:@"real"]) {
+            [sqlString appendFormat:@"%@ = %@ and",key , [object valueForKey:key]];
+        }else {
+            [sqlString appendFormat:@"%@ = '%@' and ",key , [object valueForKey:key]];
+        }
+    }];
+    // 删除最后多余的and
+    NSRange rang = NSMakeRange(sqlString.length-@"and".length-1, @"and".length+1);
+    [sqlString deleteCharactersInRange:rang];
+    return [self executeSqlString:sqlString];
+}
 /// 数据删除
 - (BOOL)deleteObject:(Class)className withString:(NSString *)string {
     // 判断数据库有没有打开
