public void addCategories(List<Category> categories) { SQLiteDatabase db = this.getWritableDatabase(); db.delete(TABLE_CATEGORIES, null, null); for (Category category : categories) { ContentValues values = new ContentValues(); values.put(KEY_ID, category.getId()); // Contact Name values.put(KEY_NAME, category.getName()); // Contact Phone Number values.put(KEY_CREATED_AT, category.getCreated_at()); values.put(KEY_UPDATED_AT, category.getUpdated_at()); // Inserting Row db.insert(TABLE_CATEGORIES, null, values); } db.close(); // Closing database connection }