Introduces deletePeopleForLocalBlogId to decrease number of sql queries

2 files changed, 7 insertions, 4 deletions

diff --git a/WordPress/src/main/java/org/wordpress/android/WordPressDB.java b/WordPress/src/main/java/org/wordpress/android/WordPressDB.java
index 6ba4364d2..79c70d5d6 100644
--- a/WordPress/src/main/java/org/wordpress/android/WordPressDB.java
+++ b/WordPress/src/main/java/org/wordpress/android/WordPressDB.java
@@ -767,8 +767,7 @@ public class WordPressDB {
         int rowsAffected = db.delete(BLOGS_TABLE, "id=?", new String[]{Integer.toString(id)});
         deleteQuickPressShortcutsForLocalTableBlogId(ctx, id);
         deleteAllPostsForLocalTableBlogId(id);
-        PeopleTable.deleteUsersForLocalBlogId(id);
-        PeopleTable.deleteFollowersForLocalBlogId(id);
+        PeopleTable.deletePeopleForLocalBlogId(id);
         return (rowsAffected > 0);
     }
 
@@ -778,8 +777,7 @@ public class WordPressDB {
             int localBlogId = MapUtils.getMapInt(blog, "id");
             deleteQuickPressShortcutsForLocalTableBlogId(ctx, localBlogId);
             deleteAllPostsForLocalTableBlogId(localBlogId);
-            PeopleTable.deleteUsersForLocalBlogId(localBlogId);
-            PeopleTable.deleteFollowersForLocalBlogId(localBlogId);
+            PeopleTable.deletePeopleForLocalBlogId(localBlogId);
         }
 
         // H4ck alert: We need to delete the Jetpack sites that were added in the initial
diff --git a/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java b/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java
index ce0ab1c2b..13068fff7 100644
--- a/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java
+++ b/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java
@@ -107,6 +107,11 @@ public class PeopleTable {
         }
     }
 
+    public static void deletePeopleForLocalBlogId(int localTableBlogId) {
+        String[] args = new String[]{Integer.toString(localTableBlogId)};
+        getWritableDb().delete(PEOPLE_TABLE, "local_blog_id=?", args);
+    }
+
     public static void deleteUsersForLocalBlogId(int localTableBlogId) {
         String[] args = new String[]{Integer.toString(localTableBlogId), Boolean.toString(false)};
         getWritableDb().delete(PEOPLE_TABLE, "local_blog_id=?&is_follower=?", args);